4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
11 jugadores
Francia Francia
Louis Tessier Louis Tessier 79 años POR
Alfred Compeyrat Alfred Compeyrat 61 años DEF
Henri Guerre Henri Guerre DEF
Ernest Tossier Ernest Tossier DEF
Raymond Gouin Raymond Gouin 66 años MED
Henri Bellocq Henri Bellocq 74 años MED
Jean Rigal Jean Rigal 88 años MED
Jean-Marie Barat Jean-Marie Barat 63 años MED
Henri Mouton Henri Mouton 80 años DEL
Félix Julien Félix Julien DEL
Maurice Meunier Maurice Meunier 81 años DEL
14 jugadores
Países Bajos Países Bajos
Reinier Beeuwkes Reinier Beeuwkes 79 años POR
Kees Van Nieuwenhuizen Kees Van Nieuwenhuizen DEF
Louis Otten Louis Otten 63 años DEF
Karel Heijting Karel Heijting 68 años DEF
Willem Boerdam Willem Boerdam MED
Miel Mundt Miel Mundt MED
Vic Gonsalves Vic Gonsalves 34 años MED
Dirk Lotsy Dirk Lotsy MED
Bok De Korver Bok De Korver 74 años MED
Edu Snethlage Edu Snethlage 54 años DEL
Caius Welcker Caius Welcker 53 años DEL
Dé Kessler Dé Kessler 52 años DEL
Guus Lutjens Guus Lutjens 89 años DEL
Mannes Francken Mannes Francken 60 años DEL
31 jugadores
Inglaterra Inglaterra
Sam Hardy Sam Hardy 84 años POR
Horace Bailey Horace Bailey POR
Bob Crompton Bob Crompton 61 años DEF
Frederick Chapman Frederick Chapman 68 años DEF
Herbert Smith Herbert Smith DEF
Jesse Pennington Jesse Pennington 87 años DEF
Watty Corbett Watty Corbett 79 años DEF
Bert Freeman Bert Freeman 69 años 173cm MED
Fred Pentland Fred Pentland 78 años MED
Thomas Porter Thomas Porter MED
Billy Wedlock Billy Wedlock 84 años MED
Jimmy Windridge Jimmy Windridge 56 años 171cm MED
Colin Veitch Colin Veitch 57 años 167cm MED
Arthur Bridgett Arthur Bridgett MED
Cyril Dunning Cyril Dunning MED
Ben Warren Ben Warren 37 años MED
Arthur Berry Arthur Berry 65 años 174cm MED
Robert Hawkes Robert Hawkes MED
Evelyn Lintott Evelyn Lintott 32 años MED
George Richards George Richards MED
Joe Cottle Joe Cottle 71 años MED
Kenneth Hunt Kenneth Hunt 65 años MED
Harold Halse Harold Halse 63 años DEL
George Wall George Wall DEL
Gordon Hoare Gordon Hoare 180cm DEL
Harold Fleming Harold Fleming 68 años DEL
George Holley George Holley 56 años DEL
George Hilsdon George Hilsdon 56 años DEL
Edward Davis Edward Davis DEL
Frederick Pentland Frederick Pentland DEL
Vivian Woodward Vivian Woodward 74 años 189cm DEL
24 jugadores
Escocia Escocia
Jimmy Brownlie Jimmy Brownlie 180cm POR
Peter Mcbride Peter Mcbride 76 años POR
Johnny May Johnny May 55 años DEF
Peter Somers Peter Somers DEF
Alec Mcnair Alec Mcnair 68 años DEF
Jock Cameron Jock Cameron DEF
Peter Mcwilliam Peter Mcwilliam 72 años DEF
James Stark James Stark DEF
James Sharp James Sharp 69 años DEF
John Hunter John Hunter DEF
James Hay James Hay DEF
William Walker William Walker DEF
Sandy Macfarlane Sandy Macfarlane MED
James Main James Main MED
Charlie Thomson Charlie Thomson 57 años MED
Tom Collins Tom Collins MED
Alec Bennett Alec Bennett MED
Jimmy Quinn Jimmy Quinn 67 años DEL
Harry Paul Harry Paul DEL
Bobby Walker Bobby Walker 173cm DEL
Jimmy Watson Jimmy Watson DEL
Sandy Thomson Sandy Thomson DEL
George Wilson George Wilson 77 años DEL
Jimmy Mcmenemy Jimmy Mcmenemy DEL
15 jugadores
Gales Gales
Leigh Roose Leigh Roose 185cm 85kg POR
George Latham George Latham DEF
Charlie Morris Charlie Morris DEF
Ernest Peake Ernest Peake 43 años DEF
Jeffrey Jones Jeffrey Jones DEF
Horace Blew Horace Blew DEF
Haydn Price Haydn Price 81 años DEF
Lloyd Davies Lloyd Davies DEF
Maurice Parry Maurice Parry DEF
William Jones William Jones MED
Robert Evans Robert Evans MED
George Wynn George Wynn 80 años MED
Billy Davies Billy Davies 81 años MED
Billy Meredith Billy Meredith 83 años DEL
William Davies William Davies 83 años DEL

  USO DE MEMORIA  
5,590,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.3805
Total Execution Time  0.3840
  CADENA URL  
/amistosos_selecciones1909/grupo1/jugadores
  GET DATOS  
$_GET['/amistosos_selecciones1909/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0144  SELECT type FROM routes WHERE alias = 'amistosos_selecciones1909'
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1909 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0148  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 = 39521 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 39521 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0230  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 = 39521 AND dt.id IN (3770,3775,1017,2523,3811,3768,3756,3750,3813,3850,3776,3761,3810,3798,3075,3738,3745,3076,3074,3762,3777,3723,3754,2731,3746,3774,3767,5270,3759,3734,17581,3771,3725,3758,3731,3735) 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-04-28 18:29:43' 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-04-28 18:29:43' 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=4 AND last_update > '2024-04-28 18:29:43' 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-04-28 18:29:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1909 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0147  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 1909
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events1909 e WHERE e.league_id IN (39521) 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.0147  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 (39521) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (399616,407482,399893,407547,411032,399613,399652,399802,407488,410939) ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 1909
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1909 e WHERE e.league_id IN (39521) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0147  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 1909
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1909 e WHERE e.league_id IN (39521) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10