4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mecklenburg Schwerin
TEMPORADA 2023/2024
LANDESLIGA GRUPO 31
Equipo PJ GF GC Puntos
1 Torgelow-Ueckermünde Torgelow-Uec 24 82 21 66
2 Malchower SV Malchower 24 72 24 61
3 Neubrandenburg 04 Neubrandenbu 24 72 23 57
4 SV Siedenbollentin Siedenbollen 24 56 29 47
5 SV Pastow SV Pastow 24 65 30 42
6 Bentwisch Bentwisch 23 51 45 41
7 Pampow Pampow 24 47 47 35
8 Mecklenburg Schwerin Mecklenburg 24 43 37 31
9 Greifswalder FC II Greifswalder 24 41 48 29
10 FC Förderkader René Schneid Förderkader 23 41 40 27
11 Schönberg Schönberg 24 36 61 23
12 FSV Kühlungsborn Kühlungsbor 24 37 57 22
13 Güstrower Güstrower 24 43 60 21
14 Doberaner FC Doberaner 24 38 77 19
15 SV Warnemünde Warnemünde 24 37 89 15
16 TSV Stralsund Stralsund 24 32 105 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 2017/2018
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Optik Rathenow Optik 32 77 22 78
2 Tennis Borussia Tennis 32 64 24 72
3 Lichtenberg Lichtenberg 32 69 34 67
4 FC Hertha 03 Zehlendorf Hertha 33 63 45 63
5 Staaken Staaken 32 74 46 56
6 Brandenburger Brandenburge 32 58 45 54
7 Strausberg Strausberg 32 66 51 51
8 Anker Wismar Anker Wismar 32 54 44 51
9 Altlüdersdorf Altlüdersdo 32 60 56 47
10 Hansa Rostock II Hansa 33 66 73 43
11 Torgelower SV Greif Torgelower 32 42 54 35
12 Malchower SV Malchower 32 55 78 33
13 CFC Hertha 06 Hertha 32 44 64 32
14 Mecklenburg Schwerin Mecklenburg 32 36 61 25
15 Victoria Seelow Victoria 32 49 78 25
16 FC Frankfurt Frankfurt 32 40 79 25
17 Grün-Weiß Brieselang Grün-Weiß 32 39 102 19
TEMPORADA 2016/2017
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Altglienicke Altglienicke 30 69 28 71
2 Optik Rathenow Optik 30 94 33 70
3 Lichtenberg Lichtenberg 30 88 33 60
4 Anker Wismar Anker Wismar 30 62 41 53
5 FC Hertha 03 Zehlendorf Hertha 30 65 53 51
6 Tennis Borussia Tennis 30 54 39 48
7 Malchower SV Malchower 30 50 65 42
8 Victoria Seelow Victoria 30 51 44 40
9 Hansa Rostock II Hansa 30 63 72 38
10 Altlüdersdorf Altlüdersdo 30 53 56 37
11 Mecklenburg Schwerin Mecklenburg 30 55 68 36
12 CFC Hertha 06 Hertha 30 48 76 33
13 Strausberg Strausberg 30 36 63 25
14 Grün-Weiß Brieselang Grün-Weiß 30 38 75 25
15 Germania Schöneiche Germania 30 38 68 23
16 FC Frankfurt Frankfurt 30 30 80 14
TEMPORADA 1995/1996
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 SC Charlottenburg Charlottenbu 32 64 33 62
2 Lichterfelder Lichterfelde 32 67 37 62
3 Türkiyemspor Berlin Türkiyemspo 32 62 39 62
4 Greifswalder Greifswalder 32 58 37 58
5 Preussen Eberswalde Preussen 32 51 39 54
6 Parchimer FC Parchimer 32 60 34 51
7 PSV Rostock PSV Rostock 32 59 46 51
8 Mecklenburg Schwerin Mecklenburg 32 59 60 48
9 Magdeburg Magdeburg 32 46 59 40
10 Köpenicker SC Köpenicker 32 51 52 39
11 FC Schwedt 02 Schwedt 32 42 44 38
12 ASG Vorwärts Dessau Vorwärts 32 46 60 38
13 SG Bornim SG Bornim 32 43 67 38
14 SV SR Neustadt/Dosse Neustadt/Dos 32 43 65 34
15 1. FC Wilmersdorf Wilmersdorf 32 39 58 33
16 BSV Stahl Brandenburg Stahl 32 30 54 21
17 FSV Prenzlau Prenzlau 32 24 60 18
TEMPORADA 1949/1950
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Zwickau Zwickau 26 69 27 61
2 Dresdner SC Dresdner SC 26 87 29 57
3 Dessau 05 Dessau 05 26 67 36 54
4 Rot-Weiss Erfurt Rot-Weiss 26 61 34 47
5 Hallescher FC Hallescher 26 56 38 44
6 Brieske-Senftenberg Brieske-Senf 26 49 48 44
7 SV Babelsberg 03 Babelsberg 26 42 66 34
8 BSG Fortschritt Meerane Fortschritt 26 38 56 30
9 Wismut Gera Wismut Gera 26 34 54 25
10 SV Motor Altenburg Motor 26 34 50 23
11 Anker Wismar Anker Wismar 26 35 60 23
12 Sachsen Leipzig Sachsen 13 20 18 20
13 Lok Stendal Lok Stendal 13 18 19 16
14 Mecklenburg Schwerin Mecklenburg 26 30 84 15
15 Lok Stendal II Stendal 13 17 29 13
16 Chemie Leipzig Chemie 13 18 27 10

  USO DE MEMORIA  
5,622,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0993
Total Execution Time  0.1005
  CADENA URL  
/historico/Fc-Mecklenburg-Schwerin
  GET DATOS  
$_GET['/historico/Fc-Mecklenburg-Schwerin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0033  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 = 'Fc-Mecklenburg-Schwerin' 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=88767 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=88767 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=88767 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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=88767 AND type_rel = 2
0.0023  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 = '88767' 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 = '88767' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '88767' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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.0022  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=88767 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,71432,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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 68171 AND teamId = 88767
0.0017  SELECT count(id) as num_players from rel_players WHERE league_id = 73075 AND teamId = 88767
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 88767
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 = 24 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 = '88767' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '88767' and rp.type = 4
0.0021  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 = '88767' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0027  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 = 88767 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 = 73075 WHERE rp.league_id = 73075 AND rp.teamId = 88767 AND (e.action = 4 or e.action = 5) 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 = 73075 WHERE rp.league_id = 73075 AND rp.teamId = 88767 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 88767 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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.0025  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.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 `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 = 39082 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 `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 = 33812 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables1996` 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 = 28370 AND t.round = 34 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 `tables1950` 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 = 45387 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC