4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Weiden Weiden 29 82 19 74
2 TSV Seebach TSV Seebach 29 68 29 62
3 FC Sturm Hauzenberg Sturm 29 63 34 60
4 TSV Kareth Lappersdorf Kareth 30 60 34 57
5 SC Ettmannsdorf Ettmannsdorf 29 66 37 53
6 Deggendorf Deggendorf 29 31 48 40
7 ASV Burglengenfeld Burglengenfe 29 44 47 39
8 SpVgg Lam SpVgg Lam 29 39 45 39
9 Wildenau Wildenau 29 50 48 38
10 TB Roding TB Roding 29 51 56 37
11 Bad Kötzting Kötzting 29 48 50 36
12 SpVgg Osterhofen SpVgg 29 40 63 31
13 Bogen Bogen 30 39 46 29
14 Landshut Landshut 29 31 47 29
15 Ruhmannsfelden Ruhmannsfeld 30 32 57 28
16 TB/ASV Regenstauf TB/ASV 29 39 65 26
17 FC Tegernheim Tegernheim 29 26 84 19
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 TSV Nördlingen Nördlingen 34 77 32 72
2 Sonthofen Sonthofen 34 72 29 70
3 TSV Gilching-Argelsried Gilching-Arg 34 57 39 60
4 SC Ichenhausen Ichenhausen 34 51 44 52
5 VfB Durach VfB Durach 34 56 42 49
6 SV Mering SV Mering 34 62 60 49
7 FV Illertissen II Illertissen 34 59 64 49
8 Kempten Kempten 34 62 55 48
9 TuS Geretsried Geretsried 34 51 65 46
10 FC Ehekirchen Ehekirchen 34 58 65 44
11 Gersthofen Gersthofen 34 51 65 44
12 SC Olching SC Olching 34 54 61 41
13 FC Memmingen II Memmingen 34 56 66 41
14 Garmisch-Partenkirchen Garmisch-Par 34 45 48 40
15 SV Egg SV Egg 34 52 66 39
16 SV Bad Heilbrunn Heilbrunn 34 52 60 36
17 VfR Neuburg/Donau Neuburg/Dona 34 45 76 34
18 SV Cosmos Aystetten Cosmos 34 37 60 29
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 TuSpo Surheide TuSpo 7 17 5 21
2 TuRa Bremen TuRa Bremen 7 21 9 15
3 1.FC Burg 1.FC Burg 7 17 14 15
4 Weyhe Weyhe 7 31 11 13
5 VfL Bremen VfL Bremen 6 14 4 12
6 FC Huchting FC Huchting 6 18 13 12
7 Woltmershausen Woltmershaus 6 21 11 11
8 Vahr-Blockdiek Vahr-Blockdi 7 23 14 11
9 Melchiorshausen Melchiorshau 7 16 17 11
10 TSV Hasenbüren Hasenbüren 7 20 14 10
11 Türkspor Bremen Türkspor 7 12 22 7
12 SV Grohn SV Grohn 7 14 22 6
13 SG Findorff SG Findorff 7 5 24 4
14 Osterholz-Tenever Osterholz-Te 6 11 17 3
15 SV Lemwerder Lemwerder 5 8 18 2
16 DJK Blumenthal Blumenthal 7 3 36 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 FC Gundelfingen Gundelfingen 20 43 9 48
2 VfR Neuburg/Donau Neuburg/Dona 22 56 30 44
3 Sonthofen Sonthofen 21 46 22 41
4 TuS Geretsried Geretsried 22 40 35 37
5 SV Mering SV Mering 21 42 34 35
6 Garmisch-Partenkirchen Garmisch-Par 22 48 35 34
7 Kempten Kempten 21 35 32 32
8 FC Ehekirchen Ehekirchen 22 34 48 30
9 Illertissen Illertissen 20 35 38 29
10 FC Memmingen II Memmingen 22 38 39 27
11 SV Egg SV Egg 19 37 34 26
12 SC Ichenhausen Ichenhausen 20 35 30 25
13 TSV Gilching-Argelsried Gilching-Arg 22 23 32 25
14 SC Olching SC Olching 20 27 36 21
15 VfB Durach VfB Durach 20 26 35 21
16 SV Bad Heilbrunn Heilbrunn 21 29 50 21
17 TSV Jetzendorf Jetzendorf 22 25 40 20
18 SpV Kaufbeuren Kaufbeuren 21 16 56 8
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Landsberg Landsberg 34 92 27 82
2 Türkspor Augsburg Türkspor 34 75 34 71
3 SC Ichenhausen Ichenhausen 34 72 50 62
4 VfR Neuburg/Donau Neuburg/Dona 34 64 51 62
5 FC Memmingen II Memmingen 34 66 56 57
6 SC Olching SC Olching 34 52 52 49
7 TuS Geretsried Geretsried 34 55 56 49
8 SV Egg SV Egg 34 61 58 46
9 FV Illertissen II Illertissen 34 73 71 45
10 Kempten Kempten 34 46 60 45
11 FC Gundelfingen Gundelfingen 34 49 51 42
12 SV Mering SV Mering 34 47 61 42
13 TSV Gilching-Argelsried Gilching-Arg 34 44 57 41
14 Wolfratshausen Wolfratshaus 34 48 51 39
15 SpV Kaufbeuren Kaufbeuren 34 47 58 39
16 SV Cosmos Aystetten Cosmos 34 41 64 38
17 Garmisch-Partenkirchen Garmisch-Par 34 50 71 32
18 SC Oberweikertshofen Oberweikerts 34 31 85 14
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 TSV Nördlingen Nördlingen 32 83 31 77
2 FV Illertissen II Illertissen 32 67 47 55
3 FC Memmingen II Memmingen 32 60 37 54
4 TSV Gilching-Argelsried Gilching-Arg 32 48 38 51
5 SV Mering SV Mering 32 52 45 49
6 SC Oberweikertshofen Oberweikerts 32 53 48 49
7 SC Ichenhausen Ichenhausen 32 53 45 48
8 SV Cosmos Aystetten Cosmos 32 48 43 48
9 FC Gundelfingen Gundelfingen 32 45 51 45
10 Türkspor Augsburg Türkspor 32 45 41 44
11 SpV Kaufbeuren Kaufbeuren 32 45 46 43
12 SV Egg SV Egg 32 49 48 42
13 SC Olching SC Olching 32 45 58 40
14 Raisting Raisting 32 35 59 31
15 FC Stätzling Stätzling 32 38 64 29
16 TSV Aindling Aindling 32 40 70 29
17 Bad Grönenbach Grönenbach 32 33 68 28
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 TSV Schwaben Augsburg Schwaben 32 58 20 68
2 Türkspor Augsburg Türkspor 32 68 43 61
3 FV Illertissen II Illertissen 32 74 44 57
4 SV Egg SV Egg 32 58 43 56
5 SC Ichenhausen Ichenhausen 32 44 31 56
6 TSV Nördlingen Nördlingen 32 57 50 49
7 SC Olching SC Olching 32 51 44 48
8 TSV Aindling Aindling 32 54 48 47
9 FC Memmingen II Memmingen 32 49 46 44
10 SV Mering SV Mering 32 51 54 42
11 SpV Kaufbeuren Kaufbeuren 32 40 45 39
12 FC Stätzling Stätzling 32 50 58 39
13 Raisting Raisting 32 44 52 38
14 TSV Gilching-Argelsried Gilching-Arg 32 48 61 38
15 SC Oberweikertshofen Oberweikerts 32 32 52 26
16 FC Ehekirchen Ehekirchen 32 35 77 20
17 Kissinger SC Kissinger 32 24 69 16
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 FC Gundelfingen Gundelfingen 32 65 29 63
2 SV Mering SV Mering 32 67 46 59
3 TSV Nördlingen Nördlingen 32 70 45 56
4 SC Oberweikertshofen Oberweikerts 32 48 40 51
5 SV Egg SV Egg 32 58 36 50
6 FC Memmingen II Memmingen 32 45 36 50
7 FV Illertissen II Illertissen 32 49 45 49
8 TSV Aindling Aindling 32 43 36 46
9 Raisting Raisting 32 50 40 45
10 SC Ichenhausen Ichenhausen 32 51 45 44
11 Türkspor Augsburg Türkspor 32 58 65 44
12 SpV Kaufbeuren Kaufbeuren 32 36 45 38
13 Kissinger SC Kissinger 32 39 55 35
14 TSV Meitingen Meitingen 32 47 69 35
15 Fürstenfeldbruck Fürstenfeld 32 44 63 33
16 TuS Feuchtwangen Feuchtwangen 32 42 66 30
17 SF Dinkelsbühl Dinkelsbühl 32 35 86 23

  USO DE MEMORIA  
5,922,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4116
Total Execution Time  0.4137
  CADENA URL  
/landesliga2024/grupo1/historico
  GET DATOS  
$_GET['/landesliga2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0125  SELECT type FROM routes WHERE alias = 'landesliga2024'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'landesliga' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2090 AND type_rel = 3
0.0128  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.0129  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.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2090 ORDER BY order_id ASC
0.0129  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2090 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 66642 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.0129  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 = 58569 AND t.round = 7 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 = 50264 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.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 `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 = 48732 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 46642 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 46812 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 46830 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 url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-29 12:22:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-29 12:22:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-29 12:22:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-29 12:22:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'landesliga' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73058 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73058 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73058 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73058 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73058 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73058 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(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 = 73058 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