Jornada 1
27 Ago 21 Red Bull Salzburg Sub 16Bull 1 - 2 LASK Juniors Sub 16LASK ...
28 Ago 21 Vorarlberg Sub 16Vorarlberg 3 - 7 Rapid Wien Sub 16Rapid Wien ...
28 Ago 21 Burgenland Sub 16Burgenland 0 - 1 Tirol Sub 16Tirol ...
28 Ago 21 St. Pölten Sub 16Pölten 2 - 3 Austria Wien Sub 16Austria ...
29 Ago 21 Wolfsberger AC Sub 16Wolfsberger 5 - 1 Austria Klagenfurt Sub 16Austria ...
28 Ago 21 SK Sturm Graz Sub 16Sturm Graz 1 - 3 Admira Wacker Sub 16Admira ...
Jornada 2
11 Sep 21 Austria Klagenfurt Sub 16Austria 1 - 6 Vorarlberg Sub 16Vorarlberg ...
11 Sep 21 Tirol Sub 16Tirol 0 - 3 SK Sturm Graz Sub 16Sturm Graz ...
11 Sep 21 Admira Wacker Sub 16Admira 2 - 1 St. Pölten Sub 16Pölten ...
11 Sep 21 Rapid Wien Sub 16Rapid Wien 4 - 2 Red Bull Salzburg Sub 16Bull ...
11 Sep 21 LASK Juniors Sub 16LASK 2 - 1 Ried Sub 16Ried ...
11 Sep 21 Austria Wien Sub 16Austria 3 - 2 Wolfsberger AC Sub 16Wolfsberger ...
Jornada 3
18 Sep 21 LASK Juniors Sub 16LASK 1 - 4 Rapid Wien Sub 16Rapid Wien ...
24 Nov 21 Wolfsberger AC Sub 16Wolfsberger 0 - 0 Admira Wacker Sub 16Admira ...
18 Sep 21 Vorarlberg Sub 16Vorarlberg 1 - 2 Austria Wien Sub 16Austria ...
18 Sep 21 Red Bull Salzburg Sub 16Bull 7 - 1 Austria Klagenfurt Sub 16Austria ...
16 Nov 21 Ried Sub 16Ried 1 - 0 Burgenland Sub 16Burgenland ...
18 Sep 21 St. Pölten Sub 16Pölten 5 - 1 Tirol Sub 16Tirol ...
Jornada 4
25 Sep 21 Austria Wien Sub 16Austria 0 - 5 Red Bull Salzburg Sub 16Bull ...
25 Sep 21 Burgenland Sub 16Burgenland 0 - 3 SK Sturm Graz Sub 16Sturm Graz ...
25 Sep 21 Admira Wacker Sub 16Admira 0 - 1 Vorarlberg Sub 16Vorarlberg ...
25 Sep 21 Tirol Sub 16Tirol 1 - 1 Wolfsberger AC Sub 16Wolfsberger ...
25 Sep 21 Rapid Wien Sub 16Rapid Wien 5 - 3 Ried Sub 16Ried ...
25 Sep 21 Austria Klagenfurt Sub 16Austria 0 - 5 LASK Juniors Sub 16LASK ...
Jornada 5
09 Oct 21 Ried Sub 16Ried 2 - 3 SK Sturm Graz Sub 16Sturm Graz ...
01 Oct 21 St. Pölten Sub 16Pölten 4 - 0 Burgenland Sub 16Burgenland ...
02 Oct 21 LASK Juniors Sub 16LASK 2 - 2 Austria Wien Sub 16Austria ...
02 Oct 21 Red Bull Salzburg Sub 16Bull 3 - 1 Admira Wacker Sub 16Admira ...
02 Oct 21 Rapid Wien Sub 16Rapid Wien 4 - 0 Austria Klagenfurt Sub 16Austria ...
02 Oct 21 Vorarlberg Sub 16Vorarlberg 1 - 3 Tirol Sub 16Tirol ...
Jornada 6
16 Oct 21 Burgenland Sub 16Burgenland 2 - 3 Wolfsberger AC Sub 16Wolfsberger ...
16 Oct 21 Admira Wacker Sub 16Admira 3 - 0 LASK Juniors Sub 16LASK ...
16 Oct 21 Austria Wien Sub 16Austria 2 - 4 Rapid Wien Sub 16Rapid Wien ...
16 Oct 21 Austria Klagenfurt Sub 16Austria 0 - 5 Ried Sub 16Ried ...
16 Oct 21 Tirol Sub 16Tirol 0 - 3 Red Bull Salzburg Sub 16Bull ...
16 Oct 21 SK Sturm Graz Sub 16Sturm Graz 7 - 2 St. Pölten Sub 16Pölten ...
Jornada 7
23 Oct 21 Wolfsberger AC Sub 16Wolfsberger 0 - 2 SK Sturm Graz Sub 16Sturm Graz ...
23 Oct 21 Vorarlberg Sub 16Vorarlberg 4 - 1 Burgenland Sub 16Burgenland ...
23 Oct 21 LASK Juniors Sub 16LASK 4 - 5 Tirol Sub 16Tirol ...
23 Oct 21 Rapid Wien Sub 16Rapid Wien 6 - 1 Admira Wacker Sub 16Admira ...
23 Oct 21 Austria Klagenfurt Sub 16Austria 0 - 7 Austria Wien Sub 16Austria ...
23 Oct 21 Ried Sub 16Ried 2 - 2 St. Pölten Sub 16Pölten ...
Jornada 8
27 Oct 21 Austria Wien Sub 16Austria 3 - 0 Ried Sub 16Ried ...
27 Oct 21 St. Pölten Sub 16Pölten 4 - 2 Wolfsberger AC Sub 16Wolfsberger ...
27 Oct 21 Burgenland Sub 16Burgenland 1 - 3 Red Bull Salzburg Sub 16Bull ...
26 Oct 21 Admira Wacker Sub 16Admira 3 - 0 Austria Klagenfurt Sub 16Austria ...
27 Oct 21 SK Sturm Graz Sub 16Sturm Graz 1 - 2 Vorarlberg Sub 16Vorarlberg ...
27 Oct 21 Tirol Sub 16Tirol 2 - 4 Rapid Wien Sub 16Rapid Wien ...
Jornada 9
30 Oct 21 Austria Klagenfurt Sub 16Austria 1 - 2 Tirol Sub 16Tirol ...
30 Oct 21 Austria Wien Sub 16Austria 2 - 1 Admira Wacker Sub 16Admira ...
13 Nov 21 Vorarlberg Sub 16Vorarlberg 4 - 3 St. Pölten Sub 16Pölten ...
30 Oct 21 Ried Sub 16Ried 0 - 0 Wolfsberger AC Sub 16Wolfsberger ...
30 Oct 21 Red Bull Salzburg Sub 16Bull 4 - 0 SK Sturm Graz Sub 16Sturm Graz ...
30 Oct 21 Burgenland Sub 16Burgenland 2 - 0 LASK Juniors Sub 16LASK ...
Jornada 10
06 Nov 21 Tirol Sub 16Tirol 0 - 2 Austria Wien Sub 16Austria ...
06 Nov 21 St. Pölten Sub 16Pölten 1 - 1 Red Bull Salzburg Sub 16Bull ...
06 Nov 21 Wolfsberger AC Sub 16Wolfsberger 0 - 3 Vorarlberg Sub 16Vorarlberg ...
06 Nov 21 Burgenland Sub 16Burgenland 0 - 3 Rapid Wien Sub 16Rapid Wien ...
06 Nov 21 SK Sturm Graz Sub 16Sturm Graz 4 - 2 LASK Juniors Sub 16LASK ...
06 Nov 21 Admira Wacker Sub 16Admira 3 - 1 Ried Sub 16Ried ...
Jornada 11
20 Nov 21 Rapid Wien Sub 16Rapid Wien 0 - 2 SK Sturm Graz Sub 16Sturm Graz ...
20 Nov 21 Austria Klagenfurt Sub 16Austria 1 - 6 Burgenland Sub 16Burgenland ...
20 Nov 21 Vorarlberg Sub 16Vorarlberg 5 - 0 Ried Sub 16Ried ...
20 Nov 21 Red Bull Salzburg Sub 16Bull 1 - 2 Wolfsberger AC Sub 16Wolfsberger ...
26 Mar 22 Admira Wacker Sub 16Admira 2 - 1 Tirol Sub 16Tirol ...
20 Nov 21 St. Pölten Sub 16Pölten 0 - 4 LASK Juniors Sub 16LASK ...
Jornada 12
27 Nov 21 SK Sturm Graz Sub 16Sturm Graz 4 - 0 Austria Klagenfurt Sub 16Austria ...
01 Dic 21 Burgenland Sub 16Burgenland 1 - 1 Austria Wien Sub 16Austria ...
08 Dic 21 St. Pölten Sub 16Pölten 1 - 4 Rapid Wien Sub 16Rapid Wien ...
27 Nov 21 Vorarlberg Sub 16Vorarlberg 0 - 7 Red Bull Salzburg Sub 16Bull ...
08 Dic 21 Wolfsberger AC Sub 16Wolfsberger 3 - 3 LASK Juniors Sub 16LASK ...
09 Mar 22 Tirol Sub 16Tirol 3 - 1 Ried Sub 16Ried ...
Jornada 13
12 Nov 21 Admira Wacker Sub 16Admira 2 - 5 Burgenland Sub 16Burgenland ...
04 Dic 21 Austria Klagenfurt Sub 16Austria 0 - 0 St. Pölten Sub 16Pölten ...
04 Dic 21 LASK Juniors Sub 16LASK 1 - 4 Vorarlberg Sub 16Vorarlberg ...
04 Dic 21 SK Sturm Graz Sub 16Sturm Graz 1 - 4 Austria Wien Sub 16Austria ...
04 Dic 21 Rapid Wien Sub 16Rapid Wien 2 - 1 Wolfsberger AC Sub 16Wolfsberger ...
04 Dic 21 Red Bull Salzburg Sub 16Bull 5 - 0 Ried Sub 16Ried ...
Jornada 14
26 Feb 22 LASK Juniors Sub 16LASK 2 - 3 Red Bull Salzburg Sub 16Bull ...
26 Feb 22 Rapid Wien Sub 16Rapid Wien 2 - 5 Vorarlberg Sub 16Vorarlberg ...
01 Jun 22 Austria Wien Sub 16Austria 3 - 1 St. Pölten Sub 16Pölten ...
26 Feb 22 Tirol Sub 16Tirol 4 - 0 Burgenland Sub 16Burgenland ...
26 Feb 22 Admira Wacker Sub 16Admira 2 - 3 SK Sturm Graz Sub 16Sturm Graz ...
17 May 22 Austria Klagenfurt Sub 16Austria 1 - 3 Wolfsberger AC Sub 16Wolfsberger ...
Jornada 15
05 Mar 22 Ried Sub 16Ried 0 - 1 LASK Juniors Sub 16LASK ...
01 Jun 22 Red Bull Salzburg Sub 16Bull 1 - 0 Rapid Wien Sub 16Rapid Wien ...
05 Mar 22 Vorarlberg Sub 16Vorarlberg 5 - 0 Austria Klagenfurt Sub 16Austria ...
26 Mar 22 Wolfsberger AC Sub 16Wolfsberger 1 - 2 Austria Wien Sub 16Austria ...
05 Mar 22 SK Sturm Graz Sub 16Sturm Graz 0 - 0 Tirol Sub 16Tirol ...
13 May 22 St. Pölten Sub 16Pölten 2 - 2 Admira Wacker Sub 16Admira ...
Jornada 16
12 Mar 22 Tirol Sub 16Tirol 3 - 0 St. Pölten Sub 16Pölten ...
12 Mar 22 Austria Klagenfurt Sub 16Austria 0 - 4 Red Bull Salzburg Sub 16Bull ...
12 Mar 22 Admira Wacker Sub 16Admira 2 - 3 Wolfsberger AC Sub 16Wolfsberger ...
12 Mar 22 Rapid Wien Sub 16Rapid Wien 1 - 2 LASK Juniors Sub 16LASK ...
12 Mar 22 Austria Wien Sub 16Austria 3 - 2 Vorarlberg Sub 16Vorarlberg ...
12 Mar 22 Burgenland Sub 16Burgenland 2 - 1 Ried Sub 16Ried ...
Jornada 17
19 Mar 22 SK Sturm Graz Sub 16Sturm Graz 3 - 1 Burgenland Sub 16Burgenland ...
19 Mar 22 Ried Sub 16Ried 0 - 7 Rapid Wien Sub 16Rapid Wien ...
19 Mar 22 Red Bull Salzburg Sub 16Bull 1 - 1 Austria Wien Sub 16Austria ...
19 Mar 22 Wolfsberger AC Sub 16Wolfsberger 0 - 3 Tirol Sub 16Tirol ...
26 Abr 22 LASK Juniors Sub 16LASK 1 - 0 Austria Klagenfurt Sub 16Austria ...
19 Mar 22 Vorarlberg Sub 16Vorarlberg 1 - 3 Admira Wacker Sub 16Admira ...
Jornada 18
02 Abr 22 Austria Wien Sub 16Austria 3 - 3 LASK Juniors Sub 16LASK ...
02 Abr 22 SK Sturm Graz Sub 16Sturm Graz 5 - 2 Ried Sub 16Ried ...
02 Abr 22 Admira Wacker Sub 16Admira 0 - 2 Red Bull Salzburg Sub 16Bull ...
02 Abr 22 Tirol Sub 16Tirol 0 - 4 Vorarlberg Sub 16Vorarlberg ...
02 Abr 22 Austria Klagenfurt Sub 16Austria 0 - 1 Rapid Wien Sub 16Rapid Wien ...
01 Abr 22 Burgenland Sub 16Burgenland 4 - 4 St. Pölten Sub 16Pölten ...
Jornada 19
09 Abr 22 Wolfsberger AC Sub 16Wolfsberger 3 - 0 Burgenland Sub 16Burgenland ...
09 Abr 22 Rapid Wien Sub 16Rapid Wien 5 - 0 Austria Wien Sub 16Austria ...
09 Abr 22 Red Bull Salzburg Sub 16Bull 3 - 3 Tirol Sub 16Tirol ...
09 Abr 22 Ried Sub 16Ried 2 - 0 Austria Klagenfurt Sub 16Austria ...
09 Abr 22 St. Pölten Sub 16Pölten 2 - 2 SK Sturm Graz Sub 16Sturm Graz ...
09 Abr 22 LASK Juniors Sub 16LASK 2 - 3 Admira Wacker Sub 16Admira ...
Jornada 20
23 Abr 22 St. Pölten Sub 16Pölten 4 - 4 Ried Sub 16Ried ...
23 Abr 22 Tirol Sub 16Tirol 1 - 3 LASK Juniors Sub 16LASK ...
13 Abr 22 Austria Wien Sub 16Austria 2 - 1 Austria Klagenfurt Sub 16Austria ...
23 Abr 22 SK Sturm Graz Sub 16Sturm Graz 2 - 1 Wolfsberger AC Sub 16Wolfsberger ...
23 Abr 22 Burgenland Sub 16Burgenland 0 - 4 Vorarlberg Sub 16Vorarlberg ...
22 Abr 22 Admira Wacker Sub 16Admira 2 - 3 Rapid Wien Sub 16Rapid Wien ...
Jornada 21
14 May 22 Red Bull Salzburg Sub 16Bull 4 - 1 Burgenland Sub 16Burgenland ...
30 Abr 22 Rapid Wien Sub 16Rapid Wien 2 - 2 Tirol Sub 16Tirol ...
30 Abr 22 Austria Klagenfurt Sub 16Austria 1 - 4 Admira Wacker Sub 16Admira ...
30 Abr 22 Vorarlberg Sub 16Vorarlberg 4 - 1 SK Sturm Graz Sub 16Sturm Graz ...
30 Abr 22 Wolfsberger AC Sub 16Wolfsberger 4 - 5 St. Pölten Sub 16Pölten ...
30 Abr 22 Ried Sub 16Ried 2 - 1 Austria Wien Sub 16Austria ...
Jornada 22
27 May 22 Admira Wacker Sub 16Admira 1 - 2 Austria Wien Sub 16Austria ...
07 May 22 LASK Juniors Sub 16LASK 2 - 4 Burgenland Sub 16Burgenland ...
07 May 22 St. Pölten Sub 16Pölten 1 - 1 Vorarlberg Sub 16Vorarlberg ...
07 May 22 SK Sturm Graz Sub 16Sturm Graz 2 - 7 Red Bull Salzburg Sub 16Bull ...
07 May 22 Wolfsberger AC Sub 16Wolfsberger 4 - 2 Ried Sub 16Ried ...
07 May 22 Tirol Sub 16Tirol 1 - 2 Austria Klagenfurt Sub 16Austria ...
Jornada 23
21 May 22 Red Bull Salzburg Sub 16Bull 2 - 1 St. Pölten Sub 16Pölten ...
21 May 22 Rapid Wien Sub 16Rapid Wien 5 - 2 Burgenland Sub 16Burgenland ...
21 May 22 LASK Juniors Sub 16LASK 1 - 4 SK Sturm Graz Sub 16Sturm Graz ...
21 May 22 Ried Sub 16Ried 1 - 1 Admira Wacker Sub 16Admira ...
21 May 22 Austria Wien Sub 16Austria 6 - 1 Tirol Sub 16Tirol ...
21 May 22 Vorarlberg Sub 16Vorarlberg 3 - 0 Wolfsberger AC Sub 16Wolfsberger ...
Jornada 24
28 May 22 Ried Sub 16Ried 1 - 1 Vorarlberg Sub 16Vorarlberg ...
26 May 22 Burgenland Sub 16Burgenland 1 - 0 Austria Klagenfurt Sub 16Austria ...
28 May 22 Wolfsberger AC Sub 16Wolfsberger 1 - 1 Red Bull Salzburg Sub 16Bull ...
28 May 22 SK Sturm Graz Sub 16Sturm Graz 4 - 1 Rapid Wien Sub 16Rapid Wien ...
27 May 22 LASK Juniors Sub 16LASK 5 - 0 St. Pölten Sub 16Pölten ...
13 Abr 22 Tirol Sub 16Tirol 6 - 3 Admira Wacker Sub 16Admira ...
Jornada 25
14 May 22 Ried Sub 16Ried 0 - 4 Tirol Sub 16Tirol ...
12 Abr 22 Red Bull Salzburg Sub 16Bull 5 - 1 Vorarlberg Sub 16Vorarlberg ...
10 Jun 22 Austria Klagenfurt Sub 16Austria 0 - 4 SK Sturm Graz Sub 16Sturm Graz ...
10 Jun 22 Rapid Wien Sub 16Rapid Wien 4 - 0 St. Pölten Sub 16Pölten ...
11 Jun 22 LASK Juniors Sub 16LASK 3 - 1 Wolfsberger AC Sub 16Wolfsberger ...
11 Jun 22 Austria Wien Sub 16Austria 3 - 0 Burgenland Sub 16Burgenland ...
Jornada 26
01 Jun 22 Burgenland Sub 16Burgenland 1 - 5 Admira Wacker Sub 16Admira ...
14 May 22 Austria Wien Sub 16Austria 0 - 3 SK Sturm Graz Sub 16Sturm Graz ...
11 May 22 Ried Sub 16Ried 0 - 5 Red Bull Salzburg Sub 16Bull ...
04 Jun 22 Wolfsberger AC Sub 16Wolfsberger 0 - 5 Rapid Wien Sub 16Rapid Wien ...
18 Jun 22 St. Pölten Sub 16Pölten 6 - 2 Austria Klagenfurt Sub 16Austria ...
14 May 22 Vorarlberg Sub 16Vorarlberg 5 - 1 LASK Juniors Sub 16LASK ...

Clasificación

Equipo PJ GF GC Puntos
1 Rapid Wien Sub 16 Rapid Wien 24 83 36 55
2 Red Bull Salzburg Sub 16 Bull 24 80 24 55
3 SK Sturm Graz Sub 16 Sturm Graz 24 64 40 50
4 Austria Wien Sub 16 Austria Wien 24 57 40 49
5 Vorarlberg Sub 16 Vorarlberg 24 70 43 47
6 Tirol Sub 16 Tirol 24 47 50 34
7 Admira Wacker Sub 16 Admira 24 49 48 33
8 LASK Juniors Sub 16 LASK Juniors 24 52 54 33
9 Wolfsberger AC Sub 16 Wolfsberger 24 40 51 26
10 St. Pölten Sub 16 Pölten 24 51 66 23
11 Burgenland Sub 16 Burgenland 24 34 64 20
12 Ried Sub 16 Ried Sub 16 24 31 66 17
13 Austria Klagenfurt Sub 16 Austria 24 12 88 4

  USO DE MEMORIA  
5,976,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1203
Total Execution Time  0.1222
  CADENA URL  
/bundesliga_austria_sub_162022/grupo1/calendario
  GET DATOS  
$_GET['/bundesliga_austria_sub_162022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'bundesliga_austria_sub_162022'
0.0040  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 = 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=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.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 = 63906 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  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 = 63906 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-19 07:29:51' 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-19 07:29:51' 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-19 07:29:51' 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-19 07:29:51' 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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0110  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 = 63906 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63906 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.0064  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 = 63906 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63906 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0023  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 = 63906 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63906 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  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 = 63906 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