4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
22 jugadores
Lokomotive Leipzig Lokomotive
L. Wenzel L. Wenzel 25 años 183cm 74kg POR
F. Guderitz F. Guderitz 27 años 192cm POR
Leon Heynke Leon Heynke 24 años 186cm DEF
P. Wolf P. Wolf 35 años 189cm 81kg DEF
K. Schulze K. Schulze 32 años 189cm 82kg DEF
Robert Berger Robert Berger 27 años 179cm 77kg DEF
D. Urban D. Urban 31 años 188cm 82kg DEF
Stöckner Stöckner 35 años 189cm DEF
R. Zickert R. Zickert 34 años 185cm 84kg DEF
P. Misch P. Misch 27 años 191cm DEF
S. Pfeffer S. Pfeffer 37 años 176cm 73kg MED
M. Pommer M. Pommer 26 años MED
M. Salewski M. Salewski 34 años 174cm MED
N. Brandt N. Brandt 32 años 182cm 77kg MED
P. Panier P. Panier MED
A. Soyak A. Soyak 28 años 179cm 75kg MED
P. Schinke P. Schinke 32 años 176cm MED
M. Steinborn M. Steinborn 35 años 186cm DEL
Romario Hajrulla Romario Hajrulla 25 años 179cm DEL
S. Mvibudulu S. Mvibudulu 30 años 188cm 84kg DEL
D. Ziane D. Ziane 32 años 186cm DEL
I. Schubert-Abubakari I. Schubert-Abubakari 23 años 171cm DEL
17 jugadores
Verl Verl
L. Klante L. Klante 25 años 180cm POR
R. Brüseke R. Brüseke 30 años 184cm 80kg POR
P. Choroba P. Choroba 27 años 183cm DEF
Yannick Langesberg Yannick Langesberg 30 años 191cm 82kg DEF
Stöckner Stöckner 35 años 189cm DEF
L. Ritzka L. Ritzka 25 años 185cm 80kg DEF
D. Mikic D. Mikic 31 años 180cm 78kg DEF
J. Schöppner J. Schöppner 24 años 190cm 78kg MED
M. Kurt M. Kurt 28 años 181cm 76kg MED
R. Schallenberg R. Schallenberg 25 años 185cm 68kg MED
H. Lohmar H. Lohmar 27 años 190cm 85kg MED
M. Haeder M. Haeder 35 años 175cm DEL
N. Hecker N. Hecker 32 años 183cm DEL
P. Schikowski P. Schikowski 31 años 181cm 73kg DEL
E. Andzouana E. Andzouana 30 años 188cm DEL
Z. Janjic Z. Janjic 37 años 184cm 80kg DEL
A. Yildirim A. Yildirim 29 años 180cm 78kg DEL

JUGADORES DESTACADOS

Equipos de esta liga

2

  USO DE MEMORIA  
4,432,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.0593
Total Execution Time  0.0628
  CADENA URL  
/bundesliga_42020/grupo0/jugadores
  GET DATOS  
$_GET['/bundesliga_42020/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0019  SELECT type FROM routes WHERE alias = 'bundesliga_42020'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_4' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=178 AND type_rel = 3
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 178 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1312550,1292079,1266183,1227043,1201762) ORDER BY n.cover_points DESC, update_date DESC
0.0019  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 = 56812 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 56812 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0027  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 = 56812 AND dt.id IN (9745,2904) ORDER BY dt.relations DESC,dp.role ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 16:39:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 16:39:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 16:39:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 16:39:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  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 events2020 e ON e.player_id = p.id AND e.league_id = 56812 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 56812 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.0024  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 events2020 e ON e.player_id = p.id AND e.league_id = 56812 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 56812 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 events2020 e ON e.player_id = p.id AND e.league_id = 56812 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 56812 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10