4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1924/1925
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Hakoah Wien Hakoah Wien 20 43 30 36
2 Austria Wien Austria Wien 20 36 28 34
3 Rapid Wien Rapid Wien 20 49 39 32
4 First Vienna First Vienna 20 41 32 32
5 Wiener AC Wiener AC 20 42 37 31
6 Admira Admira 20 39 30 30
7 Wacker Wien Wacker Wien 20 34 36 26
8 Simmeringer SC Simmeringer 20 43 44 25
9 Wiener SC Wiener SC 20 32 35 23
10 Slovan-Hütteldorfer Slovan-Hütt 20 31 42 22
11 Rudolfshügel Rudolfshüge 20 21 58 9
TEMPORADA 1923/1924
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 22 53 19 52
2 First Vienna First Vienna 22 54 30 46
3 Wiener SC Wiener SC 22 40 17 41
4 Rapid Wien Rapid Wien 22 55 48 38
5 Simmeringer SC Simmeringer 22 46 32 34
6 Hakoah Wien Hakoah Wien 22 41 34 30
7 Admira Admira 22 36 34 28
8 Wacker Wien Wacker Wien 22 33 34 26
9 Slovan-Hütteldorfer Slovan-Hütt 22 36 46 25
10 Hertha Wien Hertha Wien 22 22 33 21
11 Brigittenauer Brigittenaue 22 17 64 11
12 WAF WAF 22 26 68 8
TEMPORADA 1922/1923
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 24 78 42 51
2 Austria Wien Austria Wien 24 65 35 46
3 Admira Admira 24 60 52 39
4 First Vienna First Vienna 24 46 52 35
5 Wiener SC Wiener SC 24 40 34 34
6 Hakoah Wien Hakoah Wien 24 44 33 33
7 Wacker Wien Wacker Wien 24 42 40 33
8 Hertha Wien Hertha Wien 24 40 41 31
9 Simmeringer SC Simmeringer 24 36 43 31
10 WAF WAF 24 34 53 29
11 FAC Wien FAC Wien 24 42 54 24
12 Wiener AC Wiener AC 24 36 58 22
13 Rudolfshügel Rudolfshüge 24 30 56 21
TEMPORADA 1921/1922
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Wiener SC Wiener SC 24 45 24 49
2 Rapid Wien Rapid Wien 24 72 46 45
3 Hakoah Wien Hakoah Wien 24 48 32 44
4 Austria Wien Austria Wien 24 59 39 42
5 Wacker Wien Wacker Wien 24 38 35 37
6 Hertha Wien Hertha Wien 24 34 41 32
7 WAF WAF 24 38 52 30
8 First Vienna First Vienna 24 44 47 28
9 Admira Admira 24 45 62 28
10 FAC Wien FAC Wien 24 47 52 27
11 Rudolfshügel Rudolfshüge 24 33 37 26
12 Simmeringer SC Simmeringer 24 38 52 26
13 Brigittenauer Brigittenaue 24 32 54 23
TEMPORADA 1920/1921
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 24 86 39 57
2 Austria Wien Austria Wien 24 66 30 49
3 Rudolfshügel Rudolfshüge 24 44 41 35
4 Hakoah Wien Hakoah Wien 24 34 28 33
5 Hertha Wien Hertha Wien 24 44 41 32
6 WAF WAF 24 37 36 32
7 Wiener SC Wiener SC 24 41 42 30
8 FAC Wien FAC Wien 24 44 47 29
9 Simmeringer SC Simmeringer 24 38 56 29
10 First Vienna First Vienna 24 33 47 28
11 Wacker Wien Wacker Wien 24 27 41 26
12 Admira Admira 24 40 56 23
13 Wiener AC Wiener AC 24 37 67 23
TEMPORADA 1919/1920
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 22 71 29 48
2 Austria Wien Austria Wien 22 55 24 47
3 Wiener SC Wiener SC 22 37 28 43
4 FAC Wien FAC Wien 22 36 24 39
5 Rudolfshügel Rudolfshüge 22 42 30 36
6 Wiener AC Wiener AC 22 31 36 30
7 Simmeringer SC Simmeringer 22 39 44 29
8 Wacker Wien Wacker Wien 22 27 48 23
9 Hertha Wien Hertha Wien 22 24 33 22
10 First Vienna First Vienna 22 36 47 19
11 WAF WAF 22 30 43 17
12 Admira Admira 22 25 67 14
TEMPORADA 1918/1919
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 18 67 15 46
2 Rudolfshügel Rudolfshüge 18 51 32 34
3 Wiener AC Wiener AC 18 42 26 31
4 WAF WAF 18 32 26 28
5 Wiener SC Wiener SC 18 25 38 27
6 FAC Wien FAC Wien 19 46 35 25
7 Austria Wien Austria Wien 19 29 39 21
8 Hertha Wien Hertha Wien 18 34 52 17
9 Simmeringer SC Simmeringer 18 29 63 16
10 Wacker Wien Wacker Wien 18 20 49 10
TEMPORADA 1917/1918
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 FAC Wien FAC Wien 18 47 16 33
2 Rapid Wien Rapid Wien 18 46 23 33
3 WAF WAF 18 52 41 32
4 Rudolfshügel Rudolfshüge 18 45 31 31
5 Wacker Wien Wacker Wien 19 28 36 27
6 Wiener AC Wiener AC 18 33 24 23
7 Wiener SC Wiener SC 18 35 50 21
8 Simmeringer SC Simmeringer 19 31 49 20
9 Austria Wien Austria Wien 18 23 33 19
10 Hertha Wien Hertha Wien 18 24 61 10
TEMPORADA 1916/1917
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 18 64 28 42
2 FAC Wien FAC Wien 18 55 17 39
3 Rudolfshügel Rudolfshüge 18 49 30 39
4 WAF WAF 18 61 32 36
5 Wacker Wien Wacker Wien 18 36 38 25
6 Wiener AC Wiener AC 18 34 40 25
7 Wiener SC Wiener SC 18 36 42 20
8 Austria Wien Austria Wien 18 34 47 12
9 Simmeringer SC Simmeringer 18 25 64 10
10 Hertha Wien Hertha Wien 18 20 76 7
TEMPORADA 1915/1916
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 18 87 26 46
2 FAC Wien FAC Wien 18 51 18 43
3 WAF WAF 18 65 24 38
4 Wiener AC Wiener AC 18 64 35 38
5 Rudolfshügel Rudolfshüge 18 54 39 32
6 Wacker Wien Wacker Wien 18 28 34 24
7 Austria Wien Austria Wien 18 23 46 20
8 Wiener SC Wiener SC 18 28 49 13
9 Hertha Wien Hertha Wien 18 12 68 4
10 Simmeringer SC Simmeringer 18 18 91 3
TEMPORADA 1914/1915
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Wiener AC Wiener AC 9 46 9 24
2 WAF WAF 9 30 14 22
3 Rapid Wien Rapid Wien 9 23 16 14
4 Austria Wien Austria Wien 9 15 11 13
5 FAC Wien FAC Wien 9 22 22 12
6 Rudolfshügel Rudolfshüge 9 21 26 12
7 Hertha Wien Hertha Wien 9 15 22 11
8 Wiener SC Wiener SC 9 13 26 9
9 Wacker Wien Wacker Wien 9 13 22 6
10 Simmeringer SC Simmeringer 9 15 45 4
TEMPORADA 1913/1914
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 18 51 26 27
2 WAF WAF 18 54 34 25
3 Wiener SC Wiener SC 18 40 29 24
4 Wiener AC Wiener AC 18 51 27 23
5 Austria Wien Austria Wien 18 34 43 17
6 Simmeringer SC Simmeringer 18 38 42 16
7 Rudolfshügel Rudolfshüge 18 25 36 16
8 FAC Wien FAC Wien 18 32 43 13
9 Hertha Wien Hertha Wien 18 27 44 11
10 First Vienna First Vienna 18 21 49 8
TEMPORADA 1912/1913
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 18 59 17 48
2 WAF WAF 18 39 21 38
3 Wiener SC Wiener SC 18 45 24 31
4 Wiener AC Wiener AC 18 41 28 27
5 Austria Wien Austria Wien 18 39 31 26
6 Simmeringer SC Simmeringer 18 29 53 22
7 Hertha Wien Hertha Wien 18 31 42 19
8 Rudolfshügel Rudolfshüge 18 19 44 18
9 First Vienna First Vienna 18 19 37 15
10 FAC Wien FAC Wien 18 25 49 15
TEMPORADA 1911/1912
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 20 64 31 46
2 Wiener SC Wiener SC 20 53 35 43
3 WAF WAF 20 59 23 42
4 Wiener AC Wiener AC 20 59 41 35
5 First Vienna First Vienna 20 50 36 32
6 Simmeringer SC Simmeringer 20 57 63 30
7 FAC Wien FAC Wien 20 61 54 28
8 Austria Wien Austria Wien 21 50 52 23
9 Rudolfshügel Rudolfshüge 21 41 42 22
10 Hertha Wien Hertha Wien 21 31 51 20
11 SC Wiener Viktoria Wiener 4 6 16 3
12 Cricket Cricket 21 13 100 2

  USO DE MEMORIA  
6,055,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1214
Total Execution Time  0.1226
  CADENA URL  
/historico/Rapid-Wien/1925
  GET DATOS  
$_GET['/historico/Rapid-Wien/1925']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0042  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 = 26287
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9774 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9774 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  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 (2898,4250,4425,4889,5084) ORDER BY n.cover_points DESC, update_date DESC
0.0102  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 = '9774' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 26287 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0081  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=9774 AND l.year in (1924,1925,1926) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (26291) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 26291 AND teamId = 9774
0.0026  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 events1925 e ON e.player_id = p.id AND e.league_id = 26287 WHERE rp.league_id = 26287 AND rp.teamId = 9774 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.0022  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 events1925 e ON e.player_id = p.id AND e.league_id = 26287 WHERE rp.league_id = 26287 AND rp.teamId = 9774 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 events1925 e ON e.player_id = p.id AND e.league_id = 26287 WHERE rp.league_id = 26287 AND rp.teamId = 9774 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0083  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 = 9774 AND l.year <= 1925 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1925` 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 = 26287 AND t.round = 22 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 `tables1924` 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 = 26291 AND t.round = 22 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 `tables1923` 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 = 26299 AND t.round = 26 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 `tables1922` 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 = 26300 AND t.round = 26 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 `tables1921` 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 = 26303 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables1920` 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 = 26305 AND t.round = 22 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 `tables1919` 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 = 26307 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables1918` 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 = 26308 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables1917` 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 = 26309 AND t.round = 18 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 `tables1916` 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 = 26312 AND t.round = 18 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 `tables1915` 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 = 26313 AND t.round = 9 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 `tables1914` 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 = 26314 AND t.round = 18 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 `tables1913` 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 = 26315 AND t.round = 18 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 `tables1912` 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 = 26316 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC