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

Clasificación

Equipo PJ GF GC Puntos
1 Salzburg Sub 18 Salzburg 24 81 20 67
2 Rapid Wien Sub 18 Rapid Wien 24 65 27 52
3 Vorarlberg Sub 18 Vorarlberg 24 64 50 45
4 Burgenland Sub 18 Burgenland 24 49 45 43
5 Lask Juniors Sub 18 Lask Juniors 24 49 31 38
6 Austria Wien Sub 18 Austria Wien 24 50 39 38
7 Sturm Graz Sub 18 Sturm Graz 24 56 47 34
8 St. Pölten Sub 18 Pölten 24 31 35 30
9 Admira Wacker Sub 18 Admira 24 45 53 29
10 Tirol Sub 18 Tirol 24 33 58 21
11 Ried Sub 18 Ried Sub 18 24 37 63 20
12 Wolfsberger AC Sub 18 Wolfsberger 24 29 43 19
13 Austria Klagenfurt Sub 18 Austria 24 12 90 5

  USO DE MEMORIA  
5,973,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4312
Total Execution Time  0.4333
  CADENA URL  
/bundesliga_austria_sub_182022/grupo1/calendario
  GET DATOS  
$_GET['/bundesliga_austria_sub_182022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0124  SELECT type FROM routes WHERE alias = 'bundesliga_austria_sub_182022'
0.0253  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_18' 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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1587 AND type_rel = 3
0.0124  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1587 ORDER BY order_id ASC
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1587 GROUP BY l.categoryId
0.0132  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=1587 GROUP BY l.year ORDER BY l.year DESC
0.0137  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 = 63922 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0163  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 = 63922 ORDER BY round ASC
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 08:19:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 08:19:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-24 08:19:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 08:19:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0140  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_18' 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.0487  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 = 63922 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63922 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.0324  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 = 63922 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63922 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  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 = 63922 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63922 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0145  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 = 63922 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