4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Astoria Walldorf II
TEMPORADA 2023/2024
LANDESLIGA GRUPO 30
Equipo PJ GF GC Puntos
1 Weinheim Weinheim 22 50 21 50
2 Zuzenhausen Zuzenhausen 22 51 29 48
3 1.FC Mühlhausen 1.FC 22 66 31 45
4 Astoria Walldorf II Astoria 22 58 31 45
5 Spielberg Spielberg 22 47 32 42
6 Fortuna Heddesheim Fortuna 22 48 32 39
7 VfB Eppingen Eppingen 22 45 37 34
8 Waldhof Mannheim II Waldhof 22 37 38 31
9 Bruchsal Bruchsal 22 33 40 27
10 ASC Neuenheim Neuenheim 22 40 45 26
11 FC Bammental Bammental 22 31 46 26
12 VfB Bretten VfB Bretten 22 27 52 21
13 FV Mosbach FV Mosbach 22 33 55 20
14 VFR Gommersdorf Gommersdorf 22 24 47 19
15 Germania Friedrichstal Germania 22 23 57 15
16 Reichenbach Reichenbach 22 26 46 11
TEMPORADA 2021/2022
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Freiberg Freiberg 38 116 30 91
2 Stuttgarter Kickers Stuttgarter 38 91 25 91
3 TSG Backnang Backnang 38 89 59 68
4 Villingen Villingen 38 75 47 64
5 CfR Pforzheim Pforzheim 38 68 52 60
6 Göppinger SV Göppinger 38 64 58 60
7 Nottingen Nottingen 38 77 77 57
8 Ravensburg Ravensburg 38 77 70 55
9 Reutlingen Reutlingen 38 60 59 55
10 Bissingen Bissingen 38 73 63 52
11 1.FC Rielasingen-Arlen 1.FC 38 58 62 52
12 Neckarsulmer SU Neckarsulmer 38 51 61 51
13 Oberachern Oberachern 38 65 76 51
14 Freiburger FC Freiburger 38 61 61 47
15 Sportfreunde Dorfmerkingen Sportfreunde 38 53 77 46
16 Astoria Walldorf II Astoria 38 58 81 45
17 Linx Linx 38 57 81 41
18 Bruchsal Bruchsal 38 57 94 37
19 TSV Ilshofen Ilshofen 38 57 96 36
20 FV Lörrach-Brombach Lörrach-Bro 38 28 106 11
TEMPORADA 2020/2021
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Freiberg Freiberg 13 42 6 35
2 Stuttgarter Kickers Stuttgarter 13 41 12 30
3 Göppinger SV Göppinger 13 26 14 26
4 Bissingen Bissingen 13 26 21 25
5 Nottingen Nottingen 11 25 16 23
6 1.FC Rielasingen-Arlen 1.FC 12 18 12 22
7 Neckarsulmer SU Neckarsulmer 13 18 14 22
8 Ravensburg Ravensburg 12 22 14 18
9 Sportfreunde Dorfmerkingen Sportfreunde 12 15 11 17
10 Villingen Villingen 12 10 9 17
11 CfR Pforzheim Pforzheim 12 21 17 15
12 TSG Backnang Backnang 12 19 21 15
13 Reutlingen Reutlingen 12 18 29 14
14 Bruchsal Bruchsal 11 16 23 12
15 TSV Ilshofen Ilshofen 12 15 28 11
16 Linx Linx 12 17 33 11
17 Oberachern Oberachern 11 10 21 10
18 FV Lörrach-Brombach Lörrach-Bro 13 16 30 8
19 Astoria Walldorf II Astoria 13 18 34 8
20 Freiburger FC Freiburger 12 12 28 8
21 Sandhausen II Sandhausen 12 18 30 7
TEMPORADA 2017/2018
OBERLIGA GRUPO 13
Equipo PJ GF GC Puntos
1 TSG Balingen Balingen 34 79 31 78
2 Villingen Villingen 34 73 31 71
3 Freiberg Freiberg 34 72 50 63
4 Bissingen Bissingen 34 74 44 62
5 Nottingen Nottingen 34 61 51 58
6 Ravensburg Ravensburg 34 65 49 56
7 Reutlingen Reutlingen 34 60 48 55
8 Göppinger SV Göppinger 34 71 57 51
9 Bahlinger SC Bahlinger 34 62 62 51
10 Neckarsulmer SU Neckarsulmer 34 51 39 45
11 Oberachern Oberachern 34 53 55 44
12 TSG Backnang Backnang 34 53 65 43
13 CfR Pforzheim Pforzheim 34 38 54 40
14 Spielberg Spielberg 34 43 70 34
15 Karlsruher SC II Karlsruher 34 43 63 33
16 Sandhausen II Sandhausen 34 45 70 31
17 Astoria Walldorf II Astoria 34 34 71 26
18 Weinheim Weinheim 34 24 91 13
TEMPORADA 2016/2017
OBERLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 Freiburg II Freiburg II 34 78 20 79
2 Bissingen Bissingen 34 86 32 77
3 Neckarsulmer SU Neckarsulmer 34 61 45 61
4 TSG Balingen Balingen 34 72 43 58
5 Bahlinger SC Bahlinger 34 55 46 54
6 Ravensburg Ravensburg 34 64 49 51
7 Göppinger SV Göppinger 34 43 35 50
8 CfR Pforzheim Pforzheim 34 54 50 49
9 Reutlingen Reutlingen 34 64 56 47
10 Spielberg Spielberg 34 64 63 46
11 Sandhausen II Sandhausen 34 48 55 46
12 Karlsruher SC II Karlsruher 34 59 50 45
13 Oberachern Oberachern 34 49 61 42
14 Stuttgarter Kickers II Stuttgarter 34 48 59 38
15 Astoria Walldorf II Astoria 34 33 59 36
16 Hollenbach Hollenbach 34 45 69 35
17 Offenburger FV Offenburger 34 45 68 31
18 SpVgg Neckarelz SpVgg 34 23 131 8

  USO DE MEMORIA  
5,376,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0992
Total Execution Time  0.1005
  CADENA URL  
/historico/Fc-Astoria-Walldorf-Ii
  GET DATOS  
$_GET['/historico/Fc-Astoria-Walldorf-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0029  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-Astoria-Walldorf-Ii' 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.0020  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=90535 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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=90535 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=90535 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 73074
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90535 AND type_rel = 2
0.0026  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 = '90535' ORDER BY l.year DESC,cat.coefficient DESC
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 = '90535' 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 = '90535' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73074 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=90535 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (73074,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 = 73074 AND teamId = 90535
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 90535
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 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 = 73074 AND t.round = 26 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 = '90535' 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 = '90535' and rp.type = 4
0.0021  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 = '90535' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 73074 WHERE rp.league_id = 73074 AND rp.teamId = 90535 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.0020  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 = 73074 WHERE rp.league_id = 73074 AND rp.teamId = 90535 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 73074 WHERE rp.league_id = 73074 AND rp.teamId = 90535 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 = 90535 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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 = 73074 AND t.round = 26 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 `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 = 63240 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.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 `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 = 57318 AND t.round = 13 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 `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 = 39163 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 34101 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 73074 ORDER BY nameShow LIMIT 100