4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
TEMPORADA 1984/1985
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 BFC Dynamo BFC Dynamo 26 90 28 64
2 Lokomotive Leipzig Lokomotive 26 55 26 55
3 Dynamo Dresden Dynamo 26 69 34 53
4 BSG Wismut Aue Wismut 26 38 33 44
5 Magdeburg Magdeburg 26 53 35 42
6 Rot-Weiss Erfurt Rot-Weiss 26 47 39 40
7 FC Carl Zeiss Jena Carl Zeiss. 26 36 27 34
8 FC Vorwärts Frankfurt Vorwärts 26 41 38 29
9 Chemnitzer Chemnitzer 26 39 48 28
10 Hansa Rostock Hansa 26 37 51 27
11 BSG Stahl Riesa Stahl Riesa 26 29 55 26
12 BSV Stahl Brandenburg Stahl 26 25 39 25
13 Chemie Leipzig Chemie 26 26 56 21
14 BSG Motor Suhl Motor Suhl 26 16 92 6
TEMPORADA 1983/1984
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 BFC Dynamo BFC Dynamo 26 66 36 56
2 Lokomotive Leipzig Lokomotive 26 56 28 53
3 Dynamo Dresden Dynamo 26 61 28 51
4 FC Vorwärts Frankfurt Vorwärts 26 56 36 46
5 Magdeburg Magdeburg 26 56 33 44
6 Chemnitzer Chemnitzer 26 37 34 40
7 Rot-Weiss Erfurt Rot-Weiss 26 36 39 38
8 BSG Wismut Aue Wismut 26 28 34 34
9 Hansa Rostock Hansa 26 32 41 32
10 FC Carl Zeiss Jena Carl Zeiss. 26 50 63 27
11 BSG Stahl Riesa Stahl Riesa 26 41 55 27
12 Union Berlin Union Berlin 26 27 55 18
13 Chemie Leipzig Chemie 26 21 49 18
14 Hallescher FC Hallescher 26 32 68 12
TEMPORADA 1982/1983
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 BFC Dynamo BFC Dynamo 26 72 22 66
2 FC Carl Zeiss Jena Carl Zeiss. 26 46 29 49
3 FC Vorwärts Frankfurt Vorwärts 26 56 29 47
4 Lokomotive Leipzig Lokomotive 26 45 27 43
5 Rot-Weiss Erfurt Rot-Weiss 26 45 37 42
6 Dynamo Dresden Dynamo 26 51 43 41
7 Magdeburg Magdeburg 26 52 32 39
8 Hansa Rostock Hansa 26 38 40 39
9 Chemnitzer Chemnitzer 26 41 41 36
10 BSG Wismut Aue Wismut 26 30 45 26
11 Hallescher FC Hallescher 26 41 53 22
12 Union Berlin Union Berlin 26 23 50 22
13 BSG Chemie Böhlen Chemie 26 31 80 17
14 Zwickau Zwickau 26 21 64 11
TEMPORADA 1981/1982
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 BFC Dynamo BFC Dynamo 26 74 27 59
2 Dynamo Dresden Dynamo 26 50 24 49
3 FC Vorwärts Frankfurt Vorwärts 26 56 39 47
4 Lokomotive Leipzig Lokomotive 26 53 29 46
5 FC Carl Zeiss Jena Carl Zeiss. 26 49 27 46
6 Magdeburg Magdeburg 26 49 42 45
7 Rot-Weiss Erfurt Rot-Weiss 26 55 44 38
8 Hansa Rostock Hansa 26 37 40 34
9 Chemnitzer Chemnitzer 26 50 38 33
10 BSG Wismut Aue Wismut 26 33 48 31
11 Hallescher FC Hallescher 26 28 46 31
12 Zwickau Zwickau 26 24 57 18
13 Energie Cottbus Energie 26 21 62 14
14 SV 1899 Merseburg 1899 26 21 77 14
TEMPORADA 1980/1981
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 BFC Dynamo BFC Dynamo 26 74 31 56
2 FC Carl Zeiss Jena Carl Zeiss. 26 57 29 52
3 Dynamo Dresden Dynamo 26 49 37 50
4 Magdeburg Magdeburg 26 58 35 49
5 FC Vorwärts Frankfurt Vorwärts 26 58 40 44
6 Lokomotive Leipzig Lokomotive 26 46 35 40
7 Rot-Weiss Erfurt Rot-Weiss 26 37 49 37
8 Hallescher FC Hallescher 26 41 41 36
9 Chemnitzer Chemnitzer 26 37 54 27
10 Hansa Rostock Hansa 26 35 47 26
11 Zwickau Zwickau 26 32 51 25
12 BSG Wismut Aue Wismut 26 34 60 25
13 BSG Stahl Riesa Stahl Riesa 26 38 64 23
14 BSG Chemie Böhlen Chemie 26 25 48 21
TEMPORADA 1978/1979
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 BFC Dynamo BFC Dynamo 26 75 18 67
2 Dynamo Dresden Dynamo 26 59 19 54
3 FC Carl Zeiss Jena Carl Zeiss. 26 38 21 48
4 Magdeburg Magdeburg 26 63 32 47
5 Lokomotive Leipzig Lokomotive 26 41 40 40
6 Hallescher FC Hallescher 26 36 32 37
7 Rot-Weiss Erfurt Rot-Weiss 26 37 46 33
8 Chemnitzer Chemnitzer 26 32 38 31
9 BSG Stahl Riesa Stahl Riesa 26 33 47 29
10 Union Berlin Union Berlin 26 22 39 28
11 BSG Wismut Aue Wismut 26 34 49 27
12 Zwickau Zwickau 26 23 63 25
13 BSG Chemie Böhlen Chemie 26 33 66 21
14 Hansa Rostock Hansa 26 30 46 20
TEMPORADA 1976/1977
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Dynamo Dresden Dynamo 26 66 27 54
2 Magdeburg Magdeburg 26 47 28 48
3 FC Carl Zeiss Jena Carl Zeiss. 26 45 31 47
4 BFC Dynamo BFC Dynamo 26 43 27 46
5 Lokomotive Leipzig Lokomotive 26 40 29 39
6 Rot-Weiss Erfurt Rot-Weiss 26 27 35 33
7 Chemnitzer Chemnitzer 26 35 39 32
8 Hallescher FC Hallescher 26 34 39 31
9 FC Vorwärts Frankfurt Vorwärts 26 23 36 30
10 Zwickau Zwickau 26 32 34 29
11 BSG Stahl Riesa Stahl Riesa 26 28 47 29
12 Union Berlin Union Berlin 26 30 42 28
13 BSG Wismut Aue Wismut 26 27 45 28
14 Hansa Rostock Hansa 26 23 41 26
TEMPORADA 1974/1975
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Magdeburg Magdeburg 26 57 28 58
2 FC Carl Zeiss Jena Carl Zeiss. 26 42 23 55
3 Dynamo Dresden Dynamo 26 42 30 44
4 BFC Dynamo BFC Dynamo 26 47 29 40
5 BSG Stahl Riesa Stahl Riesa 26 34 42 37
6 FC Vorwärts Frankfurt Vorwärts 26 37 31 34
7 Zwickau Zwickau 26 42 39 34
8 Lokomotive Leipzig Lokomotive 26 37 39 33
9 Rot-Weiss Erfurt Rot-Weiss 26 37 42 32
10 Chemnitzer Chemnitzer 26 28 38 29
11 BSG Wismut Aue Wismut 26 24 43 28
12 Hansa Rostock Hansa 26 29 35 27
13 Hallescher FC Hallescher 26 37 49 26
14 ASG Vorwärts Stralsund Vorwärts 26 21 46 19
TEMPORADA 1973/1974
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Magdeburg Magdeburg 26 50 27 55
2 FC Carl Zeiss Jena Carl Zeiss. 26 55 26 52
3 Dynamo Dresden Dynamo 26 55 40 50
4 FC Vorwärts Frankfurt Vorwärts 26 48 27 47
5 Lokomotive Leipzig Lokomotive 26 49 35 41
6 BFC Dynamo BFC Dynamo 26 42 41 39
7 Hansa Rostock Hansa 26 37 35 35
8 Zwickau Zwickau 26 37 41 35
9 Chemnitzer Chemnitzer 26 42 46 31
10 BSG Stahl Riesa Stahl Riesa 26 25 42 30
11 BSG Wismut Aue Wismut 26 29 38 29
12 Rot-Weiss Erfurt Rot-Weiss 26 27 39 24
13 Chemie Leipzig Chemie 26 22 39 18
14 Energie Cottbus Energie 26 16 58 11
TEMPORADA 1972/1973
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Dynamo Dresden Dynamo 26 61 30 60
2 FC Carl Zeiss Jena Carl Zeiss. 26 46 21 54
3 Magdeburg Magdeburg 26 50 28 48
4 Lokomotive Leipzig Lokomotive 26 57 41 42
5 Chemnitzer Chemnitzer 26 33 32 41
6 FC Vorwärts Frankfurt Vorwärts 26 54 46 35
7 BFC Dynamo BFC Dynamo 26 41 42 35
8 Zwickau Zwickau 26 37 43 32
9 Rot-Weiss Erfurt Rot-Weiss 26 37 56 27
10 BSG Wismut Aue Wismut 26 27 46 27
11 Chemie Leipzig Chemie 26 21 26 26
12 Hansa Rostock Hansa 26 36 44 26
13 Union Berlin Union Berlin 26 22 45 25
14 Hallescher FC Hallescher 26 35 57 20
TEMPORADA 1971/1972
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Magdeburg Magdeburg 26 48 23 55
2 BFC Dynamo BFC Dynamo 26 45 20 48
3 Dynamo Dresden Dynamo 26 59 30 45
4 FC Carl Zeiss Jena Carl Zeiss. 26 42 34 43
5 Hallescher FC Hallescher 26 40 44 37
6 FC Vorwärts Frankfurt Vorwärts 26 33 36 36
7 Lokomotive Leipzig Lokomotive 26 30 31 34
8 Hansa Rostock Hansa 26 27 24 32
9 Zwickau Zwickau 26 26 25 32
10 BSG Wismut Aue Wismut 26 34 46 30
11 Union Berlin Union Berlin 26 21 32 26
12 Chemnitzer Chemnitzer 26 34 48 26
13 ASG Vorwärts Stralsund Vorwärts 26 20 48 24
14 BSG Stahl Riesa Stahl Riesa 26 23 41 23
TEMPORADA 1970/1971
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Dynamo Dresden Dynamo 26 56 29 57
2 FC Carl Zeiss Jena Carl Zeiss. 26 58 29 47
3 Hallescher FC Hallescher 26 35 29 40
4 Magdeburg Magdeburg 26 37 38 37
5 Zwickau Zwickau 26 40 42 37
6 FC Vorwärts Berlin Vorwärts 26 38 44 36
7 Hansa Rostock Hansa 26 31 25 35
8 BFC Dynamo BFC Dynamo 26 31 29 35
9 Union Berlin Union Berlin 26 27 33 35
10 Lokomotive Leipzig Lokomotive 26 42 46 33
11 BSG Wismut Aue Wismut 26 30 36 29
12 BSG Stahl Riesa Stahl Riesa 26 28 41 27
13 Rot-Weiss Erfurt Rot-Weiss 26 28 44 27
14 Chemie Leipzig Chemie 26 27 43 24
TEMPORADA 1969/1970
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 FC Carl Zeiss Jena Carl Zeiss. 26 50 16 55
2 Dynamo Dresden Dynamo 26 36 26 44
3 FC Vorwärts Berlin Vorwärts 26 43 34 44
4 Chemie Leipzig Chemie 26 33 27 41
5 BFC Dynamo BFC Dynamo 26 29 32 38
6 Zwickau Zwickau 26 25 26 37
7 BSG Wismut Aue Wismut 26 31 34 37
8 Magdeburg Magdeburg 26 37 37 34
9 Rot-Weiss Erfurt Rot-Weiss 26 32 40 32
10 BSG Stahl Riesa Stahl Riesa 26 31 35 31
11 Hallescher FC Hallescher 26 35 34 30
12 Hansa Rostock Hansa 26 22 33 28
13 Chemnitzer Chemnitzer 26 27 42 26
14 Stahl Eisenhüttenstadt Stahl 26 21 36 22
TEMPORADA 1968/1969
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 FC Vorwärts Berlin Vorwärts 26 47 28 49
2 FC Carl Zeiss Jena Carl Zeiss. 26 43 22 45
3 Magdeburg Magdeburg 26 43 41 44
4 Hansa Rostock Hansa 26 42 33 39
5 Zwickau Zwickau 26 23 19 37
6 Chemnitzer Chemnitzer 26 35 36 36
7 Rot-Weiss Erfurt Rot-Weiss 26 32 27 35
8 Chemie Leipzig Chemie 26 30 27 35
9 BFC Dynamo BFC Dynamo 26 25 36 35
10 BSG Wismut Aue Wismut 26 33 31 34
11 BSG Stahl Riesa Stahl Riesa 26 26 43 31
12 Hallescher FC Hallescher 26 32 35 28
13 Union Berlin Union Berlin 26 29 41 26
14 Lokomotive Leipzig Lokomotive 26 16 37 24
TEMPORADA 1967/1968
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 FC Carl Zeiss Jena Carl Zeiss. 26 51 19 56
2 Hansa Rostock Hansa 26 37 27 49
3 Magdeburg Magdeburg 26 43 38 46
4 FC Vorwärts Berlin Vorwärts 26 34 29 37
5 Zwickau Zwickau 26 36 34 36
6 Lokomotive Leipzig Lokomotive 26 39 35 34
7 Union Berlin Union Berlin 26 26 35 34
8 Chemnitzer Chemnitzer 26 33 30 33
9 Rot-Weiss Erfurt Rot-Weiss 26 34 39 31
10 BSG Wismut Aue Wismut 26 32 40 31
11 Hallescher FC Hallescher 26 32 41 31
12 Chemie Leipzig Chemie 26 26 32 28
13 Lok Stendal Lok Stendal 26 26 42 27
14 Dynamo Dresden Dynamo 26 25 33 26
TEMPORADA 1966/1967
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Chemnitzer Chemnitzer 26 39 23 51
2 Lokomotive Leipzig Lokomotive 26 39 32 44
3 Dynamo Dresden Dynamo 26 35 31 38
4 FC Carl Zeiss Jena Carl Zeiss. 26 31 29 38
5 Lok Stendal Lok Stendal 26 39 44 38
6 BSG Wismut Aue Wismut 26 45 43 37
7 Hallescher FC Hallescher 26 38 41 37
8 Zwickau Zwickau 26 41 26 36
9 FC Vorwärts Berlin Vorwärts 26 43 34 36
10 Union Berlin Union Berlin 26 33 35 36
11 Hansa Rostock Hansa 26 27 27 35
12 Chemie Leipzig Chemie 26 35 38 34
13 BFC Dynamo BFC Dynamo 26 28 40 27
14 Wismut Gera Wismut Gera 26 27 57 16
TEMPORADA 1964/1965
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 FC Vorwärts Berlin Vorwärts 26 51 24 54
2 FC Carl Zeiss Jena Carl Zeiss. 26 41 27 46
3 Sachsen Leipzig Sachsen 26 53 34 42
4 Chemie Leipzig Chemie 26 47 29 42
5 Hansa Rostock Hansa 26 37 33 41
6 Lok Stendal Lok Stendal 26 47 42 35
7 Zwickau Zwickau 26 36 46 33
8 Dynamo Dresden Dynamo 26 34 38 32
9 Chemnitzer Chemnitzer 26 36 41 31
10 BFC Dynamo BFC Dynamo 26 27 37 30
11 BSG Wismut Aue Wismut 26 23 36 30
12 SV Steinach 1908 Steinach 26 28 49 27
13 Neubrandenburg 04 Neubrandenbu 26 34 58 27
14 Magdeburg Magdeburg 13 23 21 17
15 Magdeburg II Magdeburg 13 12 14 17
TEMPORADA 1963/1964
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Chemie Leipzig Chemie 26 38 21 48
2 Hansa Rostock Hansa 26 40 23 46
3 Sachsen Leipzig Sachsen 26 34 27 44
4 Chemnitzer Chemnitzer 26 31 29 39
5 FC Vorwärts Berlin Vorwärts 26 45 36 36
6 FC Carl Zeiss Jena Carl Zeiss. 26 43 35 36
7 SV Steinach 1908 Steinach 26 30 36 33
8 Lok Stendal Lok Stendal 26 31 34 32
9 BFC Dynamo BFC Dynamo 26 35 34 31
10 Zwickau Zwickau 26 37 41 30
11 BSG Wismut Aue Wismut 26 23 32 30
12 Hallescher FC Hallescher 26 24 35 30
13 Magdeburg Magdeburg 26 25 38 30
14 Rot-Weiss Erfurt Rot-Weiss 26 23 38 25

  USO DE MEMORIA  
7,255,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7351
Total Execution Time  0.7363
  CADENA URL  
/historico/Hansa-Rostock/1988
  GET DATOS  
$_GET['/historico/Hansa-Rostock/1988']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0223  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 = 1988 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.0152  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.0152  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.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1292 AND type_rel = 2
0.0150  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.0153  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.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 = '1292' AND l.year = 1988 ORDER BY l.year DESC,cat.coefficient DESC
0.0155  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.0152  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 (1987,1988,1989) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (45333) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 45333 AND teamId = 1292
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 = '1292' 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 = '1292' and rp.type = 4
0.0151  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.0232  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 events1988 e ON e.player_id = p.id AND e.league_id = 45333 WHERE rp.league_id = 45333 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.0196  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 events1988 e ON e.player_id = p.id AND e.league_id = 45333 WHERE rp.league_id = 45333 AND rp.teamId = 1292 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0200  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 events1988 e ON e.player_id = p.id AND e.league_id = 45333 WHERE rp.league_id = 45333 AND rp.teamId = 1292 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 = 1292 AND l.year <= 1988 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0147  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.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 `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
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 `tables1985` 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 = 45336 AND t.round = 26 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 `tables1984` 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 = 45337 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables1983` 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 = 45338 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables1982` 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 = 45339 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables1981` 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 = 45340 AND t.round = 26 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 `tables1979` 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 = 45345 AND t.round = 26 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 `tables1977` 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 = 45347 AND t.round = 26 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 `tables1975` 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 = 45349 AND t.round = 26 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 `tables1974` 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 = 45350 AND t.round = 26 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 `tables1973` 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 = 45351 AND t.round = 26 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 `tables1972` 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 = 45352 AND t.round = 26 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 `tables1971` 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 = 45353 AND t.round = 26 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 `tables1970` 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 = 45354 AND t.round = 26 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 `tables1969` 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 = 45355 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 `tables1968` 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 = 45356 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 `tables1967` 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 = 45357 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 `tables1965` 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 = 45359 AND t.round = 26 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 `tables1964` 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 = 45360 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC