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

Clasificación

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

  USO DE MEMORIA  
6,118,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3846
Total Execution Time  0.3864
  CADENA URL  
/liga_mexico_sub_18_apertura2022/grupo1/calendario
  GET DATOS  
$_GET['/liga_mexico_sub_18_apertura2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0124  SELECT type FROM routes WHERE alias = 'liga_mexico_sub_18_apertura2022'
0.0251  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_apertura' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 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=2494 AND type_rel = 3
0.0128  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2494 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 = 2494 GROUP BY l.categoryId
0.0129  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=2494 GROUP BY l.year ORDER BY l.year DESC
0.0130  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 = 64074 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0144  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 calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 64074 ORDER BY round ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 13:37:28' 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-04-26 13:37:28' 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-04-26 13:37:28' 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-04-26 13:37:28' 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_apertura' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0270  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 events2022 e ON e.player_id = p.id AND e.league_id = 64074 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64074 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.0210  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 events2022 e ON e.player_id = p.id AND e.league_id = 64074 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64074 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 events2022 e ON e.player_id = p.id AND e.league_id = 64074 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64074 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 `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 = 64074 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