4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kirchanschöring
TEMPORADA 2023/2024
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 TSV Schwaben Augsburg Schwaben 31 71 32 61
2 Landsberg Landsberg 31 78 47 60
3 SV Erlbach SV Erlbach 31 44 25 60
4 Heimstetten Heimstetten 31 54 34 59
5 FC Deisenhofen Deisenhofen 31 60 31 56
6 TSV Nördlingen Nördlingen 31 59 42 55
7 1860 München II 1860 31 56 45 49
8 Kottern Kottern 31 57 48 46
9 Kirchanschöring Kirchanschö 31 36 43 43
10 FC Pipinsried Pipinsried 30 36 33 40
11 Sonthofen Sonthofen 30 45 44 40
12 Rain / Lech Rain / Lech 30 37 49 38
13 Dachau Dachau 31 50 63 37
14 Ismaning Ismaning 31 39 62 36
15 FC Gundelfingen Gundelfingen 31 35 51 32
16 Türkspor Augsburg Türkspor 30 27 41 29
17 VfR Garching Garching 30 29 74 18
18 Kirchheimer SC Kirchheimer 30 37 86 13
TEMPORADA 2022/2023
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Schalding-Heining Schalding-He 34 73 36 73
2 Memmingen Memmingen 34 51 36 63
3 Landsberg Landsberg 34 70 45 60
4 Ingolstadt 04 II Ingolstadt 34 64 39 60
5 Kottern Kottern 34 57 44 60
6 Kirchanschöring Kirchanschö 34 56 45 58
7 TSV Schwaben Augsburg Schwaben 34 63 52 54
8 1860 München II 1860 34 56 40 53
9 FC Gundelfingen Gundelfingen 34 50 47 50
10 Ismaning Ismaning 34 47 52 50
11 TSV Nördlingen Nördlingen 34 66 64 46
12 FC Deisenhofen Deisenhofen 34 56 47 44
13 SV Erlbach SV Erlbach 34 42 36 42
14 Dachau Dachau 34 45 61 40
15 VfR Garching Garching 34 35 56 34
16 Türkspor Augsburg Türkspor 34 38 79 23
17 Rosenheim Rosenheim 34 37 83 21
18 VfB Hallbergmoos Hallbergmoos 34 35 79 15
TEMPORADA 2021/2022
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Hankofen-Hailing Hankofen-Hai 36 63 36 72
2 SV Donaustauf Donaustauf 36 80 56 66
3 Ingolstadt 04 II Ingolstadt 36 70 40 65
4 Jahn Regensburg II Jahn 36 66 44 64
5 Kirchanschöring Kirchanschö 36 51 42 62
6 1860 München II 1860 36 55 42 51
7 TSV Schwaben Augsburg Schwaben 36 47 42 51
8 Ismaning Ismaning 36 45 41 51
9 Landsberg Landsberg 36 55 41 50
10 FC Deisenhofen Deisenhofen 36 63 50 49
11 VfR Garching Garching 36 46 55 45
12 FC Gundelfingen Gundelfingen 36 41 47 44
13 Kottern Kottern 36 47 52 44
14 Türkspor Augsburg Türkspor 36 47 55 42
15 VfB Hallbergmoos Hallbergmoos 36 43 66 39
16 Pullach Pullach 36 49 65 38
17 Dachau Dachau 36 42 66 38
18 TSV Wasserburg Wasserburg 36 39 58 35
19 Schwabmünchen Schwabmünch 36 27 78 18
TEMPORADA 2019/2020
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Pipinsried Pipinsried 23 81 20 63
2 TSV Wasserburg Wasserburg 23 40 29 42
3 FC Deisenhofen Deisenhofen 22 51 37 41
4 Ingolstadt 04 II Ingolstadt 23 58 42 39
5 Schwabmünchen Schwabmünch 23 49 36 39
6 Kottern Kottern 22 39 31 38
7 1860 München II 1860 23 40 38 33
8 Kirchanschöring Kirchanschö 23 31 36 31
9 Ismaning Ismaning 23 41 35 30
10 Dachau Dachau 23 30 45 27
11 SV Donaustauf Donaustauf 21 30 39 26
12 Türkspor Augsburg Türkspor 22 37 40 25
13 Landsberg Landsberg 23 35 42 25
14 Hankofen-Hailing Hankofen-Hai 22 27 34 24
15 Jahn Regensburg II Jahn 23 42 55 24
16 Pullach Pullach 23 33 57 23
17 TSV Schwaben Augsburg Schwaben 23 26 48 20
18 TSV Nördlingen Nördlingen 23 25 51 14
TEMPORADA 2018/2019
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Türkgücü München Türkgücü 32 59 30 68
2 Rain / Lech Rain / Lech 32 60 42 58
3 Jahn Regensburg II Jahn 32 69 48 53
4 Pullach Pullach 32 52 48 53
5 Vilzing Vilzing 32 47 36 51
6 Dachau Dachau 32 47 45 49
7 Kottern Kottern 32 46 47 46
8 1860 München II 1860 32 58 48 45
9 Schwabmünchen Schwabmünch 32 57 52 45
10 TSV Nördlingen Nördlingen 32 53 55 45
11 Kirchanschöring Kirchanschö 32 51 47 44
12 TSV Schwaben Augsburg Schwaben 32 41 44 43
13 Hankofen-Hailing Hankofen-Hai 32 47 50 39
14 Sonthofen Sonthofen 32 54 64 38
15 Ismaning Ismaning 32 45 51 37
16 Unterföhring Unterföhrin 32 41 59 28
17 TuS Holzkirchen Holzkirchen 32 30 91 9
TEMPORADA 2017/2018
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Heimstetten Heimstetten 36 93 51 72
2 Pullach Pullach 36 75 48 65
3 Rain / Lech Rain / Lech 36 70 44 62
4 Kottern Kottern 36 59 48 60
5 TSV Schwaben Augsburg Schwaben 36 64 50 54
6 Schwabmünchen Schwabmünch 36 52 52 53
7 Vilzing Vilzing 36 65 54 52
8 ASV Neumarkt Neumarkt 36 51 48 50
9 Dachau Dachau 36 64 52 49
10 Sonthofen Sonthofen 36 59 50 49
11 Ismaning Ismaning 36 70 70 47
12 TuS Holzkirchen Holzkirchen 36 57 69 47
13 Hankofen-Hailing Hankofen-Hai 36 53 66 46
14 1860 München II 1860 36 47 47 43
15 Chiemgau Traunstein Chiemgau 36 49 63 41
16 Kirchanschöring Kirchanschö 36 44 51 40
17 Landsberg Landsberg 36 52 72 39
18 Wolfratshausen Wolfratshaus 36 57 85 39
19 TSV Kornburg Kornburg 36 36 97 28
TEMPORADA 2016/2017
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Pullach Pullach 34 73 32 73
2 Unterföhring Unterföhrin 34 62 42 69
3 FC Pipinsried Pipinsried 34 55 38 63
4 Schwabmünchen Schwabmünch 34 54 43 60
5 Dachau Dachau 34 56 49 60
6 Heimstetten Heimstetten 34 68 52 52
7 Vilzing Vilzing 34 47 48 52
8 Kirchanschöring Kirchanschö 34 40 39 48
9 Sonthofen Sonthofen 34 55 44 47
10 Rain / Lech Rain / Lech 34 64 58 46
11 Ismaning Ismaning 34 52 52 42
12 Kottern Kottern 34 64 72 39
13 Hankofen-Hailing Hankofen-Hai 34 36 57 35
14 Landsberg Landsberg 34 46 65 34
15 Wolfratshausen Wolfratshaus 34 44 66 34
16 Jahn Regensburg II Jahn 34 53 56 33
17 Bogen Bogen 34 34 62 31
18 FC Gundelfingen Gundelfingen 34 39 67 27
TEMPORADA 2015/2016
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 VfR Garching Garching 34 67 29 68
2 Pullach Pullach 34 63 37 65
3 Rosenheim Rosenheim 34 66 39 64
4 Sonthofen Sonthofen 34 62 33 60
5 Unterföhring Unterföhrin 34 55 43 59
6 Heimstetten Heimstetten 34 63 47 58
7 Kirchanschöring Kirchanschö 34 48 45 51
8 Dachau Dachau 34 55 48 45
9 Hankofen-Hailing Hankofen-Hai 34 48 55 44
10 FC Pipinsried Pipinsried 34 50 56 43
11 Kottern Kottern 34 59 58 42
12 Vilzing Vilzing 34 40 47 42
13 Wolfratshausen Wolfratshaus 34 47 64 42
14 Schwabmünchen Schwabmünch 34 43 64 42
15 Landsberg Landsberg 34 51 54 41
16 Bogen Bogen 34 55 66 36
17 SV Erlbach SV Erlbach 34 36 53 33
18 Ruhmannsfelden Ruhmannsfeld 34 22 92 8

  USO DE MEMORIA  
5,906,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1485
Total Execution Time  0.1506
  CADENA URL  
/historico/Kirchanschoring
  GET DATOS  
$_GET['/historico/Kirchanschoring']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64968 AND type_rel = 2
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 = '64968' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0072  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=64968 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (72394,67320) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72394 AND teamId = 64968
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 64968
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 = '64968' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '64968' 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 = '64968' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0030  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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 64968 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.0038  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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 64968 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 64968 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 = 64968 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0066  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 = 68055 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 63158 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 50138 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.0028  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 = 44076 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 38870 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 33324 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 15534 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC