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 2003/2004
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  
5,567,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5291
Total Execution Time  0.5303
  CADENA URL  
/historico/Hartberg/2004
  GET DATOS  
$_GET['/historico/Hartberg/2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0140  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 = 2004 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.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=12367 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=12367 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=12367 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 = 27570
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 = 23360
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12367 AND type_rel = 2
0.0126  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.0129  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.0134  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.0134  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 = 2004 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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.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 = 23360 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 = 27570 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0143  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 (2003,2004,2005) 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 (44521,23361) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 44521 AND teamId = 12367
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 23361 AND teamId = 12367
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133  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.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12367' and rp.type = 4
0.0126  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.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 events2004 e ON e.player_id = p.id AND e.league_id = 27570 WHERE rp.league_id = 27570 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.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 events2004 e ON e.player_id = p.id AND e.league_id = 27570 WHERE rp.league_id = 27570 AND rp.teamId = 12367 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 events2004 e ON e.player_id = p.id AND e.league_id = 27570 WHERE rp.league_id = 27570 AND rp.teamId = 12367 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 <= 2004 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 `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.0134  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.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 `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