4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1918
Temporada Siguiente »
Copa del Rey 1918
1917/1918

copa de su majestad el rey, copa del rey, campeonato de españa, la copa de españa,

Copa del Rey 1918

15 jugadores
Real Madrid Real Madrid
Teus Teus 64 años POR
Manzanedo Manzanedo DEF
Cordero Cordero DEF
Rey Rey MED
Castell Castell 85 años MED
Caballero Caballero MED
Aranguren Aranguren 80 años MED
Caruncho Caruncho MED
Machimbarrena Machimbarrena MED
Posada Posada DEL
Sansinenea Sansinenea 28 años DEL
Muguiro Muguiro DEL
Álvarez Álvarez 57 años DEL
De Miguel De Miguel 40 años DEL
Bernabéu Bernabéu 82 años DEL
11 jugadores
Espanyol Espanyol
Zamora Zamora 77 años POR
Pakán Pakán DEF
Amadeo Amadeo DEF
Blanco Blanco MED
Querol Querol MED
Urgell Urgell MED
Gràcia Gràcia DEL
Alfaro Alfaro DEL
Alvarado Alvarado DEL
Reig Reig DEL
Ventura Ventura DEL
11 jugadores
Real Sporting Real Sporting
Soto Soto POR
Salas Salas DEF
Conrado Conrado DEF
Riera Riera MED
Morán Morán MED
Meana Meana 83 años MED
Villaverde Villaverde DEL
Villaverde Iii Villaverde Iii DEL
Embil Embil DEL
Argüelles Argüelles DEL
Arcadio Arcadio DEL
12 jugadores
Recreativo Recreativo
González Pérez González Pérez POR
Arana Arana DEF
A. Mata A. Mata DEF
Manuel Mata Manuel Mata MED
Reyes Reyes MED
Ochoa Ochoa MED
Núñez Núñez DEL
Montenegro Montenegro 61 años DEL
Gregorio Gregorio DEL
Molina Molina DEL
Fuentes Fuentes DEL
Chazarry Chazarry DEL
12 jugadores
Real Unión Club Real Unión Club
Muguruza Muguruza 69 años POR
Múgica Múgica DEF
Emery Emery DEF
Carrasco Carrasco DEF
Legarreta Legarreta MED
René Petit René Petit 90 años MED
Eguiazábal Eguiazábal MED
Pepe Angoso Pepe Angoso DEL
Vázquez Vázquez 68 años DEL
Acosta Acosta DEL
Amantegui Amantegui DEL
Patricio Patricio 41 años DEL
11 jugadores
Real Club Fortuna de Vigo Real Club Fortu.
Ruiz Ruiz POR
Fernández Fernández DEF
Juanito Juanito DEF
Herminio Herminio 80 años DEF
Abad Abad MED
Torres Torres MED
Catalán Catalán MED
Bachmann Bachmann MED
Pío Pío DEL
Quico Pérez Quico Pérez DEL
Cambón Cambón DEL

  USO DE MEMORIA  
4,576,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4156
Total Execution Time  0.4175
  CADENA URL  
/copa_del_rey1918/grupo0/jugadores
  GET DATOS  
$_GET['/copa_del_rey1918/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0144  SELECT type FROM routes WHERE alias = 'copa_del_rey1918'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_del_rey' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1918 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=129 AND type_rel = 3
0.0331  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 129 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (1313202,801142,1286949,1244521,905062) ORDER BY n.cover_points DESC, update_date DESC
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 = 22182 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 = 22182 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0153  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 = 22182 AND dt.id IN (998,2107,2125,2141,2130,85858) 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 22:45:18' 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=2 AND last_update > '2024-05-01 22:45:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 22:45:18' 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=3 AND last_update > '2024-05-01 22:45:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1918
0.0152  SELECT e.action, count(e.action) as total, e.player_id FROM events1918 e WHERE e.league_id IN (22182) 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.0160  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 (22182) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (1026732,1026792,251723,1026797,399937,1026658,1026808,1026707,1026742,1026771) ORDER BY rp.in_squad = 1 DESC
0.0155  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1918
0.0152  SELECT e.action, count(e.action) as total, e.player_id FROM events1918 e WHERE e.league_id IN (22182) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0159  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1918
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1918 e WHERE e.league_id IN (22182) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10