4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
18 jugadores
Hammarby Sub 19 Hammarby Sub 19
Theodor Lindgren Theodor Lindgren 19 años POR
Nils Björklund Nils Björklund 22 años POR
Stevan Beko Stevan Beko 20 años DEF
Vilmer Rönnberg Vilmer Rönnberg 22 años DEF
Ben Engdahl Ben Engdahl 20 años DEF
Gustav Hedin Gustav Hedin 20 años DEF
Elias René Rautanen Elias René Rautanen 22 años DEF
M. Assarsson M. Assarsson 21 años DEF
Markus Karlsson Markus Karlsson 20 años 180cm DEF
Marcus Tastekin Marcus Tastekin 20 años 171cm 70kg MED
Nobel Gebrezgi Nobel Gebrezgi 20 años MED
Joel Allard Joel Allard 21 años MED
Alper Demirol Alper Demirol 21 años 184cm MED
Ahmet Tuhral Ahmet Tuhral 20 años MED
Adam Würtz Adam Würtz 21 años DEL
Deniz Gül Deniz Gül 19 años DEL
Mustafa Ali Ismael Mustafa Ali Ismael 22 años 175cm 64kg DEL
Elias Mohammad Elias Mohammad 20 años DEL
18 jugadores
IFK Göteborg Sub 19 Göteborg
Boris Sadiku Boris Sadiku
A. Benediktsson A. Benediktsson 21 años 196cm POR
Lucas Samuelsson Lucas Samuelsson 19 años 180cm 70kg POR
Anton Pärleholt Anton Pärleholt 21 años 174cm DEF
H. Lennartsson H. Lennartsson 21 años DEF
J. Bångsbo J. Bångsbo 21 años 191cm 85kg DEF
T. Van Assema T. Van Assema 22 años 187cm DEF
Liam Röhne Liam Röhne 20 años DEF
Felix Eriksson Felix Eriksson 19 años 177cm DEF
Alai Ghasem Alai Ghasem 21 años 178cm DEF
William Sandford William Sandford 21 años MED
Algot Pärleholt Algot Pärleholt 20 años 162cm MED
Y. Finey Y. Finey 20 años MED
H. Carneil H. Carneil 20 años 176cm MED
Jonathan Enhult Jonathan Enhult 21 años MED
Anton Kurochkin Anton Kurochkin 20 años 173cm 63kg MED
A. Nygaard A. Nygaard 22 años 185cm 71kg DEL
J. Selvén J. Selvén 20 años 175cm 64kg DEL

JUGADORES DESTACADOS

Nombre Goles Equipo
Ahmet Tuhral se Ahmet Tuhral 1 HAM Hammarby Sub 19
A. Nygaard se A. Nygaard 1 GOT IFK Göteborg Sub 19
Y. Finey se Y. Finey 1 GOT IFK Göteborg Sub 19

Equipos de esta liga

2

  USO DE MEMORIA  
4,364,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3164
Total Execution Time  0.3184
  CADENA URL  
/liga_suecia_sub_192021/grupo0/jugadores
  GET DATOS  
$_GET['/liga_suecia_sub_192021/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0144  SELECT type FROM routes WHERE alias = 'liga_suecia_sub_192021'
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_suecia_sub_19' 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.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1712 AND type_rel = 3
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1712 ORDER BY order_id ASC
0.0145  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 = 66509 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 66509 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0151  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 = 66509 AND dt.id IN (62638,62651) ORDER BY dt.relations DESC,dp.role ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 05:13:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 05:13:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 05:13:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 05:13:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  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 = 66509 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66509 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.0148  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 = 66509 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66509 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  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 = 66509 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66509 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10