4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Gleisdorf
TEMPORADA 2016/2017
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 30 74 38 62
2 SV Lafnitz SV Lafnitz 30 54 27 60
3 Gleisdorf Gleisdorf 30 53 35 59
4 Stadl-Paura Stadl-Paura 30 75 53 51
5 Deutschlandsberger Deutschlands 30 65 45 46
6 Vorwarts Steyr Vorwarts 30 56 49 44
7 Kalsdorf Kalsdorf 30 38 35 44
8 Gurten Gurten 30 39 43 42
9 Union St. Florian Union 30 36 46 39
10 Sturm Graz II Sturm Graz 30 42 51 38
11 Weiz Weiz 30 40 52 38
12 Austria Klagenfurt Austria 30 43 61 35
13 Allerheiligen Allerheilige 30 46 60 33
14 SV Pasching SV Pasching 30 43 49 31
15 Grieskirchen Grieskirchen 30 44 64 23
16 ATSV Wolfsberg ATSV 30 25 65 19
TEMPORADA 2015/2016
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Gleisdorf Gleisdorf 29 59 25 64
2 Weindorf St. Anna Weindorf 29 71 46 60
3 SV Union Gnas Union Gnas 29 50 29 55
4 Liezen Liezen 29 49 30 50
5 Leoben Leoben 29 49 37 45
6 TUS Bad Gleichenberg Gleichenberg 29 46 42 44
7 Voitsberg Voitsberg 29 52 51 44
8 Lebring Lebring 29 56 47 41
9 Frohnleiten Frohnleiten 29 40 47 38
10 SC Fürstenfeld Fürstenfeld 29 41 47 37
11 TUS Heiligenkreuz Heiligenkreu 29 42 54 33
12 Lankowitz Lankowitz 15 35 19 32
13 Zeltweg Zeltweg 29 51 71 29
14 Kapfenberger SV KM II Kapfenberger 29 41 51 28
15 SV ADA Anger Anger 29 31 60 22
16 Kindberg-Mürzhofen Kindberg-Mü 29 24 81 8
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Deutschlandsberger Deutschlands 30 84 35 68
2 TUS Heiligenkreuz Heiligenkreu 30 71 38 66
3 Gleisdorf Gleisdorf 30 60 46 48
4 Frohnleiten Frohnleiten 30 48 48 47
5 SV Union Gnas Union Gnas 30 55 43 45
6 Zeltweg Zeltweg 30 61 50 44
7 SV ADA Anger Anger 30 50 44 44
8 Kapfenberger SV KM II Kapfenberger 30 52 48 44
9 Voitsberg Voitsberg 30 51 53 44
10 Weindorf St. Anna Weindorf 30 58 61 38
11 Liezen Liezen 30 37 49 37
12 Lebring Lebring 30 34 43 36
13 Leoben Leoben 30 45 55 34
14 SC Fürstenfeld Fürstenfeld 30 46 56 32
15 SV Gleinstätten Gleinstätte 30 63 78 31
16 Gratkorn Gratkorn 30 27 95 9
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Weiz Weiz 30 71 19 72
2 Gleisdorf Gleisdorf 30 70 39 61
3 Deutschlandsberger Deutschlands 30 72 42 59
4 SV Gleinstätten Gleinstätte 30 56 43 53
5 SV Union Gnas Union Gnas 30 43 34 46
6 TUS Heiligenkreuz Heiligenkreu 30 65 59 45
7 Frohnleiten Frohnleiten 30 53 49 42
8 Voitsberg Voitsberg 30 47 45 41
9 Leoben Leoben 30 40 44 39
10 SC Fürstenfeld Fürstenfeld 30 45 45 37
11 Gratkorn Gratkorn 30 41 55 32
12 SV ADA Anger Anger 30 35 47 31
13 Liezen Liezen 30 38 55 31
14 Wildon Wildon 30 38 59 30
15 Grossklein Grossklein 30 27 65 20
16 Irdning Irdning 30 32 73 18
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 SV Lafnitz SV Lafnitz 30 80 36 63
2 Weiz Weiz 30 60 33 60
3 SV Gleinstätten Gleinstätte 30 61 41 53
4 Deutschlandsberger Deutschlands 30 58 49 51
5 Gleisdorf Gleisdorf 30 63 44 47
6 Frohnleiten Frohnleiten 30 47 48 47
7 SC Fürstenfeld Fürstenfeld 30 52 44 45
8 Voitsberg Voitsberg 30 50 39 42
9 Liezen Liezen 30 44 42 40
10 Wildon Wildon 30 43 62 38
11 TUS Heiligenkreuz Heiligenkreu 30 45 59 35
12 SV ADA Anger Anger 30 38 52 34
13 SV Pachern SV Pachern 30 50 60 32
14 Gratkorn II Gratkorn II 30 37 65 30
15 SVA Kindberg Kindberg 30 29 55 29
16 Zeltweg Zeltweg 30 33 61 25
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Kalsdorf Kalsdorf 30 74 38 64
2 Weiz Weiz 30 67 36 55
3 Liezen Liezen 30 57 33 54
4 Gleisdorf Gleisdorf 30 62 32 51
5 Voitsberg Voitsberg 30 57 42 46
6 SC Fürstenfeld Fürstenfeld 30 51 54 46
7 SV Lafnitz SV Lafnitz 30 64 59 44
8 SVA Kindberg Kindberg 30 50 47 43
9 SV ADA Anger Anger 30 60 56 42
10 Frohnleiten Frohnleiten 30 41 44 39
11 SV Pachern SV Pachern 30 43 65 35
12 Wildon Wildon 30 56 62 34
13 Gratkorn II Gratkorn II 30 42 73 33
14 Irdning Irdning 30 32 69 28
15 Grossklein Grossklein 30 49 68 26
16 Mürzhofen/Allerheiligen Mürzhofen/A 30 36 63 26
TEMPORADA 2010/2011
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Kapfenberger SV KM II Kapfenberger 30 69 35 62
2 Frohnleiten Frohnleiten 30 42 26 51
3 Gleisdorf Gleisdorf 30 50 38 48
4 SV Pachern SV Pachern 30 48 45 47
5 SVA Kindberg Kindberg 30 47 45 47
6 Liezen Liezen 30 49 39 45
7 Wildon Wildon 30 54 48 45
8 SC Fürstenfeld Fürstenfeld 30 50 39 44
9 SV ADA Anger Anger 30 48 45 42
10 Gratkorn II Gratkorn II 30 59 49 41
11 Kalsdorf Kalsdorf 30 39 42 37
12 Irdning Irdning 30 39 47 35
13 TSV Pöllau TSV Pöllau 30 40 55 31
14 Fehring Fehring 30 39 56 29
15 Köflach Köflach 30 32 63 25
16 SVL Flavia Solva Flavia Solva 30 34 67 25
TEMPORADA 2009/2010
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 SV Gleinstätten Gleinstätte 30 67 33 58
2 Kapfenberger SV KM II Kapfenberger 30 54 34 56
3 Irdning Irdning 30 51 37 50
4 SC Fürstenfeld Fürstenfeld 30 54 48 46
5 Kalsdorf Kalsdorf 30 51 48 45
6 SV ADA Anger Anger 30 42 44 44
7 Gleisdorf Gleisdorf 30 45 35 43
8 Gratkorn II Gratkorn II 30 49 47 43
9 Köflach Köflach 30 44 48 41
10 Fehring Fehring 30 38 44 41
11 Wildon Wildon 30 58 54 40
12 SV Pachern SV Pachern 30 49 52 38
13 Liezen Liezen 30 43 48 36
14 Grossklein Grossklein 30 32 44 36
15 SC Bruck SC Bruck 30 29 49 20
16 Grazer AK II Grazer 30 29 70 16
TEMPORADA 2008/2009
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 SVL Flavia Solva Flavia Solva 30 54 34 52
2 Kalsdorf Kalsdorf 29 56 38 52
3 SC Fürstenfeld Fürstenfeld 30 55 50 51
4 Gleisdorf Gleisdorf 30 47 40 50
5 Fehring Fehring 30 57 47 47
6 SV Gleinstätten Gleinstätte 30 64 48 46
7 SC Bruck SC Bruck 30 40 34 46
8 Köflach Köflach 30 52 49 41
9 Gratkorn II Gratkorn II 30 55 50 40
10 Wildon Wildon 30 40 47 39
11 Grazer AK II Grazer 30 53 46 37
12 Irdning Irdning 30 32 41 36
13 Kapfenberger SV KM II Kapfenberger 29 44 53 34
14 Grossklein Grossklein 30 40 52 34
15 Deutschlandsberger Deutschlands 30 40 64 32
16 Hartberg II Hartberg II 30 33 69 25

  USO DE MEMORIA  
6,212,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1459
Total Execution Time  0.1473
  CADENA URL  
/historico/Gleisdorf/2017
  GET DATOS  
$_GET['/historico/Gleisdorf/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0049  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 = 'Gleisdorf' AND l.year = 2017 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.0018  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=18095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=18095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=18095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=18095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 33372
0.0024  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 = 33329
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18095 AND type_rel = 2
0.0032  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 = '18095' ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '18095' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '18095' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 33329 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 33372 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=18095 AND l.year in (2016,2017,2018) 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 (38883,38838,38427,15767) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 38883 AND teamId = 18095
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 15767 AND teamId = 18095
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 38838 AND teamId = 18095
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 18095
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 FROM `tables2017` 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 = 33372 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '18095' 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 = '18095' 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 = '18095' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040  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 events2017 e ON e.player_id = p.id AND e.league_id = 33372 WHERE rp.league_id = 33372 AND rp.teamId = 18095 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.0038  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 events2017 e ON e.player_id = p.id AND e.league_id = 33372 WHERE rp.league_id = 33372 AND rp.teamId = 18095 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 events2017 e ON e.player_id = p.id AND e.league_id = 33372 WHERE rp.league_id = 33372 AND rp.teamId = 18095 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 18095 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2017` 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 = 33372 AND t.round = 30 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 `tables2016` 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 = 15767 AND t.round = 30 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 `tables2015` 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 = 3939 AND t.round = 30 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 `tables2014` 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 = 27166 AND t.round = 30 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 `tables2013` 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 = 27164 AND t.round = 30 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 `tables2012` 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 = 27202 AND t.round = 30 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 `tables2011` 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 = 27218 AND t.round = 30 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 `tables2010` 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 = 27238 AND t.round = 30 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 `tables2009` 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 = 27261 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 33372 ORDER BY nameShow LIMIT 100