4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Union Fürstenwalde
TEMPORADA 2016/2017
REGIONALLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 FC Carl Zeiss Jena Carl Zeiss. 34 68 25 75
2 Energie Cottbus Energie 34 58 26 66
3 RB Leipzig II Leipzig 34 67 42 60
4 Viktoria Berlin Viktoria 34 63 47 56
5 SV Babelsberg 03 Babelsberg 34 55 42 55
6 Berliner AK 07 Berliner 34 54 42 55
7 Wacker Nordhausen Wacker 34 47 47 51
8 Oberlausitz Neugersdorf Oberlausitz 34 41 33 48
9 Hertha BSC II Hertha 34 46 48 48
10 Lokomotive Leipzig Lokomotive 34 53 49 47
11 Schönberg Schönberg 34 53 60 47
12 Auerbach Auerbach 34 47 50 45
13 Union Fürstenwalde Union 34 49 59 45
14 Meuselwitz Meuselwitz 34 37 36 44
15 BFC Dynamo BFC Dynamo 34 51 54 44
16 Luckenwalde Luckenwalde 34 35 75 24
17 Budissa Bautzen Budissa 34 29 68 18
18 Neustrelitz Neustrelitz 34 30 80 11
TEMPORADA 2015/2016
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Union Fürstenwalde Union 30 84 35 69
2 Hansa Rostock II Hansa 30 78 30 65
3 FC Hertha 03 Zehlendorf Hertha 30 75 37 59
4 Tennis Borussia Tennis 30 55 35 55
5 Lichtenberg Lichtenberg 30 54 34 53
6 Malchower SV Malchower 30 65 46 48
7 Anker Wismar Anker Wismar 30 59 36 45
8 Germania Schöneiche Germania 30 32 30 40
9 Victoria Seelow Victoria 30 38 46 39
10 Altlüdersdorf Altlüdersdo 30 49 56 38
11 CFC Hertha 06 Hertha 30 45 49 37
12 Neubrandenburg 04 Neubrandenbu 30 55 61 36
13 BSC Süd 05 BSC Süd 05 30 38 61 33
14 Strausberg Strausberg 30 29 48 30
15 FC Frankfurt Frankfurt 30 31 77 21
16 BSV Hürtürkel Hürtürkel 30 24 130 10
TEMPORADA 2014/2015
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Optik Rathenow Optik 30 65 38 66
2 Schönberg Schönberg 30 73 23 63
3 Luckenwalde Luckenwalde 30 65 32 61
4 Lichtenberg Lichtenberg 30 69 49 52
5 Malchower SV Malchower 30 50 45 49
6 Altlüdersdorf Altlüdersdo 30 54 36 48
7 Hansa Rostock II Hansa 30 48 36 47
8 Union Fürstenwalde Union 30 41 45 44
9 FC Hertha 03 Zehlendorf Hertha 30 58 43 43
10 Neubrandenburg 04 Neubrandenbu 30 45 60 37
11 Waren Waren 30 37 57 37
12 Germania Schöneiche Germania 30 31 52 34
13 BSC Süd 05 BSC Süd 05 30 46 59 32
14 Strausberg Strausberg 30 40 59 26
15 Pommern Greifswald Pommern 30 24 53 21
16 BSV Hürtürkel Hürtürkel 30 31 90 9
TEMPORADA 2013/2014
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 BFC Dynamo BFC Dynamo 30 75 10 84
2 BSC Süd 05 BSC Süd 05 30 40 41 50
3 Lichtenberg Lichtenberg 30 42 33 48
4 Hansa Rostock II Hansa 30 68 47 47
5 Strausberg Strausberg 30 48 42 44
6 Altlüdersdorf Altlüdersdo 30 55 55 43
7 Altglienicke Altglienicke 30 47 62 43
8 Luckenwalde Luckenwalde 30 50 45 40
9 Pommern Greifswald Pommern 30 39 39 40
10 BSV Hürtürkel Hürtürkel 30 44 66 40
11 Schönberg Schönberg 30 51 51 36
12 Union Fürstenwalde Union 30 37 45 34
13 Malchower SV Malchower 30 39 49 33
14 Neubrandenburg 04 Neubrandenbu 30 45 66 32
15 Waltersdorf Waltersdorf 30 38 50 29
16 Torgelower SV Greif Torgelower 30 28 45 25
TEMPORADA 2012/2013
OBERLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 BFC Viktoria 1889 Viktoria 30 57 20 66
2 Union Fürstenwalde Union 30 73 32 61
3 BFC Dynamo BFC Dynamo 30 59 28 56
4 Altlüdersdorf Altlüdersdo 30 46 25 53
5 Luckenwalde Luckenwalde 30 64 49 52
6 Hansa Rostock II Hansa 30 49 40 46
7 Lichtenberg Lichtenberg 30 37 37 45
8 Pommern Greifswald Pommern 30 32 42 42
9 Altglienicke Altglienicke 30 49 54 36
10 Malchower SV Malchower 30 43 55 33
11 Neubrandenburg 04 Neubrandenbu 30 35 39 32
12 Waltersdorf Waltersdorf 30 33 46 32
13 BSC Süd 05 BSC Süd 05 30 41 68 32
14 Lichterfelder Lichterfelde 30 46 69 29
15 Waren Waren 30 38 73 25
16 Anker Wismar Anker Wismar 30 38 63 22
TEMPORADA 2011/2012
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Hansa Rostock II Hansa 28 64 26 65
2 Union Berlin II Union Berlin 28 55 34 56
3 Optik Rathenow Optik 28 57 36 55
4 Neustrelitz Neustrelitz 28 51 24 54
5 Torgelower SV Greif Torgelower 28 54 42 48
6 Germania Schöneiche Germania 28 54 39 46
7 BFC Viktoria 1889 Viktoria 28 54 35 43
8 Union Fürstenwalde Union 28 34 39 38
9 Neubrandenburg 04 Neubrandenbu 28 40 46 34
10 Malchower SV Malchower 28 40 45 33
11 Anker Wismar Anker Wismar 28 42 61 32
12 Altlüdersdorf Altlüdersdo 28 33 52 31
13 BFC Dynamo BFC Dynamo 28 35 39 29
14 BSC Süd 05 BSC Süd 05 28 26 73 18
15 Lichterfelder Lichterfelde 28 22 70 5
16 Türkiyemspor Berlin Türkiyemspo 0 0 0 0

  USO DE MEMORIA  
5,575,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0860
Total Execution Time  0.0872
  CADENA URL  
/historico/Union-Furstenwalde/2017
  GET DATOS  
$_GET['/historico/Union-Furstenwalde/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0028  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 = 'Union-Furstenwalde' AND l.year = 2017 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=17186 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=17186 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=17186 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17186 AND type_rel = 2
0.0025  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 = '17186' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient 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 = '17186' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=17186 AND l.year in (2016,2017,2018) 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 (38890,38427,15540) 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 = 38890 AND teamId = 17186
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 15540 AND teamId = 17186
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 17186
0.0035  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 events2017 e ON e.player_id = p.id AND e.league_id = 33792 WHERE rp.league_id = 33792 AND rp.teamId = 17186 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.0030  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 events2017 e ON e.player_id = p.id AND e.league_id = 33792 WHERE rp.league_id = 33792 AND rp.teamId = 17186 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2017 e ON e.player_id = p.id AND e.league_id = 33792 WHERE rp.league_id = 33792 AND rp.teamId = 17186 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 17186 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0040  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 = 33792 AND t.round = 34 ORDER BY team.conference 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 `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 = 15540 AND t.round = 30 ORDER BY team.conference 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 `tables2015` 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 = 4375 AND t.round = 30 ORDER BY team.conference 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 `tables2014` 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 = 3543 AND t.round = 30 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 = 19815 AND t.round = 30 ORDER BY team.conference 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 `tables2012` 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 = 19824 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC