4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Tusker FC Tusker FC 34 42 17 66
2 Kakamega Homeboyz Kakamega 34 54 33 66
3 Bandari Bandari 34 43 26 57
4 Gor Mahia Gor Mahia 32 36 27 55
5 Nairobi City Stars Nairobi City 34 45 34 52
6 AFC Leopards Leopards 33 43 35 49
7 KCB KCB 34 40 33 49
8 Sofapaka Sofapaka 33 32 26 49
9 Kariobangi Sharks Kariobangi 34 44 40 45
10 Police FC Police FC 33 42 35 44
11 Posta Rangers Posta 34 44 41 44
12 FC Talanta FC Talanta 34 39 43 44
13 Ulinzi Stars Ulinzi Stars 32 21 22 43
14 Nzoia Sugar Nzoia Sugar 34 36 39 37
15 Bidco United FC Bidco United 34 32 40 36
16 Muhoroni Youth Muhoroni 33 32 50 31
17 Vihiga Bullets Vihiga 33 23 58 24
18 Mathare United Mathare 31 18 67 11
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Tusker FC Tusker FC 33 54 27 68
2 KCB KCB 33 45 24 63
3 Bandari Bandari 33 48 38 54
4 AFC Leopards Leopards 31 39 31 51
5 Nairobi City Stars Nairobi City 33 55 49 50
6 Gor Mahia Gor Mahia 31 36 29 48
7 Muhoroni Youth Muhoroni 32 30 32 47
8 Bidco United FC Bidco United 32 29 27 46
9 Kariobangi Sharks Kariobangi 30 40 38 45
10 Kakamega Homeboyz Kakamega 32 45 40 44
11 Sofapaka Sofapaka 33 37 36 44
12 Ulinzi Stars Ulinzi Stars 32 29 29 44
13 Nzoia Sugar Nzoia Sugar 32 34 36 36
14 Posta Rangers Posta 32 42 52 33
15 Mathare United Mathare 32 32 45 30
16 Vihiga Bullets Vihiga 32 19 42 26
17 Western Stima Western 33 31 58 23
18 Zoo Kericho Zoo Kericho 14 8 20 8
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Gor Mahia Gor Mahia 23 47 17 54
2 Kakamega Homeboyz Kakamega 22 45 24 47
3 Tusker FC Tusker FC 22 41 21 46
4 Ulinzi Stars Ulinzi Stars 23 32 15 43
5 KCB KCB 23 37 20 42
6 AFC Leopards Leopards 23 30 17 40
7 Western Stima Western 23 34 27 36
8 Mathare United Mathare 22 33 26 33
9 Bandari Bandari 23 29 27 32
10 Sofapaka Sofapaka 23 34 29 31
11 Posta Rangers Posta 23 28 26 30
12 Kariobangi Sharks Kariobangi 22 27 32 20
13 Muhoroni Youth Muhoroni 23 24 30 20
14 Zoo Kericho Zoo Kericho 22 23 41 16
15 Nzoia Sugar Nzoia Sugar 22 18 39 13
16 Kisumu All Stars Kisumu Stars 22 13 50 9
17 Chemelil Sugar Chemelil 23 11 65 9
18 SoNy Sugar SoNy Sugar 0 0 0 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Gor Mahia Gor Mahia 33 56 24 69
2 Bandari Bandari 34 45 29 64
3 Sofapaka Sofapaka 34 50 30 62
4 Tusker FC Tusker FC 34 49 33 56
5 SoNy Sugar SoNy Sugar 34 41 28 56
6 Mathare United Mathare 34 48 35 55
7 Kakamega Homeboyz Kakamega 34 48 31 52
8 Ulinzi Stars Ulinzi Stars 33 33 30 45
9 Kariobangi Sharks Kariobangi 34 40 37 45
10 KCB KCB 34 38 36 45
11 AFC Leopards Leopards 33 31 39 40
12 Nzoia Sugar Nzoia Sugar 33 31 34 39
13 Western Stima Western 34 27 37 39
14 Chemelil Sugar Chemelil 34 27 41 34
15 Zoo Kericho Zoo Kericho 34 30 49 33
16 Posta Rangers Posta 34 28 36 32
17 Vihiga Bullets Vihiga 34 27 48 26
18 Mount Kenya United Mount Kenya 34 31 83 18
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Gor Mahia Gor Mahia 34 71 31 75
2 Bandari Bandari 34 40 20 62
3 Tusker FC Tusker FC 34 47 35 56
4 Ulinzi Stars Ulinzi Stars 34 38 26 54
5 Sofapaka Sofapaka 34 45 41 53
6 Kariobangi Sharks Kariobangi 34 48 40 51
7 AFC Leopards Leopards 34 47 48 51
8 Mathare United Mathare 34 47 45 48
9 SoNy Sugar SoNy Sugar 34 33 30 45
10 Kakamega Homeboyz Kakamega 34 35 44 44
11 Zoo Kericho Zoo Kericho 34 42 48 42
12 Vihiga Bullets Vihiga 34 29 30 41
13 Nzoia Sugar Nzoia Sugar 34 35 38 41
14 Chemelil Sugar Chemelil 34 24 28 39
15 Posta Rangers Posta 34 27 37 38
16 Mount Kenya United Mount Kenya 34 49 61 37
17 Muhoroni Youth Muhoroni 34 31 53 31
18 Thika United Thika United 34 23 56 23
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Gor Mahia Gor Mahia 34 53 22 74
2 Sofapaka Sofapaka 34 48 31 55
3 Kariobangi Sharks Kariobangi 34 42 26 52
4 Posta Rangers Posta 34 28 22 51
5 Kakamega Homeboyz Kakamega 34 30 23 50
6 Tusker FC Tusker FC 34 33 34 50
7 Ulinzi Stars Ulinzi Stars 34 37 29 48
8 AFC Leopards Leopards 34 26 28 45
9 Nzoia Sugar Nzoia Sugar 34 41 40 44
10 SoNy Sugar SoNy Sugar 34 31 30 43
11 Bandari Bandari 34 29 34 40
12 Zoo Kericho Zoo Kericho 34 39 49 40
13 Mathare United Mathare 34 32 36 39
14 Chemelil Sugar Chemelil 34 28 34 39
15 Mount Kenya United Mount Kenya 34 33 41 39
16 Thika United Thika United 34 27 36 38
17 Western Stima Western 34 31 41 38
18 Muhoroni Youth 2017 Muhoroni 34 28 60 28
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Tusker FC Tusker FC 30 40 25 61
2 Gor Mahia Gor Mahia 30 35 14 57
3 Ulinzi Stars Ulinzi Stars 30 35 25 46
4 Posta Rangers Posta 30 22 15 45
5 Chemelil Sugar Chemelil 30 25 24 45
6 Western Stima Western 30 32 24 44
7 Mathare United Mathare 30 33 29 44
8 Kakamega Homeboyz Kakamega 30 27 25 42
9 SoNy Sugar SoNy Sugar 30 23 21 39
10 Muhoroni Youth 2017 Muhoroni 30 26 32 38
11 Bandari Bandari 30 28 31 37
12 Thika United Thika United 30 24 32 34
13 AFC Leopards Leopards 30 32 38 33
14 Sofapaka Sofapaka 30 34 40 26
15 Ushuru Ushuru 30 24 43 26
16 Nairobi City Stars Nairobi City 30 17 39 19
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Gor Mahia Gor Mahia 30 60 12 78
2 Ulinzi Stars Ulinzi Stars 30 41 25 58
3 Sofapaka Sofapaka 30 39 39 47
4 Muhoroni Youth 2017 Muhoroni 31 32 36 47
5 Bandari Bandari 30 32 25 46
6 Tusker FC Tusker FC 30 46 28 44
7 AFC Leopards Leopards 30 33 30 41
8 Ushuru Ushuru 30 22 28 37
9 Mathare United Mathare 31 35 35 36
10 SoNy Sugar SoNy Sugar 30 23 26 35
11 Western Stima Western 30 25 31 35
12 Thika United Thika United 30 31 42 35
13 Chemelil Sugar Chemelil 30 23 35 32
14 Nairobi City Stars Nairobi City 30 25 37 28
15 KCB KCB 30 34 48 26
16 Nakuru AllStars Nakuru 30 34 58 23
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Gor Mahia Gor Mahia 30 43 21 60
2 Sofapaka Sofapaka 30 49 27 57
3 Tusker FC Tusker FC 30 42 26 53
4 Ulinzi Stars Ulinzi Stars 30 33 20 51
5 Chemelil Sugar Chemelil 30 24 16 48
6 SoNy Sugar SoNy Sugar 30 27 21 41
7 AFC Leopards Leopards 30 30 25 41
8 Muhoroni Youth 2017 Muhoroni 30 24 28 40
9 Thika United Thika United 30 31 31 39
10 Mathare United Mathare 30 19 25 38
11 Western Stima Western 30 26 33 36
12 KRA KRA 30 22 40 33
13 Bandari Bandari 30 23 29 30
14 KCB KCB 30 30 39 29
15 Nairobi City Stars Nairobi City 30 18 35 24
16 Nakuru AllStars Nakuru 30 13 38 17
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Gor Mahia Gor Mahia 30 32 17 58
2 AFC Leopards Leopards 30 39 25 50
3 Sofapaka Sofapaka 30 35 22 50
4 KCB KCB 30 40 22 47
5 Tusker FC Tusker FC 30 30 23 42
6 Bandari Bandari 30 30 28 42
7 Thika United Thika United 30 28 31 42
8 Ulinzi Stars Ulinzi Stars 30 22 21 41
9 Chemelil Sugar Chemelil 30 27 25 40
10 SoNy Sugar SoNy Sugar 30 21 28 35
11 Muhoroni Youth 2017 Muhoroni 30 21 40 35
12 Western Stima Western 30 23 25 32
13 Mathare United Mathare 30 24 27 32
14 Nairobi City Stars Nairobi City 30 24 36 32
15 Kakamega Homeboyz Kakamega 30 22 29 29
16 Karuturi Sport Karuturi 30 17 36 22
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Tusker FC Tusker FC 30 39 14 60
2 Gor Mahia Gor Mahia 30 37 18 59
3 AFC Leopards Leopards 30 45 27 57
4 Sofapaka Sofapaka 30 34 24 48
5 Thika United Thika United 30 36 33 46
6 Ulinzi Stars Ulinzi Stars 30 35 29 45
7 Chemelil Sugar Chemelil 30 18 17 41
8 Mathare United Mathare 30 36 36 41
9 Western Stima Western 30 27 25 40
10 KCB KCB 30 35 31 39
11 SoNy Sugar SoNy Sugar 30 26 26 38
12 Karuturi Sport Karuturi 30 18 26 32
13 Nairobi City Stars Nairobi City 30 16 32 29
14 Muhoroni Youth 2017 Muhoroni 30 19 34 27
15 Oserian Oserian 30 15 33 24
16 Posta Rangers Posta 30 22 53 24
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Tusker FC Tusker FC 30 34 17 58
2 Ulinzi Stars Ulinzi Stars 30 38 20 57
3 Sofapaka Sofapaka 30 42 23 52
4 Gor Mahia Gor Mahia 30 27 22 48
5 AFC Leopards Leopards 30 36 27 46
6 SoNy Sugar SoNy Sugar 30 33 33 44
7 Posta Rangers Posta 30 33 31 43
8 Chemelil Sugar Chemelil 30 30 27 41
9 KCB KCB 30 38 32 40
10 Thika United Thika United 30 36 39 39
11 Western Stima Western 30 21 28 37
12 Mathare United Mathare 30 32 35 34
13 Karuturi Sport Karuturi 30 19 28 34
14 Nairobi City Stars Nairobi City 30 28 34 31
15 Bandari Bandari 30 22 39 31
16 Congo United Congo United 30 18 52 20
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Ulinzi Stars Ulinzi Stars 30 37 16 59
2 Gor Mahia Gor Mahia 30 33 15 56
3 Tusker FC Tusker FC 30 35 19 53
4 Sofapaka Sofapaka 30 39 23 47
5 SoNy Sugar SoNy Sugar 30 26 26 41
6 Mathare United Mathare 30 31 28 39
7 Karuturi Sport Karuturi 30 22 24 38
8 Western Stima Western 30 28 31 38
9 Chemelil Sugar Chemelil 30 22 26 34
10 Thika United Thika United 30 23 30 34
11 Nairobi City Stars Nairobi City 30 25 34 34
12 AFC Leopards Leopards 30 29 41 34
13 Posta Rangers Posta 30 28 37 33
14 KCB KCB 30 29 40 33
15 Red Berets Red Berets 30 27 32 31
16 Mahakama Mahakama 30 21 33 26
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Sofapaka Sofapaka 30 39 21 59
2 Mathare United Mathare 30 39 23 53
3 Thika United Thika United 30 31 19 51
4 Tusker FC Tusker FC 30 47 30 48
5 Gor Mahia Gor Mahia 30 39 33 46
6 Nairobi City Stars Nairobi City 30 30 29 43
7 Karuturi Sport Karuturi 30 19 17 40
8 Chemelil Sugar Chemelil 30 28 28 40
9 SoNy Sugar SoNy Sugar 30 29 31 40
10 Ulinzi Stars Ulinzi Stars 30 24 26 39
11 Western Stima Western 30 29 28 36
12 KCB KCB 30 32 39 34
13 AFC Leopards Leopards 30 28 36 34
14 Red Berets Red Berets 30 28 43 30
15 Bandari Bandari 30 25 41 29
16 Agro-Chemical Agro-Chemica 30 20 43 23

  USO DE MEMORIA  
6,940,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1166
Total Execution Time  0.1185
  CADENA URL  
/premier_league_kenia2022/grupo1/historico
  GET DATOS  
$_GET['/premier_league_kenia2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0018  SELECT type FROM routes WHERE alias = 'premier_league_kenia2022'
0.0044  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_kenia' 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.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=407 ORDER BY order_id ASC
0.0020  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 = 64648 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 407 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0023  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 = 64648 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 60202 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 51222 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2019` 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 = 48572 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 42096 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 38032 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 20350 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 10358 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 4833 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 2913 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 15995 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 15996 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 15997 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 15998 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 10:18:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-20 10:18:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-20 10:18:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-20 10:18:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_kenia' 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.0086  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 = 64648 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64648 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.0021  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 = 64648 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64648 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0022  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 = 64648 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64648 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  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 = 64648 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC