4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
13 Sep 23 LASK Juniors Sub 16LASK 5 - 2 Ried Sub 16Ried ...
19 Ago 23 Admira Wacker Sub 16Admira 0 - 2 Rapid Wien Sub 16Rapid Wien ...
04 Oct 23 Austria Wien Sub 16Austria 5 - 2 St. Pölten Sub 16Pölten ...
18 Ago 23 Vorarlberg Sub 16Vorarlberg 4 - 1 Burgenland Sub 16Burgenland ...
27 Sep 23 Red Bull Akademie Sub 16Bull 1 - 1 SK Sturm Graz Sub 16Sturm Graz ...
19 Ago 23 Austria Klagenfurt Sub 16Austria 0 - 2 Tirol Sub 16Tirol ...
Ver jornada
Jornada 2
26 Ago 23 Tirol Sub 16Tirol 6 - 0 LASK Juniors Sub 16LASK ...
26 Ago 23 Burgenland Sub 16Burgenland 2 - 2 Austria Klagenfurt Sub 16Austria ...
26 Ago 23 Rapid Wien Sub 16Rapid Wien 1 - 1 Vorarlberg Sub 16Vorarlberg ...
26 Ago 23 St. Pölten Sub 16Pölten 4 - 2 Wolfsberger AC Sub 16Wolfsberger ...
26 Ago 23 Ried Sub 16Ried 5 - 2 Austria Wien Sub 16Austria ...
26 Ago 23 SK Sturm Graz Sub 16Sturm Graz 5 - 0 Admira Wacker Sub 16Admira ...
Ver jornada
Jornada 3
01 Sep 23 Austria Wien Sub 16Austria 7 - 1 Tirol Sub 16Tirol ...
02 Sep 23 LASK Juniors Sub 16LASK 3 - 1 Burgenland Sub 16Burgenland ...
02 Sep 23 Vorarlberg Sub 16Vorarlberg 0 - 3 SK Sturm Graz Sub 16Sturm Graz ...
02 Sep 23 Austria Klagenfurt Sub 16Austria 1 - 1 Rapid Wien Sub 16Rapid Wien ...
01 Sep 23 St. Pölten Sub 16Pölten 5 - 2 Ried Sub 16Ried ...
02 Sep 23 Wolfsberger AC Sub 16Wolfsberger 1 - 2 Red Bull Akademie Sub 16Bull ...
Ver jornada
Jornada 4
16 Sep 23 Tirol Sub 16Tirol 4 - 1 St. Pölten Sub 16Pölten ...
16 Sep 23 Burgenland Sub 16Burgenland 0 - 3 Austria Wien Sub 16Austria ...
31 Oct 23 Red Bull Akademie Sub 16Bull 1 - 1 Admira Wacker Sub 16Admira ...
16 Sep 23 Rapid Wien Sub 16Rapid Wien 2 - 0 LASK Juniors Sub 16LASK ...
16 Sep 23 Ried Sub 16Ried 3 - 3 Wolfsberger AC Sub 16Wolfsberger ...
16 Sep 23 SK Sturm Graz Sub 16Sturm Graz 0 - 3 Austria Klagenfurt Sub 16Austria ...
Ver jornada
Jornada 5
23 Sep 23 LASK Juniors Sub 16LASK 4 - 2 SK Sturm Graz Sub 16Sturm Graz ...
23 Sep 23 Austria Wien Sub 16Austria 1 - 3 Rapid Wien Sub 16Rapid Wien ...
23 Sep 23 Vorarlberg Sub 16Vorarlberg 0 - 5 Red Bull Akademie Sub 16Bull ...
22 Sep 23 St. Pölten Sub 16Pölten 3 - 1 Burgenland Sub 16Burgenland ...
23 Sep 23 Ried Sub 16Ried 3 - 2 Tirol Sub 16Tirol ...
23 Sep 23 Wolfsberger AC Sub 16Wolfsberger 0 - 2 Admira Wacker Sub 16Admira ...
Ver jornada
Jornada 6
30 Sep 23 Tirol Sub 16Tirol 5 - 1 Wolfsberger AC Sub 16Wolfsberger ...
30 Sep 23 Admira Wacker Sub 16Admira 5 - 1 Vorarlberg Sub 16Vorarlberg ...
30 Sep 23 Burgenland Sub 16Burgenland 3 - 3 Ried Sub 16Ried ...
30 Sep 23 Red Bull Akademie Sub 16Bull 1 - 1 Austria Klagenfurt Sub 16Austria ...
30 Sep 23 Rapid Wien Sub 16Rapid Wien 0 - 2 St. Pölten Sub 16Pölten ...
30 Sep 23 SK Sturm Graz Sub 16Sturm Graz 1 - 6 Austria Wien Sub 16Austria ...
Ver jornada
Jornada 7
18 Nov 23 LASK Juniors Sub 16LASK 0 - 4 Red Bull Akademie Sub 16Bull ...
07 Oct 23 Tirol Sub 16Tirol 4 - 1 Burgenland Sub 16Burgenland ...
07 Oct 23 Austria Klagenfurt Sub 16Austria 1 - 3 Admira Wacker Sub 16Admira ...
07 Oct 23 St. Pölten Sub 16Pölten 0 - 3 SK Sturm Graz Sub 16Sturm Graz ...
07 Oct 23 Ried Sub 16Ried 1 - 4 Rapid Wien Sub 16Rapid Wien ...
07 Oct 23 Wolfsberger AC Sub 16Wolfsberger 1 - 4 Vorarlberg Sub 16Vorarlberg ...
Ver jornada
Jornada 8
21 Oct 23 Admira Wacker Sub 16Admira 4 - 2 LASK Juniors Sub 16LASK ...
21 Oct 23 Burgenland Sub 16Burgenland 2 - 1 Wolfsberger AC Sub 16Wolfsberger ...
21 Oct 23 Vorarlberg Sub 16Vorarlberg 3 - 0 Austria Klagenfurt Sub 16Austria ...
21 Oct 23 Red Bull Akademie Sub 16Bull 2 - 4 Austria Wien Sub 16Austria ...
21 Oct 23 Rapid Wien Sub 16Rapid Wien 0 - 3 Tirol Sub 16Tirol ...
21 Oct 23 SK Sturm Graz Sub 16Sturm Graz 1 - 3 Ried Sub 16Ried ...
Ver jornada
Jornada 9
28 Oct 23 LASK Juniors Sub 16LASK 5 - 0 Vorarlberg Sub 16Vorarlberg ...
28 Oct 23 Tirol Sub 16Tirol 1 - 2 SK Sturm Graz Sub 16Sturm Graz ...
28 Oct 23 Austria Wien Sub 16Austria 4 - 0 Admira Wacker Sub 16Admira ...
26 Oct 23 Burgenland Sub 16Burgenland 0 - 2 Rapid Wien Sub 16Rapid Wien ...
28 Oct 23 St. Pölten Sub 16Pölten 0 - 5 Red Bull Akademie Sub 16Bull ...
16 Nov 23 Wolfsberger AC Sub 16Wolfsberger 2 - 1 Austria Klagenfurt Sub 16Austria ...
Ver jornada
Jornada 10
17 Oct 23 Admira Wacker Sub 16Admira 3 - 3 St. Pölten Sub 16Pölten ...
27 Mar 24 Vorarlberg Sub 16Vorarlberg 1 - 5 Austria Wien Sub 16Austria ...
04 Nov 23 Red Bull Akademie Sub 16Bull 6 - 0 Ried Sub 16Ried ...
04 Nov 23 Austria Klagenfurt Sub 16Austria 6 - 3 LASK Juniors Sub 16LASK ...
31 Oct 23 Rapid Wien Sub 16Rapid Wien 6 - 1 Wolfsberger AC Sub 16Wolfsberger ...
04 Nov 23 SK Sturm Graz Sub 16Sturm Graz 1 - 1 Burgenland Sub 16Burgenland ...
Ver jornada
Jornada 11
11 Nov 23 LASK Juniors Sub 16LASK 7 - 2 Wolfsberger AC Sub 16Wolfsberger ...
11 Nov 23 Tirol Sub 16Tirol 3 - 5 Red Bull Akademie Sub 16Bull ...
11 Nov 23 Austria Wien Sub 16Austria 5 - 0 Austria Klagenfurt Sub 16Austria ...
11 Nov 23 Rapid Wien Sub 16Rapid Wien 2 - 3 SK Sturm Graz Sub 16Sturm Graz ...
11 Nov 23 St. Pölten Sub 16Pölten 0 - 2 Vorarlberg Sub 16Vorarlberg ...
11 Nov 23 Ried Sub 16Ried 2 - 3 Admira Wacker Sub 16Admira ...
Ver jornada
Jornada 12
16 Abr 24 LASK Juniors Sub 16LASK 0 - 6 Austria Wien Sub 16Austria ...
25 Nov 23 Admira Wacker Sub 16Admira 2 - 0 Tirol Sub 16Tirol ...
25 Nov 23 Vorarlberg Sub 16Vorarlberg 2 - 1 Ried Sub 16Ried ...
25 Nov 23 Red Bull Akademie Sub 16Bull 4 - 2 Burgenland Sub 16Burgenland ...
25 Nov 23 Austria Klagenfurt Sub 16Austria 4 - 1 St. Pölten Sub 16Pölten ...
25 Nov 23 Wolfsberger AC Sub 16Wolfsberger 1 - 3 SK Sturm Graz Sub 16Sturm Graz ...
Ver jornada
Jornada 13
04 Nov 23 Tirol Sub 16Tirol 1 - 3 Vorarlberg Sub 16Vorarlberg ...
08 Jun 24 Austria Wien Sub 16Austria
14:00
 		Wolfsberger AC Sub 16Wolfsberger ...
08 Nov 23 Burgenland Sub 16Burgenland 1 - 1 Admira Wacker Sub 16Admira ...
05 Mar 24 Rapid Wien Sub 16Rapid Wien 4 - 2 Red Bull Akademie Sub 16Bull ...
27 Mar 24 Ried Sub 16Ried 3 - 0 Austria Klagenfurt Sub 16Austria ...
15 May 24 LASK Juniors Sub 16LASK
16:00
 		St. Pölten Sub 16Pölten ...
Ver jornada
Jornada 14
24 Feb 24 Tirol Sub 16Tirol 6 - 2 Austria Klagenfurt Sub 16Austria ...
24 Feb 24 Burgenland Sub 16Burgenland 1 - 1 Vorarlberg Sub 16Vorarlberg ...
24 Feb 24 Rapid Wien Sub 16Rapid Wien 1 - 2 Admira Wacker Sub 16Admira ...
24 Feb 24 St. Pölten Sub 16Pölten 1 - 2 Austria Wien Sub 16Austria ...
23 Mar 24 Ried Sub 16Ried 2 - 5 LASK Juniors Sub 16LASK ...
24 Feb 24 SK Sturm Graz Sub 16Sturm Graz 1 - 5 Red Bull Akademie Sub 16Bull ...
Ver jornada
Jornada 15
02 Mar 24 LASK Juniors Sub 16LASK 0 - 7 Tirol Sub 16Tirol ...
02 Mar 24 Admira Wacker Sub 16Admira 2 - 2 SK Sturm Graz Sub 16Sturm Graz ...
02 Mar 24 Austria Wien Sub 16Austria 4 - 3 Ried Sub 16Ried ...
02 Mar 24 Vorarlberg Sub 16Vorarlberg 0 - 5 Rapid Wien Sub 16Rapid Wien ...
02 Mar 24 Austria Klagenfurt Sub 16Austria 3 - 0 Burgenland Sub 16Burgenland ...
01 Mar 24 Wolfsberger AC Sub 16Wolfsberger 1 - 3 St. Pölten Sub 16Pölten ...
Ver jornada
Jornada 16
09 Mar 24 Tirol Sub 16Tirol 2 - 5 Austria Wien Sub 16Austria ...
09 Mar 24 Burgenland Sub 16Burgenland 1 - 3 LASK Juniors Sub 16LASK ...
09 Mar 24 Red Bull Akademie Sub 16Bull 9 - 0 Wolfsberger AC Sub 16Wolfsberger ...
09 Mar 24 Rapid Wien Sub 16Rapid Wien 2 - 3 Austria Klagenfurt Sub 16Austria ...
30 Abr 24 Ried Sub 16Ried
17:00
 		St. Pölten Sub 16Pölten ...
09 Mar 24 SK Sturm Graz Sub 16Sturm Graz 2 - 4 Vorarlberg Sub 16Vorarlberg ...
Ver jornada
Jornada 17
16 Mar 24 LASK Juniors Sub 16LASK 1 - 3 Rapid Wien Sub 16Rapid Wien ...
16 Mar 24 Admira Wacker Sub 16Admira 1 - 1 Red Bull Akademie Sub 16Bull ...
16 Mar 24 Austria Wien Sub 16Austria 2 - 2 Burgenland Sub 16Burgenland ...
16 Mar 24 Austria Klagenfurt Sub 16Austria 1 - 4 SK Sturm Graz Sub 16Sturm Graz ...
16 Mar 24 St. Pölten Sub 16Pölten 2 - 4 Tirol Sub 16Tirol ...
16 Mar 24 Wolfsberger AC Sub 16Wolfsberger 1 - 0 Ried Sub 16Ried ...
Ver jornada
Jornada 18
06 Abr 24 Tirol Sub 16Tirol 5 - 2 Ried Sub 16Ried ...
06 Abr 24 Admira Wacker Sub 16Admira 5 - 0 Wolfsberger AC Sub 16Wolfsberger ...
05 Abr 24 Burgenland Sub 16Burgenland 2 - 1 St. Pölten Sub 16Pölten ...
06 Abr 24 Red Bull Akademie Sub 16Bull 4 - 3 Vorarlberg Sub 16Vorarlberg ...
05 Abr 24 Rapid Wien Sub 16Rapid Wien 0 - 2 Austria Wien Sub 16Austria ...
06 Abr 24 SK Sturm Graz Sub 16Sturm Graz 3 - 2 LASK Juniors Sub 16LASK ...
Ver jornada
Jornada 19
13 Abr 24 Austria Wien Sub 16Austria 4 - 1 SK Sturm Graz Sub 16Sturm Graz ...
13 Abr 24 Vorarlberg Sub 16Vorarlberg 3 - 0 Admira Wacker Sub 16Admira ...
13 Abr 24 Austria Klagenfurt Sub 16Austria 1 - 3 Red Bull Akademie Sub 16Bull ...
13 Abr 24 St. Pölten Sub 16Pölten 1 - 0 Rapid Wien Sub 16Rapid Wien ...
13 Abr 24 Ried Sub 16Ried 0 - 0 Burgenland Sub 16Burgenland ...
13 Abr 24 Wolfsberger AC Sub 16Wolfsberger 2 - 2 Tirol Sub 16Tirol ...
Ver jornada
Jornada 20
20 Abr 24 Admira Wacker Sub 16Admira 5 - 0 Austria Klagenfurt Sub 16Austria ...
20 Abr 24 Burgenland Sub 16Burgenland 2 - 4 Tirol Sub 16Tirol ...
20 Abr 24 Vorarlberg Sub 16Vorarlberg 6 - 0 Wolfsberger AC Sub 16Wolfsberger ...
20 Abr 24 Red Bull Akademie Sub 16Bull 6 - 0 LASK Juniors Sub 16LASK ...
20 Abr 24 Rapid Wien Sub 16Rapid Wien 1 - 2 Ried Sub 16Ried ...
20 Abr 24 SK Sturm Graz Sub 16Sturm Graz 2 - 5 St. Pölten Sub 16Pölten ...
Ver jornada
Jornada 21
27 Abr 24 LASK Juniors Sub 16LASK 1 - 1 Admira Wacker Sub 16Admira ...
27 Abr 24 Tirol Sub 16Tirol 8 - 2 Rapid Wien Sub 16Rapid Wien ...
27 Abr 24 Austria Wien Sub 16Austria 1 - 3 Red Bull Akademie Sub 16Bull ...
27 Abr 24 Austria Klagenfurt Sub 16Austria 3 - 1 Vorarlberg Sub 16Vorarlberg ...
27 Abr 24 Ried Sub 16Ried 1 - 1 SK Sturm Graz Sub 16Sturm Graz ...
27 Abr 24 Wolfsberger AC Sub 16Wolfsberger 3 - 1 Burgenland Sub 16Burgenland ...
Ver jornada
Jornada 22
04 May 24 Admira Wacker Sub 16Admira
13:00
 		Austria Wien Sub 16Austria ...
04 May 24 Vorarlberg Sub 16Vorarlberg
10:00
 		LASK Juniors Sub 16LASK ...
04 May 24 Red Bull Akademie Sub 16Bull
13:00
 		St. Pölten Sub 16Pölten ...
16 May 24 Austria Klagenfurt Sub 16Austria
17:00
 		Wolfsberger AC Sub 16Wolfsberger ...
04 May 24 Rapid Wien Sub 16Rapid Wien
13:00
 		Burgenland Sub 16Burgenland ...
04 May 24 SK Sturm Graz Sub 16Sturm Graz
12:30
 		Tirol Sub 16Tirol ...
Ver jornada
Jornada 23
11 May 24 LASK Juniors Sub 16LASK
13:00
 		Austria Klagenfurt Sub 16Austria ...
11 May 24 Austria Wien Sub 16Austria
13:00
 		Vorarlberg Sub 16Vorarlberg ...
11 May 24 Burgenland Sub 16Burgenland
13:00
 		SK Sturm Graz Sub 16Sturm Graz ...
11 May 24 St. Pölten Sub 16Pölten
13:00
 		Admira Wacker Sub 16Admira ...
11 May 24 Ried Sub 16Ried
13:00
 		Red Bull Akademie Sub 16Bull ...
11 May 24 Wolfsberger AC Sub 16Wolfsberger
13:00
 		Rapid Wien Sub 16Rapid Wien ...
Ver jornada
Jornada 24
25 May 24 Admira Wacker Sub 16Admira
13:00
 		Ried Sub 16Ried ...
25 May 24 Vorarlberg Sub 16Vorarlberg
13:00
 		St. Pölten Sub 16Pölten ...
25 May 24 Red Bull Akademie Sub 16Bull
13:00
 		Tirol Sub 16Tirol ...
25 May 24 Austria Klagenfurt Sub 16Austria
13:00
 		Austria Wien Sub 16Austria ...
25 May 24 Wolfsberger AC Sub 16Wolfsberger
13:00
 		LASK Juniors Sub 16LASK ...
25 May 24 SK Sturm Graz Sub 16Sturm Graz
16:00
 		Rapid Wien Sub 16Rapid Wien ...
Ver jornada
Jornada 25
28 Mar 24 Tirol Sub 16Tirol 1 - 0 Admira Wacker Sub 16Admira ...
01 Jun 24 Austria Wien Sub 16Austria
13:00
 		LASK Juniors Sub 16LASK ...
01 Jun 24 Burgenland Sub 16Burgenland
13:00
 		Red Bull Akademie Sub 16Bull ...
01 Jun 24 St. Pölten Sub 16Pölten
13:00
 		Austria Klagenfurt Sub 16Austria ...
01 Jun 24 Ried Sub 16Ried
13:00
 		Vorarlberg Sub 16Vorarlberg ...
01 Jun 24 SK Sturm Graz Sub 16Sturm Graz
16:00
 		Wolfsberger AC Sub 16Wolfsberger ...
Ver jornada
Jornada 26
08 Jun 24 St. Pölten Sub 16Pölten
11:00
 		LASK Juniors Sub 16LASK ...
17 May 24 Admira Wacker Sub 16Admira
16:00
 		Burgenland Sub 16Burgenland ...
23 Mar 24 Vorarlberg Sub 16Vorarlberg 2 - 1 Tirol Sub 16Tirol ...
29 May 24 Red Bull Akademie Sub 16Bull
13:00
 		Rapid Wien Sub 16Rapid Wien ...
08 Jun 24 Austria Klagenfurt Sub 16Austria
16:00
 		Ried Sub 16Ried ...
30 Abr 24 Wolfsberger AC Sub 16Wolfsberger
14:00
 		Austria Wien Sub 16Austria ...

Clasificación

Equipo PJ GF GC Puntos
1 Red Bull Akademie Sub 16 Bull 19 69 24 43
2 Austria Wien Sub 16 Austria Wien 18 68 27 43
3 Tirol Sub 16 Tirol 20 70 42 37
4 Admira Wacker Sub 16 Admira 19 40 30 33
5 Rapid Wien Sub 16 Rapid Wien 20 41 34 29
6 Vorarlberg Sub 16 Vorarlberg 19 39 43 29
7 SK Sturm Graz Sub 16 Sturm Graz 20 41 46 28
8 St. Pölten Sub 16 Pölten 17 34 42 22
9 LASK Juniors Sub 16 LASK Juniors 18 41 58 22
10 Austria Klagenfurt Sub 16 Austria 19 32 47 21
11 Ried Sub 16 Ried Sub 16 19 38 53 19
12 Burgenland Sub 16 Burgenland 20 24 48 13
13 Wolfsberger AC Sub 16 Wolfsberger 18 22 65 11

  USO DE MEMORIA  
5,967,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1303
Total Execution Time  0.1323
  CADENA URL  
/bundesliga_austria_sub_162024/grupo1/calendario
  GET DATOS  
$_GET['/bundesliga_austria_sub_162024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0019  SELECT type FROM routes WHERE alias = 'bundesliga_austria_sub_162024'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_austria_sub_16' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 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=2110 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2110 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 = 2110 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=2110 GROUP BY l.year ORDER BY l.year DESC
0.0020  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 = 72361 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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 72361 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 18:26:09' 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=2 AND last_update > '2024-04-28 18:26:09' 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 18:26:09' 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=3 AND last_update > '2024-04-28 18:26:09' 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 = 'bundesliga_austria_sub_16' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0114  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 = 72361 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72361 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.0076  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 = 72361 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72361 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0026  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 = 72361 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72361 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0033  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 = 72361 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC