4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1958/1959
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Wiener SC Wiener SC 26 104 35 66
2 Rapid Wien Rapid Wien 26 102 29 65
3 First Vienna First Vienna 26 63 41 45
4 Austria Wien Austria Wien 26 63 47 43
5 Wiener AC Wiener AC 26 56 45 42
6 Simmeringer SC Simmeringer 26 63 58 36
7 Grazer AK Grazer AK 26 46 61 36
8 Wacker Wien Wacker Wien 26 57 61 33
9 Kremser SC Kremser SC 26 49 51 30
10 LASK LASK 26 46 68 30
11 Leoben Leoben 26 63 91 30
12 Admira Admira 26 55 63 27
13 Kapfenberger SV Kapfenberger 26 32 68 21
14 Olympia Wien Olympia Wien 26 25 106 10
TEMPORADA 1957/1958
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Wiener SC Wiener SC 26 100 35 65
2 Rapid Wien Rapid Wien 26 93 39 63
3 First Vienna First Vienna 27 60 39 45
4 Wacker Wien Wacker Wien 26 54 39 38
5 Grazer AK Grazer AK 26 63 46 37
6 Austria Wien Austria Wien 26 63 52 36
7 Wiener AC Wiener AC 26 57 51 36
8 Kapfenberger SV Kapfenberger 26 42 62 36
9 Simmeringer SC Simmeringer 26 52 65 32
10 Admira Admira 26 53 76 30
11 Olympia Wien Olympia Wien 26 34 53 28
12 Kremser SC Kremser SC 26 39 67 28
13 Sturm Graz Sturm Graz 27 42 84 24
14 FC Wien FC Wien 26 26 70 15
TEMPORADA 1956/1957
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 26 100 43 59
2 First Vienna First Vienna 26 71 32 56
3 Austria Wien Austria Wien 26 68 41 56
4 Wacker Wien Wacker Wien 26 82 37 49
5 Simmeringer SC Simmeringer 26 67 60 42
6 Grazer AK Grazer AK 26 47 55 38
7 Kapfenberger SV Kapfenberger 26 56 74 36
8 Admira Admira 26 52 57 31
9 Kremser SC Kremser SC 26 53 79 31
10 Wiener SC Wiener SC 26 50 46 30
11 Sturm Graz Sturm Graz 26 48 66 30
12 Wiener AC Wiener AC 26 58 62 29
13 Salzburg Salzburg 26 55 83 21
14 Stadlau Stadlau 26 26 98 10
TEMPORADA 1955/1956
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 26 93 37 63
2 Wacker Wien Wacker Wien 26 85 33 60
3 First Vienna First Vienna 26 96 41 58
4 Austria Wien Austria Wien 26 78 47 51
5 Wiener SC Wiener SC 26 50 51 41
6 Simmeringer SC Simmeringer 26 68 61 38
7 Grazer AK Grazer AK 26 59 63 38
8 Salzburg Salzburg 26 50 65 32
9 Admira Admira 26 54 61 25
10 Kapfenberger SV Kapfenberger 26 39 67 24
11 Sturm Graz Sturm Graz 26 43 68 23
12 Austria Graz Austria Graz 26 25 78 22
13 Stadlau Stadlau 26 43 74 20
14 FC Wien FC Wien 26 31 68 20
TEMPORADA 1954/1955
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 26 64 26 56
2 Wiener SC Wiener SC 26 75 40 56
3 Rapid Wien Rapid Wien 26 87 47 50
4 Wacker Wien Wacker Wien 26 86 53 50
5 Austria Wien Austria Wien 26 68 49 46
6 Kapfenberger SV Kapfenberger 26 55 57 38
7 Admira Admira 26 54 51 37
8 Grazer AK Grazer AK 26 45 47 33
9 Simmeringer SC Simmeringer 26 57 55 31
10 Stadlau Stadlau 27 31 49 30
11 Salzburg Salzburg 26 43 55 29
12 LASK LASK 27 47 65 23
13 FC Wien FC Wien 26 39 77 23
14 SW Bregenz SW Bregenz 26 13 93 10
TEMPORADA 1951/1952
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 26 107 39 61
2 Austria Wien Austria Wien 26 95 40 57
3 First Vienna First Vienna 26 71 52 46
4 Wacker Wien Wacker Wien 26 84 55 45
5 Admira Admira 26 71 55 44
6 Grazer AK Grazer AK 26 66 48 42
7 Sturm Graz Sturm Graz 26 42 56 36
8 LASK LASK 26 42 54 35
9 FAC Wien FAC Wien 26 56 70 34
10 FC Wien FC Wien 26 42 55 32
11 Simmeringer SC Simmeringer 26 40 58 31
12 Wiener SC Wiener SC 26 34 69 24
13 Kapfenberger SV Kapfenberger 26 31 66 19
14 Blau-Weiß Linz Blau-Weiß 26 25 89 18

  USO DE MEMORIA  
5,401,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4095
Total Execution Time  0.4115
  CADENA URL  
/historico/Kapfenberger-Sv/1959
  GET DATOS  
$_GET['/historico/Kapfenberger-Sv/1959']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0255  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 = 26119
0.0131  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 = 26779
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3972 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3972 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (260835,581429) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = '3972' ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '3972' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 26119 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 26779 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=3972 AND l.year in (1958,1959,1960) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (26779,26123) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 26123 AND teamId = 3972
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 26779 AND teamId = 3972
0.0127  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 = '3972' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3972' and rp.type = 4
0.0128  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 = '3972' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0131  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 = 3972 AND l.year <= 1959 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133  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 `tables1959` 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 = 26119 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables1958` 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 = 26123 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1957` 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 = 26131 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables1956` 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 = 26134 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1955` 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 = 26135 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1952` 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 = 26166 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC