4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
26 jugadores
Türkspor Bremen Türkspor Bremen
Evren Boga Evren Boga 43 años POR
Philipp Krol Philipp Krol POR
Hendrik Schulz Hendrik Schulz 33 años 190cm POR
John Halstenberg John Halstenberg DEF
K. Ozdemir K. Ozdemir 26 años 181cm 70kg DEF
Izzet Bekar Izzet Bekar 43 años 177cm DEF
Baba Seckan Baba Seckan DEF
Hasan Sahin Hasan Sahin 43 años DEF
Mohamed Chaaban Mohamed Chaaban DEF
Ergün Köseler Ergün Köseler 51 años MED
Augustina Majestic Boahen Augustina Majestic Boahen MED
Batuhan Ozturk Batuhan Ozturk 22 años MED
Kubilay Acan Kubilay Acan MED
Anil Arda Acan Anil Arda Acan MED
Pascal Krombholz Pascal Krombholz 28 años MED
Malte Heinzel Malte Heinzel 30 años 183cm 70kg MED
Sinan Yapici Sinan Yapici MED
Enes Kök Enes Kök MED
Kemal Kök Kemal Kök MED
Bela Prieß Bela Prieß 28 años MED
Ismaila Jammeh Ismaila Jammeh MED
Cebrail Finke Cebrail Finke MED
Juliano Barthel Juliano Barthel DEL
Caner Lias Caner Lias DEL
Sezer Aydin Sezer Aydin DEL
Adnan Erkenekli Adnan Erkenekli 46 años DEL
24 jugadores
TuRa Bremen TuRa Bremen
Dennis Kutschmann Dennis Kutschmann POR
Ersin Riza Kozulcali Ersin Riza Kozulcali POR
Dennis Kutschmann Dennis Kutschmann POR
Jan Stelljes Jan Stelljes POR
Deividas Zukovas Deividas Zukovas DEF
Senol Aridir Senol Aridir DEF
Mehmet Emre Ali Demir Mehmet Emre Ali Demir DEF
Niklas Sudmann Niklas Sudmann 175cm DEF
Cenk Yilmaz Cenk Yilmaz 28 años MED
Fikri Cam Fikri Cam 33 años 186cm MED
Oguzhan Hoshaber Oguzhan Hoshaber MED
Semih Demir Semih Demir 30 años MED
Nils Krause Nils Krause MED
Kilian Nonnast Kilian Nonnast MED
A. Gul A. Gul 33 años 176cm MED
Steven-Arnold Srock Steven-Arnold Srock MED
Firas Tayari Firas Tayari 34 años MED
Hassan Turgay Hassan Turgay 37 años MED
Terence Baah Terence Baah 34 años 183cm MED
Muhammet Cökmez Muhammet Cökmez 33 años MED
Numan-Resul Dön Numan-Resul Dön DEL
Sönke Voss Sönke Voss 39 años DEL
Damir Begić Damir Begić 33 años DEL
Kahlil Hamma Kahlil Hamma DEL
29 jugadores
TuSpo Surheide TuSpo Surheide
Paul Zielinski Paul Zielinski POR
Felix Felix 21 años DEF
Anil Anil 22 años DEF
Dominik Hucke Dominik Hucke DEF
Mehmet Can Bektas Mehmet Can Bektas DEF
Igor Casanova Igor Casanova 40 años DEF
Robin Salge Robin Salge DEF
Mike Bogumil Mike Bogumil DEF
Amarilio-Jose Maravalhas-Moca Amarilio-Jose Maravalhas-Moca DEF
Ali Murad Ali Murad DEF
Oguzhan Denkgelen Oguzhan Denkgelen MED
Eric Beyer-Franzen Eric Beyer-Franzen 27 años MED
Jerome Weinlich Jerome Weinlich 25 años 170cm MED
Fabian Schröder Fabian Schröder 29 años MED
Abbas Moussa Abbas Moussa MED
Fabian Meyer Fabian Meyer 33 años 198cm MED
Tom Tom 22 años MED
Alagie Bah Alagie Bah 26 años MED
Toni Döscher Toni Döscher MED
Justin Schade Justin Schade MED
Mergim Nebihi Mergim Nebihi 29 años 184cm MED
Marvin Marvin 24 años MED
Max Max 22 años MED
Wilson Berisha Wilson Berisha MED
Fin-Luca Fin-Luca 25 años MED
Burga Kurt Burga Kurt DEL
Mert Tayirczik Mert Tayirczik 29 años DEL
Behar Nebihi Behar Nebihi 40 años DEL
Nils Nils 22 años DEL

Clasificación

Equipo PJ GF GC Puntos
1 TuSpo Surheide TuSpo 7 17 5 21
2 TuRa Bremen TuRa Bremen 7 21 9 15
3 1.FC Burg 1.FC Burg 7 17 14 15
4 Weyhe Weyhe 7 31 11 13
5 VfL Bremen VfL Bremen 6 14 4 12
6 FC Huchting FC Huchting 6 18 13 12
7 Woltmershausen Woltmershaus 6 21 11 11
8 Vahr-Blockdiek Vahr-Blockdi 7 23 14 11
9 Melchiorshausen Melchiorshau 7 16 17 11
10 TSV Hasenbüren Hasenbüren 7 20 14 10
11 Türkspor Bremen Türkspor 7 12 22 7
12 SV Grohn SV Grohn 7 14 22 6
13 SG Findorff SG Findorff 7 5 24 4
14 Osterholz-Tenever Osterholz-Te 6 11 17 3
15 SV Lemwerder Lemwerder 5 8 18 2
16 DJK Blumenthal Blumenthal 7 3 36 0

  USO DE MEMORIA  
6,583,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3129
Total Execution Time  0.3148
  CADENA URL  
/landesliga2021/grupo1/jugadores
  GET DATOS  
$_GET['/landesliga2021/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0125  SELECT type FROM routes WHERE alias = 'landesliga2021'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'landesliga' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2090 ORDER BY order_id ASC
0.0127  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58569 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58569 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0275  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 58569 AND dt.id IN (17091,17088,17082,83256,83269,17085,83322,115563,115564,115561,119427,115913,83270,138322,121965,119426) ORDER BY dt.relations DESC,dp.role ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 19:06:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 19:06:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 19:06:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 19:06:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'landesliga' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0129  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58569 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58569 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58569 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58569 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58569 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58569 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  SELECT *,(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 = 58569 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC