4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del TSV Buch
TEMPORADA 2023/2024
LANDESLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Eintracht Münchberg Eintracht 31 70 36 65
2 FSV Stadeln FSV Stadeln 31 60 28 63
3 TSV Buch TSV Buch 31 57 30 63
4 SC 04 Schwabach Schwabach 31 53 43 51
5 SV Buckenhofen Buckenhofen 30 54 43 50
6 SC Großschwarzenlohe Großschwarz 30 59 34 47
7 ASV Weisendorf Weisendorf 31 43 49 47
8 Jahn Forchheim Jahn 31 48 50 44
9 TSV 1860 Weissenburg 1860 31 41 42 41
10 SV Unterreichenbach Unterreichen 31 46 50 39
11 SV Mitterteich Mitterteich 30 37 49 38
12 Quelle Furth Quelle Furth 31 48 64 38
13 Baiersdorfer SV Baiersdorfer 31 52 49 36
14 Erlangen-Bruck Erlangen-Bru 30 43 56 34
15 Bayreuth II SpVgg Bayreuth 31 43 66 33
16 FC Herzogenaurach Herzogenaura 31 42 58 31
17 FC Vorwärts Röslau Vorwärts 31 48 67 31
18 VfR Katschenreuth Katschenreut 31 43 73 27
TEMPORADA 2021/2022
LANDESLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 FC Herzogenaurach Herzogenaura 18 36 19 35
2 Jahn Forchheim Jahn 18 37 17 34
3 Neudrossenfeld Neudrossenfe 18 39 21 34
4 FSV Stadeln FSV Stadeln 18 27 25 29
5 FC Vorwärts Röslau Vorwärts 18 26 25 29
6 Kickers Selb Kickers Selb 18 32 36 23
7 FC Eintracht Münchberg Eintracht 18 22 27 22
8 Erlangen-Bruck Erlangen-Bru 18 29 39 21
9 ASV Vach ASV Vach 18 18 38 17
10 SV Mitterteich Mitterteich 18 20 39 10
11 TSV Kornburg Kornburg 16 52 10 46
12 SC 04 Schwabach Schwabach 16 41 21 31
13 TSV Buch TSV Buch 16 24 30 25
14 TSV 1860 Weissenburg 1860 16 26 28 20
15 Quelle Furth Quelle Furth 16 27 25 19
16 Türkspor Nürnberg Türkspor 16 29 36 19
17 SC Großschwarzenlohe Großschwarz 16 19 35 18
18 SV Schwaig SV Schwaig 16 17 31 14
19 Woffenbach Woffenbach 16 16 35 13
TEMPORADA 2019/2020
LANDESLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Feucht SC Feucht SC 22 61 14 53
2 TSV Buch TSV Buch 21 50 23 43
3 SC 04 Schwabach Schwabach 22 42 22 42
4 Neudrossenfeld Neudrossenfe 23 48 36 39
5 Kickers Selb Kickers Selb 22 56 32 38
6 FSV Stadeln FSV Stadeln 21 40 24 38
7 Jahn Forchheim Jahn 23 32 25 36
8 Erlangen-Bruck Erlangen-Bru 23 43 30 34
9 ASV Vach ASV Vach 22 36 33 30
10 Quelle Furth Quelle Furth 21 33 39 28
11 SV Mitterteich Mitterteich 20 33 36 27
12 SV Schwaig SV Schwaig 21 26 34 26
13 FC Vorwärts Röslau Vorwärts 21 33 52 25
14 TSV Kornburg Kornburg 21 31 44 24
15 FC Herzogenaurach Herzogenaura 23 39 53 24
16 SC Großschwarzenlohe Großschwarz 21 23 42 21
17 TuS Feuchtwangen Feuchtwangen 21 28 59 16
18 Baiersdorfer SV Baiersdorfer 22 20 76 4
TEMPORADA 2018/2019
LANDESLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Eintracht Bamberg Eintracht 34 100 36 81
2 Feucht SC Feucht SC 34 90 31 80
3 Neudrossenfeld Neudrossenfe 34 82 32 76
4 SC 04 Schwabach Schwabach 34 91 46 71
5 FC Herzogenaurach Herzogenaura 34 57 46 51
6 Memmelsdorf Memmelsdorf 37 71 63 51
7 SV Mitterteich Mitterteich 34 41 45 51
8 Quelle Furth Quelle Furth 34 63 53 49
9 TSV Buch TSV Buch 36 58 53 45
10 FC Lichtenfels Lichtenfels 34 47 55 45
11 FC Vorwärts Röslau Vorwärts 34 52 52 42
12 SV Friesen SV Friesen 34 62 67 42
13 TSV Kornburg Kornburg 34 52 62 42
14 SC Großschwarzenlohe Großschwarz 34 45 70 37
15 FC Coburg FC Coburg 34 50 53 36
16 Baiersdorfer SV Baiersdorfer 35 35 60 33
17 SpVgg Selbitz SpVgg 34 40 79 24
18 TSV Sonnefeld Sonnefeld 34 17 150 6
TEMPORADA 2017/2018
LANDESLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 ATSV Erlangen ATSV 34 97 26 78
2 TSV Buch TSV Buch 34 77 33 75
3 Feucht SC Feucht SC 34 82 34 73
4 Neudrossenfeld Neudrossenfe 34 71 41 63
5 Quelle Furth Quelle Furth 34 66 54 54
6 Memmelsdorf Memmelsdorf 34 72 56 52
7 SC 04 Schwabach Schwabach 34 75 63 49
8 SpVgg Selbitz SpVgg 34 59 56 46
9 SV Mitterteich Mitterteich 34 43 50 46
10 FC Lichtenfels Lichtenfels 34 54 56 43
11 SV Friesen SV Friesen 34 48 66 41
12 Baiersdorfer SV Baiersdorfer 34 60 69 39
13 TSV Sonnefeld Sonnefeld 34 44 64 39
14 VfL Frohnlach Frohnlach 34 52 81 34
15 ASV Veitsbronn Veitsbronn 34 46 79 34
16 FSV Bayreuth Bayreuth 34 46 86 34
17 Bayreuth II SpVgg Bayreuth 34 34 77 33
18 SpVgg Erlangen SpVgg 34 36 71 27
TEMPORADA 2016/2017
LANDESLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 TSV Kornburg Kornburg 34 82 36 75
2 Erlangen-Bruck Erlangen-Bru 34 75 44 72
3 Quelle Furth Quelle Furth 34 79 49 69
4 TSV Buch TSV Buch 34 71 38 68
5 ATSV Erlangen ATSV 34 70 43 58
6 ASV Vach ASV Vach 34 55 37 56
7 Baiersdorfer SV Baiersdorfer 34 62 55 56
8 Neudrossenfeld Neudrossenfe 34 61 50 54
9 SC 04 Schwabach Schwabach 34 58 53 44
10 SpVgg Selbitz SpVgg 34 48 53 44
11 ASV Veitsbronn Veitsbronn 34 52 61 43
12 FSV Bayreuth Bayreuth 34 57 70 38
13 FC Vorwärts Röslau Vorwärts 34 44 55 36
14 SV Mitterteich Mitterteich 34 43 56 36
15 Bayreuth II SpVgg Bayreuth 34 51 74 34
16 ASV Pegnitz ASV Pegnitz 34 50 74 33
17 Türkspor Augsburg Türkspor 34 57 100 28
18 SSV Kasendorf Kasendorf 34 34 101 12
TEMPORADA 2015/2016
LANDESLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 ASV Neumarkt Neumarkt 34 85 30 81
2 TSV Kornburg Kornburg 34 89 37 72
3 Quelle Furth Quelle Furth 34 61 35 59
4 ASV Vach ASV Vach 34 46 40 54
5 Neudrossenfeld Neudrossenfe 34 58 39 52
6 TSV Buch TSV Buch 34 58 48 51
7 Türkspor Augsburg Türkspor 34 52 56 51
8 SpVgg Selbitz SpVgg 34 57 55 49
9 ASV Pegnitz ASV Pegnitz 34 52 56 46
10 Erlangen-Bruck Erlangen-Bru 34 42 53 43
11 FC Vorwärts Röslau Vorwärts 34 42 47 41
12 ASV Veitsbronn Veitsbronn 34 53 62 39
13 SSV Kasendorf Kasendorf 34 48 67 39
14 FSV Stadeln FSV Stadeln 34 50 69 37
15 SV Poppenreuth Poppenreuth 34 49 74 36
16 Baiersdorfer SV Baiersdorfer 34 42 69 33
17 SV Seligenporten II Seligenporte 34 45 68 31
18 SV Friesen SV Friesen 34 41 65 31

  USO DE MEMORIA  
5,615,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2816
Total Execution Time  0.2829
  CADENA URL  
/historico/Tsv-Buch
  GET DATOS  
$_GET['/historico/Tsv-Buch']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=115532 AND type_rel = 2
0.0129  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 = '115532' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=115532 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (73059) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73059 AND teamId = 115532
0.0135  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 = 115532 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0263  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 = 73059 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 66648 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.0130  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 = 51136 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.0131  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 = 48736 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 46646 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 46816 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 46834 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC