4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Liga MX Sub 18 - Apertura 2024
2023/2024

Temporada Regular

Liga MX Sub 18 - Apertura 2024

  • Pumas UNAM Sub 18
  • Monterrey Sub 18
  • Necaxa Sub 18
  • Tijuana Sub 18
  • Toluca Sub 18
  • Tigres UANL Sub 18
  • América Sub 18
  • León Sub 18
  • Santos Laguna Sub 18
  • Pachuca Sub 18
  • Atl. San Luis Sub 18
  • Chivas Guadalajara Sub 18
  • Atlas Guadalajara Sub 18
  • Cruz Azul Sub 18
  • Puebla Sub 18
  • Mazatlán FC Sub 18
  • Querétaro Sub 18
  • FC Juárez Sub 18
Ver jornada
Jornada 1
30 Jun 23 América Sub 18América 2 - 0 FC Juárez Sub 18Juárez ...
30 Jun 23 Mazatlán FC Sub 18Mazatlán 1 - 1 Pachuca Sub 18Pachuca ...
30 Jun 23 Tijuana Sub 18Tijuana 0 - 1 Pumas UNAM Sub 18Pumas UNAM ...
01 Jul 23 Atlas Guadalajara Sub 18Atlas 1 - 2 Cruz Azul Sub 18Cruz Azul ...
22 Jul 23 Atl. San Luis Sub 18Atl. Luis 2 - 1 Monterrey Sub 18Monterrey ...
02 Jul 23 Santos Laguna Sub 18Santos 1 - 1 Querétaro Sub 18Querétaro ...
02 Jul 23 Toluca Sub 18Toluca 2 - 1 Necaxa Sub 18Necaxa ...
03 Jul 23 León Sub 18León 1 - 0 Chivas Guadalajara Sub 18Chivas ...
13 Oct 23 Tigres UANL Sub 18Tigres UANL 5 - 1 Puebla Sub 18Puebla ...
Ver jornada
Jornada 2
07 Jul 23 Puebla Sub 18Puebla 1 - 5 Santos Laguna Sub 18Santos ...
08 Jul 23 Cruz Azul Sub 18Cruz Azul 2 - 0 Toluca Sub 18Toluca ...
08 Jul 23 Chivas Guadalajara Sub 18Chivas 0 - 0 Atl. San Luis Sub 18Atl. Luis ...
09 Sep 23 Monterrey Sub 18Monterrey 1 - 0 Atlas Guadalajara Sub 18Atlas ...
09 Jul 23 Querétaro Sub 18Querétaro 2 - 1 América Sub 18América ...
07 Jul 23 Necaxa Sub 18Necaxa 7 - 0 Tijuana Sub 18Tijuana ...
09 Jul 23 Pumas UNAM Sub 18Pumas UNAM 2 - 1 Mazatlán FC Sub 18Mazatlán ...
10 Jul 23 León Sub 18León 1 - 0 Pachuca Sub 18Pachuca ...
05 Ago 23 FC Juárez Sub 18Juárez 1 - 3 Tigres UANL Sub 18Tigres UANL ...
Ver jornada
Jornada 3
13 Jul 23 Santos Laguna Sub 18Santos 5 - 1 Atlas Guadalajara Sub 18Atlas ...
13 Jul 23 Chivas Guadalajara Sub 18Chivas 1 - 2 Necaxa Sub 18Necaxa ...
14 Jul 23 Mazatlán FC Sub 18Mazatlán 3 - 3 Monterrey Sub 18Monterrey ...
14 Jul 23 Tijuana Sub 18Tijuana 1 - 0 Cruz Azul Sub 18Cruz Azul ...
15 Jul 23 América Sub 18América 1 - 1 Puebla Sub 18Puebla ...
15 Jul 23 Atl. San Luis Sub 18Atl. Luis 1 - 2 Querétaro Sub 18Querétaro ...
16 Jul 23 Pachuca Sub 18Pachuca 3 - 2 Pumas UNAM Sub 18Pumas UNAM ...
16 Jul 23 Toluca Sub 18Toluca 3 - 0 FC Juárez Sub 18Juárez ...
12 Ago 23 Tigres UANL Sub 18Tigres UANL 3 - 1 León Sub 18León ...
Ver jornada
Jornada 4
20 Ago 23 Atlas Guadalajara Sub 18Atlas 5 - 1 América Sub 18América ...
14 Oct 23 Cruz Azul Sub 18Cruz Azul 1 - 0 Santos Laguna Sub 18Santos ...
13 Oct 23 FC Juárez Sub 18Juárez 1 - 1 Chivas Guadalajara Sub 18Chivas ...
20 Ago 23 Querétaro Sub 18Querétaro 1 - 4 Pachuca Sub 18Pachuca ...
20 Ago 23 Necaxa Sub 18Necaxa 3 - 1 Tigres UANL Sub 18Tigres UANL ...
18 Ago 23 León Sub 18León 2 - 0 Mazatlán FC Sub 18Mazatlán ...
18 Ago 23 Puebla Sub 18Puebla 1 - 2 Atl. San Luis Sub 18Atl. Luis ...
25 Oct 23 Monterrey Sub 18Monterrey 4 - 2 Tijuana Sub 18Tijuana ...
18 Ago 23 Pumas UNAM Sub 18Pumas UNAM 1 - 0 Toluca Sub 18Toluca ...
Ver jornada
Jornada 5
23 Ago 23 América Sub 18América 1 - 1 Necaxa Sub 18Necaxa ...
23 Ago 23 Atl. San Luis Sub 18Atl. Luis 1 - 0 León Sub 18León ...
22 Ago 23 FC Juárez Sub 18Juárez 1 - 1 Pumas UNAM Sub 18Pumas UNAM ...
30 Ago 23 Querétaro Sub 18Querétaro 0 - 0 Atlas Guadalajara Sub 18Atlas ...
11 Sep 23 Chivas Guadalajara Sub 18Chivas 1 - 1 Tijuana Sub 18Tijuana ...
23 Ago 23 Pachuca Sub 18Pachuca 4 - 0 Cruz Azul Sub 18Cruz Azul ...
09 Sep 23 Mazatlán FC Sub 18Mazatlán 4 - 4 Puebla Sub 18Puebla ...
30 Ago 23 Tigres UANL Sub 18Tigres UANL 2 - 2 Santos Laguna Sub 18Santos ...
13 Oct 23 Toluca Sub 18Toluca 3 - 1 Monterrey Sub 18Monterrey ...
Ver jornada
Jornada 6
25 Ago 23 Puebla Sub 18Puebla 2 - 3 FC Juárez Sub 18Juárez ...
25 Ago 23 Tijuana Sub 18Tijuana 3 - 2 Mazatlán FC Sub 18Mazatlán ...
07 Sep 23 Santos Laguna Sub 18Santos 1 - 0 Chivas Guadalajara Sub 18Chivas ...
26 Ago 23 América Sub 18América 3 - 0 León Sub 18León ...
26 Ago 23 Atlas Guadalajara Sub 18Atlas 3 - 1 Toluca Sub 18Toluca ...
27 Ago 23 Necaxa Sub 18Necaxa 2 - 0 Querétaro Sub 18Querétaro ...
18 Oct 23 Monterrey Sub 18Monterrey 2 - 0 Cruz Azul Sub 18Cruz Azul ...
27 Ago 23 Pumas UNAM Sub 18Pumas UNAM 4 - 2 Tigres UANL Sub 18Tigres UANL ...
28 Ago 23 Pachuca Sub 18Pachuca 1 - 2 Atl. San Luis Sub 18Atl. Luis ...
Ver jornada
Jornada 7
01 Sep 23 Puebla Sub 18Puebla 1 - 1 Tijuana Sub 18Tijuana ...
03 Sep 23 Atl. San Luis Sub 18Atl. Luis 1 - 1 Atlas Guadalajara Sub 18Atlas ...
02 Sep 23 FC Juárez Sub 18Juárez 1 - 0 Mazatlán FC Sub 18Mazatlán ...
02 Sep 23 Santos Laguna Sub 18Santos 2 - 3 Pumas UNAM Sub 18Pumas UNAM ...
02 Sep 23 León Sub 18León 1 - 1 Necaxa Sub 18Necaxa ...
02 Sep 23 Cruz Azul Sub 18Cruz Azul 1 - 1 América Sub 18América ...
03 Sep 23 Chivas Guadalajara Sub 18Chivas 0 - 2 Monterrey Sub 18Monterrey ...
02 Sep 23 Tigres UANL Sub 18Tigres UANL 3 - 0 Querétaro Sub 18Querétaro ...
03 Sep 23 Toluca Sub 18Toluca 1 - 0 Pachuca Sub 18Pachuca ...
Ver jornada
Jornada 8
15 Sep 23 Mazatlán FC Sub 18Mazatlán 2 - 0 Cruz Azul Sub 18Cruz Azul ...
15 Sep 23 Tijuana Sub 18Tijuana 2 - 1 Toluca Sub 18Toluca ...
16 Sep 23 América Sub 18América 2 - 2 Chivas Guadalajara Sub 18Chivas ...
16 Sep 23 Necaxa Sub 18Necaxa 0 - 1 FC Juárez Sub 18Juárez ...
16 Sep 23 Monterrey Sub 18Monterrey 5 - 3 León Sub 18León ...
17 Sep 23 Atlas Guadalajara Sub 18Atlas 3 - 0 Tigres UANL Sub 18Tigres UANL ...
17 Sep 23 Querétaro Sub 18Querétaro 0 - 5 Puebla Sub 18Puebla ...
17 Sep 23 Pumas UNAM Sub 18Pumas UNAM 3 - 0 Atl. San Luis Sub 18Atl. Luis ...
18 Sep 23 Pachuca Sub 18Pachuca 3 - 1 Santos Laguna Sub 18Santos ...
Ver jornada
Jornada 9
22 Sep 23 Puebla Sub 18Puebla 0 - 1 Pumas UNAM Sub 18Pumas UNAM ...
22 Sep 23 Atl. San Luis Sub 18Atl. Luis 2 - 0 Mazatlán FC Sub 18Mazatlán ...
22 Sep 23 FC Juárez Sub 18Juárez 0 - 1 Atlas Guadalajara Sub 18Atlas ...
23 Sep 23 León Sub 18León 3 - 0 Tijuana Sub 18Tijuana ...
23 Sep 23 Chivas Guadalajara Sub 18Chivas 1 - 1 Pachuca Sub 18Pachuca ...
23 Sep 23 Tigres UANL Sub 18Tigres UANL 0 - 0 Monterrey Sub 18Monterrey ...
24 Sep 23 Santos Laguna Sub 18Santos 0 - 2 Necaxa Sub 18Necaxa ...
24 Sep 23 Cruz Azul Sub 18Cruz Azul 1 - 1 Querétaro Sub 18Querétaro ...
24 Sep 23 Toluca Sub 18Toluca 0 - 0 América Sub 18América ...
Ver jornada
Jornada 10
28 Sep 23 Atlas Guadalajara Sub 18Atlas 1 - 1 Puebla Sub 18Puebla ...
29 Sep 23 Querétaro Sub 18Querétaro 2 - 4 León Sub 18León ...
30 Sep 23 Mazatlán FC Sub 18Mazatlán 2 - 3 Tigres UANL Sub 18Tigres UANL ...
29 Sep 23 Tijuana Sub 18Tijuana 2 - 1 FC Juárez Sub 18Juárez ...
30 Sep 23 Pachuca Sub 18Pachuca 0 - 1 Necaxa Sub 18Necaxa ...
30 Sep 23 América Sub 18América 3 - 2 Pumas UNAM Sub 18Pumas UNAM ...
30 Sep 23 Monterrey Sub 18Monterrey 1 - 2 Santos Laguna Sub 18Santos ...
29 Sep 23 Atl. San Luis Sub 18Atl. Luis 1 - 1 Cruz Azul Sub 18Cruz Azul ...
01 Oct 23 Toluca Sub 18Toluca 2 - 0 Chivas Guadalajara Sub 18Chivas ...
Ver jornada
Jornada 11
03 Oct 23 América Sub 18América 3 - 1 Pachuca Sub 18Pachuca ...
03 Oct 23 Puebla Sub 18Puebla 0 - 2 Monterrey Sub 18Monterrey ...
04 Oct 23 Necaxa Sub 18Necaxa 2 - 0 Cruz Azul Sub 18Cruz Azul ...
17 Oct 23 Tigres UANL Sub 18Tigres UANL 1 - 1 Toluca Sub 18Toluca ...
04 Oct 23 Pumas UNAM Sub 18Pumas UNAM 1 - 0 Querétaro Sub 18Querétaro ...
24 Oct 23 León Sub 18León 1 - 3 Atlas Guadalajara Sub 18Atlas ...
26 Sep 23 Chivas Guadalajara Sub 18Chivas 3 - 1 Mazatlán FC Sub 18Mazatlán ...
04 Oct 23 Santos Laguna Sub 18Santos 3 - 3 Tijuana Sub 18Tijuana ...
25 Oct 23 FC Juárez Sub 18Juárez 1 - 0 Atl. San Luis Sub 18Atl. Luis ...
Ver jornada
Jornada 12
06 Oct 23 Mazatlán FC Sub 18Mazatlán 0 - 4 América Sub 18América ...
07 Oct 23 Pachuca Sub 18Pachuca 1 - 1 Tigres UANL Sub 18Tigres UANL ...
07 Oct 23 Cruz Azul Sub 18Cruz Azul 1 - 2 Pumas UNAM Sub 18Pumas UNAM ...
07 Oct 23 Chivas Guadalajara Sub 18Chivas 1 - 0 Atlas Guadalajara Sub 18Atlas ...
07 Oct 23 Monterrey Sub 18Monterrey 2 - 1 FC Juárez Sub 18Juárez ...
08 Oct 23 Santos Laguna Sub 18Santos 3 - 3 León Sub 18León ...
08 Oct 23 Necaxa Sub 18Necaxa 0 - 1 Puebla Sub 18Puebla ...
08 Oct 23 Toluca Sub 18Toluca 0 - 1 Querétaro Sub 18Querétaro ...
08 Oct 23 Tijuana Sub 18Tijuana 3 - 1 Atl. San Luis Sub 18Atl. Luis ...
Ver jornada
Jornada 13
20 Oct 23 Puebla Sub 18Puebla 0 - 0 Chivas Guadalajara Sub 18Chivas ...
20 Oct 23 Atlas Guadalajara Sub 18Atlas 0 - 2 Mazatlán FC Sub 18Mazatlán ...
20 Oct 23 FC Juárez Sub 18Juárez 0 - 1 Pachuca Sub 18Pachuca ...
21 Oct 23 León Sub 18León 1 - 3 Toluca Sub 18Toluca ...
21 Oct 23 América Sub 18América 3 - 2 Santos Laguna Sub 18Santos ...
21 Oct 23 Tigres UANL Sub 18Tigres UANL 2 - 2 Cruz Azul Sub 18Cruz Azul ...
22 Oct 23 Atl. San Luis Sub 18Atl. Luis 1 - 1 Necaxa Sub 18Necaxa ...
21 Oct 23 Querétaro Sub 18Querétaro 1 - 2 Tijuana Sub 18Tijuana ...
22 Oct 23 Pumas UNAM Sub 18Pumas UNAM 1 - 0 Monterrey Sub 18Monterrey ...
Ver jornada
Jornada 14
27 Oct 23 Necaxa Sub 18Necaxa 1 - 1 Pumas UNAM Sub 18Pumas UNAM ...
27 Oct 23 Mazatlán FC Sub 18Mazatlán 3 - 2 Querétaro Sub 18Querétaro ...
28 Oct 23 Pachuca Sub 18Pachuca 0 - 1 Puebla Sub 18Puebla ...
28 Oct 23 Cruz Azul Sub 18Cruz Azul 1 - 0 León Sub 18León ...
28 Oct 23 Chivas Guadalajara Sub 18Chivas 2 - 1 Tigres UANL Sub 18Tigres UANL ...
28 Oct 23 Monterrey Sub 18Monterrey 5 - 3 América Sub 18América ...
29 Oct 23 Santos Laguna Sub 18Santos 2 - 1 FC Juárez Sub 18Juárez ...
29 Oct 23 Toluca Sub 18Toluca 3 - 0 Atl. San Luis Sub 18Atl. Luis ...
29 Oct 23 Tijuana Sub 18Tijuana 3 - 1 Atlas Guadalajara Sub 18Atlas ...
Ver jornada
Jornada 15
31 Oct 23 León Sub 18León 1 - 4 Pumas UNAM Sub 18Pumas UNAM ...
31 Oct 23 Querétaro Sub 18Querétaro 0 - 2 Chivas Guadalajara Sub 18Chivas ...
31 Oct 23 Monterrey Sub 18Monterrey 3 - 2 Necaxa Sub 18Necaxa ...
31 Oct 23 Toluca Sub 18Toluca 4 - 0 Puebla Sub 18Puebla ...
01 Nov 23 Atlas Guadalajara Sub 18Atlas 2 - 3 Pachuca Sub 18Pachuca ...
01 Nov 23 Atl. San Luis Sub 18Atl. Luis 1 - 1 América Sub 18América ...
01 Nov 23 Cruz Azul Sub 18Cruz Azul 1 - 1 FC Juárez Sub 18Juárez ...
01 Nov 23 Mazatlán FC Sub 18Mazatlán 4 - 2 Santos Laguna Sub 18Santos ...
01 Nov 23 Tijuana Sub 18Tijuana 2 - 1 Tigres UANL Sub 18Tigres UANL ...
Ver jornada
Jornada 16
03 Nov 23 Puebla Sub 18Puebla 1 - 3 León Sub 18León ...
04 Nov 23 Pachuca Sub 18Pachuca 2 - 3 Monterrey Sub 18Monterrey ...
04 Nov 23 América Sub 18América 1 - 1 Tijuana Sub 18Tijuana ...
04 Nov 23 Chivas Guadalajara Sub 18Chivas 0 - 0 Cruz Azul Sub 18Cruz Azul ...
04 Nov 23 Tigres UANL Sub 18Tigres UANL 2 - 0 Atl. San Luis Sub 18Atl. Luis ...
05 Nov 23 Santos Laguna Sub 18Santos 0 - 0 Toluca Sub 18Toluca ...
05 Nov 23 FC Juárez Sub 18Juárez 2 - 3 Querétaro Sub 18Querétaro ...
05 Nov 23 Necaxa Sub 18Necaxa 2 - 0 Mazatlán FC Sub 18Mazatlán ...
05 Nov 23 Pumas UNAM Sub 18Pumas UNAM 3 - 1 Atlas Guadalajara Sub 18Atlas ...
Ver jornada
Jornada 17
10 Nov 23 Atlas Guadalajara Sub 18Atlas 2 - 3 Necaxa Sub 18Necaxa ...
10 Nov 23 Mazatlán FC Sub 18Mazatlán 3 - 3 Toluca Sub 18Toluca ...
10 Nov 23 Tijuana Sub 18Tijuana 2 - 0 Pachuca Sub 18Pachuca ...
11 Nov 23 Atl. San Luis Sub 18Atl. Luis 3 - 3 Santos Laguna Sub 18Santos ...
11 Nov 23 Querétaro Sub 18Querétaro 0 - 0 Monterrey Sub 18Monterrey ...
11 Nov 23 Tigres UANL Sub 18Tigres UANL 3 - 0 América Sub 18América ...
11 Nov 23 Pumas UNAM Sub 18Pumas UNAM 2 - 0 Chivas Guadalajara Sub 18Chivas ...
12 Nov 23 León Sub 18León 3 - 0 FC Juárez Sub 18Juárez ...
12 Nov 23 Cruz Azul Sub 18Cruz Azul 1 - 2 Puebla Sub 18Puebla ...

Clasificación

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

  USO DE MEMORIA  
6,088,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.3129
Total Execution Time  0.3153
  CADENA URL  
/liga_mexico_sub_18_apertura2024/grupo1/calendario
  GET DATOS  
$_GET['/liga_mexico_sub_18_apertura2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2494 AND type_rel = 3
0.0128  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2494 ORDER BY order_id ASC
0.0264  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 = 72216 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-04-27 21:34:35' 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=2 AND last_update > '2024-04-27 21:34:35' 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-04-27 21:34:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:34:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0234  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 = 72216 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72216 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.0222  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 = 72216 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72216 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0130  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 = 72216 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72216 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0141  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 = 72216 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