4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Paderborn 07 II
TEMPORADA 2023/2024
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Alemannia Aachen Alemannia 31 58 30 69
2 FC Bocholt FC Bocholt 31 44 27 58
3 Wuppertaler SV Wuppertaler 30 64 41 55
4 Fortuna Köln Fortuna 31 57 34 55
5 Schalke 04 II Schalke 31 60 44 49
6 Wiedenbrück Wiedenbrück 31 43 40 47
7 Düren Düren 31 54 44 45
8 Rödinghausen Rödinghause 31 42 39 45
9 Rot-Weiß Oberhausen Rot-Weiß 31 48 32 44
10 Köln II Köln II 30 45 43 43
11 Fortuna Düsseldorf II Fortuna 30 44 42 41
12 Gutersloh Gutersloh 31 38 55 38
13 Paderborn 07 II Paderborn 31 49 49 36
14 B. Mönchengladbach II Mönchenglad 31 49 55 35
15 Lippstadt 08 Lippstadt 30 38 59 30
16 Velbert Velbert 31 34 67 28
17 Wegberg-Beeck Wegberg-Beec 31 40 70 25
18 Rot Weiss Ahlen Weiss Ahlen 31 34 70 25
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 2021/2022
OBERLIGA GRUPO 27
Equipo PJ GF GC Puntos
1 Kaan-Marienborn Kaan-Marienb 9 29 13 21
2 Westfalia Rhynern Westfalia 9 25 8 19
3 Wattenscheid 09 Wattenscheid 9 15 7 19
4 Paderborn 07 II Paderborn 9 19 10 14
5 Gutersloh Gutersloh 9 14 13 12
6 Eintracht Rheine Eintracht 9 11 13 10
7 Erndtebrück Erndtebrück 9 12 23 9
8 Siegen Sportfreunde Siegen 9 8 19 8
9 ASC 09 Dortmund Dortmund 9 13 27 8
10 Schermbeck Schermbeck 9 7 20 5
TEMPORADA 2020/2021
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Gutersloh Gutersloh 9 16 3 25
2 Holzwickeder Holzwickeder 6 20 4 18
3 Westfalia Rhynern Westfalia 8 21 10 18
4 Sprockhövel Sprockhövel 7 19 10 18
5 ASC 09 Dortmund Dortmund 9 21 17 18
6 Kaan-Marienborn Kaan-Marienb 7 27 7 16
7 Meinerzhagen Meinerzhagen 8 18 11 15
8 SpVgg Vreden SpVgg Vreden 9 19 13 14
9 Wattenscheid 09 Wattenscheid 9 14 10 14
10 Siegen Sportfreunde Siegen 10 11 13 14
11 Preußen Münster II Preußen 9 14 15 12
12 Ennepetal Ennepetal 7 18 14 11
13 TuS Haltern TuS Haltern 10 10 25 10
14 Erndtebrück Erndtebrück 8 6 14 9
15 Paderborn 07 II Paderborn 8 18 22 8
16 Schermbeck Schermbeck 7 10 14 7
17 Finnentrop/Bamenohl Finnentrop/B 10 14 20 7
18 Eintracht Rheine Eintracht 10 14 28 7
19 Victoria Clarholz Victoria 7 9 17 6
20 Westfalia Herne Westfalia 8 5 20 1
21 Hammer SpVg Hammer SpVg 8 8 25 0
TEMPORADA 2019/2020
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Wiedenbrück Wiedenbrück 20 35 23 41
2 Meinerzhagen Meinerzhagen 20 41 18 39
3 Rot Weiss Ahlen Weiss Ahlen 18 30 17 36
4 Paderborn 07 II Paderborn 22 40 36 34
5 Eintracht Rheine Eintracht 20 38 29 32
6 Holzwickeder Holzwickeder 20 39 38 31
7 Kaan-Marienborn Kaan-Marienb 21 40 30 30
8 Ennepetal Ennepetal 20 39 34 30
9 Gutersloh Gutersloh 21 28 27 29
10 Schermbeck Schermbeck 21 26 29 29
11 Westfalia Rhynern Westfalia 18 28 15 28
12 Preußen Münster II Preußen 20 30 28 28
13 ASC 09 Dortmund Dortmund 21 30 30 27
14 Westfalia Herne Westfalia 21 29 37 24
15 Siegen Sportfreunde Siegen 19 34 33 22
16 Sprockhövel Sprockhövel 21 25 40 19
17 Erndtebrück Erndtebrück 21 26 55 14
18 Hammer SpVg Hammer SpVg 20 15 54 5
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 2017/2018
OBERLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 Lippstadt 08 Lippstadt 30 56 33 60
2 Kaan-Marienborn Kaan-Marienb 30 47 29 60
3 ASC 09 Dortmund Dortmund 30 70 44 59
4 Hammer SpVg Hammer SpVg 30 64 31 55
5 TuS Haltern TuS Haltern 30 44 36 54
6 Schalke 04 II Schalke 30 51 24 53
7 Brünninghausen Brünninghau 30 62 55 50
8 Eintracht Rheine Eintracht 30 54 62 41
9 Westfalia Herne Westfalia 30 52 56 37
10 Sprockhövel Sprockhövel 30 52 58 35
11 Siegen Sportfreunde Siegen 30 46 54 33
12 Ennepetal Ennepetal 30 41 59 32
13 Paderborn 07 II Paderborn 30 50 57 29
14 Rot Weiss Ahlen Weiss Ahlen 30 41 58 29
15 Arminia Bielefeld II Arminia 30 33 67 23
16 Gutersloh Gutersloh 30 24 64 21
17 Marl Hüls Marl Hüls 0 0 0 0
18 SC Hassel SC Hassel 0 0 0 0
TEMPORADA 2016/2017
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Erndtebrück Erndtebrück 34 73 34 67
2 Westfalia Rhynern Westfalia 34 62 41 64
3 Hammer SpVg Hammer SpVg 34 56 40 62
4 Hüls Hüls 34 74 62 56
5 Lippstadt 08 Lippstadt 34 60 43 55
6 Eintracht Rheine Eintracht 34 60 53 54
7 Kaan-Marienborn Kaan-Marienb 34 38 40 48
8 Ennepetal Ennepetal 34 40 45 46
9 SC Hassel SC Hassel 34 43 48 45
10 Brünninghausen Brünninghau 34 45 47 43
11 Gutersloh Gutersloh 34 53 55 43
12 Paderborn 07 II Paderborn 34 46 50 43
13 Arminia Bielefeld II Arminia 34 48 42 42
14 ASC 09 Dortmund Dortmund 34 61 61 41
15 Roland Beckum Roland 34 38 56 41
16 Neuenkirchen Neuenkirchen 34 60 67 41
17 Stadtlohn Stadtlohn 34 40 63 31
18 SpVgg Erkenschwick SpVgg 34 33 83 19
TEMPORADA 2015/2016
OBERLIGA GRUPO 14
Equipo PJ GF GC Puntos
1 Siegen Sportfreunde Siegen 34 59 31 64
2 SpVgg Erkenschwick SpVgg 34 62 38 63
3 Sprockhövel Sprockhövel 34 73 48 61
4 Roland Beckum Roland 34 67 48 60
5 Westfalia Rhynern Westfalia 34 78 50 59
6 Lippstadt 08 Lippstadt 34 58 44 55
7 Eintracht Rheine Eintracht 34 59 54 55
8 Neuenkirchen Neuenkirchen 34 66 63 52
9 Hüls Hüls 34 66 65 48
10 Arminia Bielefeld II Arminia 34 57 58 43
11 Ennepetal Ennepetal 34 62 60 42
12 Gutersloh Gutersloh 34 52 61 42
13 Stadtlohn Stadtlohn 34 49 60 42
14 Hammer SpVg Hammer SpVg 34 50 65 41
15 ASC 09 Dortmund Dortmund 34 55 87 38
16 Paderborn 07 II Paderborn 34 49 63 36
17 Schermbeck Schermbeck 34 49 78 31
18 Zweckel Zweckel 34 40 78 28

  USO DE MEMORIA  
6,094,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4720
Total Execution Time  0.4733
  CADENA URL  
/historico/Paderborn-07-Ii
  GET DATOS  
$_GET['/historico/Paderborn-07-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0175  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 = 'Paderborn-07-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.0130  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=65734 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65734 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65734 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65734 AND type_rel = 2
0.0128  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 = '65734' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '65734' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 72582 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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=65734 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (72582,71432,68216) 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.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 72582 AND teamId = 65734
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 68216 AND teamId = 65734
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65734
0.0252  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 = 72582 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0141  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 = 72582 WHERE rp.league_id = 72582 AND rp.teamId = 65734 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.0146  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 = 72582 WHERE rp.league_id = 72582 AND rp.teamId = 65734 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 72582 WHERE rp.league_id = 72582 AND rp.teamId = 65734 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 65734 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72582 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.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 `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.0134  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 = 63363 AND t.round = 21 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 `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 = 67304 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 57811 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 50470 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 39085 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 = 33887 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 `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 = 15552 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC