TEMPORADA 2023/2024
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Leverkusen Leverkusen 26 66 18 70
2 Bayern München Bayern 26 78 31 60
3 Stuttgart Stuttgart 26 60 31 56
4 B. Dortmund B. Dortmund 26 53 32 50
5 RB Leipzig RB Leipzig 26 60 32 49
6 Eintracht Frankfurt Eintracht 26 42 35 40
7 FC Augsburg FC Augsburg 26 43 42 35
8 Hoffenheim Hoffenheim 26 44 50 33
9 SC Freiburg SC Freiburg 26 36 48 33
10 Werder Bremen Werder 26 35 41 30
11 Heidenheim Heidenheim 26 35 44 29
12 B. Mönchengladbach Mönchenglad 26 46 50 28
13 Union Berlin Union Berlin 26 25 42 28
14 Wolfsburg Wolfsburg 26 31 44 25
15 VfL Bochum VfL Bochum 26 30 54 25
16 Mainz 05 Mainz 05 26 22 46 19
17 Köln Köln 26 20 47 18
18 Darmstadt 98 Darmstadt 26 26 65 13
TEMPORADA 2022/2023
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 92 38 71
2 B. Dortmund B. Dortmund 34 83 44 71
3 RB Leipzig RB Leipzig 34 64 41 66
4 Union Berlin Union Berlin 34 51 38 62
5 SC Freiburg SC Freiburg 34 51 44 59
6 B. Leverkusen Leverkusen 34 57 49 50
7 Eintracht Frankfurt Eintracht 34 58 52 50
8 Wolfsburg Wolfsburg 34 57 48 49
9 Mainz 05 Mainz 05 34 54 55 46
10 B. Mönchengladbach Mönchenglad 34 52 55 43
11 Köln Köln 34 49 54 42
12 Hoffenheim Hoffenheim 34 48 57 36
13 Werder Bremen Werder 34 51 64 36
14 VfL Bochum VfL Bochum 34 40 72 35
15 FC Augsburg FC Augsburg 34 42 63 34
16 Stuttgart Stuttgart 34 45 57 33
17 Schalke 04 Schalke 04 34 35 71 31
18 Hertha BSC Hertha BSC 34 42 69 29
TEMPORADA 2021/2022
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 97 37 77
2 B. Dortmund B. Dortmund 34 85 52 69
3 B. Leverkusen Leverkusen 34 80 47 64
4 RB Leipzig RB Leipzig 34 72 37 58
5 Union Berlin Union Berlin 34 50 44 57
6 SC Freiburg SC Freiburg 34 58 46 55
7 Köln Köln 34 52 49 52
8 Mainz 05 Mainz 05 34 50 45 46
9 Hoffenheim Hoffenheim 34 58 60 46
10 B. Mönchengladbach Mönchenglad 34 54 61 45
11 Eintracht Frankfurt Eintracht 34 45 49 42
12 Wolfsburg Wolfsburg 34 43 54 42
13 VfL Bochum VfL Bochum 34 38 52 42
14 FC Augsburg FC Augsburg 34 39 56 38
15 Stuttgart Stuttgart 34 41 59 33
16 Hertha BSC Hertha BSC 34 37 71 33
17 Arminia Bielefeld Arminia 34 27 53 28
18 Greuther Fürth Greuther 34 28 82 18
TEMPORADA 2020/2021
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 99 44 78
2 RB Leipzig RB Leipzig 34 60 32 65
3 B. Dortmund B. Dortmund 34 75 46 64
4 Wolfsburg Wolfsburg 34 61 37 61
5 Eintracht Frankfurt Eintracht 34 69 53 60
6 B. Leverkusen Leverkusen 34 53 39 52
7 Union Berlin Union Berlin 34 50 43 50
8 B. Mönchengladbach Mönchenglad 34 64 56 49
9 Stuttgart Stuttgart 34 56 55 45
10 SC Freiburg SC Freiburg 34 52 52 45
11 Hoffenheim Hoffenheim 34 52 54 43
12 Mainz 05 Mainz 05 34 39 56 39
13 FC Augsburg FC Augsburg 34 36 54 36
14 Hertha BSC Hertha BSC 34 41 52 35
15 Arminia Bielefeld Arminia 34 26 52 35
16 Köln Köln 34 34 60 33
17 Werder Bremen Werder 34 36 57 31
18 Schalke 04 Schalke 04 34 25 86 16
TEMPORADA 2019/2020
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 100 32 82
2 B. Dortmund B. Dortmund 34 84 41 69
3 RB Leipzig RB Leipzig 34 81 37 66
4 B. Mönchengladbach Mönchenglad 34 66 40 65
5 B. Leverkusen Leverkusen 34 61 44 63
6 Hoffenheim Hoffenheim 34 53 53 52
7 Wolfsburg Wolfsburg 34 48 46 49
8 SC Freiburg SC Freiburg 34 48 47 48
9 Eintracht Frankfurt Eintracht 34 59 60 45
10 Hertha BSC Hertha BSC 34 48 59 41
11 Union Berlin Union Berlin 34 41 58 41
12 Schalke 04 Schalke 04 34 38 58 39
13 Mainz 05 Mainz 05 34 44 65 37
14 Köln Köln 34 51 69 36
15 FC Augsburg FC Augsburg 34 45 63 36
16 Werder Bremen Werder 34 42 69 31
17 Fortuna Düsseldorf Fortuna 34 36 67 30
18 Paderborn Paderborn 34 37 74 20
TEMPORADA 2018/2019
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 88 32 78
2 B. Dortmund B. Dortmund 34 81 44 76
3 RB Leipzig RB Leipzig 34 63 29 66
4 B. Leverkusen Leverkusen 34 69 52 58
5 B. Mönchengladbach Mönchenglad 34 55 42 55
6 Wolfsburg Wolfsburg 34 62 50 55
7 Eintracht Frankfurt Eintracht 34 60 48 54
8 Werder Bremen Werder 34 58 49 53
9 Hoffenheim Hoffenheim 34 70 52 51
10 Fortuna Düsseldorf Fortuna 34 49 65 44
11 Hertha BSC Hertha BSC 34 49 57 43
12 Mainz 05 Mainz 05 34 46 57 43
13 SC Freiburg SC Freiburg 34 46 61 36
14 Schalke 04 Schalke 04 34 37 55 33
15 FC Augsburg FC Augsburg 34 51 71 32
16 Stuttgart Stuttgart 34 32 70 28
17 Hannover 96 Hannover 96 34 31 71 21
18 Nürnberg Nürnberg 34 26 68 19
TEMPORADA 2017/2018
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 92 28 84
2 Schalke 04 Schalke 04 34 53 37 63
3 Hoffenheim Hoffenheim 34 66 48 55
4 B. Dortmund B. Dortmund 34 64 47 55
5 B. Leverkusen Leverkusen 34 58 44 55
6 RB Leipzig RB Leipzig 34 57 53 53
7 Stuttgart Stuttgart 34 36 36 51
8 Eintracht Frankfurt Eintracht 34 45 45 49
9 B. Mönchengladbach Mönchenglad 34 47 52 47
10 Hertha BSC Hertha BSC 34 43 46 43
11 Werder Bremen Werder 34 37 40 42
12 FC Augsburg FC Augsburg 34 43 46 41
13 Hannover 96 Hannover 96 34 44 54 39
14 Mainz 05 Mainz 05 34 38 52 36
15 SC Freiburg SC Freiburg 34 32 56 36
16 Wolfsburg Wolfsburg 34 36 48 33
17 Hamburger SV Hamburger 34 29 53 31
18 Köln Köln 34 35 70 22
TEMPORADA 2016/2017
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 89 22 82
2 RB Leipzig RB Leipzig 34 66 39 67
3 B. Dortmund B. Dortmund 34 72 40 64
4 Hoffenheim Hoffenheim 34 64 37 62
5 Köln Köln 34 51 42 49
6 Hertha BSC Hertha BSC 34 43 47 49
7 SC Freiburg SC Freiburg 34 42 60 48
8 Werder Bremen Werder 34 61 64 45
9 B. Mönchengladbach Mönchenglad 34 45 49 45
10 Schalke 04 Schalke 04 34 45 40 43
11 Eintracht Frankfurt Eintracht 34 36 43 42
12 B. Leverkusen Leverkusen 34 53 55 41
13 FC Augsburg FC Augsburg 34 35 51 38
14 Hamburger SV Hamburger 34 33 61 38
15 Mainz 05 Mainz 05 34 44 55 37
16 Wolfsburg Wolfsburg 34 34 52 37
17 Ingolstadt 04 Ingolstadt 34 36 57 32
18 Darmstadt 98 Darmstadt 34 28 63 25
TEMPORADA 2015/2016
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 80 17 88
2 B. Dortmund B. Dortmund 34 82 34 78
3 B. Leverkusen Leverkusen 34 56 40 60
4 B. Mönchengladbach Mönchenglad 34 67 50 55
5 Schalke 04 Schalke 04 34 51 49 52
6 Mainz 05 Mainz 05 34 46 42 50
7 Hertha BSC Hertha BSC 34 42 42 50
8 Wolfsburg Wolfsburg 34 47 49 45
9 Köln Köln 34 38 42 43
10 Hamburger SV Hamburger 34 40 46 41
11 Ingolstadt 04 Ingolstadt 34 33 42 40
12 FC Augsburg FC Augsburg 34 42 52 38
13 Werder Bremen Werder 34 50 65 38
14 Darmstadt 98 Darmstadt 34 38 53 38
15 Hoffenheim Hoffenheim 34 39 54 37
16 Eintracht Frankfurt Eintracht 34 34 52 36
17 Stuttgart Stuttgart 34 50 75 33
18 Hannover 96 Hannover 96 34 31 62 25
TEMPORADA 2014/2015
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 80 18 79
2 Wolfsburg Wolfsburg 34 72 38 69
3 B. Mönchengladbach Mönchenglad 34 53 26 66
4 B. Leverkusen Leverkusen 34 62 37 61
5 FC Augsburg FC Augsburg 34 43 43 49
6 Schalke 04 Schalke 04 34 42 40 48
7 B. Dortmund B. Dortmund 34 47 42 46
8 Hoffenheim Hoffenheim 34 49 55 44
9 Eintracht Frankfurt Eintracht 34 56 62 43
10 Werder Bremen Werder 34 50 65 43
11 Mainz 05 Mainz 05 34 45 47 40
12 Köln Köln 34 34 40 40
13 Hannover 96 Hannover 96 34 40 56 37
14 Stuttgart Stuttgart 34 42 60 36
15 Hertha BSC Hertha BSC 34 36 52 35
16 Hamburger SV Hamburger 34 25 50 35
17 SC Freiburg SC Freiburg 34 36 47 34
18 Paderborn Paderborn 34 31 65 31
TEMPORADA 2013/2014
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 94 23 90
2 B. Dortmund B. Dortmund 34 80 38 71
3 Schalke 04 Schalke 04 34 63 43 64
4 B. Leverkusen Leverkusen 34 60 41 61
5 Wolfsburg Wolfsburg 34 63 50 60
6 B. Mönchengladbach Mönchenglad 34 59 43 55
7 Mainz 05 Mainz 05 34 52 54 53
8 FC Augsburg FC Augsburg 34 47 47 52
9 Hoffenheim Hoffenheim 34 72 70 44
10 Hannover 96 Hannover 96 34 46 59 42
11 Hertha BSC Hertha BSC 34 40 48 41
12 Werder Bremen Werder 34 42 66 39
13 Eintracht Frankfurt Eintracht 34 40 57 36
14 SC Freiburg SC Freiburg 34 43 61 36
15 Stuttgart Stuttgart 34 49 62 32
16 Hamburger SV Hamburger 34 51 75 27
17 Nürnberg Nürnberg 34 37 70 26
18 Eintracht Braunschweig Eintracht 34 29 60 25
TEMPORADA 2012/2013
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 98 18 91
2 B. Dortmund B. Dortmund 34 81 42 66
3 B. Leverkusen Leverkusen 34 65 39 65
4 Schalke 04 Schalke 04 34 58 50 55
5 SC Freiburg SC Freiburg 34 45 40 51
6 Eintracht Frankfurt Eintracht 34 49 46 51
7 Hamburger SV Hamburger 34 42 53 48
8 B. Mönchengladbach Mönchenglad 34 45 49 47
9 Hannover 96 Hannover 96 34 60 62 45
10 Nürnberg Nürnberg 34 39 47 44
11 Wolfsburg Wolfsburg 34 47 52 43
12 Stuttgart Stuttgart 34 37 55 43
13 Mainz 05 Mainz 05 34 42 44 42
14 Werder Bremen Werder 34 50 66 34
15 FC Augsburg FC Augsburg 34 33 51 33
16 Hoffenheim Hoffenheim 34 42 67 31
17 Fortuna Düsseldorf Fortuna 34 39 57 30
18 Greuther Fürth Greuther 34 26 60 21
TEMPORADA 2011/2012
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Dortmund B. Dortmund 34 80 25 81
2 Bayern München Bayern 34 77 22 73
3 Schalke 04 Schalke 04 34 74 44 64
4 B. Mönchengladbach Mönchenglad 34 49 24 60
5 B. Leverkusen Leverkusen 34 52 44 54
6 Stuttgart Stuttgart 34 63 46 53
7 Hannover 96 Hannover 96 34 41 45 48
8 Wolfsburg Wolfsburg 34 47 60 44
9 Werder Bremen Werder 34 49 58 42
10 Nürnberg Nürnberg 34 38 49 42
11 Hoffenheim Hoffenheim 34 41 47 41
12 SC Freiburg SC Freiburg 34 45 61 40
13 Mainz 05 Mainz 05 34 47 51 39
14 FC Augsburg FC Augsburg 34 36 49 38
15 Hamburger SV Hamburger 34 35 57 36
16 Hertha BSC Hertha BSC 34 38 64 31
17 Köln Köln 34 39 75 30
18 Kaiserslautern Kaiserslaute 34 24 54 23
TEMPORADA 2010/2011
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Dortmund B. Dortmund 34 67 22 75
2 B. Leverkusen Leverkusen 34 64 44 68
3 Bayern München Bayern 34 81 40 65
4 Hannover 96 Hannover 96 34 49 45 60
5 Mainz 05 Mainz 05 34 52 39 58
6 Nürnberg Nürnberg 34 47 45 47
7 Kaiserslautern Kaiserslaute 34 48 51 46
8 Hamburger SV Hamburger 34 46 52 45
9 SC Freiburg SC Freiburg 34 41 50 44
10 Köln Köln 34 47 62 44
11 Hoffenheim Hoffenheim 34 50 50 43
12 Stuttgart Stuttgart 34 60 59 42
13 Werder Bremen Werder 34 47 61 41
14 Schalke 04 Schalke 04 34 38 44 40
15 Wolfsburg Wolfsburg 34 43 48 38
16 B. Mönchengladbach Mönchenglad 34 48 65 36
17 Eintracht Frankfurt Eintracht 34 31 49 34
18 FC St Pauli FC St Pauli 34 35 68 29
TEMPORADA 2009/2010
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 72 31 70
2 Schalke 04 Schalke 04 34 53 31 65
3 Werder Bremen Werder 34 71 40 61
4 B. Leverkusen Leverkusen 34 65 38 59
5 B. Dortmund B. Dortmund 34 54 42 57
6 Stuttgart Stuttgart 34 51 41 55
7 Hamburger SV Hamburger 34 56 41 52
8 Wolfsburg Wolfsburg 34 64 58 50
9 Mainz 05 Mainz 05 34 36 42 47
10 Eintracht Frankfurt Eintracht 34 47 54 46
11 Hoffenheim Hoffenheim 34 44 42 42
12 B. Mönchengladbach Mönchenglad 34 43 60 39
13 Köln Köln 34 33 42 38
14 SC Freiburg SC Freiburg 34 35 59 35
15 Hannover 96 Hannover 96 34 43 67 33
16 Nürnberg Nürnberg 34 32 58 31
17 VfL Bochum VfL Bochum 34 33 64 28
18 Hertha BSC Hertha BSC 34 34 56 24
TEMPORADA 2008/2009
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Wolfsburg Wolfsburg 34 80 41 69
2 Bayern München Bayern 34 71 42 67
3 Stuttgart Stuttgart 34 63 43 64
4 Hertha BSC Hertha BSC 34 48 41 63
5 Hamburger SV Hamburger 34 49 47 61
6 B. Dortmund B. Dortmund 34 60 37 59
7 Hoffenheim Hoffenheim 34 63 49 55
8 Schalke 04 Schalke 04 34 47 35 50
9 B. Leverkusen Leverkusen 34 59 46 49
10 Werder Bremen Werder 34 64 50 45
11 Hannover 96 Hannover 96 34 49 69 40
12 Köln Köln 34 35 50 39
13 Eintracht Frankfurt Eintracht 34 39 60 33
14 VfL Bochum VfL Bochum 34 39 55 32
15 B. Mönchengladbach Mönchenglad 34 39 62 31
16 Energie Cottbus Energie 34 30 57 30
17 Karlsruher SC Karlsruher 34 30 54 29
18 Arminia Bielefeld Arminia 34 29 56 28
TEMPORADA 2007/2008
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 68 21 76
2 Werder Bremen Werder 34 75 45 66
3 Schalke 04 Schalke 04 34 55 32 64
4 Hamburger SV Hamburger 34 47 26 54
5 Wolfsburg Wolfsburg 34 58 46 54
6 Stuttgart Stuttgart 34 57 57 52
7 B. Leverkusen Leverkusen 34 57 40 51
8 Hannover 96 Hannover 96 34 54 56 49
9 Eintracht Frankfurt Eintracht 34 43 50 46
10 Hertha BSC Hertha BSC 34 39 44 44
11 Karlsruher SC Karlsruher 34 38 53 43
12 VfL Bochum VfL Bochum 34 48 54 41
13 B. Dortmund B. Dortmund 34 50 62 40
14 Energie Cottbus Energie 34 35 56 36
15 Arminia Bielefeld Arminia 34 35 60 34
16 Nürnberg Nürnberg 34 35 51 31
17 Hansa Rostock Hansa 34 30 52 30
18 MSV Duisburg Duisburg 34 36 55 29
TEMPORADA 2006/2007
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Stuttgart Stuttgart 34 61 37 70
2 Schalke 04 Schalke 04 34 53 32 68
3 Werder Bremen Werder 34 76 40 66
4 Bayern München Bayern 34 55 40 60
5 B. Leverkusen Leverkusen 34 54 49 51
6 Nürnberg Nürnberg 34 43 32 48
7 Hamburger SV Hamburger 34 43 37 45
8 VfL Bochum VfL Bochum 34 49 50 45
9 B. Dortmund B. Dortmund 34 41 43 44
10 Hertha BSC Hertha BSC 34 50 55 44
11 Hannover 96 Hannover 96 34 41 50 44
12 Arminia Bielefeld Arminia 34 47 49 42
13 Energie Cottbus Energie 34 38 49 41
14 Eintracht Frankfurt Eintracht 34 46 58 40
15 Wolfsburg Wolfsburg 34 37 45 37
16 Mainz 05 Mainz 05 34 34 57 34
17 Alemannia Aachen Alemannia 34 46 70 34
18 B. Mönchengladbach Mönchenglad 34 23 44 26
TEMPORADA 2005/2006
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 67 32 75
2 Werder Bremen Werder 34 79 37 70
3 Hamburger SV Hamburger 34 53 30 68
4 Schalke 04 Schalke 04 34 47 31 61
5 B. Leverkusen Leverkusen 34 64 49 52
6 Hertha BSC Hertha BSC 34 52 48 48
7 B. Dortmund B. Dortmund 34 45 42 46
8 Nürnberg Nürnberg 34 49 51 44
9 Stuttgart Stuttgart 34 37 39 43
10 B. Mönchengladbach Mönchenglad 34 42 50 42
11 Mainz 05 Mainz 05 34 46 47 38
12 Hannover 96 Hannover 96 34 43 47 38
13 Arminia Bielefeld Arminia 34 32 47 37
14 Eintracht Frankfurt Eintracht 34 42 51 36
15 Wolfsburg Wolfsburg 34 33 55 34
16 Kaiserslautern Kaiserslaute 34 47 71 33
17 Köln Köln 34 49 71 30
18 MSV Duisburg Duisburg 34 34 63 27
TEMPORADA 2004/2005
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 75 33 77
2 Schalke 04 Schalke 04 34 56 46 63
3 Werder Bremen Werder 34 68 37 59
4 Hertha BSC Hertha BSC 34 59 31 58
5 Stuttgart Stuttgart 34 54 40 58
6 B. Leverkusen Leverkusen 34 65 44 57
7 B. Dortmund B. Dortmund 34 47 44 55
8 Hamburger SV Hamburger 34 55 50 51
9 Wolfsburg Wolfsburg 34 49 51 48
10 Hannover 96 Hannover 96 34 34 36 45
11 Mainz 05 Mainz 05 34 50 55 43
12 Kaiserslautern Kaiserslaute 34 43 52 42
13 Arminia Bielefeld Arminia 34 37 49 40
14 Nürnberg Nürnberg 34 55 63 38
15 B. Mönchengladbach Mönchenglad 34 35 51 36
16 VfL Bochum VfL Bochum 34 47 68 35
17 Hansa Rostock Hansa 34 31 65 30
18 SC Freiburg SC Freiburg 34 30 75 18
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
8,758,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6110
Total Execution Time  0.6124
  CADENA URL  
/historico/Borussia-Dortmund
  GET DATOS  
$_GET['/historico/Borussia-Dortmund']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0112  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=530 AND type_rel = 2
0.0221  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 530 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108  SELECT /*35 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 (1307216,1306906,1306553,1306557,1306256) ORDER BY n.cover_points DESC, update_date DESC
0.0234  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '530' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '530' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0122  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=530 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (74790,72172,72031,71432,68172) 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.0121  SELECT count(id) as num_players from rel_players WHERE league_id = 72031 AND teamId = 530
0.0116  SELECT count(id) as num_players from rel_players WHERE league_id = 74790 AND teamId = 530
0.0124  SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 530
0.0244  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 530
0.0117  SELECT count(id) as num_players from rel_players WHERE league_id = 68172 AND teamId = 530
0.0124  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 = '530' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '530' and rp.type = 4
0.0119  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 = '530' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0105  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '530' and rp.type = 4
0.0135  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 = 72031 WHERE rp.league_id = 72031 AND rp.teamId = 530 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.0122  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 = 72031 WHERE rp.league_id = 72031 AND rp.teamId = 530 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118  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 = 72031 WHERE rp.league_id = 72031 AND rp.teamId = 530 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0124  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 = 530 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111  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 = 72031 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 67678 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 62742 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 = 49846 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 43544 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 38635 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 29144 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 = 15095 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 3772 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121  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 = 2440 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 1930 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 1324 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 1080 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 815 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 = 279 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 30 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 60 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 `tables2006` 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 = 59 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 `tables2005` 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 = 58 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC