4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
15 jugadores
Inglaterra Inglaterra
Alan Hodgkinson Alan Hodgkinson 79 años 175cm POR
Ted Ditchburn Ted Ditchburn 84 años POR
Jeff Hall Jeff Hall 94 años DEF
R. Byrne R. Byrne 28 años DEF
Billy Wright Billy Wright 70 años DEF
Ronnie Clayton Ronnie Clayton 76 años MED
David Pegg David Pegg 88 años MED
J. Dickinson J. Dickinson 57 años MED
John Brooks John Brooks 92 años MED
Duncan Edwards Duncan Edwards 21 años MED
John Atyeo John Atyeo 92 años DEL
Tommy Taylor Tommy Taylor 26 años DEL
S. Matthews S. Matthews 85 años DEL
Thomas Finney Thomas Finney 91 años DEL
J. Haynes J. Haynes 71 años DEL
23 jugadores
Dinamarca Dinamarca
Theil Drengsgaard Theil Drengsgaard 97 años 190cm POR
Henry From Henry From 97 años POR
Kaj Jørgensen Kaj Jørgensen 98 años POR
Erling Linde Larsen Erling Linde Larsen 92 años DEF
John Amdisen John Amdisen 62 años DEF
Erik Jensen Erik Jensen 92 años MED
Ove Andersen Ove Andersen 86 años MED
Peder Kjær-Andersen Peder Kjær-Andersen 89 años MED
Erik Pondal Jensen Erik Pondal Jensen 93 años MED
Flemming Nielsen Flemming Nielsen 90 años MED
Ove Hansen Ove Hansen 94 años MED
Jørgen Olesen Jørgen Olesen 100 años MED
Aage Rou Jensen Aage Rou Jensen 99 años DEL
Bent Pedersen Bent Pedersen 95 años DEL
Ove Bech Nielsen Ove Bech Nielsen 91 años DEL
Poul Pedersen Poul Pedersen 91 años DEL
Kristian Mosegaard Kristian Mosegaard 93 años DEL
Verner Nielsen Verner Nielsen 92 años DEL
John Jensen John Jensen 75 años DEL
Jørgen Hansen Jørgen Hansen 54 años DEL
Jens Peder Hansen Jens Peder Hansen 97 años DEL
Knud Lundberg Knud Lundberg 103 años DEL
Finn Alfred Hansen Finn Alfred Hansen 88 años 185cm 82kg DEL
20 jugadores
Irlanda Irlanda
Jimmy O'neill Jimmy O'neill 92 años POR
Tommy Godwin Tommy Godwin 96 años POR
Alan Kelly Alan Kelly 87 años POR
Seamus Dunne Seamus Dunne 94 años DEF
Charlie Hurley Charlie Hurley 87 años DEF
Ronnie Nolan Ronnie Nolan 89 años DEF
Don Donovan Don Donovan 94 años DEF
N. Cantwell N. Cantwell 92 años DEF
Gerry Mackey Gerry Mackey DEF
Pat Saward Pat Saward 95 años DEF
F. O'farrell F. O'farrell 96 años DEF
Liam Whelan Liam Whelan 89 años MED
G. Cummins G. Cummins 93 años MED
Peter Farrell Peter Farrell 101 años MED
Tommy Dunne Tommy Dunne 91 años MED
A. Fitzsimons A. Fitzsimons 94 años MED
Joe Haverty Joe Haverty 88 años DEL
Johnny Gavin Johnny Gavin 96 años DEL
Dermot Curtis Dermot Curtis 91 años DEL
Alf Ringstead Alf Ringstead 96 años DEL

Clasificación

Equipo PJ GF GC Puntos
1 Inglaterra Inglaterra 4 15 5 7
2 Irlanda Irlanda 4 6 7 5
3 Dinamarca Dinamarca 4 4 13 0

Equipos de esta liga

3

  USO DE MEMORIA  
4,576,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0746
Total Execution Time  0.0767
  CADENA URL  
/clasificacion_mundial_europa1956/grupo1/jugadores
  GET DATOS  
$_GET['/clasificacion_mundial_europa1956/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119 AND type_rel = 3
0.0072  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 119 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1292065,264924,1264766,1232058,1186425) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=119 ORDER BY order_id ASC
0.0019  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 36969 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0028  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 = 36969 AND dt.id IN (3745,3076,3752) ORDER BY dt.relations DESC,dp.role ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 19:52:38' 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-05-02 19:52:38' 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-05-02 19:52:38' 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-05-02 19:52:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 119 AND l.year = 1956
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events1956 e WHERE e.league_id IN (36969,36971,36972,36973,36974,36975,36976,36977,36978,37050) 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, e.player_id ASC LIMIT 10
0.0025  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (36969,36971,36972,36973,36974,36975,36976,36977,36978,37050) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (395711,406781,389111,253842,383090,389092,406844,409077,457215,880678) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 119 AND l.year = 1956
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events1956 e WHERE e.league_id IN (36969,36971,36972,36973,36974,36975,36976,36977,36978,37050) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0022  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (36969,36971,36972,36973,36974,36975,36976,36977,36978,37050) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (383118) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 119 AND l.year = 1956
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1956 e WHERE e.league_id IN (36969,36971,36972,36973,36974,36975,36976,36977,36978,37050) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0021  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (36969,36971,36972,36973,36974,36975,36976,36977,36978,37050) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (383221) ORDER BY rp.in_squad = 1 DESC
0.0025  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1956` 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 = 36969 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC