4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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 1953/1954
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 26 96 43 59
2 Austria Wien Austria Wien 26 73 43 54
3 First Vienna First Vienna 26 72 40 46
4 Grazer AK Grazer AK 26 60 52 45
5 Wacker Wien Wacker Wien 26 72 42 43
6 Admira Admira 26 55 46 42
7 Wiener SC Wiener SC 26 61 59 40
8 LASK LASK 26 51 42 37
9 Salzburg Salzburg 26 43 67 32
10 Simmeringer SC Simmeringer 26 41 43 29
11 Wiener AC Wiener AC 26 42 69 27
12 FC Wien FC Wien 27 43 76 26
13 Sturm Graz Sturm Graz 26 48 69 22
14 FAC Wien FAC Wien 25 32 98 9
TEMPORADA 1952/1953
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 26 106 38 66
2 Wacker Wien Wacker Wien 26 101 30 64
3 Rapid Wien Rapid Wien 26 94 48 57
4 First Vienna First Vienna 26 89 48 52
5 Admira Admira 26 65 53 39
6 FAC Wien FAC Wien 26 56 82 38
7 Grazer AK Grazer AK 26 50 59 34
8 Simmeringer SC Simmeringer 26 41 52 31
9 Sturm Graz Sturm Graz 26 44 59 29
10 LASK LASK 26 51 59 27
11 Modling Modling 26 35 62 26
12 FC Wien FC Wien 26 38 61 25
13 Grazer SC Grazer SC 26 45 90 22
14 Salzburger AK Salzburger 26 33 107 5
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
TEMPORADA 1950/1951
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 24 133 40 63
2 Wacker Wien Wacker Wien 24 100 38 56
3 Austria Wien Austria Wien 24 89 49 46
4 Wiener SC Wiener SC 24 73 52 38
5 First Vienna First Vienna 24 56 58 36
6 FC Wien FC Wien 24 45 50 35
7 Sturm Graz Sturm Graz 24 48 74 31
8 Admira Admira 24 66 50 29
9 FAC Wien FAC Wien 25 55 74 28
10 LASK LASK 24 25 62 26
11 Vorwarts Steyr Vorwarts 24 34 64 23
12 Wiener Neustadt Wiener 24 45 74 21
13 Elektra Elektra 25 33 117 11
TEMPORADA 1949/1950
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 24 92 37 56
2 Rapid Wien Rapid Wien 24 87 43 52
3 Wacker Wien Wacker Wien 24 76 34 48
4 Admira Admira 24 70 48 48
5 First Vienna First Vienna 24 60 45 47
6 FC Wien FC Wien 24 64 45 46
7 Wiener SC Wiener SC 24 55 45 40
8 FAC Wien FAC Wien 24 46 50 29
9 Vorwarts Steyr Vorwarts 24 47 65 29
10 Sturm Graz Sturm Graz 24 50 58 25
11 Gloggnitz Gloggnitz 24 49 104 15
12 Slovan-Hütteldorfer Slovan-Hütt 24 31 71 11
13 Rapid Oberlaa Rapid 24 23 105 2
TEMPORADA 1942/1943
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 20 87 56 43
2 FAC Wien FAC Wien 20 61 41 36
3 Wiener AC Wiener AC 20 45 29 36
4 Wiener SC Wiener SC 20 55 44 35
5 Austria Wien Austria Wien 20 53 52 35
6 Rapid Wien Rapid Wien 20 65 53 32
7 FC Wien FC Wien 20 48 49 25
8 Admira Admira 20 38 42 22
9 Ostbahn XI Ostbahn XI 20 38 38 21
10 Wacker Wien Wacker Wien 20 32 40 20
11 Sturm Graz Sturm Graz 20 21 99 2
TEMPORADA 1941/1942
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 18 56 26 42
2 FC Wien FC Wien 17 48 23 32
3 Rapid Wien Rapid Wien 17 47 31 30
4 Austria Wien Austria Wien 18 42 25 29
5 Wacker Wien Wacker Wien 17 48 40 26
6 Wiener SC Wiener SC 17 51 38 24
7 FAC Wien FAC Wien 17 39 53 22
8 Admira Admira 17 44 42 18
9 Sturm Graz Sturm Graz 11 10 40 9
10 Post Post 17 11 78 1

  USO DE MEMORIA  
5,715,112 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4658
Total Execution Time  0.4670
  CADENA URL  
/historico/Sturm-Graz/1957
  GET DATOS  
$_GET['/historico/Sturm-Graz/1957']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0152  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 = 'Sturm-Graz' AND l.year = 1957 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.0126  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=2432 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=2432 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252  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 = 26131
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2432 AND type_rel = 2
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2432 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131  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 (1220,44393,52034,167797,365416) ORDER BY n.cover_points DESC, update_date DESC
0.0152  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 = '2432' AND l.year = 1957 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '2432' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 26131 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  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=2432 AND l.year in (1956,1957,1958) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (26134) 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 = 26134 AND teamId = 2432
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 events1957 e ON e.player_id = p.id AND e.league_id = 26131 WHERE rp.league_id = 26131 AND rp.teamId = 2432 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.0126  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 events1957 e ON e.player_id = p.id AND e.league_id = 26131 WHERE rp.league_id = 26131 AND rp.teamId = 2432 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 events1957 e ON e.player_id = p.id AND e.league_id = 26131 WHERE rp.league_id = 26131 AND rp.teamId = 2432 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 2432 AND l.year <= 1957 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 `tables1954` 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 = 26140 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 `tables1953` 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 = 26160 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
0.0130  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 `tables1951` 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 = 26170 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables1950` 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 = 26172 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1943` 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 = 26198 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 `tables1942` 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 = 26201 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC