4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Lebring
TEMPORADA 2023/2024
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 SV Tillmitsch Tillmitsch 24 44 25 46
2 Hartberg II Hartberg II 24 60 48 41
3 Wildon Wildon 24 50 33 41
4 Kalsdorf Kalsdorf 24 48 42 40
5 Lafnitz II Lafnitz II 24 52 40 39
6 Fehring Fehring 24 35 31 37
7 Lebring Lebring 24 48 43 36
8 Köflach Köflach 24 38 24 35
9 FC Schladming Schladming 24 37 46 34
10 SC Fürstenfeld Fürstenfeld 24 38 35 34
11 Ilzer SV Ilzer SV 24 35 37 34
12 Union Gamlitz Union 24 50 38 34
13 TUS Heiligenkreuz Heiligenkreu 24 47 52 33
14 SC Bruck SC Bruck 24 39 48 26
15 SV Union Gnas Union Gnas 24 26 62 18
16 Frauental Frauental 24 20 63 14
TEMPORADA 2022/2023
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Voitsberg Voitsberg 27 69 26 60
2 Lebring Lebring 27 64 51 51
3 Fehring Fehring 27 54 37 49
4 Mettersdorf Mettersdorf 27 60 37 43
5 Wildon Wildon 27 47 36 43
6 SV Union Gnas Union Gnas 27 42 43 41
7 Lafnitz II Lafnitz II 27 54 46 39
8 Union Gamlitz Union 27 42 50 39
9 TUS Heiligenkreuz Heiligenkreu 27 51 42 38
10 Köflach Köflach 27 32 32 36
11 SC Fürstenfeld Fürstenfeld 27 49 53 36
12 Ilzer SV Ilzer SV 27 46 55 32
13 SC Bruck SC Bruck 27 53 59 29
14 Frauental Frauental 27 27 47 29
15 Liezen Liezen 27 27 63 19
16 Judenburg Judenburg 27 28 68 15
TEMPORADA 2021/2022
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Leoben Leoben 30 77 19 71
2 Voitsberg Voitsberg 30 70 21 70
3 Lafnitz II Lafnitz II 30 80 29 60
4 Mettersdorf Mettersdorf 30 62 38 49
5 Union Gamlitz Union 30 52 46 44
6 TUS Heiligenkreuz Heiligenkreu 30 46 42 43
7 Frauental Frauental 30 49 49 43
8 SC Fürstenfeld Fürstenfeld 30 45 45 40
9 Lebring Lebring 30 50 56 40
10 Wildon Wildon 30 43 50 40
11 SC Bruck SC Bruck 30 50 76 36
12 Ilzer SV Ilzer SV 30 41 65 34
13 SV Union Gnas Union Gnas 30 45 61 29
14 Liezen Liezen 30 27 64 24
15 Hitthaller St. Michael Hitthaller 30 29 82 24
16 Rottenmann Rottenmann 30 44 67 23
TEMPORADA 2020/2021
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 SC Fürstenfeld Fürstenfeld 12 29 14 28
2 Voitsberg Voitsberg 10 33 12 25
3 Mettersdorf Mettersdorf 12 28 12 25
4 SV Union Gnas Union Gnas 12 27 17 23
5 Frauental Frauental 10 18 12 22
6 Lafnitz II Lafnitz II 11 22 13 21
7 Rottenmann Rottenmann 12 19 20 20
8 Lebring Lebring 12 18 17 18
9 TUS Heiligenkreuz Heiligenkreu 11 18 19 13
10 Union Gamlitz Union 11 18 32 13
11 Leoben Leoben 12 19 23 11
12 Ilzer SV Ilzer SV 11 22 26 10
13 Wildon Wildon 12 19 27 9
14 Hitthaller St. Michael Hitthaller 12 14 28 8
15 Liezen Liezen 12 10 25 7
16 SC Bruck SC Bruck 12 16 33 5
TEMPORADA 2019/2020
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Voitsberg Voitsberg 15 36 15 30
2 Mettersdorf Mettersdorf 15 32 21 30
3 Lafnitz II Lafnitz II 15 30 13 29
4 Wildon Wildon 15 31 23 28
5 SV Union Gnas Union Gnas 15 28 17 26
6 SC Bruck SC Bruck 15 29 21 26
7 SC Fürstenfeld Fürstenfeld 15 38 20 24
8 Frauental Frauental 15 20 19 23
9 Lebring Lebring 15 27 27 21
10 Leoben Leoben 15 21 28 18
11 TUS Heiligenkreuz Heiligenkreu 15 27 32 17
12 Union Gamlitz Union 15 22 33 15
13 Hitthaller St. Michael Hitthaller 15 20 32 14
14 Ilzer SV Ilzer SV 15 15 32 10
15 Rottenmann Rottenmann 15 13 30 10
16 Liezen Liezen 15 9 35 5
TEMPORADA 2018/2019
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Weindorf St. Anna Weindorf 30 78 34 68
2 SV Union Gnas Union Gnas 30 65 39 56
3 SC Fürstenfeld Fürstenfeld 30 65 52 49
4 Lebring Lebring 30 62 50 49
5 TUS Heiligenkreuz Heiligenkreu 30 54 44 47
6 Lafnitz II Lafnitz II 30 58 51 47
7 Voitsberg Voitsberg 30 58 49 45
8 Wildon Wildon 30 56 64 40
9 SC Bruck SC Bruck 30 46 61 38
10 Mettersdorf Mettersdorf 30 48 44 36
11 Frauental Frauental 30 50 63 36
12 Hitthaller St. Michael Hitthaller 30 43 63 36
13 Bad Radkersburg Radkersburg 30 46 51 35
14 Leoben Leoben 30 39 50 31
15 Liezen Liezen 30 22 54 26
16 TSV Pöllau TSV Pöllau 30 41 62 24
TEMPORADA 2017/2018
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Grazer AK Grazer AK 30 61 24 68
2 Weindorf St. Anna Weindorf 30 75 40 62
3 Lebring Lebring 30 71 46 53
4 SC Bruck SC Bruck 30 62 46 52
5 SC Fürstenfeld Fürstenfeld 30 63 48 52
6 Voitsberg Voitsberg 30 66 39 51
7 SV Union Gnas Union Gnas 30 60 48 50
8 Mettersdorf Mettersdorf 30 66 46 49
9 TUS Heiligenkreuz Heiligenkreu 30 50 65 43
10 Bad Radkersburg Radkersburg 30 57 56 38
11 TSV Pöllau TSV Pöllau 30 34 52 30
12 Leoben Leoben 30 47 61 28
13 Wildon Wildon 30 42 61 28
14 Liezen Liezen 30 40 61 27
15 Trofaiach Trofaiach 30 41 84 23
16 Kapfenberger SV KM II Kapfenberger 30 37 95 17
TEMPORADA 2016/2017
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 TUS Bad Gleichenberg Gleichenberg 30 80 32 68
2 Voitsberg Voitsberg 30 72 34 64
3 Weindorf St. Anna Weindorf 30 75 39 64
4 Mettersdorf Mettersdorf 30 75 56 52
5 Leoben Leoben 30 55 47 50
6 TUS Heiligenkreuz Heiligenkreu 30 54 52 48
7 Wildon Wildon 30 62 43 47
8 Lebring Lebring 30 60 44 45
9 SC Fürstenfeld Fürstenfeld 30 62 54 43
10 SV Union Gnas Union Gnas 30 42 51 40
11 SC Bruck SC Bruck 30 49 59 37
12 Liezen Liezen 30 42 53 35
13 Kapfenberger SV KM II Kapfenberger 30 47 69 30
14 TSV Pöllau TSV Pöllau 30 49 74 29
15 Frohnleiten Frohnleiten 30 38 65 23
16 Zeltweg Zeltweg 30 18 108 4
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

  USO DE MEMORIA  
6,040,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1210
Total Execution Time  0.1230
  CADENA URL  
/historico/Lebring
  GET DATOS  
$_GET['/historico/Lebring']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0028  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 = 'Lebring' AND l.year = 2024 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=18098 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=18098 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=18098 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18098 AND type_rel = 2
0.0023  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 = '18098' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '18098' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '18098' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73015 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=18098 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73015,71432) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73015 AND teamId = 18098
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 18098
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73015 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '18098' 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 = '18098' 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 = '18098' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 73015 WHERE rp.league_id = 73015 AND rp.teamId = 18098 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.0025  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 = 73015 WHERE rp.league_id = 73015 AND rp.teamId = 18098 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 73015 WHERE rp.league_id = 73015 AND rp.teamId = 18098 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 18098 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 73015 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 68327 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 63694 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 57785 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 50452 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 `tables2019` 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 = 44308 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 = 38908 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 = 38904 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0059  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.0055  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