4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Töging
TEMPORADA 2019/2020
LANDESLIGA GRUPO 13
Equipo PJ GF GC Puntos
1 Eintracht Karlsfeld Eintracht 23 43 26 45
2 VfB Hallbergmoos Hallbergmoos 22 43 26 39
3 Chiemgau Traunstein Chiemgau 22 37 41 39
4 Freising Freising 23 35 21 38
5 SV Erlbach SV Erlbach 21 41 28 38
6 TSV Grünwald Grünwald 23 38 34 38
7 Unterföhring Unterföhrin 23 38 32 35
8 FC Töging FC Töging 21 37 32 33
9 Kirchheimer SC Kirchheimer 23 40 36 33
10 Passau Passau 23 33 30 33
11 DJK Rosenheim Rosenheim 22 46 53 32
12 FC Sturm Hauzenberg Sturm 23 38 36 30
13 TuS Holzkirchen Holzkirchen 22 44 36 29
14 Landshut Landshut 23 29 38 26
15 TSV Kastl TSV Kastl 23 38 51 26
16 TSV Ampfing TSV Ampfing 23 28 48 22
17 ASV Dachau ASV Dachau 23 29 39 16
18 TSV Waldkirchen Waldkirchen 21 16 46 11
TEMPORADA 2018/2019
LANDESLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 TSV Wasserburg Wasserburg 34 74 29 80
2 FC Deisenhofen Deisenhofen 34 74 34 75
3 VfB Hallbergmoos Hallbergmoos 34 74 41 70
4 Freising Freising 34 69 44 65
5 ASV Dachau ASV Dachau 34 48 30 58
6 TSV Grünwald Grünwald 34 69 56 57
7 Landshut Landshut 34 73 56 53
8 FC Töging FC Töging 34 52 62 49
9 Eintracht Karlsfeld Eintracht 34 47 57 47
10 SV Erlbach SV Erlbach 34 58 52 46
11 TSV Kastl TSV Kastl 34 63 65 46
12 Bogen Bogen 34 45 50 46
13 Chiemgau Traunstein Chiemgau 34 54 58 36
14 TuS 1860 Pfarrkirchen 1860 34 45 54 36
15 DJK Rosenheim Rosenheim 34 44 57 35
16 FC Moosinning Moosinning 34 34 59 32
17 ASCK Simbach ASCK Simbach 34 33 88 22
18 TSV Neuried TSV Neuried 34 27 91 6
TEMPORADA 2017/2018
LANDESLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Türkgücü München Türkgücü 34 88 40 78
2 Freising Freising 34 81 32 73
3 FC Deisenhofen Deisenhofen 34 65 41 60
4 Landshut Landshut 34 58 43 60
5 TuS Geretsried Geretsried 34 61 63 52
6 FC Töging FC Töging 34 45 60 51
7 ASV Dachau ASV Dachau 34 66 58 46
8 VfB Hallbergmoos Hallbergmoos 34 57 59 45
9 TuS 1860 Pfarrkirchen 1860 34 40 46 45
10 SV Erlbach SV Erlbach 34 46 38 43
11 TSV Grünwald Grünwald 34 56 68 42
12 TSV Kastl TSV Kastl 34 50 55 41
13 TSV Neuried TSV Neuried 34 51 64 39
14 ESV Freilassing Freilassing 34 74 81 38
15 DJK Rosenheim Rosenheim 34 43 53 38
16 TSV Moosach TSV Moosach 34 54 83 37
17 SV Manching SV Manching 34 40 68 34
18 TV Aiglsbach Aiglsbach 34 55 78 32
TEMPORADA 2016/2017
LANDESLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 TuS Holzkirchen Holzkirchen 32 60 39 66
2 Chiemgau Traunstein Chiemgau 32 50 29 63
3 ASV Dachau ASV Dachau 32 71 41 61
4 Landshut Landshut 32 58 38 55
5 FC Deisenhofen Deisenhofen 32 49 36 52
6 Türkgücü München Türkgücü 32 59 41 49
7 TSV Kastl TSV Kastl 32 44 36 47
8 TuS Geretsried Geretsried 32 56 53 46
9 VfB Hallbergmoos Hallbergmoos 32 51 44 45
10 Freising Freising 32 39 38 43
11 SV Erlbach SV Erlbach 32 48 45 38
12 FC Töging FC Töging 32 40 56 38
13 Eintracht Karlsfeld Eintracht 32 34 44 35
14 ESV Freilassing Freilassing 32 49 67 35
15 DJK Rosenheim Rosenheim 32 31 54 28
16 TSV Eching TSV Eching 32 36 79 25
17 TSV Vilsbiburg Vilsbiburg 32 27 62 19
TEMPORADA 2015/2016
LANDESLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Ismaning Ismaning 34 77 31 78
2 FC Deisenhofen Deisenhofen 34 62 26 74
3 VfB Hallbergmoos Hallbergmoos 34 63 36 66
4 Freising Freising 34 51 37 54
5 ASV Dachau ASV Dachau 34 64 46 50
6 DJK Rosenheim Rosenheim 34 51 45 50
7 TuS Holzkirchen Holzkirchen 34 56 43 48
8 Chiemgau Traunstein Chiemgau 34 42 47 47
9 TuS Geretsried Geretsried 34 55 58 44
10 Landshut Landshut 34 47 50 42
11 FC Töging FC Töging 34 43 52 42
12 Türkgücü München Türkgücü 34 33 48 42
13 TSV Eching TSV Eching 34 46 66 42
14 SV Manching SV Manching 34 45 63 40
15 FC Gerolfing Gerolfing 34 40 48 39
16 Kirchheimer SC Kirchheimer 34 54 61 37
17 SV Planegg-Krailling Planegg-Krai 34 30 59 26
18 TSV Velden TSV Velden 34 40 83 26

  USO DE MEMORIA  
5,287,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6833
Total Execution Time  0.6845
  CADENA URL  
/historico/Fc-Toging
  GET DATOS  
$_GET['/historico/Fc-Toging']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0153  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 = 'Fc-Toging' 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.0165  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 = 'Fc-Toging' 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=89979 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=89979 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=89979 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=89979 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=89979 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=89979 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=89979 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=89979 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=89979 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=89979 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 51142
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89979 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2090 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2090 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (184451,1011237,984949) ORDER BY n.cover_points DESC, update_date DESC
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 = '89979' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '89979' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '89979' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = '89979' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0145  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 = 51142 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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=89979 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (56547,51142) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 51142 AND teamId = 89979
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 89979
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 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 = 51142 AND t.round = 23 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '89979' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '89979' and rp.type = 4
0.0146  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 = '89979' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 events2020 e ON e.player_id = p.id AND e.league_id = 51142 WHERE rp.league_id = 51142 AND rp.teamId = 89979 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.0146  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 events2020 e ON e.player_id = p.id AND e.league_id = 51142 WHERE rp.league_id = 51142 AND rp.teamId = 89979 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 events2020 e ON e.player_id = p.id AND e.league_id = 51142 WHERE rp.league_id = 51142 AND rp.teamId = 89979 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 89979 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 = 51142 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 48733 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 46643 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 46813 AND t.round = 34 ORDER BY team.conference 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 `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 = 46831 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC