4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pampow
TEMPORADA 2023/2024
LANDESLIGA GRUPO 31
Equipo PJ GF GC Puntos
1 Torgelow-Ueckermünde Torgelow-Uec 25 83 23 66
2 Malchower SV Malchower 25 75 24 64
3 Neubrandenburg 04 Neubrandenbu 25 79 24 60
4 SV Siedenbollentin Siedenbollen 25 65 29 50
5 SV Pastow SV Pastow 25 67 31 45
6 Bentwisch Bentwisch 24 51 48 41
7 Pampow Pampow 25 49 47 38
8 Mecklenburg Schwerin Mecklenburg 25 45 38 34
9 FC Förderkader René Schneid Förderkader 24 45 40 30
10 Greifswalder FC II Greifswalder 25 42 50 29
11 Schönberg Schönberg 25 38 62 26
12 FSV Kühlungsborn Kühlungsbor 25 38 59 22
13 Güstrower Güstrower 25 43 62 21
14 Doberaner FC Doberaner 25 39 84 19
15 SV Warnemünde Warnemünde 25 37 93 15
16 TSV Stralsund Stralsund 25 32 114 5
TEMPORADA 2022/2023
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Hansa Rostock II Hansa 34 94 28 81
2 Rostocker FC Rostocker 34 77 38 69
3 TUS Makkabi TUS Makkabi 34 73 32 67
4 FC Hertha 03 Zehlendorf Hertha 34 71 40 62
5 RSV Eintracht Eintracht 34 56 53 57
6 CFC Hertha 06 Hertha 34 48 44 49
7 Blau-Weiß 1890 Berlin Blau-Weiß 34 59 60 48
8 Dynamo Schwerin Dynamo 34 48 54 48
9 Neustrelitz Neustrelitz 34 55 54 47
10 Union Fürstenwalde Union 34 48 56 47
11 Mahlsdorf Mahlsdorf 34 48 52 46
12 Tasmania Berlin Tasmania 36 46 69 39
13 Optik Rathenow Optik 34 42 60 34
14 Mecklenburg Schwerin Mecklenburg 36 55 90 34
15 Staaken Staaken 34 46 61 33
16 MSV Neuruppin Neuruppin 34 43 57 32
17 FC Frankfurt Frankfurt 34 43 72 31
18 Pampow Pampow 34 51 83 30
TEMPORADA 2021/2022
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Greifswalder Greifswalder 31 61 35 68
2 FC Hertha 03 Zehlendorf Hertha 32 67 31 66
3 CFC Hertha 06 Hertha 32 58 36 63
4 Blau-Weiß 1890 Berlin Blau-Weiß 31 64 41 60
5 Staaken Staaken 32 67 36 59
6 Neustrelitz Neustrelitz 30 44 25 58
7 Rostocker FC Rostocker 31 68 32 56
8 Mahlsdorf Mahlsdorf 31 55 38 51
9 Torgelower SV Greif Torgelower 31 60 37 48
10 Hansa Rostock II Hansa 31 73 49 47
11 RSV Eintracht Eintracht 31 49 43 45
12 Pampow Pampow 31 47 55 38
13 Mecklenburg Schwerin Mecklenburg 32 39 63 34
14 Ludwigsfelder FC Ludwigsfelde 31 31 46 33
15 MSV Neuruppin Neuruppin 31 35 63 28
16 Stern Stern 31 32 64 23
17 Brandenburger Brandenburge 32 26 55 22
18 Victoria Seelow Victoria 30 31 84 16
19 Lok Stendal Lok Stendal 31 27 101 13
TEMPORADA 2020/2021
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Tasmania Berlin Tasmania 9 21 7 21
2 Greifswalder Greifswalder 9 21 7 17
3 Staaken Staaken 8 17 6 16
4 RSV Eintracht Eintracht 9 18 16 16
5 Torgelower SV Greif Torgelower 8 17 8 15
6 FC Hertha 03 Zehlendorf Hertha 9 25 17 15
7 Neustrelitz Neustrelitz 9 19 15 13
8 Blau-Weiß 1890 Berlin Blau-Weiß 9 11 7 13
9 Pampow Pampow 9 18 17 13
10 Hansa Rostock II Hansa 8 14 13 13
11 Stern Stern 8 14 13 13
12 Rostocker FC Rostocker 10 16 26 12
13 Strausberg Strausberg 9 15 18 10
14 CFC Hertha 06 Hertha 9 12 25 9
15 Victoria Seelow Victoria 9 8 24 6
16 Lok Stendal Lok Stendal 9 9 18 5
17 BSC Süd 05 BSC Süd 05 9 7 25 5
TEMPORADA 2019/2020
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Tennis Borussia Tennis 19 61 17 47
2 Greifswalder Greifswalder 18 37 15 42
3 Hansa Rostock II Hansa 19 56 22 39
4 FC Hertha 03 Zehlendorf Hertha 19 40 20 39
5 Neustrelitz Neustrelitz 19 29 27 32
6 Pampow Pampow 19 41 28 30
7 Staaken Staaken 19 42 36 25
8 Blau-Weiß 1890 Berlin Blau-Weiß 18 25 25 24
9 Torgelower SV Greif Torgelower 19 26 30 24
10 Tasmania Berlin Tasmania 19 30 37 21
11 Ludwigsfelder FC Ludwigsfelde 19 26 39 18
12 Lok Stendal Lok Stendal 18 20 33 18
13 Victoria Seelow Victoria 18 25 44 18
14 CFC Hertha 06 Hertha 19 18 43 16
15 BSC Süd 05 BSC Süd 05 18 12 35 11
16 Strausberg Strausberg 18 17 54 11

  USO DE MEMORIA  
5,233,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0862
Total Execution Time  0.0874
  CADENA URL  
/historico/Msv-Pampow
  GET DATOS  
$_GET['/historico/Msv-Pampow']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0027  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 = 'Msv-Pampow' 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=121411 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=121411 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 = 73075
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121411 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 = '121411' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '121411' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '121411' 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 = 73075 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=121411 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 (73075,68171) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 68171 AND teamId = 121411
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73075 AND teamId = 121411
0.0023  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 = 73075 AND t.round = 25 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 = '121411' 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 = '121411' 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 = '121411' 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 = 73075 WHERE rp.league_id = 73075 AND rp.teamId = 121411 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.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 = 73075 WHERE rp.league_id = 73075 AND rp.teamId = 121411 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 = 73075 WHERE rp.league_id = 73075 AND rp.teamId = 121411 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 121411 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 = 73075 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 68171 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.0023  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 = 63242 AND t.round = 33 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 `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 = 57316 AND t.round = 10 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 `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 = 50468 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.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 = 73075 ORDER BY nameShow LIMIT 100