4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Lauterach
TEMPORADA 2023/2024
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 Rotenberg Rotenberg 18 38 18 33
2 Admira Dornbirn Admira 18 44 28 32
3 Lauterach Lauterach 18 29 23 31
4 Lochau Lochau 18 29 22 31
5 Hard Hard 17 39 26 29
6 Nenzing Nenzing 18 29 22 28
7 SC Göfis SC Göfis 18 30 25 28
8 FC Lustenau FC Lustenau 18 25 29 23
9 Egg Egg 17 24 31 23
10 FC Höchst FC Höchst 17 22 32 19
11 Alberschwende Alberschwend 17 18 27 19
12 Andelsbuch Andelsbuch 17 19 32 15
13 Austria Lustenau II Austria 18 23 37 14
14 FC Hörbranz Hörbranz 17 20 37 13
TEMPORADA 2022/2023
TERCERA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Röthis Röthis 9 23 10 34
2 Wolfurt Wolfurt 9 17 7 32
3 Dornbirner SV Dornbirner 9 22 14 29
4 SC Rheindorf Altach II Rheindorf 9 10 15 28
5 Rot-Weiß Rankweil Rot-Weiß 9 18 19 24
6 Lauterach Lauterach 9 15 28 24
7 Rotenberg Rotenberg 9 9 13 23
8 Admira Dornbirn Admira 9 20 12 22
9 SC Göfis SC Göfis 9 14 23 22
10 Egg Egg 9 13 20 19
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 7
Equipo PJ GF GC Puntos
1 SW Bregenz SW Bregenz 0 0 0 15
2 SC Rheindorf Altach II Rheindorf 0 0 0 14
3 Langenegg Langenegg 0 0 0 14
4 Röthis Röthis 0 0 0 10
5 Wolfurt Wolfurt 0 0 0 10
6 Lauterach Lauterach 0 0 0 9
7 Austria Lustenau II Austria 0 0 0 8
8 Rot-Weiß Rankweil Rot-Weiß 0 0 0 6
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,765,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  4.3761
Total Execution Time  4.3774
  CADENA URL  
/historico/Lauterach
  GET DATOS  
$_GET['/historico/Lauterach']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0155  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 = 73020
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19429 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=584 AND type_rel = 3
0.3078  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 584 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0806  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 (809215,467932,467907,348427) ORDER BY n.cover_points DESC, update_date DESC
0.1181  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.0917  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.0234  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 = 73020 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.1920  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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0319  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 (73020,71432,71429) 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.3497  SELECT count(id) as num_players from rel_players WHERE league_id = 71429 AND teamId = 19429
0.1606  SELECT count(id) as num_players from rel_players WHERE league_id = 73020 AND teamId = 19429
0.3058  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 19429
0.0178  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.0372  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19429' and rp.type = 4
0.0023  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.4110  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 events2024 e ON e.player_id = p.id AND e.league_id = 73020 WHERE rp.league_id = 73020 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.4607  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 events2024 e ON e.player_id = p.id AND e.league_id = 73020 WHERE rp.league_id = 73020 AND rp.teamId = 19429 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.3422  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 events2024 e ON e.player_id = p.id AND e.league_id = 73020 WHERE rp.league_id = 73020 AND rp.teamId = 19429 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.1348  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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0568  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 `tables2024` 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 = 73020 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.0778  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 `tables2023` 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 = 68179 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.0928  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 `tables2023` 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 = 71429 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.0527  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.1172  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.0533  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.0701  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.0446  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.1072  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.0640  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.2114  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.1883  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.1162  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