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 Costa Rica Sub 20 Costa Rica 0 0 0 0
2 Cuba Sub 20 Cuba Sub 20 0 0 0 0
3 Estados Unidos Sub 20 Estados 0 0 0 0
4 Jamaica Sub 20 Jamaica 0 0 0 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Estados Unidos Sub 20 Estados 3 15 2 7
2 Cuba Sub 20 Cuba Sub 20 3 7 3 6
3 Canadá Sub 20 Canadá 3 6 3 4
4 Cristóbal y Nieves Sub 20 Cristóbal 3 0 20 0
5 México Sub 20 México 3 13 0 7
6 Haiti Sub 20 Haiti 3 7 4 5
7 Trinidad y Tobago Sub 20 Trinidad 3 7 9 4
8 Surinam Sub 20 Surinam 3 0 14 0
9 El Salvador Sub 20 Salvador 3 9 2 7
10 Guatemala Sub 20 Guatemala 3 6 7 6
11 Panamá Sub 20 Panamá 3 6 3 4
12 Aruba Sub 20 Aruba 3 2 11 0
13 Honduras Sub 20 Honduras 3 9 0 9
14 Costa Rica Sub 20 Costa Rica 3 4 2 4
15 Jamaica Sub 20 Jamaica 3 3 6 4
16 Antigua y Barbuda Sub 20 Antigua 3 0 8 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Costa Rica Sub 20 Costa Rica 0 0 0 0
2 Estados Unidos Sub 20 Estados 0 0 0 0
3 Jamaica Sub 20 Jamaica 0 0 0 0
4 Cristóbal y Nieves Sub 20 Cristóbal 0 0 0 0
5 Aruba Sub 20 Aruba 0 0 0 0
6 Canadá Sub 20 Canadá 0 0 0 0
7 El Salvador Sub 20 Salvador 0 0 0 0
8 México Sub 20 México 0 0 0 0
9 Haiti Sub 20 Haiti 0 0 0 0
10 Panamá Sub 20 Panamá 0 0 0 0
11 Surinam Sub 20 Surinam 0 0 0 0
12 Trinidad y Tobago Sub 20 Trinidad 0 0 0 0
13 Antigua y Barbuda Sub 20 Antigua 0 0 0 0
14 Cuba Sub 20 Cuba Sub 20 0 0 0 0
15 Guatemala Sub 20 Guatemala 0 0 0 0
16 Honduras Sub 20 Honduras 0 0 0 0
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Estados Unidos Sub 20 Estados 5 39 2 15
2 Surinam Sub 20 Surinam 5 18 12 9
3 Puerto Rico Sub 20 Puerto Rico 5 16 15 9
4 Trinidad y Tobago Sub 20 Trinidad 5 12 11 9
5 Vicente y Granadinas Sub 20 Vicente 5 8 15 3
6 Islas Vírgenes EEUU Sub 20 Islas 5 2 40 0
7 México Sub 20 México 5 31 2 13
8 Jamaica Sub 20 Jamaica 5 24 3 13
9 Granada Sub 20 Granada 5 7 14 6
10 Nicaragua Sub 20 Nicaragua 5 4 13 6
11 Aruba Sub 20 Aruba 5 6 20 4
12 San Martín Sub 20 Martín 5 3 23 1
13 Honduras Sub 20 Honduras 5 30 5 15
14 Cuba Sub 20 Cuba Sub 20 5 19 5 12
15 Rep. Dominicana Sub 20 Rep. 5 23 10 9
16 Antigua y Barbuda Sub 20 Antigua 5 10 11 6
17 Belice Sub 20 Belice 5 5 19 3
18 Sint Maarten Sub 20 Sint Maarten 5 4 41 0
19 Panamá Sub 20 Panamá 5 17 3 15
20 Canadá Sub 20 Canadá 5 10 6 9
21 Guadalupe Sub 20 Guadalupe 5 9 8 9
22 Dominica Sub 20 Dominica 5 5 14 6
23 Cristóbal y Nieves Sub 20 Cristóbal 5 7 10 3
24 Martinica Sub 20 Martinica 5 4 11 3
25 Costa Rica Sub 20 Costa Rica 4 14 0 12
26 Haiti Sub 20 Haiti 4 9 1 9
27 Santa Lucía Sub 20 Santa Lucía 4 3 8 6
28 Barbados Sub 20 Barbados 4 1 8 1
29 Bermudas Sub 20 Bermudas 4 0 10 1
30 El Salvador Sub 20 Salvador 4 7 5 9
31 Guatemala Sub 20 Guatemala 4 10 5 7
32 Curazao Sub 20 Curazao 4 10 10 6
33 Islas Caimán Sub 20 Islas 4 8 11 4
34 Guyana Sub 20 Guyana 4 7 11 3
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Antigua y Barbuda Sub 20 Antigua 3 9 2 7
2 Cuba Sub 20 Cuba Sub 20 3 8 3 6
3 Puerto Rico Sub 20 Puerto Rico 3 11 3 4
4 Sint Maarten Sub 20 Sint Maarten 3 0 20 0
5 Trinidad y Tobago Sub 20 Trinidad 3 13 1 7
6 Santa Lucía Sub 20 Santa Lucía 3 4 1 7
7 Guadalupe Sub 20 Guadalupe 3 5 2 3
8 I. Turcas y Caicos Sub 20 Turcas 3 0 18 0
9 Haiti Sub 20 Haiti 3 16 0 9
10 Bermudas Sub 20 Bermudas 3 10 3 6
11 Islas Caimán Sub 20 Islas 3 4 9 3
12 Anguila Sub 20 Anguila 3 1 19 0
13 Cristóbal y Nieves Sub 20 Cristóbal 3 7 4 6
14 Rep. Dominicana Sub 20 Rep. 3 6 3 6
15 Jamaica Sub 20 Jamaica 3 4 4 6
16 Dominica Sub 20 Dominica 3 3 9 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Panamá Sub 20 Panamá 5 9 0 15
2 Estados Unidos Sub 20 Estados 5 12 2 10
3 Guatemala Sub 20 Guatemala 5 6 2 10
4 Trinidad y Tobago Sub 20 Trinidad 5 7 7 4
5 Jamaica Sub 20 Jamaica 5 2 7 2
6 Aruba Sub 20 Aruba 5 1 19 1
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Costa Rica Sub 20 Costa Rica 2 3 2 4
2 Nicaragua Sub 20 Nicaragua 2 3 3 3
3 Honduras Sub 20 Honduras 2 0 1 1
4 El Salvador Sub 20 Salvador 2 4 4 3
5 Panamá Sub 20 Panamá 2 4 4 3
6 Guatemala Sub 20 Guatemala 2 1 1 3
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Haiti Sub 20 Haiti 3 9 0 9
2 Rep. Dominicana Sub 20 Rep. 3 8 2 4
3 Cuba Sub 20 Cuba Sub 20 3 6 4 4
4 Bahamas Sub 20 Bahamas 3 0 17 0
5 Jamaica Sub 20 Jamaica 3 8 0 9
6 Bermudas Sub 20 Bermudas 3 2 5 4
7 Puerto Rico Sub 20 Puerto Rico 3 4 5 3
8 Islas Caimán Sub 20 Islas 3 2 6 1
9 Cristóbal y Nieves Sub 20 Cristóbal 3 8 4 7
10 Aruba Sub 20 Aruba 3 5 5 4
11 Surinam Sub 20 Surinam 3 4 4 3
12 Dominica Sub 20 Dominica 3 2 6 1
13 Vicente y Granadinas Sub 20 Vicente 3 26 2 9
14 Granada Sub 20 Granada 3 19 3 4
15 Guyana Sub 20 Guyana 3 17 4 4
16 Islas Vírgenes Brit. Sub 20 Islas 3 1 54 0
17 Antigua y Barbuda Sub 20 Antigua 3 19 0 9
18 Curazao Sub 20 Curazao 3 11 2 6
19 San Martín Sub 20 Martín 3 8 6 3
20 Anguila Sub 20 Anguila 3 0 30 0
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Bermudas Sub 20 Bermudas 3 18 0 9
2 Bahamas Sub 20 Bahamas 3 18 5 4
3 Islas Vírgenes EEUU Sub 20 Islas 3 6 10 4
4 Islas Vírgenes Brit. Sub 20 Islas 3 0 27 0
5 Rep. Dominicana Sub 20 Rep. 3 15 0 9
6 Cuba Sub 20 Cuba Sub 20 3 13 1 6
7 Islas Caimán Sub 20 Islas 3 2 4 3
8 Anguila Sub 20 Anguila 3 0 25 0
9 Cristóbal y Nieves Sub 20 Cristóbal 3 13 1 9
10 Antigua y Barbuda Sub 20 Antigua 3 5 6 4
11 San Martín Sub 20 Martín 3 3 11 2
12 Dominica Sub 20 Dominica 3 4 7 1
13 Vicente y Granadinas Sub 20 Vicente 3 7 2 9
14 Granada Sub 20 Granada 3 4 3 6
15 Santa Lucía Sub 20 Santa Lucía 3 2 5 1
16 Barbados Sub 20 Barbados 3 1 4 1
17 Surinam Sub 20 Surinam 3 7 4 6
18 Curazao Sub 20 Curazao 3 5 3 6
19 Guyana Sub 20 Guyana 3 5 6 4
20 Aruba Sub 20 Aruba 3 1 5 1
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Trinidad y Tobago Sub 20 Trinidad 3 6 2 6
2 Surinam Sub 20 Surinam 3 4 6 6
3 Barbados Sub 20 Barbados 3 5 4 3
4 Curazao Sub 20 Curazao 3 4 7 3
5 Jamaica Sub 20 Jamaica 2 9 2 6
6 Islas Caimán Sub 20 Islas 2 2 3 3
7 Puerto Rico Sub 20 Puerto Rico 2 1 7 0
8 Haiti Sub 20 Haiti 2 13 1 6
9 Cristóbal y Nieves Sub 20 Cristóbal 2 7 5 3
10 Bahamas Sub 20 Bahamas 2 1 15 0
11 Cuba Sub 20 Cuba Sub 20 3 13 2 9
12 Dominica Sub 20 Dominica 3 4 4 6
13 Granada Sub 20 Granada 3 3 4 3
14 Santa Lucía Sub 20 Santa Lucía 3 2 12 0
Ver
TEMPORADA 1995/1996
Equipo PJ GF GC Puntos
1 México Sub 20 México 3 7 0 9
2 Guatemala Sub 20 Guatemala 3 3 3 4
3 Curazao Sub 20 Curazao 3 1 5 2
4 El Salvador Sub 20 Salvador 3 3 6 1
5 Estados Unidos Sub 20 Estados 3 6 1 7
6 Jamaica Sub 20 Jamaica 3 5 4 6
7 Honduras Sub 20 Honduras 3 3 1 4
8 Martinica Sub 20 Martinica 3 0 8 0
9 Canadá Sub 20 Canadá 3 6 0 9
10 Costa Rica Sub 20 Costa Rica 3 8 2 6
11 Trinidad y Tobago Sub 20 Trinidad 3 6 7 3
12 Nicaragua Sub 20 Nicaragua 3 1 12 0
Ver
TEMPORADA 1991/1992
Equipo PJ GF GC Puntos
1 Cuba Sub 20 Cuba Sub 20 5 20 1 15
2 Guadalupe Sub 20 Guadalupe 5 20 1 12
3 Rep. Dominicana Sub 20 Rep. 5 14 5 9
4 Cristóbal y Nieves Sub 20 Cristóbal 5 3 9 6
5 Puerto Rico Sub 20 Puerto Rico 5 8 14 3
6 Anguila Sub 20 Anguila 5 0 35 0
7 Jamaica Sub 20 Jamaica 3 8 4 6
8 Martinica Sub 20 Martinica 3 7 3 4
9 Santa Lucía Sub 20 Santa Lucía 3 4 5 4
10 Islas Caimán Sub 20 Islas 3 1 8 3
11 Trinidad y Tobago Sub 20 Trinidad 3 9 4 7
12 Guyana Francesa Sub 20 Guyana 2 6 3 4
13 Surinam Sub 20 Surinam 3 6 7 4
14 Guyana Sub 20 Guyana 4 4 11 1
15 Curazao Sub 20 Curazao 2 6 4 6
16 Haiti Sub 20 Haiti 1 3 4 0
17 Barbados Sub 20 Barbados 1 1 2 0
Ver
TEMPORADA 1989/1990
Equipo PJ GF GC Puntos
1 Guatemala Sub 20 Guatemala 2 5 1 6
2 Surinam Sub 20 Surinam 2 2 4 3
3 Bermudas Sub 20 Bermudas 2 2 4 0
4 Trinidad y Tobago Sub 20 Trinidad 2 3 1 4
5 Canadá Sub 20 Canadá 2 1 0 4
6 El Salvador Sub 20 Salvador 2 1 4 0
7 Estados Unidos Sub 20 Estados 2 5 0 6
8 Costa Rica Sub 20 Costa Rica 2 2 3 3
9 Barbados Sub 20 Barbados 2 1 5 0
10 México Sub 20 México 2 9 0 6
11 Honduras Sub 20 Honduras 2 3 4 3
12 Granada Sub 20 Granada 2 1 9 0
Ver
TEMPORADA 1987/1988
Equipo PJ GF GC Puntos
1 Costa Rica Sub 20 Costa Rica 4 9 2 10
2 Estados Unidos Sub 20 Estados 4 7 3 9
3 Trinidad y Tobago Sub 20 Trinidad 4 10 6 7
4 Guatemala Sub 20 Guatemala 4 3 9 3
5 Jamaica Sub 20 Jamaica 4 1 10 0
6 México Sub 20 México 4 15 1 12
7 Cuba Sub 20 Cuba Sub 20 4 3 2 9
8 Canadá Sub 20 Canadá 4 4 4 4
9 Bermudas Sub 20 Bermudas 4 4 7 4
10 Curazao Sub 20 Curazao 4 1 13 0

  USO DE MEMORIA  
5,941,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5707
Total Execution Time  0.5726
  CADENA URL  
/concacaf_sub_202024/grupo1/historico
  GET DATOS  
$_GET['/concacaf_sub_202024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0125  SELECT type FROM routes WHERE alias = 'concacaf_sub_202024'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'concacaf_sub_20' 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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1507 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1507 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1158039,1157432,1157027,1156944,1156750) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1507 ORDER BY order_id ASC
0.0127  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1507 GROUP BY l.categoryId
0.0126  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1507 GROUP BY l.year ORDER BY l.year DESC
0.0125  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 = 75874 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1507 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0127  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 = 75874 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 66901 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 55326 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 45439 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 30090 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 9139 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 43966 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 48035 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 48206 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2003` 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 = 48219 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 `tables1996` 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 = 48234 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1992` 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 = 48242 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1990` 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 = 48245 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1988` 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 = 48247 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 00:52:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 00:52:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 00:52:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 00:52:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'concacaf_sub_20' 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.0131  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1507 AND l.year = 2024
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75874,75875,75876) 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.0131  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1507 AND l.year = 2024
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75874,75875,75876) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0133  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1507 AND l.year = 2024
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75874,75875,75876) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0136  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 = 75874 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC