Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Kuwait SC Kuwait SC 18 37 11 42
2 Kazma SC Kazma SC 18 24 17 35
3 Al Arabi Al Arabi 18 32 23 32
4 Al Salmiyah Al Salmiyah 18 32 24 31
5 Al Qadsia Al Qadsia 18 25 23 30
6 Al Nasar Al Nasar 18 28 24 24
7 Al Fahaheel Al Fahaheel 18 16 26 18
8 Al-Tadhamon Al-Tadhamon 18 30 41 16
9 Al Yarmouk Al Yarmouk 18 20 35 12
10 Al Shabab Al Shabab 18 9 29 12
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Al Qadsia Al Qadsia 14 28 14 32
2 Al Nasar Al Nasar 13 23 5 29
3 Al Salmiyah Al Salmiyah 14 30 13 29
4 Kazma SC Kazma SC 14 22 10 28
5 Kuwait SC Kuwait SC 14 25 16 24
6 Al Arabi Al Arabi 13 19 14 22
7 Al Shabab Al Shabab 14 19 19 20
8 Al Fahaheel Al Fahaheel 14 12 12 18
9 Khaitan Khaitan 14 16 26 18
10 Al Sahel Al Sahel 14 16 16 17
11 Burgan Burgan 14 13 16 17
12 Al Jahra Al Jahra 14 15 20 14
13 Al Yarmouk Al Yarmouk 14 22 36 8
14 Al-Tadhamon Al-Tadhamon 14 15 33 8
15 Al Sulaibikhat Sulaibikhat 14 9 34 4
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Kuwait SC Kuwait SC 18 49 12 43
2 Al Qadsia Al Qadsia 18 29 11 36
3 Al Salmiyah Al Salmiyah 18 42 26 35
4 Al Arabi Al Arabi 18 26 21 31
5 Kazma SC Kazma SC 18 29 25 28
6 Al Nasar Al Nasar 18 18 22 21
7 Al Sahel Al Sahel 18 16 36 18
8 Al Shabab Al Shabab 18 17 32 17
9 Al-Tadhamon Al-Tadhamon 18 21 39 13
10 Al Yarmouk Al Yarmouk 18 16 39 8
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Kuwait SC Kuwait SC 18 52 14 42
2 Al Qadsia Al Qadsia 18 34 15 36
3 Al Salmiyah Al Salmiyah 18 31 23 33
4 Kazma SC Kazma SC 18 30 24 28
5 Al Arabi Al Arabi 18 27 24 27
6 Al Nasar Al Nasar 18 16 26 18
7 Al-Tadhamon Al-Tadhamon 18 18 27 17
8 Al Shabab Al Shabab 18 18 39 16
9 Al Jahra Al Jahra 18 16 29 15
10 Al Fahaheel Al Fahaheel 18 21 42 13
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Kuwait SC Kuwait SC 22 53 20 50
2 Al Qadsia Al Qadsia 22 41 25 36
3 Al Salmiyah Al Salmiyah 22 32 35 33
4 Kazma SC Kazma SC 22 31 30 30
5 Al Jahra Al Jahra 22 41 41 29
6 Al Nasar Al Nasar 22 33 40 29
7 Al Arabi Al Arabi 22 31 32 27
8 Al-Tadhamon Al-Tadhamon 22 33 72 10
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Kuwait SC Kuwait SC 28 70 17 69
2 Al Qadsia Al Qadsia 28 57 17 67
3 Al Nasar Al Nasar 28 49 30 57
4 Al Arabi Al Arabi 28 55 36 51
5 Kazma SC Kazma SC 28 54 36 46
6 Al Salmiyah Al Salmiyah 28 47 33 43
7 Al Jahra Al Jahra 28 52 51 40
8 Al-Tadhamon Al-Tadhamon 28 39 37 39
9 Al Fahaheel Al Fahaheel 28 39 43 38
10 Al Shabab Al Shabab 28 39 46 29
11 Al Yarmouk Al Yarmouk 28 37 46 27
12 Khaitan Khaitan 28 25 56 22
13 Al Sahel Al Sahel 28 27 61 22
14 Al Sulaibikhat Sulaibikhat 28 27 41 21
15 Burgan Burgan 28 23 90 11
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Al Qadsia Al Qadsia 25 79 12 65
2 Al Salmiyah Al Salmiyah 24 52 19 60
3 Kuwait SC Kuwait SC 24 54 16 56
4 Kazma SC Kazma SC 24 55 32 44
5 Al Arabi Al Arabi 24 49 31 36
6 Khaitan Khaitan 24 28 46 30
7 Al Fahaheel Al Fahaheel 25 29 43 27
8 Al Sahel Al Sahel 24 24 39 27
9 Al Jahra Al Jahra 24 31 54 27
10 Al Sulaibikhat Sulaibikhat 24 28 46 24
11 Al Shabab Al Shabab 24 24 49 24
12 Al Yarmouk Al Yarmouk 24 23 46 15
13 Al Nasar Al Nasar 24 13 56 6
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Kuwait SC Kuwait SC 27 78 14 69
2 Al Arabi Al Arabi 27 69 14 67
3 Al Qadsia Al Qadsia 27 64 21 59
4 Al Jahra Al Jahra 26 57 24 58
5 Al Salmiyah Al Salmiyah 26 70 27 54
6 Kazma SC Kazma SC 26 60 30 53
7 Al Sulaibikhat Sulaibikhat 26 27 35 33
8 Khaitan Khaitan 26 32 40 30
9 Al Nasar Al Nasar 26 24 41 23
10 Al Yarmouk Al Yarmouk 26 28 49 19
11 Al Shabab Al Shabab 26 19 59 18
12 Al Sahel Al Sahel 27 27 80 14
13 Al Fahaheel Al Fahaheel 28 25 76 13
14 Al-Tadhamon Al-Tadhamon 26 18 88 8
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Al Qadsia Al Qadsia 26 66 14 68
2 Kuwait SC Kuwait SC 26 67 19 64
3 Al Jahra Al Jahra 26 46 35 55
4 Kazma SC Kazma SC 26 42 26 52
5 Al Arabi Al Arabi 26 53 29 43
6 Al Salmiyah Al Salmiyah 26 54 47 37
7 Al-Tadhamon Al-Tadhamon 26 45 47 36
8 Al Nasar Al Nasar 26 40 42 33
9 Khaitan Khaitan 26 23 44 28
10 Al Yarmouk Al Yarmouk 26 21 41 27
11 Al Sulaibikhat Sulaibikhat 26 27 51 19
12 Al Sahel Al Sahel 26 28 51 18
13 Al Shabab Al Shabab 26 19 48 18
14 Al Fehaiheel Fehaiheel 26 21 58 13
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Kuwait SC Kuwait SC 21 54 13 53
2 Al Qadsia Al Qadsia 21 39 16 41
3 Al Arabi Al Arabi 21 35 20 39
4 Al Nasar Al Nasar 21 20 29 22
5 Al Jahra Al Jahra 21 15 26 21
6 Al Salmiyah Al Salmiyah 21 15 30 19
7 Kazma SC Kazma SC 21 18 29 18
8 Al Sulaibikhat Sulaibikhat 21 15 48 16
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Al Qadsia Al Qadsia 21 40 10 51
2 Kuwait SC Kuwait SC 21 29 19 40
3 Al Arabi Al Arabi 21 27 20 33
4 Al Salmiyah Al Salmiyah 21 26 34 25
5 Al Jahra Al Jahra 21 25 30 24
6 Kazma SC Kazma SC 21 31 38 22
7 Al Nasar Al Nasar 21 23 35 17
8 Al Shabab Al Shabab 21 20 35 14
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Al Qadsia Al Qadsia 21 47 10 51
2 Kuwait SC Kuwait SC 21 46 17 47
3 Al Arabi Al Arabi 21 28 19 39
4 Kazma SC Kazma SC 21 28 14 38
5 Al Jahra Al Jahra 21 14 31 19
6 Al Nasar Al Nasar 21 18 34 16
7 Al Salmiyah Al Salmiyah 21 17 36 14
8 Al Sahel Al Sahel 21 16 53 12
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Al-Quadsia Al-Quadsia 21 49 14 48
2 Kuwait SC Kuwait SC 21 42 16 46
3 Al Nasar Al Nasar 21 29 21 41
4 Kazma SC Kazma SC 21 40 26 37
5 Al Arabi Al Arabi 21 31 17 30
6 Al Salmiyah Al Salmiyah 21 24 44 20
7 Al-Tadhamon Al-Tadhamon 21 13 45 8
8 Al Sulaibikhat Sulaibikhat 21 15 60 6
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Al-Quadsia Al-Quadsia 21 32 22 40
2 Kazma SC Kazma SC 21 23 22 36
3 Kuwait SC Kuwait SC 21 34 23 35
4 Al Salmiyah Al Salmiyah 21 25 25 31
5 Al Arabi Al Arabi 21 24 18 30
6 Al Nasar Al Nasar 21 24 28 26
7 Al-Tadhamon Al-Tadhamon 21 19 30 19
8 Al Shabab Al Shabab 21 22 35 13
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Kuwait SC Kuwait SC 16 25 10 35
2 Al-Quadsia Al-Quadsia 16 33 11 34
3 Al Salmiyah Al Salmiyah 16 29 14 34
4 Kazma SC Kazma SC 16 28 18 27
5 Al Arabi Al Arabi 16 24 14 25
6 Al-Tadhamon Al-Tadhamon 16 14 25 17
7 Al Nasar Al Nasar 16 16 31 15
8 Al-Sahil Al-Sahil 16 10 32 8
9 Al Jahra Al Jahra 16 13 37 6
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Kazma SC Kazma SC 14 23 8 32
2 Kuwait SC Kuwait SC 14 24 12 32
3 Al Salmiyah Al Salmiyah 14 33 15 31
4 Al-Quadsia Al-Quadsia 14 27 19 25
5 Al Arabi Al Arabi 13 10 19 9
6 Al-Tadhamon Al-Tadhamon 14 15 28 9
7 Al Sahel Al Sahel 13 12 30 9
8 Al Fahaheel Al Fahaheel 14 8 21 8
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Kuwait SC Kuwait SC 26 63 10 66
2 Al Qadsia Al Qadsia 26 67 14 62
3 Al Salmiyah Al Salmiyah 26 78 24 58
4 Al Arabi Al Arabi 26 58 15 56
5 Kazma SC Kazma SC 26 47 20 50
6 Al-Tadhamon Al-Tadhamon 26 34 30 39
7 Al Sahel Al Sahel 26 22 36 31
8 Al Fahaheel Al Fahaheel 26 20 41 31
9 Al Yarmouk Al Yarmouk 26 30 41 27
10 Al Jahra Al Jahra 26 20 41 25
11 Al Nasar Al Nasar 26 21 36 24
12 Khaitan Khaitan 26 15 68 13
13 Al Shabab Al Shabab 26 25 69 12
14 Al Sulaibikhat Sulaibikhat 26 15 70 12
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Al Qadsia Al Qadsia 13 33 10 31
2 Kuwait SC Kuwait SC 13 27 12 27
3 Al Yarmouk Al Yarmouk 13 28 16 25
4 Al Arabi Al Arabi 13 23 13 24
5 Al Sahel Al Sahel 13 22 17 24
6 Kazma SC Kazma SC 13 19 9 23
7 Al Nasar Al Nasar 13 14 16 21
8 Al Salmiyah Al Salmiyah 13 17 13 16
9 Al Fahaheel Al Fahaheel 13 20 29 15
10 Al-Tadhamon Al-Tadhamon 13 21 34 14
11 Al Sulaibikhat Sulaibikhat 13 14 22 13
12 Al Jahra Al Jahra 13 11 21 13
13 Khaitan Khaitan 13 16 28 11
14 Al Shabab Al Shabab 13 9 34 1
JUGADORES DESTACADOS
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,238,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1684
Total Execution Time  0.1703
  CADENA URL  
/premier_league_kuwait2022/grupo1/historico
  GET DATOS  
$_GET['/premier_league_kuwait2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0034  SELECT type FROM routes WHERE alias = 'premier_league_kuwait2022'
0.0074  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_kuwait' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0034  SELECT id,name,alias,stepParent FROM categories WHERE parentId=403 ORDER BY order_id ASC
0.0036  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 65850 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 403 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0037  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 65850 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 59708 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 51113 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 39817 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 36119 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15648 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 4163 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3564 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2232 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1574 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1265 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1063 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1062 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 269 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15557 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15554 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15551 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 22:12:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 22:12:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 22:12:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 22:12:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_kuwait' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0075  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 65850 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65850 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0036  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 65850 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65850 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0038  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 65850 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65850 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0044  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 65850 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC