4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
TEMPORADA 2003/2004
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Werder Bremen Werder 34 79 38 74
2 Bayern München Bayern 34 70 39 68
3 B. Leverkusen Leverkusen 34 73 39 65
4 Stuttgart Stuttgart 34 52 24 64
5 VfL Bochum VfL Bochum 34 57 39 56
6 B. Dortmund B. Dortmund 34 59 48 55
7 Schalke 04 Schalke 04 34 49 42 50
8 Hamburger SV Hamburger 34 47 60 49
9 Hansa Rostock Hansa 34 55 54 44
10 Wolfsburg Wolfsburg 34 56 61 42
11 B. Mönchengladbach Mönchenglad 34 40 49 39
12 Hertha BSC Hertha BSC 34 42 59 39
13 SC Freiburg SC Freiburg 34 42 67 38
14 Hannover 96 Hannover 96 34 49 63 37
15 Kaiserslautern Kaiserslaute 34 39 62 36
16 Eintracht Frankfurt Eintracht 34 36 53 32
17 1860 München 1860 34 32 55 32
18 Köln Köln 34 32 57 23
TEMPORADA 2002/2003
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 70 25 75
2 Stuttgart Stuttgart 34 53 39 59
3 B. Dortmund B. Dortmund 34 51 27 58
4 Hamburger SV Hamburger 34 46 36 56
5 Hertha BSC Hertha BSC 34 52 43 54
6 Werder Bremen Werder 34 51 50 52
7 Schalke 04 Schalke 04 34 46 40 49
8 Wolfsburg Wolfsburg 34 39 42 46
9 VfL Bochum VfL Bochum 34 55 56 45
10 1860 München 1860 34 44 52 45
11 Hannover 96 Hannover 96 34 47 57 43
12 B. Mönchengladbach Mönchenglad 34 43 45 42
13 Hansa Rostock Hansa 34 35 41 41
14 Kaiserslautern Kaiserslaute 34 40 42 40
15 B. Leverkusen Leverkusen 34 47 56 40
16 Arminia Bielefeld Arminia 34 35 46 36
17 Nürnberg Nürnberg 34 33 60 30
18 Energie Cottbus Energie 34 34 64 30
TEMPORADA 2001/2002
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Dortmund B. Dortmund 34 62 33 70
2 B. Leverkusen Leverkusen 34 77 38 69
3 Bayern München Bayern 34 65 25 68
4 Hertha BSC Hertha BSC 34 61 38 61
5 Schalke 04 Schalke 04 34 52 36 61
6 Werder Bremen Werder 34 54 43 56
7 Kaiserslautern Kaiserslaute 34 62 53 56
8 Stuttgart Stuttgart 34 47 43 50
9 1860 München 1860 34 59 59 50
10 Wolfsburg Wolfsburg 34 57 49 46
11 Hamburger SV Hamburger 34 51 57 40
12 B. Mönchengladbach Mönchenglad 34 41 53 39
13 Energie Cottbus Energie 34 36 60 35
14 Hansa Rostock Hansa 34 35 54 34
15 Nürnberg Nürnberg 34 34 57 34
16 SC Freiburg SC Freiburg 34 37 64 30
17 Köln Köln 34 26 61 29
18 FC St Pauli FC St Pauli 34 37 70 22
TEMPORADA 2000/2001
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 62 37 63
2 Schalke 04 Schalke 04 34 65 35 62
3 B. Dortmund B. Dortmund 34 62 42 58
4 B. Leverkusen Leverkusen 34 54 40 57
5 Hertha BSC Hertha BSC 34 58 52 56
6 SC Freiburg SC Freiburg 34 54 37 55
7 Werder Bremen Werder 34 53 48 53
8 Kaiserslautern Kaiserslaute 34 50 53 52
9 Wolfsburg Wolfsburg 34 60 45 47
10 Köln Köln 34 59 52 46
11 1860 München 1860 34 43 55 44
12 Hansa Rostock Hansa 34 34 47 43
13 Hamburger SV Hamburger 34 57 59 40
14 Energie Cottbus Energie 34 38 52 39
15 Stuttgart Stuttgart 34 42 49 38
16 Unterhaching Unterhaching 34 35 59 35
17 Eintracht Frankfurt Eintracht 34 41 68 35
18 VfL Bochum VfL Bochum 34 30 67 27
TEMPORADA 1999/2000
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 73 28 73
2 B. Leverkusen Leverkusen 34 74 36 73
3 Hamburger SV Hamburger 34 63 39 59
4 1860 München 1860 34 55 48 53
5 Kaiserslautern Kaiserslaute 34 54 59 50
6 Hertha BSC Hertha BSC 34 39 46 50
7 Wolfsburg Wolfsburg 34 51 58 49
8 Stuttgart Stuttgart 34 44 47 48
9 Werder Bremen Werder 34 65 52 47
10 Unterhaching Unterhaching 34 40 42 44
11 B. Dortmund B. Dortmund 34 41 38 40
12 SC Freiburg SC Freiburg 34 45 50 40
13 Schalke 04 Schalke 04 34 42 44 39
14 Eintracht Frankfurt Eintracht 34 42 44 39
15 Hansa Rostock Hansa 34 44 60 38
16 Ulm Ulm 34 36 62 35
17 Arminia Bielefeld Arminia 34 40 61 30
18 MSV Duisburg Duisburg 34 37 71 22
TEMPORADA 1998/1999
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 76 28 78
2 B. Leverkusen Leverkusen 34 61 30 63
3 Hertha BSC Hertha BSC 34 59 32 62
4 B. Dortmund B. Dortmund 34 48 34 57
5 Kaiserslautern Kaiserslaute 34 51 47 57
6 Wolfsburg Wolfsburg 34 54 49 55
7 Hamburger SV Hamburger 34 47 46 50
8 MSV Duisburg Duisburg 34 48 45 49
9 1860 München 1860 34 49 56 41
10 Schalke 04 Schalke 04 34 41 54 41
11 Stuttgart Stuttgart 34 41 48 39
12 SC Freiburg SC Freiburg 34 36 44 39
13 Werder Bremen Werder 34 41 47 38
14 Hansa Rostock Hansa 34 49 58 38
15 Eintracht Frankfurt Eintracht 34 44 54 37
16 Nürnberg Nürnberg 34 40 50 37
17 VfL Bochum VfL Bochum 34 40 65 29
18 B. Mönchengladbach Mönchenglad 34 41 79 21
TEMPORADA 1997/1998
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Kaiserslautern Kaiserslaute 34 63 39 68
2 Bayern München Bayern 34 69 37 66
3 B. Leverkusen Leverkusen 34 66 39 55
4 Stuttgart Stuttgart 34 55 49 52
5 Schalke 04 Schalke 04 34 38 32 52
6 Hansa Rostock Hansa 34 54 46 51
7 Werder Bremen Werder 34 43 47 50
8 MSV Duisburg Duisburg 34 43 44 44
9 Hamburger SV Hamburger 34 38 46 44
10 B. Dortmund B. Dortmund 34 57 55 43
11 Hertha BSC Hertha BSC 34 41 53 43
12 VfL Bochum VfL Bochum 34 41 49 41
13 1860 München 1860 34 43 54 41
14 Wolfsburg Wolfsburg 34 38 54 39
15 B. Mönchengladbach Mönchenglad 34 54 59 38
16 Karlsruher SC Karlsruher 34 48 60 38
17 Köln Köln 34 49 64 36
18 Arminia Bielefeld Arminia 34 43 56 32
TEMPORADA 1996/1997
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 68 34 71
2 B. Leverkusen Leverkusen 34 69 41 69
3 B. Dortmund B. Dortmund 34 63 41 63
4 Stuttgart Stuttgart 34 78 40 61
5 VfL Bochum VfL Bochum 34 54 51 53
6 Karlsruher SC Karlsruher 34 55 44 49
7 1860 München 1860 34 56 56 49
8 Werder Bremen Werder 34 53 52 48
9 MSV Duisburg Duisburg 34 44 49 45
10 Köln Köln 34 62 62 44
11 B. Mönchengladbach Mönchenglad 34 46 48 43
12 Schalke 04 Schalke 04 34 35 40 43
13 Hamburger SV Hamburger 34 46 60 41
14 Arminia Bielefeld Arminia 34 46 54 40
15 Hansa Rostock Hansa 34 35 46 40
16 Fortuna Düsseldorf Fortuna 34 26 57 33
17 SC Freiburg SC Freiburg 34 43 67 29
18 FC St Pauli FC St Pauli 34 32 69 27
TEMPORADA 1995/1996
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Dortmund B. Dortmund 34 76 38 68
2 Bayern München Bayern 34 66 46 62
3 Schalke 04 Schalke 04 34 45 36 56
4 B. Mönchengladbach Mönchenglad 34 52 51 53
5 Hamburger SV Hamburger 34 52 47 50
6 Hansa Rostock Hansa 34 47 43 49
7 Karlsruher SC Karlsruher 34 53 47 48
8 1860 München 1860 34 52 46 45
9 Werder Bremen Werder 34 39 42 44
10 Stuttgart Stuttgart 34 59 62 43
11 SC Freiburg SC Freiburg 34 30 41 42
12 Köln Köln 34 33 35 40
13 Fortuna Düsseldorf Fortuna 34 40 47 40
14 B. Leverkusen Leverkusen 34 37 38 38
15 FC St Pauli FC St Pauli 34 43 51 38
16 Kaiserslautern Kaiserslaute 34 31 37 36
17 Eintracht Frankfurt Eintracht 34 43 68 32
18 KFC Uerdingen 05 Uerdingen 34 33 56 26

  USO DE MEMORIA  
8,865,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2343
Total Execution Time  0.2355
  CADENA URL  
/historico/Borussia-Dortmund/2015
  GET DATOS  
$_GET['/historico/Borussia-Dortmund/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (59)  
0.0040  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 = 'Borussia-Dortmund' AND l.year = 2015 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.0019  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=530 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 3772
0.0027  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 = 3836
0.0026  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 = 4233
0.0028  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 = 3977
0.0026  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 = 3849
0.0029  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 = 3804
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=530 AND type_rel = 2
0.0129  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.0024  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 (1311955,1311822,1311412,1311270,1311236) ORDER BY n.cover_points DESC, update_date DESC
0.0057  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' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0053  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.0021  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 = 3772 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 3836 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 = 3977 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 3849 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0071  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 (2014,2015,2016) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (20032,16245,16077,15321,15095,4233,3849) 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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 15095 AND teamId = 530
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 4233 AND teamId = 530
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 20032 AND teamId = 530
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 15321 AND teamId = 530
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 3849 AND teamId = 530
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 16077 AND teamId = 530
0.0057  SELECT count(id) as num_players from rel_players WHERE league_id = 16245 AND teamId = 530
0.0071  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.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '530' and rp.type = 4
0.0045  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.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '530' and rp.type = 4
0.0058  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 events2015 e ON e.player_id = p.id AND e.league_id = 3772 WHERE rp.league_id = 3772 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.0044  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 events2015 e ON e.player_id = p.id AND e.league_id = 3772 WHERE rp.league_id = 3772 AND rp.teamId = 530 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 events2015 e ON e.player_id = p.id AND e.league_id = 3772 WHERE rp.league_id = 3772 AND rp.teamId = 530 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  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 <= 2015 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 `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.0026  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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.0027  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.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 `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
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 `tables2004` 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 = 57 AND t.round = 34 ORDER BY team.conference 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 `tables2003` 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 = 56 AND t.round = 34 ORDER BY team.conference 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 `tables2002` 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 = 55 AND t.round = 34 ORDER BY team.conference 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 `tables2001` 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 = 205 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2000` 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 = 206 AND t.round = 34 ORDER BY team.conference 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 `tables1999` 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 = 207 AND t.round = 34 ORDER BY team.conference 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 `tables1998` 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 = 208 AND t.round = 34 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 `tables1997` 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 = 209 AND t.round = 34 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 `tables1996` 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 = 210 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC