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

SV Lafnitz

Entrenador: Robert Weinstabl

Temporada 2014/2015
TEMPORADA 2014/2015
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Austria Klagenfurt Austria 29 66 24 64
2 Vorwarts Steyr Vorwarts 29 43 29 56
3 Weiz Weiz 29 55 39 53
4 SV Lafnitz SV Lafnitz 29 54 27 52
5 Blau-Weiß Linz Blau-Weiß 29 49 34 51
6 Allerheiligen Allerheilige 29 52 42 48
7 Sturm Graz II Sturm Graz 29 50 41 43
8 Kalsdorf Kalsdorf 29 51 49 40
9 Wolfsberger AC II Wolfsberger 29 39 42 40
10 SV Pasching SV Pasching 29 45 49 40
11 Gurten Gurten 29 36 45 37
12 SV Wallern SV Wallern 29 35 46 34
13 Union St. Florian Union 29 32 54 30
14 SAK Klagenfurt Klagenfurt 29 29 61 24
15 Vöcklamarkt Vöcklamarkt 29 25 44 21
16 ATSV Wolfsberg ATSV 29 21 56 16
TEMPORADA 2013/2014
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 LASK LASK 30 80 19 76
2 SV Pasching SV Pasching 30 79 20 69
3 SV Lafnitz SV Lafnitz 30 68 55 55
4 SV Wallern SV Wallern 30 52 46 47
5 Austria Klagenfurt Austria 30 56 68 44
6 Blau-Weiß Linz Blau-Weiß 30 40 52 42
7 Union St. Florian Union 30 36 36 41
8 Sturm Graz II Sturm Graz 30 54 55 41
9 Kalsdorf Kalsdorf 30 53 55 39
10 Allerheiligen Allerheilige 30 49 46 37
11 SAK Klagenfurt Klagenfurt 30 57 65 37
12 Vorwarts Steyr Vorwarts 30 37 47 37
13 Vöcklamarkt Vöcklamarkt 30 38 63 34
14 Wolfsberger AC II Wolfsberger 30 35 57 27
15 SV Villach SV Villach 30 37 62 26
16 Kapfenberger SV KM II Kapfenberger 30 35 60 25
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

  USO DE MEMORIA  
5,514,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6231
Total Execution Time  0.6244
  CADENA URL  
/historico/Sv-Lafnitz/2015
  GET DATOS  
$_GET['/historico/Sv-Lafnitz/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0155  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 = 'Sv-Lafnitz' AND l.year = 2015 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.0149  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=12414 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=12414 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=12414 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=12414 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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 = 4155
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12414 AND type_rel = 2
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=338 AND type_rel = 3
0.0156  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 338 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0159  SELECT /*53 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 (1268188,1267669,1162598,981042,744718) ORDER BY n.cover_points DESC, update_date DESC
0.0161  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 = '12414' ORDER BY l.year DESC,cat.coefficient DESC
0.0155  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 = '12414' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0155  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 = '12414' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 4155 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  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=12414 AND l.year in (2014,2015,2016) 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 (20742,16245,15759) 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.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 15759 AND teamId = 12414
0.0162  SELECT count(id) as num_players from rel_players WHERE league_id = 20742 AND teamId = 12414
0.0297  SELECT count(id) as num_players from rel_players WHERE league_id = 16245 AND teamId = 12414
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 `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 = 4155 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = '12414' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12414' and rp.type = 4
0.0148  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 = '12414' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0170  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 events2015 e ON e.player_id = p.id AND e.league_id = 4155 WHERE rp.league_id = 4155 AND rp.teamId = 12414 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.0192  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 events2015 e ON e.player_id = p.id AND e.league_id = 4155 WHERE rp.league_id = 4155 AND rp.teamId = 12414 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0198  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 events2015 e ON e.player_id = p.id AND e.league_id = 4155 WHERE rp.league_id = 4155 AND rp.teamId = 12414 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0166  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 = 12414 AND l.year <= 2015 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0167  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 = 4155 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 2767 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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.0156  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