4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del VfB Stuttgart Sub 19
TEMPORADA 2023/2024
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Hoffenheim Sub 19 Hoffenheim 25 83 25 64
2 Ingolstadt Sub 19 Ingolstadt 25 50 27 55
3 Mainz 05 Sub 19 Mainz 25 47 39 46
4 VfB Stuttgart Sub 19 Stuttgart 25 57 32 45
5 Karlsruher SC Sub 19 Karlsruher 25 51 38 45
6 Eintracht Frankfurt Sub 19 Eintracht 25 55 45 44
7 Bayern München Sub 19 Bayern 25 56 48 37
8 1860 München Sub 19 1860 25 37 39 34
9 Nürnberg Sub 19 Nürnberg 25 48 58 27
10 Greuther Fürth Sub 19 Greuther 25 33 53 26
11 Heidenheim Sub 19 Heidenheim 25 42 49 25
12 Sandhausen Sub 19 Sandhausen 25 34 60 18
13 Kaiserslautern Sub 19 Kaiserslaute 25 22 61 17
14 FC Augsburg Sub 19 Augsburg 25 29 70 14
TEMPORADA 2022/2023
BUNDESLIGA SUB 19 GRUPO 4
Equipo PJ GF GC Puntos
1 Hamburger SV Sub 19 Hamburger 3 8 4 7
2 Energie Cottbus Sub 19 Energie 3 5 1 7
3 Werder Bremen Sub 19 Werder 3 11 10 6
4 Hansa Rostock Sub 19 Hansa 3 6 5 6
5 RB Leipzig Sub 19 Leipzig 3 5 4 5
6 Union Berlin Sub 19 Union Berlin 3 9 4 4
7 Dynamo Dresden Sub 19 Dynamo 3 6 5 4
8 Hertha Zehlendorf Sub 19 Hertha 3 5 5 4
9 St. Pauli Sub 19 Pauli 3 5 5 4
10 Viktoria Berlin Sub 19 Viktoria 3 5 11 3
11 Holstein Kiel Sub 19 Holstein 3 5 10 0
12 1. FC Magdeburg Sub 19 Magdeburg 3 2 8 0
13 FC Augsburg Sub 19 Augsburg 3 7 3 6
14 Heidenheim Sub 19 Heidenheim 3 7 5 6
15 Unterhaching Sub 19 Unterhaching 3 4 5 3
16 Reutlingen Sub 19 Reutlingen 3 3 8 3
17 Nürnberg Sub 19 Nürnberg 3 8 3 9
18 Bayern München Sub 19 Bayern 3 8 5 6
19 1860 München Sub 19 1860 3 3 6 1
20 Ingolstadt Sub 19 Ingolstadt 3 4 9 1
21 VfB Stuttgart Sub 19 Stuttgart 3 15 2 9
22 Hoffenheim Sub 19 Hoffenheim 3 13 8 6
23 Freiburg Sub 19 Freiburg 3 4 6 3
24 Astoria Walldorf Sub 19 Astoria 3 3 19 0
25 Eintracht Frankfurt Sub 19 Eintracht 3 12 5 7
26 Darmstadt 98 Sub 19 Darmstadt 3 10 4 6
27 Karlsruher SC Sub 19 Karlsruher 3 5 7 4
28 Eintracht Trier Sub 19 Eintracht 3 3 14 0
29 Fortuna Düsseldorf Sub 19 Fortuna 3 8 6 6
30 Rot-Weiß Oberhausen Sub 19 Rot-Weiß 3 6 4 6
31 Rot-Weiss Essen Sub 19 Rot-Weiss 3 3 2 4
32 Viktoria Koln Sub 19 Viktoria 3 2 7 1
33 B. Mönchengladbach Sub 19 Mönchenglad 3 14 8 7
34 B. Leverkusen Sub 19 Leverkusen 3 11 6 5
35 Hilden Sub 19 Hilden 3 5 6 4
36 Bonner SC Sub 19 Bonner 3 2 12 0
37 VfL Bochum Sub 19 Bochum 3 14 6 9
38 MSV Duisburg Sub 19 Duisburg 3 8 8 3
39 Meppen Sub 19 Meppen 3 7 10 3
40 Preußen Münster Sub 19 Preußen 3 5 10 3
41 Wolfsburg Sub 19 Wolfsburg 3 9 1 9
42 SC Paderborn Sub 19 Paderborn 3 6 3 6
43 Hannover 96 Sub 19 Hannover 3 7 7 3
44 SC Verl Sub 19 Verl 3 2 13 0
TEMPORADA 2021/2022
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 FC Augsburg Sub 19 Augsburg 20 56 31 46
2 Nürnberg Sub 19 Nürnberg 20 45 27 46
3 Eintracht Frankfurt Sub 19 Eintracht 20 58 24 45
4 VfB Stuttgart Sub 19 Stuttgart 20 55 16 44
5 Mainz 05 Sub 19 Mainz 20 58 39 36
6 Hoffenheim Sub 19 Hoffenheim 20 64 36 35
7 Unterhaching Sub 19 Unterhaching 20 35 34 33
8 Freiburg Sub 19 Freiburg 20 43 34 31
9 Bayern München Sub 19 Bayern 20 57 35 29
10 Karlsruher SC Sub 19 Karlsruher 20 34 30 29
11 Darmstadt 98 Sub 19 Darmstadt 20 28 32 29
12 Heidenheim Sub 19 Heidenheim 20 35 30 28
13 Ingolstadt Sub 19 Ingolstadt 20 44 40 25
14 Astoria Walldorf Sub 19 Astoria 20 39 35 25
15 Kaiserslautern Sub 19 Kaiserslaute 20 39 54 25
16 Stuttgarter Kickers Sub 19 Stuttgarter 20 33 51 20
17 Saarbrücken Sub 19 Saarbrücken 20 20 41 18
18 Greuther Fürth Sub 19 Greuther 20 27 44 17
19 Kickers Offenbach FC Sub 19 Kickers 20 24 48 17
20 Ulm Sub 19 Ulm Sub 19 20 26 53 16
21 Hessen Kassel Sub 19 Hessen 20 7 93 3
TEMPORADA 2020/2021
BUNDESLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 VfB Stuttgart Sub 19 Stuttgart 4 11 4 10
2 Mainz 05 Sub 19 Mainz 3 11 2 9
3 Ingolstadt Sub 19 Ingolstadt 4 7 4 8
4 Bayern München Sub 19 Bayern 4 11 6 7
5 Hoffenheim Sub 19 Hoffenheim 4 10 6 7
6 Darmstadt 98 Sub 19 Darmstadt 4 5 4 7
7 Heidenheim Sub 19 Heidenheim 4 7 7 7
8 Greuther Fürth Sub 19 Greuther 4 11 12 6
9 Kickers Offenbach FC Sub 19 Kickers 4 8 9 6
10 Karlsruher SC Sub 19 Karlsruher 4 8 10 6
11 Nürnberg Sub 19 Nürnberg 4 8 6 5
12 Freiburg Sub 19 Freiburg 4 6 5 5
13 Eintracht Frankfurt Sub 19 Eintracht 4 6 7 3
14 FC Augsburg Sub 19 Augsburg 4 8 10 3
15 Saarbrücken Sub 19 Saarbrücken 3 4 6 3
16 Kaiserslautern Sub 19 Kaiserslaute 4 5 9 3
17 Astoria Walldorf Sub 19 Astoria 4 3 9 3
18 Ulm Sub 19 Ulm Sub 19 4 3 16 0
TEMPORADA 2019/2020
BUNDESLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Bayern München Sub 19 Bayern 19 60 18 47
2 VfB Stuttgart Sub 19 Stuttgart 20 44 23 43
3 Mainz 05 Sub 19 Mainz 19 45 20 41
4 Freiburg Sub 19 Freiburg 20 42 20 41
5 Hoffenheim Sub 19 Hoffenheim 20 43 30 39
6 Eintracht Frankfurt Sub 19 Eintracht 20 43 28 38
7 Heidenheim Sub 19 Heidenheim 20 31 36 26
8 Ingolstadt Sub 19 Ingolstadt 20 24 36 22
9 FC Augsburg Sub 19 Augsburg 20 34 40 19
10 Kaiserslautern Sub 19 Kaiserslaute 19 20 34 19
11 Karlsruher SC Sub 19 Karlsruher 20 20 44 19
12 Kickers Offenbach FC Sub 19 Kickers 20 25 43 18
13 Ulm Sub 19 Ulm Sub 19 19 15 47 9
14 Greuther Fürth Sub 19 Greuther 20 19 46 7
TEMPORADA 2018/2019
BUNDESLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 VfB Stuttgart Sub 19 Stuttgart 26 55 27 60
2 Mainz 05 Sub 19 Mainz 26 59 23 53
3 Ingolstadt Sub 19 Ingolstadt 26 46 31 47
4 Bayern München Sub 19 Bayern 26 52 34 46
5 Hoffenheim Sub 19 Hoffenheim 26 49 45 39
6 Freiburg Sub 19 Freiburg 26 53 42 38
7 FC Augsburg Sub 19 Augsburg 26 41 47 34
8 Karlsruher SC Sub 19 Karlsruher 26 41 41 33
9 Heidenheim Sub 19 Heidenheim 26 35 39 32
10 Eintracht Frankfurt Sub 19 Eintracht 26 37 44 31
11 Kaiserslautern Sub 19 Kaiserslaute 26 34 48 31
12 Nürnberg Sub 19 Nürnberg 26 40 50 30
13 Stuttgarter Kickers Sub 19 Stuttgarter 26 19 45 24
14 FSV Frankfurt Sub 19 Frankfurt 26 18 63 12
TEMPORADA 2017/2018
BUNDESLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Hoffenheim Sub 19 Hoffenheim 26 72 23 61
2 Bayern München Sub 19 Bayern 26 56 27 61
3 FC Augsburg Sub 19 Augsburg 26 47 36 40
4 Mainz 05 Sub 19 Mainz 26 52 44 40
5 Karlsruher SC Sub 19 Karlsruher 26 36 32 40
6 VfB Stuttgart Sub 19 Stuttgart 26 44 46 38
7 Heidenheim Sub 19 Heidenheim 26 39 42 36
8 Freiburg Sub 19 Freiburg 26 44 42 35
9 Kaiserslautern Sub 19 Kaiserslaute 26 40 49 31
10 Nürnberg Sub 19 Nürnberg 26 36 51 29
11 Eintracht Frankfurt Sub 19 Eintracht 26 34 49 27
12 Wehen Wiesbaden Sub 19 Wehen 26 33 48 27
13 Unterhaching Sub 19 Unterhaching 26 39 62 21
14 Greuther Fürth Sub 19 Greuther 26 28 49 20
TEMPORADA 2016/2017
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Bayern München Sub 19 Bayern 26 54 30 49
2 Kaiserslautern Sub 19 Kaiserslaute 26 56 45 46
3 Mainz 05 Sub 19 Mainz 26 51 34 44
4 Hoffenheim Sub 19 Hoffenheim 26 57 40 43
5 FC Augsburg Sub 19 Augsburg 26 36 30 38
6 Eintracht Frankfurt Sub 19 Eintracht 26 42 37 36
7 Nürnberg Sub 19 Nürnberg 26 41 38 36
8 Freiburg Sub 19 Freiburg 26 40 44 35
9 Karlsruher SC Sub 19 Karlsruher 26 39 48 35
10 Greuther Fürth Sub 19 Greuther 26 37 46 34
11 VfB Stuttgart Sub 19 Stuttgart 26 37 42 31
12 Ingolstadt Sub 19 Ingolstadt 26 33 40 28
13 1860 München Sub 19 1860 26 36 48 28
14 Stuttgarter Kickers Sub 19 Stuttgarter 26 25 62 19
TEMPORADA 2015/2016
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Hoffenheim Sub 19 Hoffenheim 26 82 35 62
2 1860 München Sub 19 1860 26 72 31 59
3 VfB Stuttgart Sub 19 Stuttgart 26 40 27 43
4 Mainz 05 Sub 19 Mainz 26 56 40 41
5 Greuther Fürth Sub 19 Greuther 26 44 38 36
6 Nürnberg Sub 19 Nürnberg 26 39 36 35
7 Freiburg Sub 19 Freiburg 26 41 46 35
8 Bayern München Sub 19 Bayern 26 43 32 34
9 Karlsruher SC Sub 19 Karlsruher 26 48 50 33
10 Eintracht Frankfurt Sub 19 Eintracht 26 43 52 33
11 Ingolstadt Sub 19 Ingolstadt 26 45 50 31
12 Saarbrücken Sub 19 Saarbrücken 26 36 62 28
13 Heidenheim Sub 19 Heidenheim 26 33 56 26
14 Darmstadt 98 Sub 19 Darmstadt 26 17 84 16
TEMPORADA 2014/2015
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Hoffenheim Sub 19 Hoffenheim 26 82 29 64
2 Karlsruher SC Sub 19 Karlsruher 26 61 42 51
3 Mainz 05 Sub 19 Mainz 26 57 38 46
4 Freiburg Sub 19 Freiburg 26 41 32 45
5 Bayern München Sub 19 Bayern 26 65 45 42
6 Greuther Fürth Sub 19 Greuther 26 51 42 37
7 Nürnberg Sub 19 Nürnberg 26 40 41 36
8 Eintracht Frankfurt Sub 19 Eintracht 26 44 51 34
9 VfB Stuttgart Sub 19 Stuttgart 26 53 45 32
10 1860 München Sub 19 1860 26 38 39 32
11 Saarbrücken Sub 19 Saarbrücken 26 38 59 31
12 Kaiserslautern Sub 19 Kaiserslaute 26 37 63 30
13 FC Augsburg Sub 19 Augsburg 26 34 44 27
14 Waldhof Mannheim Sub 19 Waldhof 26 26 97 5
TEMPORADA 2013/2014
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Hoffenheim Sub 19 Hoffenheim 26 61 26 53
2 1860 München Sub 19 1860 26 50 34 49
3 VfB Stuttgart Sub 19 Stuttgart 26 51 30 48
4 Kaiserslautern Sub 19 Kaiserslaute 26 50 44 46
5 Mainz 05 Sub 19 Mainz 26 50 33 45
6 Bayern München Sub 19 Bayern 26 55 40 40
7 Eintracht Frankfurt Sub 19 Eintracht 26 42 32 39
8 FC Augsburg Sub 19 Augsburg 26 41 45 34
9 Greuther Fürth Sub 19 Greuther 26 43 41 33
10 Freiburg Sub 19 Freiburg 26 39 34 32
11 Karlsruher SC Sub 19 Karlsruher 26 54 48 31
12 Unterhaching Sub 19 Unterhaching 26 38 47 30
13 Astoria Walldorf Sub 19 Astoria 26 44 80 17
14 Wacker Burghausen Sub 19 Wacker 26 17 101 3
TEMPORADA 2012/2013
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Bayern München Sub 19 Bayern 26 65 28 56
2 VfB Stuttgart Sub 19 Stuttgart 26 74 37 53
3 Hoffenheim Sub 19 Hoffenheim 26 70 36 50
4 1860 München Sub 19 1860 26 37 35 46
5 Freiburg Sub 19 Freiburg 26 64 42 44
6 Mainz 05 Sub 19 Mainz 26 45 37 42
7 Unterhaching Sub 19 Unterhaching 26 48 50 33
8 Greuther Fürth Sub 19 Greuther 26 37 41 33
9 FC Augsburg Sub 19 Augsburg 26 38 56 32
10 Karlsruher SC Sub 19 Karlsruher 26 31 45 29
11 Eintracht Frankfurt Sub 19 Eintracht 26 45 57 28
12 FSV Frankfurt Sub 19 Frankfurt 26 48 78 27
13 Nürnberg Sub 19 Nürnberg 26 41 58 25
14 Stuttgarter Kickers Sub 19 Stuttgarter 26 25 68 16
TEMPORADA 2011/2012
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Bayern München Sub 19 Bayern 26 51 24 56
2 Freiburg Sub 19 Freiburg 26 56 29 50
3 Mainz 05 Sub 19 Mainz 26 51 39 48
4 Karlsruher SC Sub 19 Karlsruher 26 51 41 39
5 Eintracht Frankfurt Sub 19 Eintracht 26 47 40 39
6 VfB Stuttgart Sub 19 Stuttgart 26 45 40 38
7 Greuther Fürth Sub 19 Greuther 26 41 46 38
8 1860 München Sub 19 1860 26 42 41 36
9 Unterhaching Sub 19 Unterhaching 26 35 37 35
10 Nürnberg Sub 19 Nürnberg 26 44 50 33
11 Hoffenheim Sub 19 Hoffenheim 26 36 37 32
12 Waldhof Mannheim Sub 19 Waldhof 26 27 30 30
13 Kaiserslautern Sub 19 Kaiserslaute 26 27 42 28
14 Saarbrücken Sub 19 Saarbrücken 26 30 87 12
TEMPORADA 2010/2011
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Kaiserslautern Sub 19 Kaiserslaute 26 55 38 55
2 1860 München Sub 19 1860 26 45 32 54
3 Freiburg Sub 19 Freiburg 26 67 27 50
4 VfB Stuttgart Sub 19 Stuttgart 26 58 32 48
5 Nürnberg Sub 19 Nürnberg 26 69 44 48
6 Mainz 05 Sub 19 Mainz 26 49 36 39
7 Bayern München Sub 19 Bayern 26 40 35 37
8 Eintracht Frankfurt Sub 19 Eintracht 26 34 41 34
9 Hoffenheim Sub 19 Hoffenheim 26 51 53 33
10 Greuther Fürth Sub 19 Greuther 26 54 58 30
11 Karlsruher SC Sub 19 Karlsruher 26 28 41 27
12 Ulm Sub 19 Ulm Sub 19 26 31 69 18
13 FC Augsburg Sub 19 Augsburg 26 22 58 17
14 Wehen Wiesbaden Sub 19 Wehen 26 21 60 16
TEMPORADA 2009/2010
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 VfB Stuttgart Sub 19 Stuttgart 26 62 24 58
2 Mainz 05 Sub 19 Mainz 26 61 44 53
3 Karlsruher SC Sub 19 Karlsruher 26 55 35 50
4 Freiburg Sub 19 Freiburg 26 56 39 49
5 Hoffenheim Sub 19 Hoffenheim 26 61 41 44
6 Nürnberg Sub 19 Nürnberg 26 49 35 44
7 1860 München Sub 19 1860 26 50 31 43
8 Kaiserslautern Sub 19 Kaiserslaute 26 44 40 40
9 Bayern München Sub 19 Bayern 26 54 40 34
10 Eintracht Frankfurt Sub 19 Eintracht 26 54 62 31
11 Greuther Fürth Sub 19 Greuther 26 41 52 31
12 Darmstadt 98 Sub 19 Darmstadt 26 28 56 21
13 Waldhof Mannheim Sub 19 Waldhof 26 25 67 13
14 SSV Jahn Regensburg Sub 19 Jahn 26 21 95 8
TEMPORADA 2008/2009
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Freiburg Sub 19 Freiburg 26 68 29 57
2 Mainz 05 Sub 19 Mainz 26 61 26 54
3 Bayern München Sub 19 Bayern 26 56 28 48
4 Karlsruher SC Sub 19 Karlsruher 26 58 46 47
5 VfB Stuttgart Sub 19 Stuttgart 26 51 39 39
6 Hoffenheim Sub 19 Hoffenheim 26 41 35 37
7 1860 München Sub 19 1860 26 46 46 35
8 Kaiserslautern Sub 19 Kaiserslaute 26 49 37 34
9 Eintracht Frankfurt Sub 19 Eintracht 26 47 50 33
10 Greuther Fürth Sub 19 Greuther 26 42 36 31
11 SSV Jahn Regensburg Sub 19 Jahn 26 43 58 31
12 Kickers Offenbach FC Sub 19 Kickers 26 38 57 28
13 Unterhaching Sub 19 Unterhaching 26 33 62 23
14 Villingen Sub 19 Villingen 26 15 99 12
TEMPORADA 2007/2008
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 VfB Stuttgart Sub 19 Stuttgart 26 71 28 62
2 Freiburg Sub 19 Freiburg 26 55 32 56
3 Bayern München Sub 19 Bayern 26 79 30 55
4 Eintracht Frankfurt Sub 19 Eintracht 26 48 35 42
5 Mainz 05 Sub 19 Mainz 26 43 27 41
6 Karlsruher SC Sub 19 Karlsruher 26 36 30 40
7 Kaiserslautern Sub 19 Kaiserslaute 26 52 44 39
8 1860 München Sub 19 1860 26 40 33 35
9 Hoffenheim Sub 19 Hoffenheim 26 41 51 33
10 Greuther Fürth Sub 19 Greuther 26 32 38 31
11 SSV Jahn Regensburg Sub 19 Jahn 26 29 61 23
12 Stuttgarter Kickers Sub 19 Stuttgarter 26 24 52 19
13 Offenburger FV Sub 19 Offenburger 26 27 66 19
14 Wacker Burghausen Sub 19 Wacker 26 19 69 13
TEMPORADA 2006/2007
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Bayern München Sub 19 Bayern 26 59 22 57
2 Kaiserslautern Sub 19 Kaiserslaute 26 42 29 49
3 Mainz 05 Sub 19 Mainz 26 53 39 48
4 VfB Stuttgart Sub 19 Stuttgart 26 50 31 45
5 Freiburg Sub 19 Freiburg 26 44 24 42
6 Greuther Fürth Sub 19 Greuther 26 29 27 42
7 1860 München Sub 19 1860 26 44 33 39
8 Wacker Burghausen Sub 19 Wacker 26 35 41 37
9 Karlsruher SC Sub 19 Karlsruher 26 34 37 31
10 Hoffenheim Sub 19 Hoffenheim 26 33 38 30
11 Stuttgarter Kickers Sub 19 Stuttgarter 26 32 50 28
12 Nürnberg Sub 19 Nürnberg 26 32 52 23
13 Reutlingen Sub 19 Reutlingen 26 24 60 19
14 Ulm Sub 19 Ulm Sub 19 26 25 53 18

  USO DE MEMORIA  
7,109,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1389
Total Execution Time  0.1402
  CADENA URL  
/historico/Vfb-Stuttgart-Sub19
  GET DATOS  
$_GET['/historico/Vfb-Stuttgart-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0045  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72761
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60932 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1586 AND type_rel = 3
0.0022  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.0023  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.0028  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '60932' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72761 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=60932 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72761,68269) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72761 AND teamId = 60932
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 68269 AND teamId = 60932
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72761 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '60932' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60932' and rp.type = 4
0.0022  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '60932' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0041  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72761 WHERE rp.league_id = 72761 AND rp.teamId = 60932 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72761 WHERE rp.league_id = 72761 AND rp.teamId = 60932 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72761 WHERE rp.league_id = 72761 AND rp.teamId = 60932 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 60932 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 72761 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
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 71716 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 68272 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 71423 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 63888 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
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 57740 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 50607 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 44481 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 39562 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` 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 = 34478 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 15556 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 9347 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 42242 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 23836 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` 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 = 24286 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` 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 = 44067 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 44070 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 44078 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` 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 = 44086 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 44087 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC