4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
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
TEMPORADA 1994/1995
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Hansa Rostock Hansa 34 66 30 46
2 FC St Pauli FC St Pauli 34 58 33 44
3 Fortuna Düsseldorf Fortuna 34 51 35 43
4 Wolfsburg Wolfsburg 34 51 40 43
5 Waldhof Mannheim Waldhof 34 48 35 42
6 SV Meppen SV Meppen 34 52 40 39
7 1. FC Saarbrücken Saarbrücken 34 45 43 35
8 Fortuna Köln Fortuna 34 55 49 34
9 Chemnitzer Chemnitzer 34 47 50 34
10 Wattenscheid 09 Wattenscheid 34 50 52 33
11 Hertha BSC Hertha BSC 34 41 45 32
12 Nürnberg Nürnberg 34 40 45 32
13 Hannover 96 Hannover 96 34 52 50 31
14 Lokomotive Leipzig Lokomotive 34 44 44 30
15 Mainz 05 Mainz 05 34 50 55 30
16 Zwickau Zwickau 34 32 50 29
17 FC 08 Homburg Homburg 34 41 63 23
18 FSV Frankfurt Frankfurt 34 39 103 12
TEMPORADA 1993/1994
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 VfL Bochum VfL Bochum 38 56 34 48
2 KFC Uerdingen 05 Uerdingen 38 49 30 47
3 1860 München 1860 38 55 38 47
4 FC St Pauli FC St Pauli 38 47 39 45
5 Wolfsburg Wolfsburg 38 47 45 40
6 Waldhof Mannheim Waldhof 38 45 45 40
7 SV Meppen SV Meppen 38 48 52 39
8 Hansa Rostock Hansa 38 51 56 39
9 Chemnitzer Chemnitzer 38 34 44 39
10 FC 08 Homburg Homburg 38 53 46 37
11 Hertha BSC Hertha BSC 38 48 42 37
12 Hannover 96 Hannover 96 38 49 46 37
13 Mainz 05 Mainz 05 38 46 51 37
14 1. FC Saarbrücken Saarbrücken 38 58 69 37
15 Fortuna Köln Fortuna 38 53 49 36
16 Stuttgarter Kickers Stuttgarter 38 42 50 35
17 FC Carl Zeiss Jena Carl Zeiss. 38 38 41 34
18 Wuppertaler SV Wuppertaler 38 44 52 31
19 Rot-Weiss Essen Rot-Weiss 38 44 60 29
20 Tennis Borussia Tennis 38 42 60 26
TEMPORADA 1992/1993
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 SC Freiburg SC Freiburg 46 102 57 65
2 MSV Duisburg Duisburg 46 65 40 60
3 Lokomotive Leipzig Lokomotive 46 66 45 58
4 Waldhof Mannheim Waldhof 46 66 53 55
5 Hertha BSC Hertha BSC 46 82 55 53
6 Fortuna Köln Fortuna 46 56 44 50
7 Chemnitzer Chemnitzer 46 64 56 50
8 FC Carl Zeiss Jena Carl Zeiss. 46 66 59 50
9 Hannover 96 Hannover 96 46 60 60 48
10 SV Meppen SV Meppen 46 41 43 47
11 Hansa Rostock Hansa 46 54 52 46
12 Mainz 05 Mainz 05 46 54 58 46
13 Wuppertaler SV Wuppertaler 46 55 50 45
14 Wolfsburg Wolfsburg 46 65 69 45
15 Stuttgarter Kickers Stuttgarter 46 60 59 43
16 FC 08 Homburg Homburg 46 50 53 43
17 FC St Pauli FC St Pauli 46 47 52 43
18 Unterhaching Unterhaching 46 58 67 42
19 Eintracht Braunschweig Eintracht 46 65 73 41
20 VfL Osnabrück Osnabrück 46 63 72 41
21 Fortuna Düsseldorf Fortuna 46 45 65 34
22 VfB Oldenburg Oldenburg 46 57 90 34
23 FC Remscheid Remscheid 46 50 83 33
24 Darmstadt 98 Darmstadt 46 43 79 32
TEMPORADA 1991/1992
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Stuttgart Stuttgart 38 62 32 52
2 B. Dortmund B. Dortmund 38 66 47 52
3 Eintracht Frankfurt Eintracht 38 76 41 50
4 Köln Köln 38 58 41 44
5 Kaiserslautern Kaiserslaute 38 58 42 44
6 B. Leverkusen Leverkusen 38 53 39 43
7 Nürnberg Nürnberg 38 54 51 43
8 Karlsruher SC Karlsruher 38 48 50 41
9 Werder Bremen Werder 38 44 45 38
10 Bayern München Bayern 38 59 61 36
11 Schalke 04 Schalke 04 38 45 45 34
12 Hamburger SV Hamburger 38 32 43 34
13 B. Mönchengladbach Mönchenglad 38 37 49 34
14 Dynamo Dresden Dynamo 38 34 50 34
15 VfL Bochum VfL Bochum 38 38 55 33
16 Wattenscheid 09 Wattenscheid 38 50 60 32
17 Stuttgarter Kickers Stuttgarter 38 53 64 31
18 Hansa Rostock Hansa 38 43 55 31
19 MSV Duisburg Duisburg 38 43 55 30
20 Fortuna Düsseldorf Fortuna 38 41 69 24
TEMPORADA 1990/1991
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Hansa Rostock Hansa 26 44 25 48
2 Dynamo Dresden Dynamo 26 48 28 44
3 Rot-Weiss Erfurt Rot-Weiss 26 30 26 42
4 FC Carl Zeiss Jena Carl Zeiss. 26 40 36 40
5 Hallescher FC Hallescher 26 40 31 39
6 Lokomotive Leipzig Lokomotive 26 37 33 38
7 Chemnitzer Chemnitzer 26 24 23 38
8 BSV Stahl Brandenburg Stahl 26 34 31 36
9 Magdeburg Magdeburg 26 34 32 35
10 Stahl Eisenhüttenstadt Stahl 26 29 25 33
11 BFC Dynamo BFC Dynamo 26 25 39 29
12 Sachsen Leipzig Sachsen 26 23 37 28
13 Energie Cottbus Energie 26 21 38 19
14 FC Vorwärts Frankfurt Vorwärts 13 18 25 12
15 Frankfurter FC Viktoria Frankfurter 13 11 29 5
TEMPORADA 1989/1990
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Chemnitzer Chemnitzer 26 35 20 49
2 Dynamo Dresden Dynamo 26 47 26 48
3 Magdeburg Magdeburg 26 39 22 47
4 FC Carl Zeiss Jena Carl Zeiss. 26 29 27 41
5 Union Berlin Union Berlin 26 38 35 39
6 Energie Cottbus Energie 26 36 37 37
7 Hansa Rostock Hansa 26 38 33 36
8 Lokomotive Leipzig Lokomotive 26 34 33 34
9 Hallescher FC Hallescher 26 38 38 32
10 BSV Stahl Brandenburg Stahl 26 35 37 30
11 Rot-Weiss Erfurt Rot-Weiss 26 29 40 24
12 BSG Wismut Aue Wismut 26 25 36 23
13 Bischofswerdaer Bischofswerd 26 22 52 23
14 Stahl Eisenhüttenstadt Stahl 26 22 31 20
TEMPORADA 1988/1989
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Dynamo Dresden Dynamo 26 61 26 56
2 BFC Dynamo BFC Dynamo 26 51 32 44
3 Chemnitzer Chemnitzer 26 38 36 42
4 Hansa Rostock Hansa 26 34 31 41
5 Lokomotive Leipzig Lokomotive 26 39 26 39
6 Magdeburg Magdeburg 26 35 30 39
7 FC Carl Zeiss Jena Carl Zeiss. 26 35 24 38
8 BSG Wismut Aue Wismut 26 35 35 38
9 Hallescher FC Hallescher 26 36 38 33
10 Energie Cottbus Energie 26 29 41 32
11 BSV Stahl Brandenburg Stahl 26 36 43 31
12 Rot-Weiss Erfurt Rot-Weiss 26 27 39 30
13 Zwickau Zwickau 26 25 49 22
14 Union Berlin Union Berlin 26 22 53 20
TEMPORADA 1987/1988
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 BFC Dynamo BFC Dynamo 26 59 30 52
2 Lokomotive Leipzig Lokomotive 26 42 21 51
3 Dynamo Dresden Dynamo 26 47 24 45
4 BSV Stahl Brandenburg Stahl 26 44 37 41
5 Magdeburg Magdeburg 26 34 33 34
6 FC Carl Zeiss Jena Carl Zeiss. 26 28 29 34
7 Hallescher FC Hallescher 26 33 33 33
8 Chemnitzer Chemnitzer 26 40 45 33
9 BSG Wismut Aue Wismut 26 24 34 31
10 Hansa Rostock Hansa 26 42 49 30
11 Rot-Weiss Erfurt Rot-Weiss 26 40 49 29
12 Union Berlin Union Berlin 26 35 54 29
13 FC Vorwärts Frankfurt Vorwärts 26 33 43 27
14 BSG Stahl Riesa Stahl Riesa 26 23 43 19
TEMPORADA 1985/1986
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 BFC Dynamo BFC Dynamo 26 46 31 46
2 Lokomotive Leipzig Lokomotive 26 33 22 44
3 FC Carl Zeiss Jena Carl Zeiss. 26 32 18 40
4 BSV Stahl Brandenburg Stahl 26 27 23 39
5 Magdeburg Magdeburg 26 39 33 38
6 Dynamo Dresden Dynamo 26 40 39 38
7 Union Berlin Union Berlin 26 32 31 36
8 Chemnitzer Chemnitzer 26 33 32 35
9 FC Vorwärts Frankfurt Vorwärts 26 37 35 33
10 BSG Wismut Aue Wismut 26 31 40 31
11 Rot-Weiss Erfurt Rot-Weiss 26 41 34 30
12 BSG Stahl Riesa Stahl Riesa 26 27 36 29
13 Hansa Rostock Hansa 26 31 46 27
14 Zwickau Zwickau 26 27 56 15

  USO DE MEMORIA  
8,151,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1593
Total Execution Time  0.1605
  CADENA URL  
/historico/Hansa-Rostock/2006
  GET DATOS  
$_GET['/historico/Hansa-Rostock/2006']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0033  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 = 'Hansa-Rostock' AND l.year = 2006 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=1292 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=1292 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=1292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 548
0.0025  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 = 16412
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1292 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1292 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (102019,109260,131529,275622,275962) ORDER BY n.cover_points DESC, update_date DESC
0.0030  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 = '1292' AND l.year = 2006 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '1292' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 548 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 16412 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1292 AND l.year in (2005,2006,2007) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (49235,16413,548,58) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 58 AND teamId = 1292
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 548 AND teamId = 1292
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 16413 AND teamId = 1292
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 49235 AND teamId = 1292
0.0024  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 = '1292' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1292' and rp.type = 4
0.0021  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 = '1292' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 events2006 e ON e.player_id = p.id AND e.league_id = 548 WHERE rp.league_id = 548 AND rp.teamId = 1292 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.0031  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 events2006 e ON e.player_id = p.id AND e.league_id = 548 WHERE rp.league_id = 548 AND rp.teamId = 1292 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 events2006 e ON e.player_id = p.id AND e.league_id = 548 WHERE rp.league_id = 548 AND rp.teamId = 1292 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 1292 AND l.year <= 2006 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.0028  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.0032  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.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 `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.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 `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.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 `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.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 `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.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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
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 `tables1995` 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 = 9856 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 `tables1994` 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 = 9857 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 `tables1993` 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 = 9858 AND t.round = 46 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 `tables1992` 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 = 5454 AND t.round = 38 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 `tables1991` 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 = 45365 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables1990` 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 = 45330 AND t.round = 26 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 `tables1989` 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 = 45332 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1988` 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 = 45333 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1986` 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 = 45335 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC