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

Clasificación

Equipo PJ GF GC Puntos
1 Red Bull Akademie Sub 15 Bull 23 59 28 49
2 Wolfsberger Sub 15 Wolfsberger 23 68 40 49
3 Austria Wien Sub 15 Austria Wien 23 43 25 40
4 Admira Sub 15 Admira 23 45 34 39
5 Vorarlberg Sub 15 Vorarlberg 23 47 38 38
6 Burgenland Sub 15 Burgenland 23 51 41 37
7 Rapid Wien Sub 15 Rapid Wien 23 56 35 37
8 Lask Juniors OÖ Sub 15 Lask Juniors 23 41 43 30
9 Sturm Graz Sub 15 Sturm Graz 23 44 52 29
10 Tirol Sub 15 Tirol 24 41 52 29
11 St Pölten Sub 15 Pölten 23 39 53 28
12 Austria Klagenfurt Sub 15 Austria 23 17 69 9
13 Ried Sub 15 Ried Sub 15 23 19 60 6

  USO DE MEMORIA  
5,957,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.3609
Total Execution Time  0.3637
  CADENA URL  
/liga_austria_sub_152022/grupo1/calendario
  GET DATOS  
$_GET['/liga_austria_sub_152022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0130  SELECT type FROM routes WHERE alias = 'liga_austria_sub_152022'
0.0266  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_austria_sub_15' 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.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2382 AND type_rel = 3
0.0128  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2382 ORDER BY order_id ASC
0.0129  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 = 63899 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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 = 63899 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-25 07:19:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 07:19:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 07:19:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 07:19:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_austria_sub_15' 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.0191  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 = 63899 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63899 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.0167  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 = 63899 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63899 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0132  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 = 63899 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63899 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0141  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 = 63899 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC