4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fehring
TEMPORADA 2023/2024
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 SV Tillmitsch Tillmitsch 23 42 23 45
2 Hartberg II Hartberg II 23 58 46 40
3 Lafnitz II Lafnitz II 24 52 40 39
4 Wildon Wildon 23 39 33 38
5 Kalsdorf Kalsdorf 23 42 42 37
6 Fehring Fehring 23 34 29 37
7 Köflach Köflach 23 38 23 35
8 Ilzer SV Ilzer SV 24 35 37 34
9 Union Gamlitz Union 23 50 32 34
10 Lebring Lebring 23 44 43 33
11 TUS Heiligenkreuz Heiligenkreu 24 47 52 33
12 FC Schladming Schladming 23 35 45 31
13 SC Fürstenfeld Fürstenfeld 23 37 35 31
14 SC Bruck SC Bruck 24 39 48 26
15 SV Union Gnas Union Gnas 23 26 51 18
16 Frauental Frauental 23 20 59 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 2010/2011
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Kapfenberger SV KM II Kapfenberger 30 69 35 62
2 Frohnleiten Frohnleiten 30 42 26 51
3 Gleisdorf Gleisdorf 30 50 38 48
4 SV Pachern SV Pachern 30 48 45 47
5 SVA Kindberg Kindberg 30 47 45 47
6 Liezen Liezen 30 49 39 45
7 Wildon Wildon 30 54 48 45
8 SC Fürstenfeld Fürstenfeld 30 50 39 44
9 SV ADA Anger Anger 30 48 45 42
10 Gratkorn II Gratkorn II 30 59 49 41
11 Kalsdorf Kalsdorf 30 39 42 37
12 Irdning Irdning 30 39 47 35
13 TSV Pöllau TSV Pöllau 30 40 55 31
14 Fehring Fehring 30 39 56 29
15 Köflach Köflach 30 32 63 25
16 SVL Flavia Solva Flavia Solva 30 34 67 25
TEMPORADA 2009/2010
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 SV Gleinstätten Gleinstätte 30 67 33 58
2 Kapfenberger SV KM II Kapfenberger 30 54 34 56
3 Irdning Irdning 30 51 37 50
4 SC Fürstenfeld Fürstenfeld 30 54 48 46
5 Kalsdorf Kalsdorf 30 51 48 45
6 SV ADA Anger Anger 30 42 44 44
7 Gleisdorf Gleisdorf 30 45 35 43
8 Gratkorn II Gratkorn II 30 49 47 43
9 Köflach Köflach 30 44 48 41
10 Fehring Fehring 30 38 44 41
11 Wildon Wildon 30 58 54 40
12 SV Pachern SV Pachern 30 49 52 38
13 Liezen Liezen 30 43 48 36
14 Grossklein Grossklein 30 32 44 36
15 SC Bruck SC Bruck 30 29 49 20
16 Grazer AK II Grazer 30 29 70 16
TEMPORADA 2008/2009
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 SVL Flavia Solva Flavia Solva 30 54 34 52
2 Kalsdorf Kalsdorf 29 56 38 52
3 SC Fürstenfeld Fürstenfeld 30 55 50 51
4 Gleisdorf Gleisdorf 30 47 40 50
5 Fehring Fehring 30 57 47 47
6 SV Gleinstätten Gleinstätte 30 64 48 46
7 SC Bruck SC Bruck 30 40 34 46
8 Köflach Köflach 30 52 49 41
9 Gratkorn II Gratkorn II 30 55 50 40
10 Wildon Wildon 30 40 47 39
11 Grazer AK II Grazer 30 53 46 37
12 Irdning Irdning 30 32 41 36
13 Kapfenberger SV KM II Kapfenberger 29 44 53 34
14 Grossklein Grossklein 30 40 52 34
15 Deutschlandsberger Deutschlands 30 40 64 32
16 Hartberg II Hartberg II 30 33 69 25

  USO DE MEMORIA  
5,366,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4031
Total Execution Time  0.4043
  CADENA URL  
/historico/Fehring
  GET DATOS  
$_GET['/historico/Fehring']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0114  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 = 'Fehring' 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.0105  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=88001 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=88001 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=88001 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0214  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 = 73015
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=88001 AND type_rel = 2
0.0114  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 = '88001' ORDER BY l.year DESC,cat.coefficient DESC
0.0107  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 = '88001' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0108  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 = '88001' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0109  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.0111  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=88001 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  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.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 73015 AND teamId = 88001
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 88001
0.0119  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 = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0109  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 = '88001' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '88001' and rp.type = 4
0.0108  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 = '88001' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0119  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 = 88001 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.0111  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 = 88001 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110  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 = 88001 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0108  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 = 88001 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110  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 = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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.0109  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 `tables2011` 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 = 27218 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2010` 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 = 27238 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 27261 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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 = 73015 ORDER BY nameShow LIMIT 100