Jornada 1
11 Sep 21 Brescia Sub 19Brescia 2 - 0 Como Sub 19Como ...
11 Sep 21 Parma Sub 19Parma 6 - 1 US Alessandria Sub 19Alessandria ...
11 Sep 21 Pordenone Sub 19Pordenone 2 - 2 AC Monza Sub 19Monza ...
11 Sep 21 Reggiana Sub 19Reggiana 2 - 2 Cittadella Sub 19Cittadella ...
11 Sep 21 Venezia Sub 19Venezia 0 - 0 Cremonese Sub 19Cremonese ...
11 Sep 21 Vicenza Sub 19Vicenza 0 - 3 Virtus Entella Sub 19Virtus ...
Jornada 2
18 Sep 21 US Alessandria Sub 19Alessandria 0 - 4 Pordenone Sub 19Pordenone ...
18 Sep 21 Cittadella Sub 19Cittadella 2 - 3 Udinese Sub 19Udinese ...
18 Sep 21 Como Sub 19Como 1 - 1 Vicenza Sub 19Vicenza ...
18 Sep 21 Cremonese Sub 19Cremonese 1 - 0 Reggiana Sub 19Reggiana ...
18 Sep 21 Virtus Entella Sub 19Virtus 1 - 7 Venezia Sub 19Venezia ...
18 Sep 21 AC Monza Sub 19Monza 2 - 1 Brescia Sub 19Brescia ...
Jornada 3
25 Sep 21 Brescia Sub 19Brescia 2 - 2 Venezia Sub 19Venezia ...
25 Sep 21 Como Sub 19Como 2 - 3 Cittadella Sub 19Cittadella ...
25 Sep 21 Cremonese Sub 19Cremonese 5 - 3 US Alessandria Sub 19Alessandria ...
25 Sep 21 Pordenone Sub 19Pordenone 2 - 3 Parma Sub 19Parma ...
25 Sep 21 Reggiana Sub 19Reggiana 1 - 2 Virtus Entella Sub 19Virtus ...
26 Sep 21 Udinese Sub 19Udinese 2 - 1 AC Monza Sub 19Monza ...
Jornada 4
02 Oct 21 US Alessandria Sub 19Alessandria 1 - 2 Brescia Sub 19Brescia ...
02 Oct 21 Cittadella Sub 19Cittadella 0 - 4 Vicenza Sub 19Vicenza ...
02 Oct 21 Virtus Entella Sub 19Virtus 1 - 1 Udinese Sub 19Udinese ...
02 Oct 21 AC Monza Sub 19Monza 3 - 2 Cremonese Sub 19Cremonese ...
02 Oct 21 Parma Sub 19Parma 2 - 0 Como Sub 19Como ...
02 Oct 21 Venezia Sub 19Venezia 7 - 0 Reggiana Sub 19Reggiana ...
Jornada 5
16 Oct 21 Brescia Sub 19Brescia 2 - 0 Pordenone Sub 19Pordenone ...
16 Oct 21 Como Sub 19Como 1 - 2 AC Monza Sub 19Monza ...
16 Oct 21 Cremonese Sub 19Cremonese 0 - 3 Virtus Entella Sub 19Virtus ...
16 Oct 21 Reggiana Sub 19Reggiana 0 - 4 Parma Sub 19Parma ...
16 Oct 21 Udinese Sub 19Udinese 4 - 1 Venezia Sub 19Venezia ...
16 Oct 21 Vicenza Sub 19Vicenza 5 - 1 US Alessandria Sub 19Alessandria ...
Jornada 6
23 Oct 21 US Alessandria Sub 19Alessandria 1 - 1 Como Sub 19Como ...
23 Oct 21 Brescia Sub 19Brescia 1 - 1 Cremonese Sub 19Cremonese ...
23 Oct 21 AC Monza Sub 19Monza 3 - 0 Reggiana Sub 19Reggiana ...
23 Oct 21 Parma Sub 19Parma 3 - 3 Vicenza Sub 19Vicenza ...
23 Oct 21 Pordenone Sub 19Pordenone 0 - 4 Udinese Sub 19Udinese ...
23 Oct 21 Venezia Sub 19Venezia 1 - 1 Cittadella Sub 19Cittadella ...
Jornada 7
30 Oct 21 Cittadella Sub 19Cittadella 1 - 0 US Alessandria Sub 19Alessandria ...
30 Oct 21 Cremonese Sub 19Cremonese 0 - 6 Parma Sub 19Parma ...
30 Oct 21 Virtus Entella Sub 19Virtus 1 - 2 AC Monza Sub 19Monza ...
30 Oct 21 Reggiana Sub 19Reggiana 0 - 1 Brescia Sub 19Brescia ...
30 Oct 21 Udinese Sub 19Udinese 2 - 2 Como Sub 19Como ...
30 Oct 21 Vicenza Sub 19Vicenza 1 - 1 Pordenone Sub 19Pordenone ...
Jornada 8
06 Nov 21 US Alessandria Sub 19Alessandria 1 - 1 Venezia Sub 19Venezia ...
06 Nov 21 Brescia Sub 19Brescia 3 - 1 Virtus Entella Sub 19Virtus ...
06 Nov 21 Como Sub 19Como 1 - 2 Cremonese Sub 19Cremonese ...
06 Nov 21 Parma Sub 19Parma 1 - 0 Cittadella Sub 19Cittadella ...
06 Nov 21 Pordenone Sub 19Pordenone 1 - 0 Reggiana Sub 19Reggiana ...
06 Nov 21 Vicenza Sub 19Vicenza 0 - 5 Udinese Sub 19Udinese ...
Jornada 9
19 Nov 21 Cittadella Sub 19Cittadella 1 - 3 Pordenone Sub 19Pordenone ...
20 Nov 21 Virtus Entella Sub 19Virtus 3 - 0 Como Sub 19Como ...
20 Nov 21 AC Monza Sub 19Monza 1 - 1 US Alessandria Sub 19Alessandria ...
20 Nov 21 Reggiana Sub 19Reggiana 1 - 2 Vicenza Sub 19Vicenza ...
20 Nov 21 Udinese Sub 19Udinese 3 - 1 Brescia Sub 19Brescia ...
15 Dic 21 Venezia Sub 19Venezia 0 - 1 Parma Sub 19Parma ...
Jornada 10
27 Nov 21 US Alessandria Sub 19Alessandria 1 - 3 Virtus Entella Sub 19Virtus ...
27 Nov 21 Como Sub 19Como 0 - 1 Reggiana Sub 19Reggiana ...
27 Nov 21 Cremonese Sub 19Cremonese 4 - 1 Cittadella Sub 19Cittadella ...
27 Nov 21 Parma Sub 19Parma 3 - 1 Udinese Sub 19Udinese ...
27 Nov 21 Pordenone Sub 19Pordenone 1 - 1 Venezia Sub 19Venezia ...
27 Nov 21 Vicenza Sub 19Vicenza 2 - 0 AC Monza Sub 19Monza ...
Jornada 11
04 Dic 21 Cittadella Sub 19Cittadella 1 - 2 Brescia Sub 19Brescia ...
04 Dic 21 Virtus Entella Sub 19Virtus 1 - 0 Pordenone Sub 19Pordenone ...
04 Dic 21 AC Monza Sub 19Monza 1 - 1 Parma Sub 19Parma ...
04 Dic 21 Reggiana Sub 19Reggiana 0 - 1 US Alessandria Sub 19Alessandria ...
26 Ene 22 Udinese Sub 19Udinese 0 - 0 Cremonese Sub 19Cremonese 5
04 Dic 21 Venezia Sub 19Venezia 5 - 0 Vicenza Sub 19Vicenza ...
Jornada 12
14 Dic 21 US Alessandria Sub 19Alessandria 2 - 0 Udinese Sub 19Udinese ...
11 Dic 21 Brescia Sub 19Brescia 2 - 2 Parma Sub 19Parma ...
22 Dic 21 Como Sub 19Como 4 - 1 Pordenone Sub 19Pordenone ...
11 Dic 21 Cremonese Sub 19Cremonese 2 - 0 Vicenza Sub 19Vicenza ...
11 Dic 21 Virtus Entella Sub 19Virtus 2 - 2 Cittadella Sub 19Cittadella ...
11 Dic 21 AC Monza Sub 19Monza 2 - 1 Venezia Sub 19Venezia ...
Jornada 13
18 Dic 21 Cittadella Sub 19Cittadella 3 - 4 AC Monza Sub 19Monza ...
18 Dic 21 Parma Sub 19Parma 4 - 1 Virtus Entella Sub 19Virtus ...
18 Dic 21 Pordenone Sub 19Pordenone 0 - 3 Cremonese Sub 19Cremonese ...
18 Dic 21 Udinese Sub 19Udinese 2 - 1 Reggiana Sub 19Reggiana ...
18 Dic 21 Venezia Sub 19Venezia 0 - 0 Como Sub 19Como ...
18 Dic 21 Vicenza Sub 19Vicenza 0 - 5 Brescia Sub 19Brescia ...
Jornada 14
29 Ene 22 US Alessandria Sub 19Alessandria 1 - 4 Parma Sub 19Parma ...
16 Feb 22 Cittadella Sub 19Cittadella 7 - 0 Reggiana Sub 19Reggiana ...
09 Feb 22 Como Sub 19Como 1 - 1 Brescia Sub 19Brescia ...
29 Ene 22 Cremonese Sub 19Cremonese 3 - 2 Venezia Sub 19Venezia ...
15 Feb 22 Virtus Entella Sub 19Virtus 3 - 0 Vicenza Sub 19Vicenza ...
29 Ene 22 AC Monza Sub 19Monza 10 - 0 Pordenone Sub 19Pordenone ...
Jornada 15
05 Feb 22 Brescia Sub 19Brescia 2 - 0 AC Monza Sub 19Monza ...
05 Feb 22 Pordenone Sub 19Pordenone 0 - 2 US Alessandria Sub 19Alessandria ...
05 Feb 22 Reggiana Sub 19Reggiana 0 - 2 Cremonese Sub 19Cremonese ...
05 Feb 22 Udinese Sub 19Udinese 0 - 2 Cittadella Sub 19Cittadella ...
05 Feb 22 Venezia Sub 19Venezia 3 - 0 Virtus Entella Sub 19Virtus ...
05 Feb 22 Vicenza Sub 19Vicenza 1 - 1 Como Sub 19Como ...
Jornada 16
12 Feb 22 US Alessandria Sub 19Alessandria 1 - 4 Cremonese Sub 19Cremonese ...
12 Feb 22 Cittadella Sub 19Cittadella 1 - 1 Como Sub 19Como ...
12 Feb 22 Virtus Entella Sub 19Virtus 1 - 0 Reggiana Sub 19Reggiana ...
12 Feb 22 AC Monza Sub 19Monza 2 - 2 Udinese Sub 19Udinese ...
12 Feb 22 Parma Sub 19Parma 2 - 0 Pordenone Sub 19Pordenone ...
12 Feb 22 Venezia Sub 19Venezia 2 - 0 Brescia Sub 19Brescia ...
Jornada 17
19 Feb 22 Brescia Sub 19Brescia 3 - 2 US Alessandria Sub 19Alessandria ...
19 Feb 22 Vicenza Sub 19Vicenza 1 - 0 Cittadella Sub 19Cittadella ...
19 Feb 22 Cremonese Sub 19Cremonese 3 - 2 AC Monza Sub 19Monza ...
19 Feb 22 Como Sub 19Como 3 - 2 Parma Sub 19Parma ...
19 Feb 22 Reggiana Sub 19Reggiana 0 - 1 Venezia Sub 19Venezia ...
19 Feb 22 Udinese Sub 19Udinese 1 - 0 Virtus Entella Sub 19Virtus ...
Jornada 18
26 Feb 22 Pordenone Sub 19Pordenone 0 - 2 Brescia Sub 19Brescia ...
26 Feb 22 AC Monza Sub 19Monza 3 - 2 Como Sub 19Como ...
26 Feb 22 Virtus Entella Sub 19Virtus 0 - 1 Cremonese Sub 19Cremonese ...
26 Feb 22 US Alessandria Sub 19Alessandria 0 - 1 Vicenza Sub 19Vicenza ...
26 Feb 22 Parma Sub 19Parma 6 - 0 Reggiana Sub 19Reggiana ...
26 Feb 22 Venezia Sub 19Venezia 4 - 0 Udinese Sub 19Udinese ...
Jornada 19
07 Mar 22 Como Sub 19Como 4 - 4 US Alessandria Sub 19Alessandria ...
05 Mar 22 Cremonese Sub 19Cremonese 3 - 3 Brescia Sub 19Brescia ...
15 Mar 22 Reggiana Sub 19Reggiana 0 - 4 AC Monza Sub 19Monza ...
05 Mar 22 Vicenza Sub 19Vicenza 1 - 1 Parma Sub 19Parma ...
05 Mar 22 Udinese Sub 19Udinese 1 - 1 Pordenone Sub 19Pordenone ...
05 Mar 22 Cittadella Sub 19Cittadella 1 - 3 Venezia Sub 19Venezia ...
Jornada 20
12 Mar 22 US Alessandria Sub 19Alessandria 3 - 3 Cittadella Sub 19Cittadella ...
12 Mar 22 Parma Sub 19Parma 2 - 2 Cremonese Sub 19Cremonese ...
12 Mar 22 Pordenone Sub 19Pordenone 2 - 4 Vicenza Sub 19Vicenza ...
12 Mar 22 Brescia Sub 19Brescia 5 - 0 Reggiana Sub 19Reggiana ...
12 Mar 22 Como Sub 19Como 3 - 4 Udinese Sub 19Udinese ...
12 Mar 22 AC Monza Sub 19Monza 3 - 2 Virtus Entella Sub 19Virtus ...
Jornada 21
19 Mar 22 Cittadella Sub 19Cittadella 2 - 2 Parma Sub 19Parma ...
19 Mar 22 Cremonese Sub 19Cremonese 2 - 4 Como Sub 19Como ...
19 Mar 22 Virtus Entella Sub 19Virtus 1 - 3 Brescia Sub 19Brescia ...
19 Mar 22 Reggiana Sub 19Reggiana 1 - 1 Pordenone Sub 19Pordenone ...
19 Mar 22 Udinese Sub 19Udinese 2 - 0 Vicenza Sub 19Vicenza ...
19 Mar 22 Venezia Sub 19Venezia 5 - 1 US Alessandria Sub 19Alessandria ...
Jornada 22
26 Mar 22 US Alessandria Sub 19Alessandria 2 - 3 AC Monza Sub 19Monza ...
06 Abr 22 Brescia Sub 19Brescia 0 - 2 Udinese Sub 19Udinese ...
26 Mar 22 Como Sub 19Como 2 - 2 Virtus Entella Sub 19Virtus ...
20 Abr 22 Parma Sub 19Parma 0 - 4 Venezia Sub 19Venezia ...
26 Mar 22 Pordenone Sub 19Pordenone 1 - 2 Cittadella Sub 19Cittadella ...
26 Mar 22 Vicenza Sub 19Vicenza 4 - 3 Reggiana Sub 19Reggiana ...
Jornada 23
02 Abr 22 Cittadella Sub 19Cittadella 1 - 1 Cremonese Sub 19Cremonese ...
02 Abr 22 Virtus Entella Sub 19Virtus 0 - 0 US Alessandria Sub 19Alessandria ...
02 Abr 22 AC Monza Sub 19Monza 2 - 1 Vicenza Sub 19Vicenza ...
02 Abr 22 Reggiana Sub 19Reggiana 2 - 4 Como Sub 19Como ...
02 Abr 22 Udinese Sub 19Udinese 4 - 2 Parma Sub 19Parma ...
02 Abr 22 Venezia Sub 19Venezia 7 - 0 Pordenone Sub 19Pordenone ...
Jornada 24
09 Abr 22 US Alessandria Sub 19Alessandria 4 - 0 Reggiana Sub 19Reggiana ...
09 Abr 22 Brescia Sub 19Brescia 3 - 0 Cittadella Sub 19Cittadella ...
09 Abr 22 Cremonese Sub 19Cremonese 1 - 2 Udinese Sub 19Udinese ...
09 Abr 22 Parma Sub 19Parma 1 - 0 AC Monza Sub 19Monza ...
09 Abr 22 Pordenone Sub 19Pordenone 2 - 1 Virtus Entella Sub 19Virtus ...
09 Abr 22 Vicenza Sub 19Vicenza 0 - 5 Venezia Sub 19Venezia ...
Jornada 25
16 Abr 22 Cittadella Sub 19Cittadella 0 - 1 Virtus Entella Sub 19Virtus ...
16 Abr 22 Parma Sub 19Parma 0 - 0 Brescia Sub 19Brescia ...
15 Abr 22 Pordenone Sub 19Pordenone 1 - 1 Como Sub 19Como ...
15 Abr 22 Udinese Sub 19Udinese 8 - 1 US Alessandria Sub 19Alessandria ...
16 Abr 22 Venezia Sub 19Venezia 0 - 1 AC Monza Sub 19Monza ...
16 Abr 22 Vicenza Sub 19Vicenza 1 - 2 Cremonese Sub 19Cremonese ...
Jornada 26
23 Abr 22 Brescia Sub 19Brescia 2 - 1 Vicenza Sub 19Vicenza ...
23 Abr 22 Como Sub 19Como 2 - 1 Venezia Sub 19Venezia ...
23 Abr 22 Cremonese Sub 19Cremonese 5 - 2 Pordenone Sub 19Pordenone ...
23 Abr 22 Virtus Entella Sub 19Virtus 1 - 3 Parma Sub 19Parma ...
23 Abr 22 AC Monza Sub 19Monza 1 - 1 Cittadella Sub 19Cittadella ...
23 Abr 22 Reggiana Sub 19Reggiana 0 - 4 Udinese Sub 19Udinese ...
Clasificación
Equipo PJ GF GC Puntos
1 Udinese Sub 19 Udinese 24 57 30 50
2 Parma Sub 19 Parma 24 61 29 49
3 Brescia Sub 19 Brescia 24 48 25 48
4 AC Monza Sub 19 Monza 24 54 33 47
5 Cremonese Sub 19 Cremonese 24 49 38 45
6 Venezia Sub 19 Venezia 24 63 21 42
7 Virtus Entella Sub 19 Virtus 24 34 39 31
8 Vicenza Sub 19 Vicenza 24 33 50 29
9 Como Sub 19 Como Sub 19 24 40 44 25
10 Cittadella Sub 19 Cittadella 24 37 45 23
11 Pordenone Sub 19 Pordenone 24 25 60 18
12 US Alessandria Sub 19 Alessandria 24 34 64 18
13 Reggiana Sub 19 Reggiana 24 12 69 5
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
5,982,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3787
Total Execution Time  0.3806
  CADENA URL  
/liga_primavera_italia_22022/grupo1/calendario
  GET DATOS  
$_GET['/liga_primavera_italia_22022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0105  SELECT type FROM routes WHERE alias = 'liga_primavera_italia_22022'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_primavera_italia_2' 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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1983 AND type_rel = 3
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1983 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0110  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 (1289511,1289484,1267642,1264496,1224952) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1983 ORDER BY order_id ASC
0.0106  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 = 64185 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111  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 = 64185 ORDER BY round ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 12:37:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 12:37:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 12:37:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 12:37:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_primavera_italia_2' 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.0369  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 = 64185 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64185 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.0240  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 = 64185 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64185 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  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 = 64185 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64185 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0118  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 = 64185 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC