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

TSV Hartberg

Entrenador: Markus Schopp

Temporada 2007/2008
TEMPORADA 2007/2008
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Vöcklabruck Vöcklabruck 30 70 23 68
2 Feldkirchen Feldkirchen 30 66 45 52
3 Grazer AK Grazer AK 30 57 37 52
4 WAC Sankt Andrä Sankt Andrä 30 41 26 52
5 Sturm Graz II Sturm Graz 30 52 40 52
6 Allerheiligen Allerheilige 30 40 35 52
7 TSV Hartberg Hartberg 30 45 38 44
8 Wels Wels 30 57 46 43
9 SAK Klagenfurt Klagenfurt 30 44 43 41
10 Union St. Florian Union 30 44 45 38
11 Austria Kärnten II Austria 30 40 52 38
12 Weiz Weiz 30 45 47 35
13 Spittal Spittal 30 34 42 30
14 Gmunden Gmunden 30 33 69 26
15 Grieskirchen Grieskirchen 30 30 55 22
16 Bleiburg Bleiburg 30 19 74 10
TEMPORADA 2006/2007
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 LASK LASK 33 74 34 76
2 SC Schwanenstadt Schwanenstad 33 59 41 63
3 Leoben Leoben 33 55 36 55
4 Austria Lustenau Austria 33 57 50 50
5 Gratkorn Gratkorn 33 45 41 47
6 FC Lustenau FC Lustenau 33 54 51 47
7 FC Kärnten FC Kärnten 33 41 41 42
8 Austria Wien II Austria Wien 33 42 52 38
9 Parndorf Parndorf 33 41 47 35
10 Admira Admira 33 45 67 33
11 Kapfenberger SV Kapfenberger 33 41 60 32
12 TSV Hartberg Hartberg 33 31 65 26
TEMPORADA 2005/2006
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 30 54 28 63
2 Spittal Spittal 30 48 35 54
3 Feldkirchen Feldkirchen 30 43 38 53
4 Voitsberg Voitsberg 30 44 38 48
5 WAC Sankt Andrä Sankt Andrä 30 49 33 45
6 Union St. Florian Union 30 45 33 44
7 Köflach Köflach 30 46 42 43
8 Wels Wels 30 41 40 40
9 SAK Klagenfurt Klagenfurt 30 39 55 39
10 Bad Aussee Bad Aussee 30 38 34 37
11 Sturm Graz II Sturm Graz 30 52 46 35
12 Blau-Weiß Linz Blau-Weiß 30 32 42 34
13 FC Superfund II Superfund 30 36 42 31
14 Vöcklabruck Vöcklabruck 30 37 49 31
15 Union Perg Union Perg 30 27 43 31
16 Bleiburg Bleiburg 30 30 63 24
TEMPORADA 2004/2005
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 SC Schwanenstadt Schwanenstad 30 43 26 62
2 TSV Hartberg Hartberg 30 55 33 50
3 Spittal Spittal 30 56 43 48
4 FC Superfund II Superfund 30 57 41 47
5 Köflach Köflach 30 42 32 47
6 Sturm Graz II Sturm Graz 30 49 46 44
7 Union St. Florian Union 30 36 30 43
8 Bleiburg Bleiburg 30 37 52 40
9 Feldkirchen Feldkirchen 30 46 55 38
10 Blau-Weiß Linz Blau-Weiß 30 33 32 37
11 WAC Sankt Andrä Sankt Andrä 30 36 41 37
12 Voitsberg Voitsberg 30 39 42 35
13 Wels Wels 30 34 42 35
14 Union Perg Union Perg 30 31 45 34
15 FC Kärnten II Kärnten 30 30 41 31
16 Kalsdorf Kalsdorf 30 32 55 21
TEMPORADA 2003/2004
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Gratkorn Gratkorn 30 67 28 63
2 TSV Hartberg Hartberg 30 62 30 60
3 Arnfels Arnfels 30 50 39 49
4 Köflach Köflach 30 53 49 48
5 Blau-Weiß Linz Blau-Weiß 30 40 33 47
6 SC Schwanenstadt Schwanenstad 30 41 35 44
7 Bleiburg Bleiburg 30 33 32 42
8 Sturm Graz II Sturm Graz 30 33 35 41
9 WAC Sankt Andrä Sankt Andrä 30 44 47 40
10 FC Kärnten II Kärnten 30 31 28 39
11 Voitsberg Voitsberg 30 45 49 39
12 Union St. Florian Union 30 35 41 38
13 Union Perg Union Perg 30 35 58 35
14 Spittal Spittal 30 27 38 34
15 Wels Wels 30 25 48 26
16 LASK Linz II LASK Linz 30 23 54 19
TEMPORADA 2002/2003
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Blau-Weiß Linz Blau-Weiß 30 72 22 72
2 TSV Hartberg Hartberg 30 58 37 59
3 SC Schwanenstadt Schwanenstad 30 58 38 52
4 Voitsberg Voitsberg 30 54 29 51
5 Gratkorn Gratkorn 30 42 24 51
6 Köflach Köflach 30 49 41 50
7 Spittal Spittal 30 41 34 42
8 FC Kärnten II Kärnten 30 38 41 42
9 Bleiburg Bleiburg 30 32 43 41
10 Sturm Graz II Sturm Graz 30 58 53 39
11 Union Perg Union Perg 30 42 47 36
12 Eintracht Wels Eintracht 30 35 55 33
13 Union St. Florian Union 30 33 56 31
14 SAK Klagenfurt Klagenfurt 30 32 52 28
15 St. Veit Glan Veit Glan 30 26 70 24
16 Zeltweg Zeltweg 30 28 56 23
TEMPORADA 2001/2002
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kapfenberger SV Kapfenberger 30 79 29 66
2 Blau-Weiß Linz Blau-Weiß 30 62 34 61
3 TSV Hartberg Hartberg 30 54 26 59
4 Gratkorn Gratkorn 30 48 27 55
5 Spittal Spittal 30 49 30 53
6 SC Schwanenstadt Schwanenstad 30 47 35 49
7 Zeltweg Zeltweg 30 44 47 48
8 Voitsberg Voitsberg 30 42 41 41
9 Köflach Köflach 30 33 41 39
10 Eintracht Wels Eintracht 30 31 36 38
11 Union St. Florian Union 30 53 58 37
12 FC Kärnten II Kärnten 30 40 45 35
13 Bleiburg Bleiburg 30 26 34 33
14 Sankt Veit Sankt Veit 30 28 57 18
15 ATSV Wolfsberg ATSV 30 23 57 18
16 Donau Linz Donau Linz 30 27 89 8
TEMPORADA 2000/2001
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 SV Pasching SV Pasching 30 61 27 56
2 Kapfenberger SV Kapfenberger 30 50 34 51
3 TSV Hartberg Hartberg 30 47 30 48
4 BSV Juniors BSV Juniors 30 52 39 48
5 Gratkorn Gratkorn 30 44 35 45
6 Donau Linz Donau Linz 30 33 30 45
7 Blau-Weiß Linz Blau-Weiß 30 48 41 42
8 Alpe Adria Alpe Adria 30 38 44 41
9 Zeltweg Zeltweg 30 42 39 40
10 Spittal Spittal 30 47 51 39
11 Wels Wels 30 40 51 38
12 Voitsberg Voitsberg 30 40 48 37
13 Wolfsberger AC Wolfsberger 30 37 49 34
14 Union St. Florian Union 30 34 56 32
15 Lendorf Lendorf 30 24 45 31
16 SAK Klagenfurt Klagenfurt 30 29 47 26
TEMPORADA 1997/1998
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Vorwarts Steyr Vorwarts 28 59 30 54
2 Spittal Spittal 28 52 30 50
3 First Vienna First Vienna 28 44 26 46
4 Braunau Braunau 28 42 27 46
5 SW Bregenz SW Bregenz 28 44 31 45
6 Leoben Leoben 28 40 43 41
7 SV Stockerau Stockerau 28 44 45 40
8 Gerasdorf Stammersdorf Gerasdorf 28 49 47 39
9 VSE St. Polten Polten 28 32 40 39
10 SCR Altach SCR Altach 28 30 31 38
11 TSV Hartberg Hartberg 28 35 39 35
12 WSG Tirol WSG Tirol 28 32 36 34
13 Kufstein Kufstein 28 22 37 28
14 Kottingbrunn Kottingbrunn 28 28 60 19
15 Eintracht Wels Eintracht 28 24 55 18
TEMPORADA 1996/1997
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Lustenau Austria 30 60 18 65
2 Vorwarts Steyr Vorwarts 30 65 26 60
3 First Vienna First Vienna 30 67 31 58
4 Gerasdorf Stammersdorf Gerasdorf 30 54 38 51
5 Spittal Spittal 30 43 26 50
6 VSE St. Polten Polten 30 54 49 48
7 SW Bregenz SW Bregenz 30 39 38 43
8 SV Stockerau Stockerau 30 39 36 42
9 Braunau Braunau 30 36 35 41
10 Kufstein Kufstein 30 29 42 41
11 WSG Tirol WSG Tirol 30 41 45 38
12 Leoben Leoben 30 35 37 35
13 Modling Modling 30 35 55 34
14 TSV Hartberg Hartberg 30 34 48 30
15 SVL Flavia Solva Flavia Solva 30 19 69 15
16 Favoritner AC Favoritner 30 16 73 12

  USO DE MEMORIA  
6,045,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6436
Total Execution Time  0.6448
  CADENA URL  
/historico/Hartberg/2008
  GET DATOS  
$_GET['/historico/Hartberg/2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0199  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 = 'Hartberg' AND l.year = 2008 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.0148  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=12367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=12367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294  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 = 24541
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12367 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12367 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0152  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 (523342,887653,887837,1076481,1181602) ORDER BY n.cover_points DESC, update_date DESC
0.0159  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 = '12367' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '12367' AND l.year = 2008 ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '12367' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 24541 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  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=12367 AND l.year in (2007,2008,2009) ORDER BY l.id DESC, l.year DESC ;
0.0149  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 (24541,20736,8919) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 8919 AND teamId = 12367
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 24541 AND teamId = 12367
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 20736 AND teamId = 12367
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 FROM `tables2008` 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 = 24541 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '12367' 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 = '12367' and rp.type = 4
0.0147  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 = '12367' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159  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 events2008 e ON e.player_id = p.id AND e.league_id = 24541 WHERE rp.league_id = 24541 AND rp.teamId = 12367 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.0154  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 events2008 e ON e.player_id = p.id AND e.league_id = 24541 WHERE rp.league_id = 24541 AND rp.teamId = 12367 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 events2008 e ON e.player_id = p.id AND e.league_id = 24541 WHERE rp.league_id = 24541 AND rp.teamId = 12367 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 12367 AND l.year <= 2008 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2008` 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 = 24541 AND t.round = 30 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 `tables2007` 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 = 8919 AND t.round = 33 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 `tables2006` 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 = 27592 AND t.round = 30 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 `tables2005` 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 = 27576 AND t.round = 30 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 `tables2004` 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 = 27570 AND t.round = 30 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 `tables2003` 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 = 44521 AND t.round = 30 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 `tables2002` 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 = 27565 AND t.round = 30 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 `tables2001` 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 = 27556 AND t.round = 30 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 `tables1998` 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 = 10041 AND t.round = 30 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 `tables1997` 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 = 10042 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC