4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Lauterach
TEMPORADA 2021/2022
TERCERA AUSTRIA GRUPO 10
Equipo PJ GF GC Puntos
1 Rotenberg Rotenberg 8 11 6 30
2 Röthis Röthis 8 13 11 30
3 SW Bregenz SW Bregenz 8 20 7 29
4 Lauterach Lauterach 8 18 10 27
5 Wolfurt Wolfurt 8 14 15 27
6 Rot-Weiß Rankweil Rot-Weiß 8 12 15 23
7 Egg Egg 8 22 24 18
8 Dornbirner SV Dornbirner 8 10 18 18
9 Austria Lustenau II Austria 8 9 23 8
TEMPORADA 2020/2021
TERCERA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Hohenems Hohenems 12 42 13 32
2 Lauterach Lauterach 13 34 22 28
3 SW Bregenz SW Bregenz 14 32 22 23
4 Austria Lustenau II Austria 12 22 29 18
5 Dornbirner SV Dornbirner 12 23 26 15
6 Wolfurt Wolfurt 11 22 23 13
7 Rot-Weiß Rankweil Rot-Weiß 13 21 42 12
8 Rotenberg Rotenberg 14 25 37 11
9 Röthis Röthis 11 16 23 9
TEMPORADA 2019/2020
TERCERA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Dornbirner SV Dornbirner 18 43 28 38
2 Hohenems Hohenems 18 37 24 33
3 SW Bregenz SW Bregenz 18 41 28 30
4 SC Rheindorf Altach II Rheindorf 18 43 33 29
5 Langenegg Langenegg 18 34 37 28
6 Röthis Röthis 18 32 30 21
7 Wolfurt Wolfurt 18 29 33 20
8 Lauterach Lauterach 18 35 40 18
9 Austria Lustenau II Austria 18 26 47 17
10 Rot-Weiß Rankweil Rot-Weiß 18 36 56 13
TEMPORADA 2017/2018
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Langenegg Langenegg 30 72 41 62
2 Röthis Röthis 30 71 44 54
3 Dornbirner SV Dornbirner 30 78 50 51
4 FC Höchst FC Höchst 30 58 40 51
5 Egg Egg 30 67 50 51
6 SW Bregenz SW Bregenz 30 59 50 51
7 Lauterach Lauterach 30 70 62 48
8 Wolfurt Wolfurt 30 54 62 46
9 Andelsbuch Andelsbuch 30 65 60 41
10 Rot-Weiß Rankweil Rot-Weiß 30 61 58 40
11 Nenzing Nenzing 30 61 57 39
12 Austria Lustenau II Austria 30 58 61 39
13 Admira Dornbirn Admira 30 63 60 37
14 Fussach Fussach 30 48 66 31
15 Blau-Weiß Feldkirch Blau-Weiß 30 45 77 21
16 Schwarzach Schwarzach 30 22 114 5
TEMPORADA 2016/2017
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 Langenegg Langenegg 30 79 39 60
2 Alberschwende Alberschwend 30 56 47 50
3 Dornbirner SV Dornbirner 30 79 73 46
4 Andelsbuch Andelsbuch 30 44 40 45
5 Admira Dornbirn Admira 30 53 57 44
6 Austria Lustenau II Austria 30 56 48 43
7 SW Bregenz SW Bregenz 30 72 73 42
8 Rot-Weiß Rankweil Rot-Weiß 30 63 57 41
9 Wolfurt Wolfurt 30 55 49 41
10 FC Höchst FC Höchst 30 47 45 41
11 Röthis Röthis 30 60 61 40
12 Lauterach Lauterach 30 51 52 40
13 Egg Egg 30 63 71 38
14 Nenzing Nenzing 30 57 70 33
15 Bizau Bizau 30 53 74 31
16 Kennelbach Kennelbach 30 40 72 29
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 SW Bregenz SW Bregenz 26 52 34 49
2 Hohenems Hohenems 26 59 47 44
3 Röthis Röthis 26 53 41 44
4 Egg Egg 26 43 30 43
5 Andelsbuch Andelsbuch 26 39 40 43
6 Meiningen Meiningen 26 34 30 37
7 Austria Lustenau II Austria 26 60 50 36
8 Alberschwende Alberschwend 26 41 39 36
9 Wolfurt Wolfurt 26 38 37 34
10 Admira Dornbirn Admira 26 34 47 33
11 Rot-Weiß Rankweil Rot-Weiß 26 33 45 32
12 Lauterach Lauterach 26 37 43 29
13 Nenzing Nenzing 26 34 50 26
14 Blau-Weiß Feldkirch Blau-Weiß 26 24 48 21
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Bizau Bizau 26 51 23 57
2 Wolfurt Wolfurt 26 66 32 55
3 Andelsbuch Andelsbuch 26 65 41 51
4 Alberschwende Alberschwend 26 44 32 45
5 Röthis Röthis 26 50 28 44
6 Egg Egg 26 65 48 43
7 Rot-Weiß Rankweil Rot-Weiß 26 43 42 40
8 Nenzing Nenzing 26 44 42 34
9 Blau-Weiß Feldkirch Blau-Weiß 26 28 37 30
10 Lauterach Lauterach 26 41 55 29
11 Austria Lustenau II Austria 26 40 68 26
12 Admira Dornbirn Admira 26 44 54 25
13 Fussach Fussach 26 31 58 24
14 Rätia Bludenz Rätia 26 28 80 13
TEMPORADA 2008/2009
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 SC Rheindorf Altach II Rheindorf 26 60 37 55
2 Röthis Röthis 26 46 28 49
3 Koblach Koblach 26 30 29 44
4 Bizau Bizau 26 44 32 43
5 Egg Egg 26 42 25 40
6 Wolfurt Wolfurt 26 36 28 39
7 Andelsbuch Andelsbuch 26 33 30 38
8 Viktoria Bregenz Viktoria 26 38 36 38
9 Mäder Mäder 26 32 41 32
10 Schwarzach Schwarzach 26 39 51 30
11 Austria Lustenau II Austria 26 40 43 29
12 Lauterach Lauterach 26 41 46 29
13 Rätia Bludenz Rätia 26 34 50 21
14 Nenzing Nenzing 26 18 57 11

  USO DE MEMORIA  
5,823,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6701
Total Execution Time  0.6715
  CADENA URL  
/historico/Lauterach/2022
  GET DATOS  
$_GET['/historico/Lauterach/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0158  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 = 'Lauterach' AND l.year = 2022 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.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=19429 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=19429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=19429 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=19429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=19429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0306  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 = 63190
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19429 AND type_rel = 2
0.0157  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 = '19429' ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '19429' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0153  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 = '19429' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0175  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 = 63190 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0165  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=19429 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0158  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 (71429,63190,62807) 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.0164  SELECT count(id) as num_players from rel_players WHERE league_id = 71429 AND teamId = 19429
0.0164  SELECT count(id) as num_players from rel_players WHERE league_id = 63190 AND teamId = 19429
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 19429
0.0150  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 = '19429' 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 = '19429' and rp.type = 4
0.0150  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 = '19429' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0173  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 events2022 e ON e.player_id = p.id AND e.league_id = 63401 WHERE rp.league_id = 63401 AND rp.teamId = 19429 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.0351  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 events2022 e ON e.player_id = p.id AND e.league_id = 63401 WHERE rp.league_id = 63401 AND rp.teamId = 19429 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 events2022 e ON e.player_id = p.id AND e.league_id = 63401 WHERE rp.league_id = 63401 AND rp.teamId = 19429 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 19429 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2022` 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 = 63401 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2022` 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 = 67323 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2021` 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 = 57022 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2020` 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 = 51817 AND t.round = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables2020` 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 = 50650 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables2018` 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 = 38909 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 38905 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 3943 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 27183 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 27270 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC