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

Clasificación

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

  USO DE MEMORIA  
6,119,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1350
Total Execution Time  0.1369
  CADENA URL  
/liga_mexico_sub_17_clausura2021/grupo1/calendario
  GET DATOS  
$_GET['/liga_mexico_sub_17_clausura2021/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_mexico_sub_17_clausura2021'
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_17_clausura' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1553 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1553 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (816274,766075,613374) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1553 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 = 1553 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=1553 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 = 60791 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0044  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 calendars2021 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 60791 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-28 02:50:13' 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=2 AND last_update > '2024-04-28 02:50:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 02:50:13' 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=3 AND last_update > '2024-04-28 02:50:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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_17_clausura' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0118  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 events2021 e ON e.player_id = p.id AND e.league_id = 60791 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60791 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.0112  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 events2021 e ON e.player_id = p.id AND e.league_id = 60791 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60791 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 events2021 e ON e.player_id = p.id AND e.league_id = 60791 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60791 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 60791 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