4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kapfenberger SV

Kapfenberger SV

Entrenador: Abdulah Ibrakovic

Temporada 1970/1971
TEMPORADA 1966/1967
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 26 72 29 61
2 Wacker Innsbruck Wacker 26 58 24 59
3 Austria Wien Austria Wien 26 43 23 49
4 LASK LASK 26 39 25 43
5 Wiener SC Wiener SC 26 60 36 42
6 SW Bregenz SW Bregenz 27 26 37 39
7 First Vienna First Vienna 26 42 49 37
8 Admira Admira 26 36 25 36
9 Grazer AK Grazer AK 26 27 44 31
10 Austria Klagenfurt Austria 26 21 33 30
11 Sturm Graz Sturm Graz 26 32 47 25
12 Wacker Wien Wacker Wien 26 28 50 25
13 Wiener Neustadt Wiener 26 21 44 21
14 Kapfenberger SV Kapfenberger 27 20 59 16
TEMPORADA 1965/1966
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Admira Admira 26 51 17 43
2 Rapid Wien Rapid Wien 26 64 22 40
3 Austria Wien Austria Wien 26 58 28 35
4 Wiener SC Wiener SC 26 57 32 30
5 First Vienna First Vienna 26 52 43 30
6 Austria Klagenfurt Austria 26 39 33 29
7 LASK LASK 26 46 37 27
8 FC Wacker Innsbruck Wacker 26 32 31 25
9 Schwechat Schwechat 26 40 42 23
10 Grazer AK Grazer AK 26 35 46 23
11 Kapfenberger SV Kapfenberger 26 26 51 20
12 Wiener Neustadt Wiener 26 24 59 18
13 Salzburg Salzburg 26 25 66 12
14 Simmeringer SC Simmeringer 26 26 68 9
TEMPORADA 1964/1965
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 LASK LASK 26 49 29 50
2 Admira Admira 26 52 28 49
3 Rapid Wien Rapid Wien 26 42 21 49
4 Wiener SC Wiener SC 26 54 36 48
5 First Vienna First Vienna 26 51 36 42
6 Schwechat Schwechat 26 27 28 39
7 Austria Wien Austria Wien 26 29 28 37
8 Wacker Innsbruck Wacker 26 29 23 34
9 Wiener Neustadt Wiener 26 31 32 31
10 Sturm Graz Sturm Graz 26 29 40 26
11 Grazer AK Grazer AK 26 28 48 26
12 Kapfenberger SV Kapfenberger 26 25 45 25
13 Wiener AC Wiener AC 26 31 54 20
14 Wacker Wien Wacker Wien 26 27 56 19
TEMPORADA 1963/1964
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 26 69 27 62
2 Austria Wien Austria Wien 26 61 36 54
3 LASK LASK 26 46 36 48
4 Schwechat Schwechat 26 51 41 44
5 Wiener SC Wiener SC 26 48 53 44
6 Grazer AK Grazer AK 26 49 42 38
7 Admira Admira 26 52 49 38
8 First Vienna First Vienna 26 38 33 32
9 Wiener AC Wiener AC 26 33 38 31
10 Wiener Neustadt Wiener 26 33 47 30
11 Kapfenberger SV Kapfenberger 26 38 56 26
12 Simmeringer SC Simmeringer 26 46 64 25
13 Stickstoff Linz Stickstoff 26 42 56 22
14 Dornbirn Dornbirn 26 31 59 17
TEMPORADA 1961/1962
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 26 65 23 61
2 LASK LASK 26 69 40 54
3 Admira Admira 26 56 34 52
4 Wiener SC Wiener SC 26 58 39 44
5 Rapid Wien Rapid Wien 26 58 32 43
6 Wiener AC Wiener AC 26 47 37 38
7 Grazer AK Grazer AK 26 43 42 37
8 Stickstoff Linz Stickstoff 26 47 50 36
9 Schwechat Schwechat 26 50 68 32
10 Simmeringer SC Simmeringer 26 37 62 31
11 First Vienna First Vienna 26 44 44 29
12 Kapfenberger SV Kapfenberger 26 29 53 21
13 Wiener Neustadt Wiener 26 30 57 17
14 Salzburger AK Salzburger 26 27 79 9
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,767,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.1887
Total Execution Time  0.1912
  CADENA URL  
/historico/Kapfenberger-Sv/1971
  GET DATOS  
$_GET['/historico/Kapfenberger-Sv/1971']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0126  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 = 'Kapfenberger-Sv' AND l.year = 1971 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.0032  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=3972 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=3972 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 26706
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3972 AND type_rel = 2
0.0019  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.0021  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.0027  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' AND l.year = 1971 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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.0020  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 = 26706 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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 (1970,1971,1972) 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 (26706) 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.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 26706 AND teamId = 3972
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 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 = 26706 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0027  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.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3972' and rp.type = 4
0.0020  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.0020  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 events1971 e ON e.player_id = p.id AND e.league_id = 26706 WHERE rp.league_id = 26706 AND rp.teamId = 3972 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.0020  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 events1971 e ON e.player_id = p.id AND e.league_id = 26706 WHERE rp.league_id = 26706 AND rp.teamId = 3972 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 events1971 e ON e.player_id = p.id AND e.league_id = 26706 WHERE rp.league_id = 26706 AND rp.teamId = 3972 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 <= 1971 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 26094 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 `tables1966` 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 = 26097 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 `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 = 26100 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 `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 = 26102 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 `tables1962` 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 = 26112 AND t.round = 26 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 `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.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 `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.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 `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.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 `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.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 `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.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 26706 ORDER BY nameShow LIMIT 100
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1562 AND l.year = 1971 ORDER BY l.group_code ASC