4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Paderborn

Paderborn

Entrenador: Lukas Kwasniok

TEMPORADA 2023/2024
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 FC St Pauli FC St Pauli 31 57 33 63
2 Holstein Kiel Holstein 31 61 37 61
3 Fortuna Düsseldorf Fortuna 30 64 35 55
4 Hamburger SV Hamburger 31 59 42 52
5 Karlsruher SC Karlsruher 30 61 45 46
6 Hannover 96 Hannover 96 31 53 39 46
7 Paderborn Paderborn 31 49 50 46
8 Hertha BSC Hertha BSC 31 63 52 45
9 Greuther Fürth Greuther 30 40 43 42
10 SV Elversberg Elversberg 31 45 55 40
11 Nürnberg Nürnberg 30 38 56 37
12 Magdeburg Magdeburg 30 42 46 36
13 Schalke 04 Schalke 04 30 46 56 36
14 Eintracht Braunschweig Eintracht 31 33 45 34
15 Kaiserslautern Kaiserslaute 31 49 60 33
16 Wehen Wiesbaden Wehen 30 32 41 32
17 Hansa Rostock Hansa 31 27 51 31
18 VfL Osnabrück Osnabrück 30 27 60 24
TEMPORADA 2022/2023
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Heidenheim Heidenheim 34 67 36 67
2 Darmstadt 98 Darmstadt 34 50 33 67
3 Hamburger SV Hamburger 34 70 45 66
4 Fortuna Düsseldorf Fortuna 34 60 43 58
5 FC St Pauli FC St Pauli 34 55 39 58
6 Paderborn Paderborn 34 68 44 55
7 Karlsruher SC Karlsruher 34 56 53 46
8 Holstein Kiel Holstein 34 58 61 46
9 Kaiserslautern Kaiserslaute 34 47 48 45
10 Hannover 96 Hannover 96 34 50 55 44
11 Magdeburg Magdeburg 34 48 55 43
12 Greuther Fürth Greuther 34 47 50 41
13 Hansa Rostock Hansa 34 32 48 41
14 Nürnberg Nürnberg 34 32 49 39
15 Eintracht Braunschweig Eintracht 34 42 59 36
16 Arminia Bielefeld Arminia 34 50 62 34
17 Jahn Regensburg Jahn 34 34 58 31
18 Sandhausen Sandhausen 34 35 63 28
TEMPORADA 2021/2022
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Schalke 04 Schalke 04 34 72 44 65
2 Werder Bremen Werder 34 65 43 63
3 Hamburger SV Hamburger 34 67 35 60
4 Darmstadt 98 Darmstadt 34 71 46 60
5 FC St Pauli FC St Pauli 34 61 46 57
6 Heidenheim Heidenheim 34 43 45 52
7 Paderborn Paderborn 34 56 44 51
8 Nürnberg Nürnberg 34 49 49 51
9 Holstein Kiel Holstein 34 46 54 45
10 Fortuna Düsseldorf Fortuna 34 45 42 44
11 Hannover 96 Hannover 96 34 35 49 42
12 Karlsruher SC Karlsruher 34 54 55 41
13 Hansa Rostock Hansa 34 41 52 41
14 Sandhausen Sandhausen 34 42 54 41
15 Jahn Regensburg Jahn 34 50 51 40
16 Dynamo Dresden Dynamo 34 33 46 32
17 Erzgebirge Aue Erzgebirge 34 32 72 26
18 Ingolstadt 04 Ingolstadt 34 30 65 21
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
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
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
3. LIGA
Equipo PJ GF GC Puntos
1 Magdeburg Magdeburg 38 70 32 85
2 Paderborn Paderborn 38 90 33 83
3 Karlsruher SC Karlsruher 38 49 29 69
4 Wehen Wiesbaden Wehen 38 76 39 68
5 Würzburger Kickers Würzburger 38 53 46 61
6 Hansa Rostock Hansa 38 48 34 60
7 SV Meppen SV Meppen 38 50 47 58
8 Fortuna Köln Fortuna 38 53 48 54
9 Unterhaching Unterhaching 38 54 55 54
10 Preußen Münster Preußen 38 50 49 52
11 FC Carl Zeiss Jena Carl Zeiss. 38 49 59 52
12 VfR Aalen VfR Aalen 38 48 57 50
13 Hallescher FC Hallescher 38 52 54 49
14 SG Sonnenhof Großaspach Sonnenhof 38 55 60 47
15 Zwickau Zwickau 38 38 55 41
16 Sportfreunde Lotte Sportfreunde 38 43 60 40
17 VfL Osnabrück Osnabrück 38 47 67 37
18 Werder Bremen II Werder 38 39 62 31
19 Chemnitzer Chemnitzer 38 48 74 22
20 Rot-Weiss Erfurt Rot-Weiss 38 26 78 13
TEMPORADA 2016/2017
3. LIGA
Equipo PJ GF GC Puntos
1 MSV Duisburg Duisburg 38 52 32 68
2 Holstein Kiel Holstein 38 59 25 67
3 Jahn Regensburg Jahn 38 62 50 63
4 Magdeburg Magdeburg 38 53 36 61
5 Zwickau Zwickau 38 47 54 56
6 VfL Osnabrück Osnabrück 38 46 43 54
7 Wehen Wiesbaden Wehen 38 45 42 53
8 Chemnitzer Chemnitzer 38 54 51 52
9 Preußen Münster Preußen 38 49 43 51
10 SG Sonnenhof Großaspach Sonnenhof 38 48 48 51
11 VfR Aalen VfR Aalen 38 52 36 48
12 Sportfreunde Lotte Sportfreunde 38 46 47 48
13 Hallescher FC Hallescher 38 34 39 48
14 Rot-Weiss Erfurt Rot-Weiss 38 34 47 47
15 Hansa Rostock Hansa 38 44 46 46
16 Fortuna Köln Fortuna 38 37 59 46
17 Werder Bremen II Werder 38 32 48 45
18 Paderborn Paderborn 38 38 57 44
19 Mainz 05 II Mainz 05 II 38 41 58 40
20 FSV Frankfurt Frankfurt 38 38 50 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
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
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
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Kaiserslautern Kaiserslaute 34 56 28 67
2 FC St Pauli FC St Pauli 34 72 37 64
3 FC Augsburg FC Augsburg 34 60 40 62
4 Fortuna Düsseldorf Fortuna 34 48 31 59
5 Arminia Bielefeld Arminia 34 48 41 53
6 Paderborn Paderborn 34 49 49 51
7 MSV Duisburg Duisburg 34 51 46 50
8 1860 München 1860 34 43 45 48
9 Energie Cottbus Energie 34 55 49 47
10 Karlsruher SC Karlsruher 34 43 45 46
11 Greuther Fürth Greuther 34 51 50 44
12 Union Berlin Union Berlin 34 42 45 44
13 Alemannia Aachen Alemannia 34 37 41 43
14 Rot-Weiß Oberhausen Rot-Weiß 34 38 52 41
15 FSV Frankfurt Frankfurt 34 29 50 38
16 Hansa Rostock Hansa 34 33 45 36
17 TuS Koblenz TuS Koblenz 34 35 60 31
18 Rot Weiss Ahlen Weiss Ahlen 34 19 55 22
TEMPORADA 2008/2009
3. LIGA
Equipo PJ GF GC Puntos
1 Union Berlin Union Berlin 38 59 23 78
2 Fortuna Düsseldorf Fortuna 38 54 33 69
3 Paderborn Paderborn 38 68 38 68
4 Unterhaching Unterhaching 38 57 46 67
5 Bayern München II Bayern 38 54 38 59
6 BSV Kickers Emden Kickers 38 45 44 59
7 Kickers Offenbach FC Kickers 38 40 35 52
8 Sandhausen Sandhausen 38 58 52 50
9 Dynamo Dresden Dynamo 38 46 46 50
10 Rot-Weiss Erfurt Rot-Weiss 38 46 48 50
11 Stuttgart II Stuttgart 38 61 50 49
12 Erzgebirge Aue Erzgebirge 38 43 43 48
13 Eintracht Braunschweig Eintracht 38 46 51 45
14 Wuppertaler SV Wuppertaler 38 36 45 45
15 Jahn Regensburg Jahn 38 37 51 45
16 FC Carl Zeiss Jena Carl Zeiss. 38 41 59 41
17 Werder Bremen II Werder 38 49 58 40
18 SV Wacker Burghausen Wacker 38 40 65 40
19 VfR Aalen VfR Aalen 38 38 60 39
20 Stuttgarter Kickers Stuttgarter 38 38 71 29
TEMPORADA 2007/2008
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Mönchengladbach Mönchenglad 34 71 38 66
2 Hoffenheim Hoffenheim 34 60 40 60
3 Köln Köln 34 62 44 60
4 Mainz 05 Mainz 05 34 62 36 58
5 SC Freiburg SC Freiburg 34 49 44 55
6 Greuther Fürth Greuther 34 53 47 52
7 Alemannia Aachen Alemannia 34 49 44 51
8 TuS Koblenz TuS Koblenz 34 46 47 47
9 Wehen Wiesbaden Wehen 34 47 53 44
10 FC St Pauli FC St Pauli 34 47 53 42
11 1860 München 1860 34 42 45 41
12 VfL Osnabrück Osnabrück 34 43 54 40
13 Kaiserslautern Kaiserslaute 34 37 37 39
14 FC Augsburg FC Augsburg 34 39 51 38
15 Kickers Offenbach FC Kickers 34 38 60 38
16 Erzgebirge Aue Erzgebirge 34 49 57 32
17 Paderborn Paderborn 34 33 54 31
18 FC Carl Zeiss Jena Carl Zeiss. 34 45 68 29
TEMPORADA 2006/2007
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Karlsruher SC Karlsruher 34 69 41 70
2 Hansa Rostock Hansa 34 49 30 62
3 MSV Duisburg Duisburg 34 66 40 60
4 SC Freiburg SC Freiburg 34 55 39 60
5 Greuther Fürth Greuther 34 53 40 54
6 Kaiserslautern Kaiserslaute 34 48 34 53
7 FC Augsburg FC Augsburg 34 43 32 52
8 1860 München 1860 34 47 49 48
9 Köln Köln 34 49 50 46
10 Erzgebirge Aue Erzgebirge 34 46 48 45
11 Paderborn Paderborn 34 32 41 42
12 TuS Koblenz TuS Koblenz 34 36 45 41
13 FC Carl Zeiss Jena Carl Zeiss. 34 40 56 38
14 Kickers Offenbach FC Kickers 34 42 59 36
15 Rot-Weiss Essen Rot-Weiss 34 34 40 35
16 Unterhaching Unterhaching 34 33 49 35
17 SV Wacker Burghausen Wacker 34 42 63 32
18 Eintracht Braunschweig Eintracht 34 20 48 23
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
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Eintracht Braunschweig Eintracht 36 59 35 70
2 Paderborn Paderborn 36 63 40 70
3 VfB Lübeck VfB Lübeck 36 62 40 69
4 VfL Osnabrück Osnabrück 36 67 44 67
5 Wuppertaler SV Wuppertaler 36 46 48 54
6  Hamburger SV II Hamburger 36 49 48 53
7 FC St Pauli FC St Pauli 36 43 39 52
8 Fortuna Düsseldorf Fortuna 36 46 42 49
9 KFC Uerdingen 05 Uerdingen 36 43 50 49
10 Holstein Kiel Holstein 36 54 46 48
11 Hertha BSC II Hertha 36 61 55 47
12 Preußen Münster Preußen 36 52 58 46
13 Köln II Köln II 36 58 65 46
14 Werder Bremen II Werder 36 48 57 42
15 Chemnitzer Chemnitzer 36 33 38 40
16 B. Dortmund II Dortmund 36 57 64 40
17 Wolfsburg II Wolfsburg 36 37 58 34
18 Bielefeld Amatuere Bielefeld 36 50 83 29
19 Union Berlin Union Berlin 36 32 50 27

  USO DE MEMORIA  
8,336,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6859
Total Execution Time  0.6878
  CADENA URL  
/historico/Paderborn
  GET DATOS  
$_GET['/historico/Paderborn']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4800 AND type_rel = 2
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4800 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 (2657,19685,47636,81190,90412) ORDER BY n.cover_points DESC, update_date 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 = '4800' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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=4800 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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,72037,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.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 72037 AND teamId = 4800
0.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 4800
0.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4800
0.0149  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 = '4800' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4800' 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 = '4800' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0163  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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 4800 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.0161  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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 4800 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 4800 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 4800 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0292  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 = 67802 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.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 = 62743 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 `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.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 `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.0157  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 = 38729 AND t.round = 38 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 `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 = 33314 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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.0159  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.0157  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.0157  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.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 `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.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 `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.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 `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 = 876 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 `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 = 452 AND t.round = 38 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 `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 = 546 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 547 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 `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
0.0156  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 = 16446 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC