4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
12 Ene 24 Querétaro Sub 18Querétaro 2 - 2 Toluca Sub 18Toluca ...
12 Ene 24 Mazatlán FC Sub 18Mazatlán 1 - 1 Atl. San Luis Sub 18Atl. Luis ...
13 Ene 24 Cruz Azul Sub 18Cruz Azul 1 - 1 Pachuca Sub 18Pachuca ...
13 Ene 24 Chivas Guadalajara Sub 18Chivas 2 - 1 Santos Laguna Sub 18Santos ...
13 Ene 24 Monterrey Sub 18Monterrey 2 - 1 Puebla Sub 18Puebla ...
13 Ene 24 Tijuana Sub 18Tijuana 1 - 3 América Sub 18América ...
14 Ene 24 Pumas UNAM Sub 18Pumas UNAM 2 - 0 FC Juárez Sub 18Juárez ...
14 Ene 24 Necaxa Sub 18Necaxa 1 - 1 Atlas Guadalajara Sub 18Atlas ...
17 Ene 24 León Sub 18León 4 - 1 Tigres UANL Sub 18Tigres UANL ...
Ver jornada
Jornada 2
19 Ene 24 Puebla Sub 18Puebla 2 - 1 Necaxa Sub 18Necaxa ...
19 Ene 24 Atl. San Luis Sub 18Atl. Luis 0 - 0 Pumas UNAM Sub 18Pumas UNAM ...
19 Ene 24 FC Juárez Sub 18Juárez 1 - 1 Cruz Azul Sub 18Cruz Azul ...
20 Ene 24 América Sub 18América 0 - 2 Querétaro Sub 18Querétaro ...
20 Ene 24 Toluca Sub 18Toluca 1 - 1 Mazatlán FC Sub 18Mazatlán ...
20 Ene 24 Atlas Guadalajara Sub 18Atlas 4 - 1 Tijuana Sub 18Tijuana ...
21 Ene 24 Santos Laguna Sub 18Santos 2 - 2 Monterrey Sub 18Monterrey ...
21 Ene 24 Tigres UANL Sub 18Tigres UANL 2 - 0 Chivas Guadalajara Sub 18Chivas ...
07 Feb 24 Pachuca Sub 18Pachuca 5 - 2 León Sub 18León ...
Ver jornada
Jornada 3
26 Ene 24 Puebla Sub 18Puebla 1 - 1 Toluca Sub 18Toluca ...
26 Ene 24 Tijuana Sub 18Tijuana 2 - 4 Chivas Guadalajara Sub 18Chivas ...
27 Ene 24 León Sub 18León 0 - 1 Santos Laguna Sub 18Santos ...
27 Ene 24 Cruz Azul Sub 18Cruz Azul 2 - 0 Mazatlán FC Sub 18Mazatlán ...
27 Ene 24 Monterrey Sub 18Monterrey 2 - 1 Atl. San Luis Sub 18Atl. Luis ...
27 Ene 24 Necaxa Sub 18Necaxa 2 - 1 América Sub 18América ...
28 Ene 24 Atlas Guadalajara Sub 18Atlas 4 - 0 FC Juárez Sub 18Juárez ...
28 Ene 24 Pumas UNAM Sub 18Pumas UNAM 1 - 4 Pachuca Sub 18Pachuca ...
28 Ene 24 Querétaro Sub 18Querétaro 1 - 0 Tigres UANL Sub 18Tigres UANL ...
Ver jornada
Jornada 4
24 Ene 24 Atl. San Luis Sub 18Atl. Luis 2 - 1 Tigres UANL Sub 18Tigres UANL ...
24 Ene 24 Monterrey Sub 18Monterrey 2 - 2 Querétaro Sub 18Querétaro ...
24 Ene 24 FC Juárez Sub 18Juárez 0 - 2 América Sub 18América ...
30 Ene 24 Cruz Azul Sub 18Cruz Azul 1 - 2 Tijuana Sub 18Tijuana ...
30 Ene 24 Chivas Guadalajara Sub 18Chivas 1 - 0 Toluca Sub 18Toluca ...
30 Ene 24 Mazatlán FC Sub 18Mazatlán 1 - 1 León Sub 18León ...
30 Ene 24 Santos Laguna Sub 18Santos 4 - 2 Puebla Sub 18Puebla ...
31 Ene 24 Pumas UNAM Sub 18Pumas UNAM 3 - 2 Necaxa Sub 18Necaxa ...
31 Ene 24 Pachuca Sub 18Pachuca 4 - 0 Atlas Guadalajara Sub 18Atlas ...
Ver jornada
Jornada 5
02 Feb 24 Puebla Sub 18Puebla 1 - 1 Mazatlán FC Sub 18Mazatlán ...
02 Feb 24 Querétaro Sub 18Querétaro 1 - 0 Cruz Azul Sub 18Cruz Azul ...
03 Feb 24 América Sub 18América 1 - 1 Monterrey Sub 18Monterrey ...
03 Feb 24 Toluca Sub 18Toluca 1 - 2 León Sub 18León ...
03 Feb 24 FC Juárez Sub 18Juárez 0 - 2 Necaxa Sub 18Necaxa ...
03 Feb 24 Tigres UANL Sub 18Tigres UANL 2 - 1 Pumas UNAM Sub 18Pumas UNAM ...
03 Feb 24 Pachuca Sub 18Pachuca 0 - 1 Tijuana Sub 18Tijuana ...
04 Feb 24 Atlas Guadalajara Sub 18Atlas 1 - 0 Santos Laguna Sub 18Santos ...
04 Feb 24 Atl. San Luis Sub 18Atl. Luis 0 - 1 Chivas Guadalajara Sub 18Chivas ...
Ver jornada
Jornada 6
09 Feb 24 Mazatlán FC Sub 18Mazatlán 2 - 0 Atlas Guadalajara Sub 18Atlas ...
09 Feb 24 Tijuana Sub 18Tijuana 3 - 0 Querétaro Sub 18Querétaro ...
10 Feb 24 Santos Laguna Sub 18Santos 2 - 0 Tigres UANL Sub 18Tigres UANL ...
10 Feb 24 León Sub 18León 1 - 2 América Sub 18América ...
10 Feb 24 Necaxa Sub 18Necaxa 0 - 1 Toluca Sub 18Toluca ...
10 Feb 24 Chivas Guadalajara Sub 18Chivas 5 - 1 FC Juárez Sub 18Juárez ...
10 Feb 24 Cruz Azul Sub 18Cruz Azul 0 - 0 Atl. San Luis Sub 18Atl. Luis ...
10 Feb 24 Monterrey Sub 18Monterrey 4 - 2 Pachuca Sub 18Pachuca ...
11 Feb 24 Pumas UNAM Sub 18Pumas UNAM 2 - 1 Puebla Sub 18Puebla ...
Ver jornada
Jornada 7
16 Feb 24 Querétaro Sub 18Querétaro 1 - 0 Necaxa Sub 18Necaxa ...
16 Feb 24 Mazatlán FC Sub 18Mazatlán 0 - 1 Chivas Guadalajara Sub 18Chivas ...
17 Feb 24 FC Juárez Sub 18Juárez 2 - 1 Puebla Sub 18Puebla ...
17 Feb 24 Atl. San Luis Sub 18Atl. Luis 2 - 1 Tijuana Sub 18Tijuana ...
17 Feb 24 Cruz Azul Sub 18Cruz Azul 1 - 1 Tigres UANL Sub 18Tigres UANL ...
17 Feb 24 Pachuca Sub 18Pachuca 4 - 0 América Sub 18América ...
18 Feb 24 Atlas Guadalajara Sub 18Atlas 3 - 0 León Sub 18León ...
18 Feb 24 Pumas UNAM Sub 18Pumas UNAM 0 - 0 Santos Laguna Sub 18Santos ...
18 Feb 24 Monterrey Sub 18Monterrey 2 - 0 Toluca Sub 18Toluca ...
Ver jornada
Jornada 8
23 Feb 24 Puebla Sub 18Puebla 0 - 3 Querétaro Sub 18Querétaro ...
23 Feb 24 Necaxa Sub 18Necaxa 1 - 0 Pachuca Sub 18Pachuca ...
23 Feb 24 FC Juárez Sub 18Juárez 0 - 2 Monterrey Sub 18Monterrey ...
24 Feb 24 León Sub 18León 2 - 1 Atl. San Luis Sub 18Atl. Luis ...
24 Feb 24 América Sub 18América 3 - 1 Cruz Azul Sub 18Cruz Azul ...
24 Feb 24 Chivas Guadalajara Sub 18Chivas 2 - 0 Pumas UNAM Sub 18Pumas UNAM ...
24 Feb 24 Tigres UANL Sub 18Tigres UANL 1 - 0 Atlas Guadalajara Sub 18Atlas ...
25 Feb 24 Santos Laguna Sub 18Santos 1 - 1 Mazatlán FC Sub 18Mazatlán ...
25 Feb 24 Toluca Sub 18Toluca 4 - 2 Tijuana Sub 18Tijuana ...
Ver jornada
Jornada 9
14 Feb 24 Atlas Guadalajara Sub 18Atlas 0 - 1 Pumas UNAM Sub 18Pumas UNAM ...
27 Mar 24 Puebla Sub 18Puebla 0 - 1 Pachuca Sub 18Pachuca ...
20 Feb 24 Necaxa Sub 18Necaxa 1 - 0 Chivas Guadalajara Sub 18Chivas ...
21 Feb 24 León Sub 18León 1 - 2 Cruz Azul Sub 18Cruz Azul ...
21 Feb 24 América Sub 18América 3 - 2 Mazatlán FC Sub 18Mazatlán ...
21 Feb 24 Toluca Sub 18Toluca 5 - 1 Santos Laguna Sub 18Santos ...
27 Feb 24 Querétaro Sub 18Querétaro 1 - 1 Atl. San Luis Sub 18Atl. Luis ...
28 Feb 24 Tigres UANL Sub 18Tigres UANL 0 - 0 FC Juárez Sub 18Juárez ...
28 Feb 24 Tijuana Sub 18Tijuana 0 - 2 Monterrey Sub 18Monterrey ...
Ver jornada
Jornada 10
01 Mar 24 Querétaro Sub 18Querétaro 2 - 1 Santos Laguna Sub 18Santos ...
01 Mar 24 Atl. San Luis Sub 18Atl. Luis 2 - 1 Puebla Sub 18Puebla ...
01 Mar 24 Mazatlán FC Sub 18Mazatlán 1 - 0 Necaxa Sub 18Necaxa ...
02 Mar 24 Toluca Sub 18Toluca 1 - 0 Tigres UANL Sub 18Tigres UANL ...
02 Mar 24 Cruz Azul Sub 18Cruz Azul 0 - 1 Chivas Guadalajara Sub 18Chivas ...
02 Mar 24 América Sub 18América 2 - 0 Atlas Guadalajara Sub 18Atlas ...
02 Mar 24 Pachuca Sub 18Pachuca 2 - 0 FC Juárez Sub 18Juárez ...
03 Mar 24 Monterrey Sub 18Monterrey 1 - 0 Pumas UNAM Sub 18Pumas UNAM ...
03 Mar 24 Tijuana Sub 18Tijuana 2 - 1 León Sub 18León ...
Ver jornada
Jornada 11
08 Mar 24 Puebla Sub 18Puebla 0 - 1 Atlas Guadalajara Sub 18Atlas ...
08 Mar 24 FC Juárez Sub 18Juárez 0 - 0 Toluca Sub 18Toluca ...
08 Mar 24 Necaxa Sub 18Necaxa 1 - 0 Atl. San Luis Sub 18Atl. Luis ...
09 Mar 24 Santos Laguna Sub 18Santos 0 - 1 Cruz Azul Sub 18Cruz Azul ...
09 Mar 24 América Sub 18América 2 - 0 Tigres UANL Sub 18Tigres UANL ...
09 Mar 24 Chivas Guadalajara Sub 18Chivas 2 - 0 León Sub 18León ...
09 Mar 24 Pachuca Sub 18Pachuca 1 - 1 Querétaro Sub 18Querétaro ...
10 Mar 24 Pumas UNAM Sub 18Pumas UNAM 3 - 0 Tijuana Sub 18Tijuana ...
10 Mar 24 Monterrey Sub 18Monterrey 0 - 1 Mazatlán FC Sub 18Mazatlán ...
Ver jornada
Jornada 12
15 Mar 24 Querétaro Sub 18Querétaro 0 - 0 FC Juárez Sub 18Juárez ...
15 Mar 24 Tijuana Sub 18Tijuana 2 - 0 Santos Laguna Sub 18Santos ...
16 Mar 24 León Sub 18León 2 - 1 Puebla Sub 18Puebla ...
16 Mar 24 Cruz Azul Sub 18Cruz Azul 1 - 1 Necaxa Sub 18Necaxa ...
16 Mar 24 Toluca Sub 18Toluca 1 - 0 Pumas UNAM Sub 18Pumas UNAM ...
16 Mar 24 Tigres UANL Sub 18Tigres UANL 1 - 4 Mazatlán FC Sub 18Mazatlán ...
16 Mar 24 Chivas Guadalajara Sub 18Chivas 2 - 0 América Sub 18América ...
17 Mar 24 Atlas Guadalajara Sub 18Atlas 3 - 3 Monterrey Sub 18Monterrey ...
17 Mar 24 Atl. San Luis Sub 18Atl. Luis 0 - 1 Pachuca Sub 18Pachuca ...
Ver jornada
Jornada 13
20 Mar 24 Puebla Sub 18Puebla 1 - 1 Tigres UANL Sub 18Tigres UANL ...
29 Mar 24 Mazatlán FC Sub 18Mazatlán 0 - 1 Tijuana Sub 18Tijuana ...
30 Mar 24 América Sub 18América 1 - 1 Atl. San Luis Sub 18Atl. Luis ...
13 Mar 24 Monterrey Sub 18Monterrey 4 - 3 Chivas Guadalajara Sub 18Chivas ...
30 Mar 24 Pumas UNAM Sub 18Pumas UNAM 1 - 1 Cruz Azul Sub 18Cruz Azul ...
30 Mar 24 Pachuca Sub 18Pachuca 3 - 1 Toluca Sub 18Toluca ...
31 Mar 24 Atlas Guadalajara Sub 18Atlas 1 - 0 Querétaro Sub 18Querétaro ...
31 Mar 24 Necaxa Sub 18Necaxa 2 - 0 León Sub 18León ...
24 Abr 24 FC Juárez Sub 18Juárez 1 - 5 Santos Laguna Sub 18Santos ...
Ver jornada
Jornada 14
05 Abr 24 Mazatlán FC Sub 18Mazatlán 1 - 0 Pumas UNAM Sub 18Pumas UNAM ...
05 Abr 24 Tijuana Sub 18Tijuana 3 - 2 Necaxa Sub 18Necaxa ...
06 Abr 24 Santos Laguna Sub 18Santos 0 - 0 América Sub 18América ...
06 Abr 24 León Sub 18León 1 - 0 Querétaro Sub 18Querétaro ...
06 Abr 24 Chivas Guadalajara Sub 18Chivas 2 - 0 Puebla Sub 18Puebla ...
06 Abr 24 Tigres UANL Sub 18Tigres UANL 3 - 0 Pachuca Sub 18Pachuca ...
06 Abr 24 Cruz Azul Sub 18Cruz Azul 1 - 0 Monterrey Sub 18Monterrey ...
07 Abr 24 Toluca Sub 18Toluca 3 - 1 Atlas Guadalajara Sub 18Atlas ...
07 Abr 24 Atl. San Luis Sub 18Atl. Luis 3 - 0 FC Juárez Sub 18Juárez ...
Ver jornada
Jornada 15
12 Abr 24 Puebla Sub 18Puebla 2 - 0 Cruz Azul Sub 18Cruz Azul ...
12 Abr 24 Querétaro Sub 18Querétaro 0 - 0 Mazatlán FC Sub 18Mazatlán ...
12 Abr 24 Necaxa Sub 18Necaxa 1 - 2 Santos Laguna Sub 18Santos ...
13 Abr 24 América Sub 18América 1 - 1 Toluca Sub 18Toluca ...
13 Abr 24 Monterrey Sub 18Monterrey 2 - 1 Tigres UANL Sub 18Tigres UANL ...
13 Abr 24 Pachuca Sub 18Pachuca 1 - 0 Chivas Guadalajara Sub 18Chivas ...
14 Abr 24 Atlas Guadalajara Sub 18Atlas 1 - 1 Atl. San Luis Sub 18Atl. Luis ...
14 Abr 24 Pumas UNAM Sub 18Pumas UNAM 3 - 0 León Sub 18León ...
14 Abr 24 FC Juárez Sub 18Juárez 2 - 0 Tijuana Sub 18Tijuana ...
Ver jornada
Jornada 16
19 Abr 24 Atl. San Luis Sub 18Atl. Luis 2 - 1 Toluca Sub 18Toluca ...
19 Abr 24 Mazatlán FC Sub 18Mazatlán 1 - 0 FC Juárez Sub 18Juárez ...
22 Abr 24 Tijuana Sub 18Tijuana 2 - 0 Puebla Sub 18Puebla ...
20 Abr 24 León Sub 18León 1 - 3 Monterrey Sub 18Monterrey ...
20 Abr 24 Tigres UANL Sub 18Tigres UANL 1 - 3 Necaxa Sub 18Necaxa ...
20 Abr 24 Chivas Guadalajara Sub 18Chivas 1 - 1 Querétaro Sub 18Querétaro ...
20 Abr 24 Pumas UNAM Sub 18Pumas UNAM 1 - 0 América Sub 18América ...
21 Abr 24 Santos Laguna Sub 18Santos 2 - 0 Pachuca Sub 18Pachuca ...
21 Abr 24 Cruz Azul Sub 18Cruz Azul 2 - 1 Atlas Guadalajara Sub 18Atlas ...
Ver jornada
Jornada 17
26 Abr 24 Puebla Sub 18Puebla 1 - 0 América Sub 18América ...
26 Abr 24 Querétaro Sub 18Querétaro 0 - 1 Pumas UNAM Sub 18Pumas UNAM ...
27 Abr 24 FC Juárez Sub 18Juárez 1 - 5 León Sub 18León ...
27 Abr 24 Tigres UANL Sub 18Tigres UANL 2 - 0 Tijuana Sub 18Tijuana ...
27 Abr 24 Toluca Sub 18Toluca 0 - 1 Cruz Azul Sub 18Cruz Azul ...
27 Abr 24 Atlas Guadalajara Sub 18Atlas 2 - 2 Chivas Guadalajara Sub 18Chivas ...
27 Abr 24 Pachuca Sub 18Pachuca 2 - 2 Mazatlán FC Sub 18Mazatlán ...
28 Abr 24 Santos Laguna Sub 18Santos 3 - 2 Atl. San Luis Sub 18Atl. Luis ...
28 Abr 24 Necaxa Sub 18Necaxa 3 - 2 Monterrey Sub 18Monterrey ...

Clasificación

Equipo PJ GF GC Puntos
1 Chivas Guadalajara Sub 18 Chivas 17 29 15 35
2 Monterrey Sub 18 Monterrey 17 34 22 34
3 Pachuca Sub 18 Pachuca 17 31 19 30
4 Pumas UNAM Sub 18 Pumas UNAM 17 19 15 27
5 Necaxa Sub 18 Necaxa 17 23 19 26
6 Mazatlán FC Sub 18 Mazatlán 17 19 15 25
7 Santos Laguna Sub 18 Santos 17 25 22 25
8 Querétaro Sub 18 Querétaro 17 17 14 25
9 América Sub 18 América 17 21 20 25
10 Cruz Azul Sub 18 Cruz Azul 17 16 16 24
11 Tijuana Sub 18 Tijuana 17 23 30 24
12 Toluca Sub 18 Toluca 17 23 20 23
13 Atlas Guadalajara Sub 18 Atlas 17 23 23 22
14 Atl. San Luis Sub 18 Atl. Luis 17 19 18 21
15 León Sub 18 León 17 23 31 19
16 Tigres UANL Sub 18 Tigres UANL 17 17 24 18
17 Puebla Sub 18 Puebla 17 15 27 12
18 FC Juárez Sub 18 Juárez 17 8 35 10

  USO DE MEMORIA  
6,119,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.4140
Total Execution Time  0.4165
  CADENA URL  
/liga_mexico_sub_18_clausura2024/grupo1/calendario
  GET DATOS  
$_GET['/liga_mexico_sub_18_clausura2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0124  SELECT type FROM routes WHERE alias = 'liga_mexico_sub_18_clausura2024'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_mexico_sub_18_clausura' 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=2495 AND type_rel = 3
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2495 ORDER BY order_id ASC
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2495 GROUP BY l.categoryId
0.0127  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=2495 GROUP BY l.year ORDER BY l.year DESC
0.0127  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 = 75044 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 75044 ORDER BY round ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 11:15:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 11:15:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 11:15:14' 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-05 11:15:14' 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 = 'liga_mexico_sub_18_clausura' 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.0239  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 events2024 e ON e.player_id = p.id AND e.league_id = 75044 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75044 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.0272  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 events2024 e ON e.player_id = p.id AND e.league_id = 75044 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75044 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0134  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 events2024 e ON e.player_id = p.id AND e.league_id = 75044 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75044 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  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 = 75044 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC