4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Leverkusen Leverkusen 31 77 22 81
2 Bayern München Bayern 31 89 38 69
3 Stuttgart Stuttgart 31 70 38 64
4 RB Leipzig RB Leipzig 31 73 35 62
5 B. Dortmund B. Dortmund 31 59 39 57
6 Eintracht Frankfurt Eintracht 31 47 42 45
7 SC Freiburg SC Freiburg 31 43 55 40
8 FC Augsburg FC Augsburg 31 48 52 39
9 Hoffenheim Hoffenheim 31 55 63 39
10 Werder Bremen Werder 31 41 50 37
11 Heidenheim Heidenheim 30 43 52 34
12 Wolfsburg Wolfsburg 31 37 51 34
13 B. Mönchengladbach Mönchenglad 30 53 60 31
14 VfL Bochum VfL Bochum 31 37 62 30
15 Union Berlin Union Berlin 30 26 50 29
16 Mainz 05 Mainz 05 30 31 48 27
17 Köln Köln 30 23 53 22
18 Darmstadt 98 Darmstadt 30 30 72 17
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
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 VfL Bochum VfL Bochum 34 66 39 67
2 Greuther Fürth Greuther 34 69 44 64
3 Holstein Kiel Holstein 34 57 35 62
4 Hamburger SV Hamburger 34 71 44 58
5 Fortuna Düsseldorf Fortuna 34 55 46 56
6 Karlsruher SC Karlsruher 34 51 44 52
7 Darmstadt 98 Darmstadt 34 63 55 51
8 Heidenheim Heidenheim 34 49 49 51
9 Paderborn Paderborn 34 53 45 47
10 FC St Pauli FC St Pauli 34 51 56 47
11 Nürnberg Nürnberg 34 46 51 44
12 Erzgebirge Aue Erzgebirge 34 44 53 44
13 Hannover 96 Hannover 96 34 53 51 42
14 Jahn Regensburg Jahn 34 37 50 38
15 Sandhausen Sandhausen 34 41 60 34
16 VfL Osnabrück Osnabrück 34 35 58 33
17 Eintracht Braunschweig Eintracht 34 30 59 31
18 Würzburger Kickers Würzburger 34 37 69 25
TEMPORADA 2019/2020
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Arminia Bielefeld Arminia 34 65 30 68
2 Stuttgart Stuttgart 34 62 41 58
3 Heidenheim Heidenheim 34 45 36 55
4 Hamburger SV Hamburger 34 62 46 54
5 Darmstadt 98 Darmstadt 34 48 43 52
6 Hannover 96 Hannover 96 34 54 49 48
7 Erzgebirge Aue Erzgebirge 34 46 48 47
8 VfL Bochum VfL Bochum 34 53 51 46
9 Greuther Fürth Greuther 34 46 45 44
10 Sandhausen Sandhausen 34 43 45 43
11 Holstein Kiel Holstein 34 53 56 43
12 Jahn Regensburg Jahn 34 50 56 43
13 VfL Osnabrück Osnabrück 34 46 48 40
14 FC St Pauli FC St Pauli 34 41 50 39
15 Karlsruher SC Karlsruher 34 45 56 37
16 Nürnberg Nürnberg 34 45 58 37
17 Wehen Wiesbaden Wehen 34 45 65 34
18 Dynamo Dresden Dynamo 34 32 58 32
TEMPORADA 2018/2019
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Köln Köln 34 84 47 63
2 Paderborn Paderborn 34 76 50 57
3 Union Berlin Union Berlin 34 54 33 57
4 Hamburger SV Hamburger 34 45 42 56
5 Heidenheim Heidenheim 34 55 45 55
6 Holstein Kiel Holstein 34 60 51 49
7 Arminia Bielefeld Arminia 34 52 50 49
8 Jahn Regensburg Jahn 34 55 54 49
9 FC St Pauli FC St Pauli 34 46 53 49
10 Darmstadt 98 Darmstadt 34 45 53 46
11 VfL Bochum VfL Bochum 34 49 50 44
12 Dynamo Dresden Dynamo 34 41 48 42
13 Greuther Fürth Greuther 34 37 56 42
14 Erzgebirge Aue Erzgebirge 34 43 47 40
15 Sandhausen Sandhausen 34 45 52 38
16 Ingolstadt 04 Ingolstadt 34 43 55 35
17 Magdeburg Magdeburg 34 35 53 31
18 MSV Duisburg Duisburg 34 39 65 28
TEMPORADA 2017/2018
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Fortuna Düsseldorf Fortuna 34 57 44 63
2 Nürnberg Nürnberg 34 61 39 60
3 Holstein Kiel Holstein 34 71 44 56
4 Arminia Bielefeld Arminia 34 51 47 48
5 Jahn Regensburg Jahn 34 53 53 48
6 VfL Bochum VfL Bochum 34 37 40 48
7 MSV Duisburg Duisburg 34 52 56 48
8 Union Berlin Union Berlin 34 54 46 47
9 Ingolstadt 04 Ingolstadt 34 47 45 45
10 Darmstadt 98 Darmstadt 34 47 45 43
11 Sandhausen Sandhausen 34 35 33 43
12 FC St Pauli FC St Pauli 34 35 48 43
13 Heidenheim Heidenheim 34 50 56 42
14 Dynamo Dresden Dynamo 34 42 52 41
15 Greuther Fürth Greuther 34 37 48 40
16 Erzgebirge Aue Erzgebirge 34 35 49 40
17 Eintracht Braunschweig Eintracht 34 37 43 39
18 Kaiserslautern Kaiserslaute 34 42 55 35
TEMPORADA 2016/2017
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Stuttgart Stuttgart 34 63 37 69
2 Hannover 96 Hannover 96 34 51 32 67
3 Eintracht Braunschweig Eintracht 34 50 36 66
4 Union Berlin Union Berlin 34 51 39 60
5 Dynamo Dresden Dynamo 34 53 46 50
6 Heidenheim Heidenheim 34 43 39 46
7 FC St Pauli FC St Pauli 34 39 35 45
8 Greuther Fürth Greuther 34 33 40 45
9 VfL Bochum VfL Bochum 34 42 47 44
10 Sandhausen Sandhausen 34 41 36 42
11 Fortuna Düsseldorf Fortuna 34 37 39 42
12 Nürnberg Nürnberg 34 46 52 42
13 Kaiserslautern Kaiserslaute 34 29 33 41
14 Erzgebirge Aue Erzgebirge 34 37 52 39
15 Arminia Bielefeld Arminia 34 50 54 37
16 1860 München 1860 34 37 47 36
17 Würzburger Kickers Würzburger 34 32 41 34
18 Karlsruher SC Karlsruher 34 27 56 25
TEMPORADA 2015/2016
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 SC Freiburg SC Freiburg 34 75 39 72
2 RB Leipzig RB Leipzig 34 54 32 67
3 Nürnberg Nürnberg 34 68 41 65
4 FC St Pauli FC St Pauli 34 45 39 53
5 VfL Bochum VfL Bochum 34 56 40 51
6 Union Berlin Union Berlin 34 56 50 49
7 Karlsruher SC Karlsruher 34 35 37 47
8 Eintracht Braunschweig Eintracht 34 44 38 46
9 Greuther Fürth Greuther 34 49 55 46
10 Kaiserslautern Kaiserslaute 34 49 47 45
11 Heidenheim Heidenheim 34 42 40 45
12 Arminia Bielefeld Arminia 34 38 39 42
13 Sandhausen Sandhausen 34 40 50 40
14 Fortuna Düsseldorf Fortuna 34 32 47 35
15 1860 München 1860 34 32 46 34
16 MSV Duisburg Duisburg 34 32 54 32
17 FSV Frankfurt Frankfurt 34 33 59 32
18 Paderborn Paderborn 34 28 55 28
TEMPORADA 2014/2015
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Ingolstadt 04 Ingolstadt 34 53 32 64
2 Darmstadt 98 Darmstadt 34 44 26 59
3 Karlsruher SC Karlsruher 34 46 26 58
4 Kaiserslautern Kaiserslaute 34 45 31 56
5 RB Leipzig RB Leipzig 34 39 31 50
6 Eintracht Braunschweig Eintracht 34 44 41 50
7 Union Berlin Union Berlin 34 46 51 47
8 Heidenheim Heidenheim 34 49 44 46
9 Nürnberg Nürnberg 34 42 47 45
10 Fortuna Düsseldorf Fortuna 34 48 52 44
11 VfL Bochum VfL Bochum 34 53 55 42
12 Sandhausen Sandhausen 34 32 37 39
13 FSV Frankfurt Frankfurt 34 41 53 39
14 Greuther Fürth Greuther 34 34 42 37
15 FC St Pauli FC St Pauli 34 40 51 37
16 1860 München 1860 34 41 51 36
17 Erzgebirge Aue Erzgebirge 34 32 47 36
18 VfR Aalen VfR Aalen 34 34 46 31
TEMPORADA 2013/2014
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Köln Köln 34 53 20 68
2 Paderborn Paderborn 34 63 48 62
3 Greuther Fürth Greuther 34 64 38 60
4 Kaiserslautern Kaiserslaute 34 55 39 54
5 Karlsruher SC Karlsruher 34 47 34 50
6 Fortuna Düsseldorf Fortuna 34 45 44 50
7 1860 München 1860 34 38 41 48
8 FC St Pauli FC St Pauli 34 44 49 48
9 Union Berlin Union Berlin 34 48 47 44
10 Ingolstadt 04 Ingolstadt 34 34 33 44
11 VfR Aalen VfR Aalen 34 36 39 44
12 Sandhausen Sandhausen 34 29 35 44
13 FSV Frankfurt Frankfurt 34 46 51 41
14 Erzgebirge Aue Erzgebirge 34 42 54 41
15 VfL Bochum VfL Bochum 34 30 43 40
16 Arminia Bielefeld Arminia 34 40 58 35
17 Dynamo Dresden Dynamo 34 36 53 32
18 Energie Cottbus Energie 34 35 59 25
TEMPORADA 2012/2013
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Hertha BSC Hertha BSC 34 65 28 76
2 Eintracht Braunschweig Eintracht 34 52 34 67
3 Kaiserslautern Kaiserslaute 34 55 33 58
4 FSV Frankfurt Frankfurt 34 55 45 54
5 Köln Köln 34 43 33 54
6 1860 München 1860 34 39 31 49
7 Union Berlin Union Berlin 34 50 49 49
8 Energie Cottbus Energie 34 41 36 48
9 VfR Aalen VfR Aalen 34 40 39 46
10 FC St Pauli FC St Pauli 34 44 47 43
11 MSV Duisburg Duisburg 34 37 49 43
12 Paderborn Paderborn 34 45 45 42
13 Ingolstadt 04 Ingolstadt 34 36 43 42
14 VfL Bochum VfL Bochum 34 40 52 38
15 Erzgebirge Aue Erzgebirge 34 39 46 37
16 Dynamo Dresden Dynamo 34 35 49 37
17 Sandhausen Sandhausen 34 38 66 26
18 Jahn Regensburg Jahn 34 36 65 19
TEMPORADA 2011/2012
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Greuther Fürth Greuther 34 73 27 70
2 Eintracht Frankfurt Eintracht 34 76 33 68
3 Fortuna Düsseldorf Fortuna 34 64 35 62
4 FC St Pauli FC St Pauli 34 59 34 62
5 Paderborn Paderborn 34 51 42 61
6 1860 München 1860 34 63 46 57
7 Union Berlin Union Berlin 34 55 58 48
8 Eintracht Braunschweig Eintracht 34 37 35 45
9 Dynamo Dresden Dynamo 34 50 52 45
10 MSV Duisburg Duisburg 34 42 47 39
11 VfL Bochum VfL Bochum 34 41 55 37
12 Ingolstadt 04 Ingolstadt 34 43 58 37
13 FSV Frankfurt Frankfurt 34 43 59 35
14 Energie Cottbus Energie 34 30 49 35
15 Erzgebirge Aue Erzgebirge 34 31 56 35
16 Karlsruher SC Karlsruher 34 34 60 33
17 Alemannia Aachen Alemannia 34 30 47 31
18 Hansa Rostock Hansa 34 34 63 27
TEMPORADA 2010/2011
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Hertha BSC Hertha BSC 34 69 28 74
2 FC Augsburg FC Augsburg 34 58 27 65
3 VfL Bochum VfL Bochum 34 49 35 65
4 Greuther Fürth Greuther 34 47 27 61
5 Erzgebirge Aue Erzgebirge 34 40 37 56
6 Energie Cottbus Energie 34 65 52 55
7 Fortuna Düsseldorf Fortuna 34 49 39 53
8 MSV Duisburg Duisburg 34 53 38 52
9 1860 München 1860 34 50 36 52
10 Alemannia Aachen Alemannia 34 58 60 48
11 Union Berlin Union Berlin 34 39 45 42
12 Paderborn Paderborn 34 32 47 39
13 FSV Frankfurt Frankfurt 34 42 54 38
14 Ingolstadt 04 Ingolstadt 34 40 46 37
15 Karlsruher SC Karlsruher 34 46 72 33
16 VfL Osnabrück Osnabrück 34 40 62 31
17 Rot-Weiß Oberhausen Rot-Weiß 34 30 65 28
18 Arminia Bielefeld Arminia 34 28 65 20
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
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 VfL Bochum VfL Bochum 34 55 26 66
2 Alemannia Aachen Alemannia 34 61 36 65
3 Energie Cottbus Energie 34 49 33 58
4 SC Freiburg SC Freiburg 34 41 33 56
5 Greuther Fürth Greuther 34 51 42 54
6 Karlsruher SC Karlsruher 34 55 45 53
7 Erzgebirge Aue Erzgebirge 34 38 36 48
8 SV Wacker Burghausen Wacker 34 45 49 47
9 Paderborn Paderborn 34 46 40 46
10 Hansa Rostock Hansa 34 44 49 43
11 Kickers Offenbach FC Kickers 34 42 53 43
12 Eintracht Braunschweig Eintracht 34 37 48 43
13 1860 München 1860 34 41 44 42
14 Unterhaching Unterhaching 34 42 48 42
15 Dynamo Dresden Dynamo 34 39 45 41
16 1. FC Saarbrücken Saarbrücken 34 37 63 38
17 Rot Weiss Ahlen Weiss Ahlen 34 36 50 35
18 Siegen Sportfreunde Siegen 34 35 54 31
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 MEMORIA  
8,222,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.7642
Total Execution Time  0.7654
  CADENA URL  
/historico/Bochum
  GET DATOS  
$_GET['/historico/Bochum']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0171  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Bochum' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=515 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=515 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=515 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=515 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=515 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 515 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (1312758,6454,29036,41207,41364) ORDER BY n.cover_points DESC, update_date DESC
0.0158  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 = '515' ORDER BY l.year DESC,cat.coefficient DESC
0.0153  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 = '515' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '515' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156  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=515 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0150  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 (72172,72031,71432) 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.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 72031 AND teamId = 515
0.0183  SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 515
0.0302  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 515
0.0147  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 = '515' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '515' and rp.type = 4
0.0146  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 = '515' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0171  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 = 515 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.0168  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 = 515 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0179  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 = 515 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0192  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 = 515 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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.0151  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 = 56926 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.0152  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 = 49867 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.0154  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 = 43559 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 38638 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 29215 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 15098 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 3811 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 2445 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 1920 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 1325 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 1081 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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.0152  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.0155  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.0158  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.0160  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 = 548 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC