4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sulingen
TEMPORADA 2023/2024
LANDESLIGA GRUPO 13
Equipo PJ GF GC Puntos
1 1.FC Sarstedt 1.FC 0 0 0 0
2 Bavenstedt Bavenstedt 0 0 0 0
3 Bückeburg Bückeburg 0 0 0 0
4 FC Eldagsen FC Eldagsen 0 0 0 0
5 FC Lehrte FC Lehrte 0 0 0 0
6 Halvestorf-Herkendorf Halvestorf-H 0 0 0 0
7 Hannoverscher Hannoversche 0 0 0 0
8 HSC/BW Tündern HSC/BW 0 0 0 0
9 Niedersachsen Döhren Niedersachse 0 0 0 0
10 OSV Hannover Hannover 0 0 0 0
11 SC Hemmingen/Westerfeld Hemmingen/We 0 0 0 0
12 Sulingen Sulingen 0 0 0 0
13 TSV Krähenwinkel/Kaltenweid Krähenwinke 0 0 0 0
14 TSV Pattensen Pattensen 0 0 0 0
15 TSV Wetschen Wetschen 0 0 0 0
16 TuS Garbsen TuS Garbsen 0 0 0 0
17 VfR Evesen VfR Evesen 0 0 0 0
18 Wunstorf Wunstorf 0 0 0 0
TEMPORADA 2022/2023
LANDESLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 STK Eilvese STK Eilvese 32 89 45 74
2 TSV Krähenwinkel/Kaltenweid Krähenwinke 32 58 25 71
3 VfR Evesen VfR Evesen 32 94 55 62
4 OSV Hannover Hannover 32 75 48 59
5 TSV Wetschen Wetschen 32 68 47 58
6 Wunstorf Wunstorf 32 63 47 55
7 Bavenstedt Bavenstedt 32 54 39 46
8 HSC/BW Tündern HSC/BW 32 69 60 44
9 1.FC Sarstedt 1.FC 32 56 66 39
10 TuS Garbsen TuS Garbsen 32 47 56 38
11 Niedersachsen Döhren Niedersachse 32 53 62 36
12 Sulingen Sulingen 32 58 68 36
13 FC Eldagsen FC Eldagsen 32 53 61 35
14 TSV Godshorn Godshorn 32 42 72 34
15 SV Alfeld SV Alfeld 32 48 89 29
16 TSV Stelingen Stelingen 32 56 94 27
17 SV BE Steimbke Steimbke 32 42 91 23
TEMPORADA 2020/2021
LANDESLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 VfR Evesen VfR Evesen 8 25 12 17
2 SC Hemmingen/Westerfeld Hemmingen/We 8 13 9 14
3 TSV Pattensen Pattensen 8 13 10 14
4 FC Eldagsen FC Eldagsen 8 14 15 13
5 Bückeburg Bückeburg 8 13 12 11
6 Bavenstedt Bavenstedt 7 11 10 11
7 Wunstorf Wunstorf 7 12 10 9
8 SpVgg Bad Pyrmont SpVgg 8 8 13 8
9 TSV Barsinghausen Barsinghause 8 9 20 7
10 1.FC Sarstedt 1.FC 8 8 15 4
11 STK Eilvese STK Eilvese 7 15 10 13
12 TSV Stelingen Stelingen 6 9 7 13
13 TSV Krähenwinkel/Kaltenweid Krähenwinke 6 12 7 12
14 OSV Hannover Hannover 5 8 5 10
15 Sulingen Sulingen 6 7 5 9
16 TSV Godshorn Godshorn 5 5 6 5
17 Heeßeler SV Heeßeler 6 7 15 4
18 TSV Burgdorf Burgdorf 4 4 7 2
19 TSV Wetschen Wetschen 5 1 6 1
TEMPORADA 2019/2020
LANDESLIGA GRUPO 11
Equipo PJ GF GC Puntos
1 Ramlingen / Ehlershausen Ramlingen 18 39 9 43
2 TSV Krähenwinkel/Kaltenweid Krähenwinke 18 36 21 31
3 Bavenstedt Bavenstedt 17 32 25 30
4 STK Eilvese STK Eilvese 17 28 24 28
5 OSV Hannover Hannover 17 35 39 28
6 Sulingen Sulingen 19 36 35 27
7 TSV Barsinghausen Barsinghause 18 37 31 26
8 SC Hemmingen/Westerfeld Hemmingen/We 18 31 32 24
9 Bückeburg Bückeburg 16 40 40 22
10 FC Eldagsen FC Eldagsen 16 28 30 22
11 Wunstorf Wunstorf 14 31 24 20
12 TSV Pattensen Pattensen 16 35 36 20
13 TSV Burgdorf Burgdorf 17 31 30 17
14 TSV Godshorn Godshorn 17 24 35 17
15 SpVgg Bad Pyrmont SpVgg 14 26 35 14
16 Heeßeler SV Heeßeler 14 14 57 3
TEMPORADA 2018/2019
LANDESLIGA GRUPO 16
Equipo PJ GF GC Puntos
1 HSC/BW Tündern HSC/BW 30 73 30 64
2 SC Hemmingen/Westerfeld Hemmingen/We 30 67 31 63
3 Ramlingen / Ehlershausen Ramlingen 30 71 37 56
4 Bavenstedt Bavenstedt 30 59 38 56
5 Sulingen Sulingen 30 53 31 53
6 Burgdorf Burgdorf 30 51 41 52
7 Heeßeler SV Heeßeler 30 67 53 51
8 TSV Pattensen Pattensen 30 56 44 45
9 Bückeburg Bückeburg 30 47 54 41
10 SpVgg Bad Pyrmont SpVgg 30 41 52 39
11 TSV Krähenwinkel/Kaltenweid Krähenwinke 30 51 61 32
12 OSV Hannover Hannover 30 46 67 31
13 SV Iraklis Hellas Hannover Iraklis 30 37 66 29
14 MTV Almstedt Almstedt 30 47 74 26
15 TV Stuhr TV Stuhr 30 34 80 18
16 SV BE Steimbke Steimbke 30 40 81 16
TEMPORADA 2017/2018
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Lupo-Martini Lupo-Martini 30 58 27 58
2 VfL Oldenburg Oldenburg 30 53 29 58
3 Spelle-Venhaus Spelle-Venha 30 64 51 57
4 Wunstorf Wunstorf 30 54 36 56
5 TuS Bersenbrück Bersenbrück 30 58 40 49
6 Eintracht Northeim Eintracht 30 63 54 47
7 Arminia Hannover Arminia 30 55 44 46
8 Heeslinger SC Heeslinger 30 44 41 41
9 Atlas Delmenhorst Atlas 30 58 46 37
10 TB Uphusen TB Uphusen 30 32 42 37
11 Cloppenburg Cloppenburg 30 40 56 37
12 MTV Gifhorn MTV Gifhorn 30 41 54 34
13 Vorsfelde Vorsfelde 30 39 51 29
14 Sulingen Sulingen 30 32 56 29
15 TuS Celle TuS Celle 30 42 67 28
16 SVG Göttingen Göttingen 30 44 83 24
TEMPORADA 2016/2017
LANDESLIGA GRUPO 16
Equipo PJ GF GC Puntos
1 Sulingen Sulingen 30 67 26 63
2 Bavenstedt Bavenstedt 30 45 16 61
3 OSV Hannover Hannover 30 53 36 54
4 Ramlingen / Ehlershausen Ramlingen 30 59 45 53
5 Bückeburg Bückeburg 30 63 51 48
6 Burgdorf Burgdorf 30 45 32 46
7 TSV Pattensen Pattensen 30 49 42 44
8 Heeßeler SV Heeßeler 30 55 54 41
9 SpVgg Bad Pyrmont SpVgg 30 36 34 40
10 SV BE Steimbke Steimbke 30 45 47 38
11 FC Eldagsen FC Eldagsen 30 40 56 38
12 TSV Krähenwinkel/Kaltenweid Krähenwinke 30 46 50 36
13 MTV Almstedt Almstedt 30 39 60 34
14 FC Lehrte FC Lehrte 30 39 54 31
15 Koldinger SV Koldinger 30 28 53 23
16 TSV Wetschen Wetschen 30 32 85 12
TEMPORADA 2015/2016
LANDESLIGA GRUPO 16
Equipo PJ GF GC Puntos
1 Hannoverscher Hannoversche 30 90 31 70
2 Bavenstedt Bavenstedt 30 78 33 63
3 Sulingen Sulingen 30 57 25 63
4 Ramlingen / Ehlershausen Ramlingen 30 78 37 61
5 Heeßeler SV Heeßeler 30 78 45 60
6 SG Hameln 74 Hameln 30 65 56 48
7 Burgdorf Burgdorf 30 44 40 48
8 TSV Pattensen Pattensen 30 46 43 40
9 FC Eldagsen FC Eldagsen 30 53 66 40
10 OSV Hannover Hannover 30 49 68 34
11 TSV Krähenwinkel/Kaltenweid Krähenwinke 30 33 59 31
12 TSV Wetschen Wetschen 30 43 74 27
13 MTV Almstedt Almstedt 30 47 78 26
14 STK Eilvese STK Eilvese 30 52 79 24
15 TuS Garbsen TuS Garbsen 30 38 72 22
16 TSV Barsinghausen Barsinghause 30 32 77 17

  USO DE MEMORIA  
5,650,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1085
Total Execution Time  0.1098
  CADENA URL  
/historico/Tus-Sulingen
  GET DATOS  
$_GET['/historico/Tus-Sulingen']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0032  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 = 'Tus-Sulingen' 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.0018  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=101746 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=101746 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73079
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=101746 AND type_rel = 2
0.0021  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 = '101746' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '101746' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0019  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 = '101746' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 73079 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=101746 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73079,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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73079 AND teamId = 101746
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 101746
0.0019  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 = '101746' 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 = '101746' and rp.type = 4
0.0019  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 = '101746' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73079 WHERE rp.league_id = 73079 AND rp.teamId = 101746 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 = 73079 WHERE rp.league_id = 73079 AND rp.teamId = 101746 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 = 73079 WHERE rp.league_id = 73079 AND rp.teamId = 101746 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 101746 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 = 73079 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 72017 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.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 `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 = 58574 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 51140 AND t.round = 19 ORDER BY team.conference ASC,t.position 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 `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 = 48749 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 38892 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 46827 AND t.round = 30 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 `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 = 46845 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC