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

Clasificación

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

  USO DE MEMORIA  
6,120,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1216
Total Execution Time  0.1235
  CADENA URL  
/liga_mexico_sub_20_clausura2022/grupo1/calendario
  GET DATOS  
$_GET['/liga_mexico_sub_20_clausura2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_mexico_sub_20_clausura2022'
0.0040  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_20_clausura' 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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1550 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1550 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1141556,1140299,1118173,1108904,981412) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1550 ORDER BY order_id ASC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1550 GROUP BY l.categoryId
0.0019  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=1550 GROUP BY l.year ORDER BY l.year DESC
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 = 66244 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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 = 66244 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 07:23:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 07:23:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 07:23:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 07:23:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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_20_clausura' 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.0072  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 = 66244 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66244 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.0092  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 = 66244 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66244 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0025  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 = 66244 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66244 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  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 = 66244 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