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 Rio Branco Acre Branco Acre 5 9 3 11
2 Vasco da Gama AC Vasco Gama 5 12 6 9
3 Independência Independênc 5 7 4 9
4 Senador Guiomard Senador 5 4 3 6
5 Atlético Acreano Atlético 5 1 9 4
6 Andirá EC Andirá EC 5 2 10 1
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Humaitá Humaitá 6 18 4 13
2 Independência Independênc 5 11 3 12
3 Rio Branco Acre Branco Acre 5 8 5 12
4 São Francisco AC São 4 12 7 10
5 Galvez EC Galvez EC 5 17 6 9
6 Atlético Acreano Atlético 4 12 6 7
7 Plácido de Castro Plácido 5 12 14 6
8 Náuas Náuas 4 6 13 3
9 Senador Guiomard Senador 5 4 14 3
10 Andirá EC Andirá EC 5 5 18 0
11 Vasco da Gama AC Vasco Gama 4 4 19 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Senador Guiomard Senador 5 8 3 10
2 Náuas Náuas 5 3 2 8
3 Plácido de Castro Plácido 5 10 6 7
4 Rio Branco Acre Branco Acre 5 7 5 7
5 Atlético Acreano Atlético 5 3 6 5
6 Vasco da Gama AC Vasco Gama 5 5 14 3
7 Humaitá Humaitá 4 8 2 8
8 Galvez EC Galvez EC 4 9 2 7
9 São Francisco AC São 4 4 5 5
10 Independência Independênc 4 5 11 4
11 Andirá EC Andirá EC 4 5 11 2
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Humaitá Humaitá 8 20 3 20
2 Atlético Acreano Atlético 8 15 1 20
3 Galvez EC Galvez EC 8 17 6 17
4 Rio Branco Acre Branco Acre 8 15 8 11
5 Vasco da Gama AC Vasco Gama 8 13 13 10
6 São Francisco AC São 8 9 12 8
7 Náuas Náuas 8 3 14 8
8 Andirá EC Andirá EC 8 8 16 6
9 Plácido de Castro Plácido 8 9 36 1
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Atlético Acreano Atlético 4 12 3 9
2 Plácido de Castro Plácido 4 12 5 9
3 Rio Branco Acre Branco Acre 4 12 11 9
4 Andirá EC Andirá EC 4 7 9 3
5 São Francisco AC São 4 4 19 0
6 Galvez EC Galvez EC 3 14 2 9
7 Humaitá Humaitá 3 5 5 6
8 Náuas Náuas 3 6 3 3
9 Independência Independênc 0 0 0 0
10 Vasco da Gama AC Vasco Gama 3 2 17 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Atlético Acreano Atlético 5 12 0 13
2 Independência Independênc 5 11 6 10
3 Rio Branco Acre Branco Acre 5 15 8 9
4 Humaitá Humaitá 5 4 7 7
5 Andirá EC Andirá EC 5 6 10 5
6 Galvez EC Galvez EC 5 13 4 12
7 Plácido de Castro Plácido 5 5 6 5
8 Náuas Náuas 5 3 9 4
9 São Francisco AC São 5 5 17 3
10 Vasco da Gama AC Vasco Gama 5 5 12 2
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Plácido de Castro Plácido 4 7 3 10
2 Atlético Acreano Atlético 4 12 2 9
3 Humaitá Humaitá 4 6 7 6
4 Andirá EC Andirá EC 4 2 10 3
5 Rio Branco Acre Branco Acre 4 9 3 9
6 Galvez EC Galvez EC 4 8 3 7
7 Vasco da Gama AC Vasco Gama 4 4 7 3
8 São Francisco AC São 4 1 14 0
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 7 22 8 17
2 Atlético Acreano Atlético 7 19 7 15
3 Plácido de Castro Plácido 7 17 14 13
4 Galvez EC Galvez EC 7 13 10 13
5 Humaitá Humaitá 7 11 14 10
6 Vasco da Gama AC Vasco Gama 7 11 12 9
7 Andirá EC Andirá EC 7 8 23 4
8 Alto Acre FC Alto Acre 7 6 19 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 7 19 1 19
2 Atlético Acreano Atlético 7 19 7 18
3 Galvez EC Galvez EC 7 19 9 16
4 Alto Acre FC Alto Acre 7 8 12 9
5 Vasco da Gama AC Vasco Gama 7 9 14 7
6 Plácido de Castro Plácido 7 4 15 5
7 Andirá EC Andirá EC 7 9 18 4
8 Amax Amax 7 9 20 3
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Atlético Acreano Atlético 14 36 9 35
2 Rio Branco Acre Branco Acre 14 48 12 30
3 Plácido de Castro Plácido 14 23 19 23
4 Galvez EC Galvez EC 14 23 20 23
5 Amax Amax 14 19 21 19
6 Vasco da Gama AC Vasco Gama 14 22 35 11
7 Alto Acre FC Alto Acre 14 18 41 11
8 Náuas Náuas 14 9 41 7
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Atlético Acreano Atlético 14 29 9 36
2 Rio Branco Acre Branco Acre 14 27 7 30
3 Plácido de Castro Plácido 14 28 13 25
4 Galvez EC Galvez EC 14 26 23 19
5 Vasco da Gama AC Vasco Gama 14 28 29 15
6 Náuas Náuas 14 19 27 15
7 Alto Acre FC Alto Acre 14 15 39 11
8 Andirá EC Andirá EC 14 11 36 7
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 14 44 8 34
2 Atlético Acreano Atlético 14 24 13 30
3 Plácido de Castro Plácido 14 24 14 28
4 Galvez EC Galvez EC 14 32 14 24
5 Juventus AC Juventus AC 14 32 30 19
6 Alto Acre FC Alto Acre 14 18 31 11
7 Andirá EC Andirá EC 14 14 39 9
8 Náuas Náuas 14 14 53 5
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 14 48 20 34
2 Independência Independênc 14 22 20 25
3 Atlético Acreano Atlético 14 28 20 24
4 Juventus AC Juventus AC 14 29 22 20
5 Plácido de Castro Plácido 14 19 24 20
6 Andirá EC Andirá EC 14 23 35 16
7 Náuas Náuas 14 23 23 15
8 Alto Acre FC Alto Acre 14 12 40 3
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Juventus AC Juventus AC 14 37 14 33
2 Atlético Acreano Atlético 14 35 14 33
3 Rio Branco Acre Branco Acre 14 33 19 28
4 Plácido de Castro Plácido 14 23 15 19
5 Náuas Náuas 14 18 26 16
6 ADESG ADESG 14 16 31 15
7 Alto Acre FC Alto Acre 14 13 25 12
8 Independência Independênc 14 13 44 4
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 9 28 10 24
2 Náuas Náuas 9 17 4 22
3 Atlético Acreano Atlético 9 24 14 17
4 Juventus AC Juventus AC 9 20 12 15
5 Alto Acre FC Alto Acre 9 12 12 13
6 Plácido de Castro Plácido 9 15 11 11
7 Independência Independênc 9 17 29 8
8 ADESG ADESG 9 16 25 7
9 Vasco da Gama AC Vasco Gama 9 11 24 6
10 Andirá EC Andirá EC 9 10 29 1
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 4 11 5 10
2 Atlético Acreano Atlético 4 11 7 7
3 Vasco da Gama AC Vasco Gama 4 7 6 6
4 Plácido de Castro Plácido 4 7 10 4
5 Independência Independênc 4 2 10 1
6 Juventus AC Juventus AC 4 7 0 10
7 Andirá EC Andirá EC 4 9 5 7
8 Náuas Náuas 4 7 6 6
9 São Francisco AC São 4 5 9 3
10 ADESG ADESG 4 2 10 3
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 8 31 11 21
2 Juventus AC Juventus AC 8 19 6 20
3 Plácido de Castro Plácido 8 15 9 16
4 Náuas Náuas 8 17 18 11
5 ADESG ADESG 8 13 13 10
6 Independência Independênc 8 14 20 10
7 Vasco da Gama AC Vasco Gama 8 13 17 9
8 São Francisco AC São 8 7 20 4
9 Atlético Acreano Atlético 8 6 21 3
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 6 24 5 16
2 Andirá EC Andirá EC 6 7 5 11
3 ADESG ADESG 6 11 14 8
4 Vasco da Gama AC Vasco Gama 6 9 13 8
5 Independência Independênc 6 8 9 7
6 Atlético Acreano Atlético 6 5 8 4
7 São Francisco AC São 6 5 15 4
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 3 7 2 9
2 Andirá EC Andirá EC 3 8 2 6
3 Vasco da Gama AC Vasco Gama 3 3 5 3
4 Atlético Acreano Atlético 3 1 10 0
5 ADESG ADESG 3 6 1 7
6 Independência Independênc 3 5 2 5
7 Juventus AC Juventus AC 3 6 7 4
8 São Francisco AC São 3 2 9 0
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 ADESG ADESG 5 11 5 12
2 Rio Branco Acre Branco Acre 5 18 3 10
3 Juventus AC Juventus AC 5 6 7 6
4 Atlético Acreano Atlético 5 3 4 6
5 Independência Independênc 5 4 12 4
6 Vasco da Gama AC Vasco Gama 5 5 16 4

  USO DE MEMORIA  
5,799,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1269
Total Execution Time  0.1290
  CADENA URL  
/acreano2024/grupo1/historico
  GET DATOS  
$_GET['/acreano2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0018  SELECT type FROM routes WHERE alias = 'acreano2024'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'acreano' 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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1729 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1729 ORDER BY order_id ASC
0.0019  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 = 74981 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1729 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 74981 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.0021  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 = 70774 AND t.round = 2 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 `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 = 66333 AND t.round = 4 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 `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 = 61663 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 53472 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 48420 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 42234 AND t.round = 4 ORDER BY team.conference 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 `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 = 37732 AND t.round = 7 ORDER BY team.conference 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 `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 = 20105 AND t.round = 7 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 = 11110 AND t.round = 14 ORDER BY team.conference 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 `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 = 14541 AND t.round = 14 ORDER BY team.conference 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 `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 = 14543 AND t.round = 14 ORDER BY team.conference 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 `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 = 14545 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 14547 AND t.round = 14 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 = 14549 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 14551 AND t.round = 4 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 14554 AND t.round = 9 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 `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 = 14556 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 14558 AND t.round = 3 ORDER BY team.conference 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 `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 = 14561 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:32:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:32:48' 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-27 23:32:48' 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-27 23:32:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'acreano' 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.0025  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1729 AND l.year = 2024
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74981,75160,75792,75793) 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.0025  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 (74981,75160,75792,75793) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (639512,476457,996512,1031448,838180,3220867,3386531,368638,512802,934301) ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1729 AND l.year = 2024
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74981,75160,75792,75793) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0023  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 (74981,75160,75792,75793) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (913097,981452,3243553,274665,347744,362993,424583,511641,838180,860595) ORDER BY rp.in_squad = 1 DESC
0.0029  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1729 AND l.year = 2024
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74981,75160,75792,75793) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0026  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 (74981,75160,75792,75793) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3243553,474169,615360,838180,860595,981452,3150607,3160491,3271426,3302492) ORDER BY rp.in_squad = 1 DESC
0.0030  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 = 74981 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