4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 5 14 5 11
2 Maracanã Maracanã 5 8 5 9
3 Floresta EC Floresta EC 5 7 5 7
4 Caucaia EC Caucaia EC 5 3 10 3
5 Atlético Cearense Atlético 5 2 11 2
6 Ceará Ceará 5 16 4 11
7 Iguatu Iguatu 5 7 5 10
8 Ferroviário Ferroviário 5 6 6 8
9 Horizonte Horizonte 5 5 10 4
10 Barbalha Barbalha 5 2 9 2
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Ceará Ceará 5 14 3 13
2 Fortaleza EC Fortaleza 5 12 4 12
3 Iguatu Iguatu 5 10 6 10
4 Maracanã Maracanã 5 5 4 8
5 Atlético Cearense Atlético 5 5 8 8
6 Ferroviário Ferroviário 5 8 5 7
7 Caucaia EC Caucaia EC 5 8 4 6
8 Pacajus Pacajus 5 6 11 4
9 Barbalha Barbalha 5 6 13 3
10 Guarani de Juazeiro Guarani 5 3 19 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Caucaia EC Caucaia EC 14 20 8 30
2 Ferroviário Ferroviário 14 24 9 26
3 Pacajus Pacajus 14 17 14 20
4 Iguatu Iguatu 14 23 13 19
5 Maracanã Maracanã 14 16 15 17
6 Icasa Icasa 14 9 11 16
7 Atlético Cearense Atlético 14 19 24 13
8 Crato Crato 14 5 39 5
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Ferroviário Ferroviário 7 12 5 16
2 Pacajus Pacajus 7 10 3 15
3 Atlético Cearense Atlético 7 12 9 11
4 Caucaia EC Caucaia EC 7 14 6 10
5 Icasa Icasa 7 9 7 10
6 Crato Crato 7 6 9 5
7 Guarany de Sobral Guarany 7 4 10 5
8 Barbalha Barbalha 7 5 23 4
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Guarany de Sobral Guarany 7 9 3 15
2 Barbalha Barbalha 7 11 3 14
3 Ferroviário Ferroviário 7 6 4 12
4 Caucaia EC Caucaia EC 7 9 8 8
5 Atlético Cearense Atlético 7 8 9 8
6 Pacajus Pacajus 7 4 6 7
7 Floresta EC Floresta EC 7 9 14 6
8 Horizonte Horizonte 7 3 12 2
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Barbalha Barbalha 7 12 5 15
2 Atlético Cearense Atlético 7 14 9 12
3 Ferroviário Ferroviário 7 14 9 11
4 Guarany de Sobral Guarany 7 5 2 11
5 Floresta EC Floresta EC 7 10 11 8
6 Horizonte Horizonte 7 5 6 8
7 Iguatu Iguatu 7 8 15 5
8 Guarani de Juazeiro Guarani 7 1 12 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 9 22 9 21
2 Ceará Ceará 9 22 11 19
3 Iguatu Iguatu 9 14 8 18
4 Ferroviário Ferroviário 9 15 11 17
5 Atlético Cearense Atlético 9 12 12 15
6 Floresta EC Floresta EC 9 13 12 13
7 Horizonte Horizonte 9 12 16 11
8 Guarani de Juazeiro Guarani 9 12 22 6
9 Tiradentes CE Tiradentes 9 13 18 5
10 Maranguape Maranguape 9 3 19 1
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Ceará Ceará 9 12 5 20
2 Fortaleza EC Fortaleza 9 16 5 17
3 Horizonte Horizonte 9 14 11 15
4 Guarani de Juazeiro Guarani 9 15 9 15
5 Maranguape Maranguape 9 11 13 14
6 Ferroviário Ferroviário 9 12 8 13
7 Tiradentes CE Tiradentes 9 15 14 11
8 Atlético Cearense Atlético 9 13 18 9
9 Guarany de Sobral Guarany 9 10 19 6
10 Itapipoca Itapipoca 9 6 22 3
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 8 19 8 19
2 Atlético Cearense Atlético 8 13 9 18
3 Maranguape Maranguape 8 11 12 10
4 Icasa Icasa 8 8 15 5
5 Itapipoca Itapipoca 8 3 10 5
6 Ceará Ceará 8 14 3 21
7 Guarani de Juazeiro Guarani 8 10 6 14
8 Guarany de Sobral Guarany 8 7 7 13
9 Tiradentes CE Tiradentes 8 5 10 6
10 Quixadá Quixadá 8 2 12 2
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Icasa Icasa 8 15 11 16
2 Fortaleza EC Fortaleza 8 13 7 15
3 Quixadá Quixadá 8 10 7 14
4 Horizonte Horizonte 8 10 13 8
5 São Benedito São 8 9 19 3
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 16 48 14 42
2 Guarani de Juazeiro Guarani 16 17 18 26
3 Horizonte Horizonte 16 26 18 25
4 Icasa Icasa 16 18 19 24
5 Quixadá Quixadá 16 25 23 23
6 Itapipoca Itapipoca 16 19 24 21
7 Ferroviário Ferroviário 16 26 25 18
8 Tiradentes CE Tiradentes 16 26 32 12
9 Crato Crato 16 8 40 5
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Ceará Ceará 22 52 17 54
2 Fortaleza EC Fortaleza 22 42 19 52
3 Horizonte Horizonte 22 50 30 44
4 Tiradentes CE Tiradentes 22 36 29 38
5 Crato Crato 22 28 26 34
6 Guarani de Juazeiro Guarani 22 36 36 29
7 Crateús Crateús 22 30 36 26
8 Guarany de Sobral Guarany 22 28 33 25
9 Icasa Icasa 22 22 38 22
10 Ferroviário Ferroviário 22 29 42 21
11 Trairiense Trairiense 22 27 40 17
12 Itapipoca Itapipoca 22 13 47 7
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Ceará Ceará 11 22 7 29
2 Fortaleza EC Fortaleza 11 25 12 24
3 Guarani de Juazeiro Guarani 11 23 15 21
4 Guarany de Sobral Guarany 11 19 13 17
5 Horizonte Horizonte 11 20 17 17
6 Tiradentes CE Tiradentes 11 21 15 15
7 Icasa Icasa 11 9 12 13
8 Itapipoca Itapipoca 11 13 23 13
9 EC Limoeiro EC Limoeiro 11 14 18 11
10 Crato Crato 11 13 20 9
11 Quixadá Quixadá 11 12 25 9
12 Ferroviário Ferroviário 11 12 26 7
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Ferroviário Ferroviário 11 15 8 21
2 Guarany de Sobral Guarany 11 16 11 21
3 Horizonte Horizonte 11 25 16 20
4 Fortaleza EC Fortaleza 11 22 15 20
5 Guarani de Juazeiro Guarani 11 17 17 19
6 Crato Crato 11 16 12 15
7 Ceará Ceará 11 18 14 13
8 Itapipoca Itapipoca 11 16 21 13
9 Quixadá Quixadá 11 19 29 13
10 Maranguape Maranguape 11 13 18 10
11 EC Limoeiro EC Limoeiro 11 17 26 10
12 Boa Viagem EC Viagem 11 13 20 9
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Ceará Ceará 9 17 11 18
2 Ferroviário Ferroviário 9 17 14 18
3 Maranguape Maranguape 9 21 16 16
4 Fortaleza EC Fortaleza 9 18 11 15
5 Horizonte Horizonte 9 17 12 15
6 Guarany de Sobral Guarany 9 8 8 11
7 Itapipoca Itapipoca 9 11 17 10
8 Boa Viagem EC Viagem 9 10 14 8
9 Icasa Icasa 9 12 15 5
10 Quixadá Quixadá 9 10 23 4
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Horizonte Horizonte 9 14 8 17
2 Icasa Icasa 9 14 12 17
3 Fortaleza EC Fortaleza 9 21 13 16
4 Ceará Ceará 9 15 13 16
5 Quixadá Quixadá 9 17 16 14
6 Ferroviário Ferroviário 9 17 17 13
7 Guarani de Juazeiro Guarani 9 11 11 11
8 Itapipoca Itapipoca 9 11 15 11
9 Boa Viagem EC Viagem 9 17 18 9
10 Atlético Cearense Atlético 9 10 24 0
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 18 40 22 38
2 Icasa Icasa 18 44 25 37
3 Ceará Ceará 18 35 24 36
4 Itapipoca Itapipoca 18 37 29 33
5 Ferroviário Ferroviário 18 29 31 23
6 Quixadá Quixadá 18 30 37 22
7 Guarani de Juazeiro Guarani 18 22 31 19
8 Atlético Cearense Atlético 18 20 34 16
9 Maranguape Maranguape 18 29 37 14
10 Itapaje Itapaje 18 25 41 10
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 18 45 22 36
2 Ceará Ceará 18 35 29 33
3 Icasa Icasa 18 29 21 31
4 Ferroviário Ferroviário 18 37 28 29
5 Maranguape Maranguape 18 28 25 22
6 Quixadá Quixadá 18 30 35 22
7 Itapipoca Itapipoca 18 32 33 19
8 Atlético Cearense Atlético 18 28 30 19
9 Guarany de Sobral Guarany 18 14 25 18
10 EC Limoeiro EC Limoeiro 18 21 51 13
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Icasa Icasa 9 10 5 20
2 Ferroviário Ferroviário 9 19 12 19
3 Fortaleza EC Fortaleza 9 17 7 18
4 Quixadá Quixadá 9 13 12 13
5 Ceará Ceará 9 13 18 13
6 Itapipoca Itapipoca 9 14 14 11
7 Atlético Cearense Atlético 9 13 15 9
8 EC Limoeiro EC Limoeiro 9 6 9 9
9 Guarani de Juazeiro Guarani 9 13 19 8
10 Tiradentes CE Tiradentes 9 9 16 5

  USO DE MEMORIA  
5,973,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7207
Total Execution Time  0.7226
  CADENA URL  
/cearense_12024/grupo1/historico
  GET DATOS  
$_GET['/cearense_12024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0144  SELECT type FROM routes WHERE alias = 'cearense_12024'
0.0290  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cearense_1' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=568 ORDER BY order_id ASC
0.0146  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 = 74869 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 568 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0148  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 `tables2024` 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 = 74869 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2023` 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 = 70565 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 66135 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 61237 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 53482 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 47857 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 41615 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 37305 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 19425 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 9065 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 3497 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 13841 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 13840 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 13839 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 13838 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 13837 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 13836 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 13835 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 13834 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 13833 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 11:39:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 11:39:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 11:39:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 11:39:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cearense_1' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 568 AND l.year = 2024
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74869,75449,75450) 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, e.player_id ASC LIMIT 10
0.0151  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (74869,75449,75450) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (912355,668025,112707,202329,219214,267054,315568,603051,838134,921650) ORDER BY rp.in_squad = 1 DESC
0.0150  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 568 AND l.year = 2024
0.0148  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74869,75449,75450) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0149  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (74869,75449,75450) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (429386,3160451,360688,361135,436596,492522,652429,851865,912602,3154713) ORDER BY rp.in_squad = 1 DESC
0.0149  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 568 AND l.year = 2024
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74869,75449,75450) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0150  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (74869,75449,75450) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (32869,3160451,162494,219214,383413,475362,490806,912244,3230158,3381661) ORDER BY rp.in_squad = 1 DESC
0.0154  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 74869 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC