Ver jornada
Jornada 1
13 Ago 21 1. FC Magdeburg Sub 19Magdeburg 1 - 2 Hallescher FC Sub 19Hallescher ...
13 Ago 21 Hertha BSC Sub 19Hertha 2 - 1 Wolfsburg Sub 19Wolfsburg ...
14 Ago 21 Union Berlin Sub 19Union 0 - 0 Viktoria Berlin Sub 19Viktoria ...
14 Ago 21 Hamburger SV Sub 19Hamburger 0 - 3 RB Leipzig Sub 19Leipzig ...
14 Ago 21 Hannover 96 Sub 19Hannover 1 - 0 Dynamo Dresden Sub 19Dynamo ...
14 Ago 21 St. Pauli Sub 19Pauli 3 - 6 Holstein Kiel Sub 19Holstein ...
14 Ago 21 Energie Cottbus Sub 19Energie 2 - 0 Chemnitzer FC Sub 19Chemnitzer ...
14 Ago 21 Hansa Rostock Sub 19Hansa 0 - 1 Eimsbütteler Sub 19Eimsbüttel ...
15 Ago 21 Carl Zeiss Jena Sub 19Carl Zeiss 0 - 0 Osnabrück Sub 19Osnabrück ...
Ver jornada
Jornada 2
21 Ago 21 Eimsbütteler Sub 19Eimsbüttel 1 - 2 Energie Cottbus Sub 19Energie ...
21 Ago 21 Chemnitzer FC Sub 19Chemnitzer 1 - 1 Hamburger SV Sub 19Hamburger ...
21 Ago 21 RB Leipzig Sub 19Leipzig 2 - 2 St. Pauli Sub 19Pauli ...
21 Ago 21 Holstein Kiel Sub 19Holstein 2 - 1 Carl Zeiss Jena Sub 19Carl Zeiss ...
21 Ago 21 Wolfsburg Sub 19Wolfsburg 2 - 1 1. FC Magdeburg Sub 19Magdeburg ...
21 Ago 21 Hallescher FC Sub 19Hallescher 1 - 3 Union Berlin Sub 19Union ...
22 Ago 21 Dynamo Dresden Sub 19Dynamo 2 - 1 Hansa Rostock Sub 19Hansa ...
22 Ago 21 Werder Bremen Sub 19Werder 2 - 5 Hertha BSC Sub 19Hertha ...
22 Ago 21 Viktoria Berlin Sub 19Viktoria 1 - 1 Hannover 96 Sub 19Hannover ...
Ver jornada
Jornada 3
11 Sep 21 St. Pauli Sub 19Pauli 3 - 0 Chemnitzer FC Sub 19Chemnitzer ...
11 Sep 21 Hamburger SV Sub 19Hamburger 2 - 0 Eimsbütteler Sub 19Eimsbüttel ...
06 Nov 21 1. FC Magdeburg Sub 19Magdeburg 1 - 3 Werder Bremen Sub 19Werder ...
11 Sep 21 Hansa Rostock Sub 19Hansa 4 - 2 Viktoria Berlin Sub 19Viktoria ...
11 Sep 21 Energie Cottbus Sub 19Energie 1 - 0 Dynamo Dresden Sub 19Dynamo ...
27 Oct 21 Hannover 96 Sub 19Hannover 2 - 0 Hallescher FC Sub 19Hallescher ...
11 Sep 21 Union Berlin Sub 19Union 2 - 2 Wolfsburg Sub 19Wolfsburg ...
11 Sep 21 Carl Zeiss Jena Sub 19Carl Zeiss 0 - 1 RB Leipzig Sub 19Leipzig ...
12 Sep 21 Osnabrück Sub 19Osnabrück 0 - 2 Holstein Kiel Sub 19Holstein ...
Ver jornada
Jornada 4
18 Sep 21 Wolfsburg Sub 19Wolfsburg 1 - 1 Hannover 96 Sub 19Hannover ...
09 Oct 21 Hallescher FC Sub 19Hallescher 0 - 5 Hansa Rostock Sub 19Hansa ...
18 Sep 21 Viktoria Berlin Sub 19Viktoria 2 - 2 Energie Cottbus Sub 19Energie ...
18 Sep 21 Dynamo Dresden Sub 19Dynamo 1 - 3 Hamburger SV Sub 19Hamburger ...
17 Sep 21 Eimsbütteler Sub 19Eimsbüttel 1 - 1 St. Pauli Sub 19Pauli ...
18 Sep 21 Chemnitzer FC Sub 19Chemnitzer 1 - 1 Carl Zeiss Jena Sub 19Carl Zeiss ...
19 Sep 21 RB Leipzig Sub 19Leipzig 4 - 0 Osnabrück Sub 19Osnabrück ...
08 Dic 21 Hertha BSC Sub 19Hertha 3 - 2 1. FC Magdeburg Sub 19Magdeburg ...
19 Sep 21 Werder Bremen Sub 19Werder 2 - 4 Union Berlin Sub 19Union ...
Ver jornada
Jornada 5
25 Sep 21 St. Pauli Sub 19Pauli 0 - 1 Dynamo Dresden Sub 19Dynamo ...
06 Nov 21 Hamburger SV Sub 19Hamburger 2 - 2 Viktoria Berlin Sub 19Viktoria ...
25 Sep 21 Energie Cottbus Sub 19Energie 2 - 0 Hallescher FC Sub 19Hallescher ...
25 Sep 21 Hansa Rostock Sub 19Hansa 2 - 2 Wolfsburg Sub 19Wolfsburg ...
25 Sep 21 Hannover 96 Sub 19Hannover 1 - 4 Werder Bremen Sub 19Werder ...
25 Sep 21 Union Berlin Sub 19Union 0 - 3 Hertha BSC Sub 19Hertha ...
25 Sep 21 Holstein Kiel Sub 19Holstein 2 - 2 RB Leipzig Sub 19Leipzig ...
26 Sep 21 Osnabrück Sub 19Osnabrück 1 - 0 Chemnitzer FC Sub 19Chemnitzer ...
25 Sep 21 Carl Zeiss Jena Sub 19Carl Zeiss 4 - 1 Eimsbütteler Sub 19Eimsbüttel ...
Ver jornada
Jornada 6
02 Oct 21 Wolfsburg Sub 19Wolfsburg 0 - 1 Energie Cottbus Sub 19Energie ...
02 Oct 21 Hallescher FC Sub 19Hallescher 1 - 1 Hamburger SV Sub 19Hamburger ...
02 Oct 21 Viktoria Berlin Sub 19Viktoria 3 - 0 St. Pauli Sub 19Pauli ...
02 Oct 21 Dynamo Dresden Sub 19Dynamo 4 - 0 Carl Zeiss Jena Sub 19Carl Zeiss ...
03 Oct 21 Eimsbütteler Sub 19Eimsbüttel 2 - 1 Osnabrück Sub 19Osnabrück ...
02 Oct 21 Chemnitzer FC Sub 19Chemnitzer 4 - 2 Holstein Kiel Sub 19Holstein ...
02 Oct 21 1. FC Magdeburg Sub 19Magdeburg 0 - 3 Union Berlin Sub 19Union ...
02 Oct 21 Hertha BSC Sub 19Hertha 2 - 1 Hannover 96 Sub 19Hannover ...
02 Oct 21 Werder Bremen Sub 19Werder 2 - 1 Hansa Rostock Sub 19Hansa ...
Ver jornada
Jornada 7
16 Oct 21 St. Pauli Sub 19Pauli 3 - 2 Hallescher FC Sub 19Hallescher ...
16 Oct 21 Hamburger SV Sub 19Hamburger 0 - 1 Wolfsburg Sub 19Wolfsburg ...
16 Oct 21 Energie Cottbus Sub 19Energie 1 - 6 Werder Bremen Sub 19Werder ...
15 Oct 21 Hansa Rostock Sub 19Hansa 1 - 2 Hertha BSC Sub 19Hertha ...
16 Oct 21 Hannover 96 Sub 19Hannover 2 - 0 1. FC Magdeburg Sub 19Magdeburg ...
16 Oct 21 RB Leipzig Sub 19Leipzig 0 - 1 Chemnitzer FC Sub 19Chemnitzer ...
17 Oct 21 Holstein Kiel Sub 19Holstein 1 - 0 Eimsbütteler Sub 19Eimsbüttel ...
18 Dic 21 Osnabrück Sub 19Osnabrück 3 - 2 Dynamo Dresden Sub 19Dynamo ...
17 Oct 21 Carl Zeiss Jena Sub 19Carl Zeiss 0 - 1 Viktoria Berlin Sub 19Viktoria ...
Ver jornada
Jornada 8
23 Oct 21 Wolfsburg Sub 19Wolfsburg 2 - 2 St. Pauli Sub 19Pauli ...
23 Oct 21 Hallescher FC Sub 19Hallescher 3 - 1 Carl Zeiss Jena Sub 19Carl Zeiss ...
24 Oct 21 Viktoria Berlin Sub 19Viktoria 2 - 2 Osnabrück Sub 19Osnabrück ...
23 Oct 21 Dynamo Dresden Sub 19Dynamo 0 - 1 Holstein Kiel Sub 19Holstein ...
23 Oct 21 Eimsbütteler Sub 19Eimsbüttel 3 - 6 RB Leipzig Sub 19Leipzig ...
12 Feb 22 Union Berlin Sub 19Union 0 - 2 Hannover 96 Sub 19Hannover ...
23 Oct 21 1. FC Magdeburg Sub 19Magdeburg 3 - 1 Hansa Rostock Sub 19Hansa ...
01 Dic 21 Hertha BSC Sub 19Hertha 2 - 0 Energie Cottbus Sub 19Energie 4
23 Oct 21 Werder Bremen Sub 19Werder 4 - 2 Hamburger SV Sub 19Hamburger ...
Ver jornada
Jornada 9
30 Oct 21 St. Pauli Sub 19Pauli 0 - 1 Werder Bremen Sub 19Werder ...
30 Oct 21 Hamburger SV Sub 19Hamburger 2 - 2 Hertha BSC Sub 19Hertha ...
30 Oct 21 Energie Cottbus Sub 19Energie 3 - 0 1. FC Magdeburg Sub 19Magdeburg ...
31 Oct 21 Hansa Rostock Sub 19Hansa 1 - 1 Union Berlin Sub 19Union ...
11 Dic 21 Chemnitzer FC Sub 19Chemnitzer 2 - 2 Eimsbütteler Sub 19Eimsbüttel ...
29 Oct 21 RB Leipzig Sub 19Leipzig 0 - 3 Dynamo Dresden Sub 19Dynamo ...
31 Oct 21 Holstein Kiel Sub 19Holstein 1 - 0 Viktoria Berlin Sub 19Viktoria ...
31 Oct 21 Osnabrück Sub 19Osnabrück 0 - 1 Hallescher FC Sub 19Hallescher ...
30 Oct 21 Carl Zeiss Jena Sub 19Carl Zeiss 1 - 3 Wolfsburg Sub 19Wolfsburg ...
Ver jornada
Jornada 10
20 Nov 21 Wolfsburg Sub 19Wolfsburg 2 - 3 Osnabrück Sub 19Osnabrück ...
20 Nov 21 Hallescher FC Sub 19Hallescher 1 - 0 Holstein Kiel Sub 19Holstein ...
20 Nov 21 Viktoria Berlin Sub 19Viktoria 0 - 0 RB Leipzig Sub 19Leipzig ...
01 Dic 21 Dynamo Dresden Sub 19Dynamo 2 - 0 Chemnitzer FC Sub 19Chemnitzer ...
20 Nov 21 Hannover 96 Sub 19Hannover 1 - 1 Hansa Rostock Sub 19Hansa ...
23 Feb 22 Union Berlin Sub 19Union 0 - 0 Energie Cottbus Sub 19Energie ...
12 Mar 22 1. FC Magdeburg Sub 19Magdeburg 6 - 2 Hamburger SV Sub 19Hamburger ...
20 Nov 21 Hertha BSC Sub 19Hertha 4 - 2 St. Pauli Sub 19Pauli ...
09 Feb 22 Werder Bremen Sub 19Werder 3 - 2 Carl Zeiss Jena Sub 19Carl Zeiss 1
Ver jornada
Jornada 11
12 Feb 22 St. Pauli Sub 19Pauli 2 - 1 1. FC Magdeburg Sub 19Magdeburg ...
27 Nov 21 Hamburger SV Sub 19Hamburger 5 - 1 Union Berlin Sub 19Union ...
13 Mar 22 Energie Cottbus Sub 19Energie 4 - 3 Hannover 96 Sub 19Hannover ...
27 Nov 21 Eimsbütteler Sub 19Eimsbüttel 0 - 2 Dynamo Dresden Sub 19Dynamo ...
27 Mar 22 Chemnitzer FC Sub 19Chemnitzer 0 - 3 Viktoria Berlin Sub 19Viktoria ...
12 Feb 22 RB Leipzig Sub 19Leipzig 7 - 0 Hallescher FC Sub 19Hallescher ...
12 Feb 22 Holstein Kiel Sub 19Holstein 1 - 1 Wolfsburg Sub 19Wolfsburg ...
28 Nov 21 Osnabrück Sub 19Osnabrück 2 - 3 Werder Bremen Sub 19Werder ...
27 Nov 21 Carl Zeiss Jena Sub 19Carl Zeiss 0 - 2 Hertha BSC Sub 19Hertha ...
Ver jornada
Jornada 12
12 Mar 22 Wolfsburg Sub 19Wolfsburg 0 - 1 RB Leipzig Sub 19Leipzig ...
04 Dic 21 Hallescher FC Sub 19Hallescher 1 - 1 Chemnitzer FC Sub 19Chemnitzer ...
06 Feb 22 Viktoria Berlin Sub 19Viktoria 3 - 1 Eimsbütteler Sub 19Eimsbüttel ...
12 Feb 22 Hansa Rostock Sub 19Hansa 0 - 2 Energie Cottbus Sub 19Energie ...
02 Mar 22 Hannover 96 Sub 19Hannover 1 - 2 Hamburger SV Sub 19Hamburger ...
05 Feb 22 Union Berlin Sub 19Union 2 - 1 St. Pauli Sub 19Pauli ...
15 Feb 22 1. FC Magdeburg Sub 19Magdeburg 2 - 0 Carl Zeiss Jena Sub 19Carl Zeiss ...
05 Dic 21 Hertha BSC Sub 19Hertha 4 - 0 Osnabrück Sub 19Osnabrück ...
23 Feb 22 Werder Bremen Sub 19Werder 1 - 3 Holstein Kiel Sub 19Holstein ...
Ver jornada
Jornada 13
17 Mar 22 St. Pauli Sub 19Pauli 2 - 1 Hannover 96 Sub 19Hannover ...
19 Feb 22 Hamburger SV Sub 19Hamburger 1 - 2 Hansa Rostock Sub 19Hansa ...
19 Feb 22 Dynamo Dresden Sub 19Dynamo 3 - 4 Viktoria Berlin Sub 19Viktoria ...
14 Abr 22 Eimsbütteler Sub 19Eimsbüttel 1 - 2 Hallescher FC Sub 19Hallescher ...
19 Feb 22 Chemnitzer FC Sub 19Chemnitzer 3 - 0 Wolfsburg Sub 19Wolfsburg ...
19 Feb 22 RB Leipzig Sub 19Leipzig 5 - 2 Werder Bremen Sub 19Werder ...
13 Mar 22 Holstein Kiel Sub 19Holstein 1 - 4 Hertha BSC Sub 19Hertha ...
20 Feb 22 Osnabrück Sub 19Osnabrück 2 - 2 1. FC Magdeburg Sub 19Magdeburg ...
19 Feb 22 Carl Zeiss Jena Sub 19Carl Zeiss 1 - 3 Union Berlin Sub 19Union ...
Ver jornada
Jornada 14
26 Feb 22 Wolfsburg Sub 19Wolfsburg 1 - 0 Eimsbütteler Sub 19Eimsbüttel ...
26 Feb 22 Hallescher FC Sub 19Hallescher 0 - 0 Dynamo Dresden Sub 19Dynamo ...
27 Feb 22 Energie Cottbus Sub 19Energie 4 - 1 Hamburger SV Sub 19Hamburger ...
27 Feb 22 Hansa Rostock Sub 19Hansa 5 - 1 St. Pauli Sub 19Pauli ...
26 Feb 22 Hannover 96 Sub 19Hannover 2 - 1 Carl Zeiss Jena Sub 19Carl Zeiss ...
27 Feb 22 Union Berlin Sub 19Union 3 - 1 Osnabrück Sub 19Osnabrück ...
27 Feb 22 1. FC Magdeburg Sub 19Magdeburg 4 - 0 Holstein Kiel Sub 19Holstein ...
26 Feb 22 Hertha BSC Sub 19Hertha 1 - 4 RB Leipzig Sub 19Leipzig ...
26 Feb 22 Werder Bremen Sub 19Werder 2 - 0 Chemnitzer FC Sub 19Chemnitzer ...
Ver jornada
Jornada 15
05 Mar 22 St. Pauli Sub 19Pauli 0 - 2 Energie Cottbus Sub 19Energie ...
05 Mar 22 Viktoria Berlin Sub 19Viktoria 2 - 1 Hallescher FC Sub 19Hallescher ...
05 Mar 22 Dynamo Dresden Sub 19Dynamo 0 - 1 Wolfsburg Sub 19Wolfsburg ...
05 Mar 22 Eimsbütteler Sub 19Eimsbüttel 0 - 0 Werder Bremen Sub 19Werder ...
05 Mar 22 Chemnitzer FC Sub 19Chemnitzer 3 - 1 Hertha BSC Sub 19Hertha ...
05 Mar 22 RB Leipzig Sub 19Leipzig 1 - 3 1. FC Magdeburg Sub 19Magdeburg ...
05 Mar 22 Holstein Kiel Sub 19Holstein 2 - 0 Union Berlin Sub 19Union ...
05 Mar 22 Osnabrück Sub 19Osnabrück 1 - 1 Hannover 96 Sub 19Hannover ...
05 Mar 22 Carl Zeiss Jena Sub 19Carl Zeiss 0 - 3 Hansa Rostock Sub 19Hansa ...
Ver jornada
Jornada 16
02 Abr 22 Wolfsburg Sub 19Wolfsburg 1 - 0 Viktoria Berlin Sub 19Viktoria ...
02 Abr 22 Hamburger SV Sub 19Hamburger 2 - 1 St. Pauli Sub 19Pauli ...
02 Abr 22 Energie Cottbus Sub 19Energie 3 - 0 Carl Zeiss Jena Sub 19Carl Zeiss ...
03 Abr 22 Hansa Rostock Sub 19Hansa 0 - 1 Osnabrück Sub 19Osnabrück ...
03 Abr 22 Hannover 96 Sub 19Hannover 0 - 1 Holstein Kiel Sub 19Holstein ...
02 Abr 22 Union Berlin Sub 19Union 1 - 2 RB Leipzig Sub 19Leipzig ...
02 Abr 22 1. FC Magdeburg Sub 19Magdeburg 4 - 0 Chemnitzer FC Sub 19Chemnitzer ...
02 Abr 22 Hertha BSC Sub 19Hertha 5 - 1 Eimsbütteler Sub 19Eimsbüttel ...
02 Abr 22 Werder Bremen Sub 19Werder 4 - 2 Dynamo Dresden Sub 19Dynamo ...
Ver jornada
Jornada 17
09 Abr 22 Hallescher FC Sub 19Hallescher 0 - 1 Wolfsburg Sub 19Wolfsburg ...
09 Abr 22 Viktoria Berlin Sub 19Viktoria 4 - 1 Werder Bremen Sub 19Werder ...
09 Abr 22 Dynamo Dresden Sub 19Dynamo 1 - 1 Hertha BSC Sub 19Hertha ...
09 Abr 22 Eimsbütteler Sub 19Eimsbüttel 1 - 1 1. FC Magdeburg Sub 19Magdeburg ...
09 Abr 22 Chemnitzer FC Sub 19Chemnitzer 0 - 2 Union Berlin Sub 19Union ...
09 Abr 22 RB Leipzig Sub 19Leipzig 2 - 0 Hannover 96 Sub 19Hannover ...
10 Abr 22 Holstein Kiel Sub 19Holstein 0 - 2 Hansa Rostock Sub 19Hansa ...
09 Abr 22 Osnabrück Sub 19Osnabrück 2 - 0 Energie Cottbus Sub 19Energie ...
09 Abr 22 Carl Zeiss Jena Sub 19Carl Zeiss 0 - 5 Hamburger SV Sub 19Hamburger ...
Ver jornada
Jornada 18
23 Abr 22 St. Pauli Sub 19Pauli 2 - 0 Carl Zeiss Jena Sub 19Carl Zeiss ...
23 Abr 22 Hamburger SV Sub 19Hamburger 4 - 1 Osnabrück Sub 19Osnabrück ...
23 Abr 22 Energie Cottbus Sub 19Energie 2 - 1 Holstein Kiel Sub 19Holstein ...
23 Abr 22 Hansa Rostock Sub 19Hansa 1 - 3 RB Leipzig Sub 19Leipzig ...
23 Abr 22 Hannover 96 Sub 19Hannover 1 - 0 Chemnitzer FC Sub 19Chemnitzer ...
23 Abr 22 Union Berlin Sub 19Union 0 - 3 Eimsbütteler Sub 19Eimsbüttel ...
23 Abr 22 1. FC Magdeburg Sub 19Magdeburg 2 - 2 Dynamo Dresden Sub 19Dynamo ...
23 Abr 22 Hertha BSC Sub 19Hertha 1 - 0 Viktoria Berlin Sub 19Viktoria ...
23 Abr 22 Werder Bremen Sub 19Werder 2 - 3 Hallescher FC Sub 19Hallescher ...
Ver jornada
Jornada 19
30 Abr 22 Wolfsburg Sub 19Wolfsburg 1 - 1 Werder Bremen Sub 19Werder ...
30 Abr 22 Hallescher FC Sub 19Hallescher 1 - 2 Hertha BSC Sub 19Hertha ...
30 Abr 22 Viktoria Berlin Sub 19Viktoria 2 - 0 1. FC Magdeburg Sub 19Magdeburg ...
30 Abr 22 Dynamo Dresden Sub 19Dynamo 1 - 1 Union Berlin Sub 19Union ...
30 Abr 22 Eimsbütteler Sub 19Eimsbüttel 0 - 4 Hannover 96 Sub 19Hannover ...
30 Abr 22 Chemnitzer FC Sub 19Chemnitzer 0 - 2 Hansa Rostock Sub 19Hansa ...
30 Abr 22 RB Leipzig Sub 19Leipzig 1 - 1 Energie Cottbus Sub 19Energie ...
30 Abr 22 Holstein Kiel Sub 19Holstein 2 - 0 Hamburger SV Sub 19Hamburger ...
30 Abr 22 Osnabrück Sub 19Osnabrück 1 - 9 St. Pauli Sub 19Pauli ...

Clasificación

Equipo PJ GF GC Puntos
1 Hertha BSC Sub 19 Hertha 18 46 22 44
2 Energie Cottbus Sub 19 Energie 18 32 19 39
3 RB Leipzig Sub 19 Leipzig 18 44 20 37
4 Werder Bremen Sub 19 Werder 18 43 37 32
5 Holstein Kiel Sub 19 Holstein 18 28 25 32
6 Viktoria Berlin Sub 19 Viktoria 18 31 20 30
7 Wolfsburg Sub 19 Wolfsburg 18 22 21 27
8 Union Berlin Sub 19 Union Berlin 18 26 27 26
9 Hannover 96 Sub 19 Hannover 18 25 22 25
10 Hamburger SV Sub 19 Hamburger 18 35 33 25
11 Hansa Rostock Sub 19 Hansa 18 32 24 24
12 Dynamo Dresden Sub 19 Dynamo 18 26 23 22
13 1. FC Magdeburg Sub 19 Magdeburg 18 33 31 21
14 St. Pauli Sub 19 Pauli 18 34 36 21
15 Hallescher FC Sub 19 Hallescher 18 19 34 21
16 Osnabrück Sub 19 Osnabrück 18 21 41 19
17 Chemnitzer FC Sub 19 Chemnitzer 18 16 30 16
18 Eimsbütteler Sub 19 Eimsbüttele 18 18 37 13
19 Carl Zeiss Jena Sub 19 Carl Zeiss. 18 12 41 5

  USO DE MEMORIA  
6,310,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1581
Total Execution Time  0.1601
  CADENA URL  
/bundesliga_sub_192022/grupo1/calendario
  GET DATOS  
$_GET['/bundesliga_sub_192022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'bundesliga_sub_192022'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_sub_19' 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=1586 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1586 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  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 (1197781,1187339,1177490,1177454,1135000) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1586 ORDER BY order_id ASC
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 = 63887 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 = 63887 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 13:20:10' 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-18 13:20:10' 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-18 13:20:10' 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-18 13:20:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_sub_19' 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.0147  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 = 63887 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63887 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.0163  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 = 63887 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63887 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 = 63887 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63887 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  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 = 63887 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC