4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Gievenbeck
TEMPORADA 2023/2024
OBERLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 Sportfreunde Lotte Sportfreunde 30 79 28 67
2 Türkspor Dortmund Türkspor 29 71 37 62
3 ASC 09 Dortmund Dortmund 29 52 31 58
4 SpVgg Erkenschwick SpVgg 29 67 46 54
5 Gievenbeck Gievenbeck 29 51 30 49
6 SpVgg Vreden SpVgg Vreden 29 48 36 46
7 Schermbeck Schermbeck 29 55 55 45
8 Preußen Münster II Preußen 28 50 33 44
9 Siegen Sportfreunde Siegen 29 55 41 43
10 Finnentrop/Bamenohl Finnentrop/B 29 59 70 40
11 Ennepetal Ennepetal 29 42 58 34
12 Westfalia Rhynern Westfalia 29 40 53 32
13 Wattenscheid 09 Wattenscheid 29 40 59 30
14 Eintracht Rheine Eintracht 29 41 66 29
15 TuS Bovinghausen Bovinghausen 29 33 73 26
16 Victoria Clarholz Victoria 29 35 56 25
17 Sprockhövel Sprockhövel 30 41 63 22
18 Brünninghausen Brünninghau 28 35 59 22
TEMPORADA 2022/2023
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Gutersloh Gutersloh 34 67 38 72
2 Preußen Münster II Preußen 34 82 46 65
3 Paderborn 07 II Paderborn 34 53 23 64
4 Sportfreunde Lotte Sportfreunde 34 64 43 60
5 TuS Bovinghausen Bovinghausen 34 73 59 53
6 Westfalia Rhynern Westfalia 34 52 48 52
7 ASC 09 Dortmund Dortmund 34 51 55 49
8 Victoria Clarholz Victoria 34 53 48 48
9 Finnentrop/Bamenohl Finnentrop/B 34 66 56 47
10 Eintracht Rheine Eintracht 34 52 60 46
11 SpVgg Vreden SpVgg Vreden 34 59 67 43
12 Schermbeck Schermbeck 34 43 56 39
13 Gievenbeck Gievenbeck 34 48 50 36
14 Siegen Sportfreunde Siegen 34 50 54 35
15 Sprockhövel Sprockhövel 34 48 69 35
16 Ennepetal Ennepetal 34 32 59 35
17 Erndtebrück Erndtebrück 34 47 85 34
18 Delbrücker SC Delbrücker 34 47 71 32
TEMPORADA 2018/2019
OBERLIGA GRUPO 11
Equipo PJ GF GC Puntos
1 Schalke 04 II Schalke 34 93 21 85
2 TuS Haltern TuS Haltern 34 63 26 70
3 ASC 09 Dortmund Dortmund 34 60 37 64
4 Sprockhövel Sprockhövel 34 73 53 51
5 Westfalia Rhynern Westfalia 34 50 53 49
6 Paderborn 07 II Paderborn 34 70 64 46
7 Westfalia Herne Westfalia 34 58 60 45
8 Schermbeck Schermbeck 34 43 55 45
9 Rot Weiss Ahlen Weiss Ahlen 34 61 62 44
10 Gutersloh Gutersloh 34 48 61 44
11 Holzwickeder Holzwickeder 34 52 55 42
12 Hammer SpVg Hammer SpVg 34 49 58 42
13 Siegen Sportfreunde Siegen 34 42 59 42
14 Ennepetal Ennepetal 34 44 57 41
15 Erndtebrück Erndtebrück 34 49 56 40
16 Eintracht Rheine Eintracht 34 47 81 40
17 Brünninghausen Brünninghau 34 42 62 37
18 Gievenbeck Gievenbeck 34 40 64 29
TEMPORADA 2012/2013
OBERLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 Lippstadt 08 Lippstadt 34 75 25 75
2 Wattenscheid 09 Wattenscheid 34 70 37 73
3 Arminia Bielefeld II Arminia 34 70 35 66
4 Erndtebrück Erndtebrück 34 68 47 63
5 SpVgg Erkenschwick SpVgg 34 63 42 60
6 Westfalia Rhynern Westfalia 34 61 52 52
7 Neuenkirchen Neuenkirchen 34 60 62 47
8 Gutersloh Gutersloh 34 46 48 46
9 Rot Weiss Ahlen Weiss Ahlen 34 51 62 46
10 Sprockhövel Sprockhövel 34 41 40 45
11 Roland Beckum Roland 34 53 66 44
12 Hammer SpVg Hammer SpVg 34 46 51 39
13 Heven Heven 34 51 67 38
14 Ennepetal Ennepetal 34 50 64 36
15 Dornberg Dornberg 34 53 69 33
16 Westfalia Herne Westfalia 34 44 66 33
17 Schermbeck Schermbeck 34 44 79 31
18 Gievenbeck Gievenbeck 34 32 66 18

  USO DE MEMORIA  
5,336,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0858
Total Execution Time  0.0870
  CADENA URL  
/historico/Gievenbeck
  GET DATOS  
$_GET['/historico/Gievenbeck']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0040  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 = 72710
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=83241 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=573 AND type_rel = 3
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 573 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1247431,1040230,935468,822575,807123) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '83241' 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 = 72710 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=83241 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 (72710,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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72710 AND teamId = 83241
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 83241
0.0025  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 = 72710 AND t.round = 30 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 = '83241' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '83241' and rp.type = 4
0.0020  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 = '83241' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 83241 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.0033  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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 83241 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 83241 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 = 83241 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72710 AND t.round = 30 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 `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 = 68216 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 `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 = 44367 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 `tables2013` 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 = 19817 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC