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 2016/2017
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
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Blau-Weiß Linz Blau-Weiß 30 89 25 70
2 TSV Hartberg Hartberg 30 64 38 60
3 Union St. Florian Union 30 53 35 52
4 Kalsdorf Kalsdorf 30 56 43 51
5 SV Pasching SV Pasching 30 59 46 50
6 SV Lafnitz SV Lafnitz 30 62 52 49
7 Stadl-Paura Stadl-Paura 30 58 49 48
8 Allerheiligen Allerheilige 30 50 43 48
9 Deutschlandsberger Deutschlands 30 49 43 43
10 Gurten Gurten 30 51 44 40
11 Sturm Graz II Sturm Graz 30 48 48 38
12 Vorwarts Steyr Vorwarts 30 36 49 34
13 Weiz Weiz 30 33 66 26
14 Wolfsberger AC II Wolfsberger 30 34 64 23
15 SV Wallern SV Wallern 30 35 70 22
16 Annabichler Austria Annabichler 30 24 86 19
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,793,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5220
Total Execution Time  0.5234
  CADENA URL  
/historico/Sv-Lafnitz/2017
  GET DATOS  
$_GET['/historico/Sv-Lafnitz/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0152  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 = 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.0128  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.0128  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.0127  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.0126  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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12414 AND type_rel = 2
0.0148  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.0153  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 = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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.0129  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.0137  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 (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0128  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) 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.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 38883 AND teamId = 12414
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 38838 AND teamId = 12414
0.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 12414
0.0142  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.0134  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.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12414' and rp.type = 4
0.0136  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.0183  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 = 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.0174  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 = 12414 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169  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 = 12414 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0145  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 <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0142  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.0144  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 = 15759 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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.0138  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.0140  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.0140  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.0128  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