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

Copa UECF

Copa del Rey 1913

13 jugadores
Barcelona Barcelona
Reñé Reñé POR
Berrondo Berrondo 45 años DEF
Irizar Irizar DEF
Amechazurra Amechazurra DEF
Oller Oller MED
Castejón Castejón MED
Berdié Berdié MED
Alfred Massana Alfred Massana MED
Bori Bori 73 años MED
P. Alcántara P. Alcántara 67 años MED
Forns Forns DEL
Apolinario Apolinario 80 años DEL
Peris De Vargas Peris De Vargas 65 años DEL
17 jugadores
Real Sociedad Real Sociedad
Eizaguirre Eizaguirre 66 años POR
Anechino Anechino POR
Berraondo Berraondo DEF
Sena Sena 71 años DEF
Arrate Arrate 71 años DEF
Barandiaran Barandiaran DEF
Eguía Eguía DEF
Arruti Arruti DEF
Arrillaga Arrillaga DEF
Leturia Leturia 91 años DEF
Artola Artola 41 años MED
Machimbarrena Machimbarrena MED
Minondo Minondo 91 años DEL
Fernández Fernández DEL
Larrañaga Larrañaga DEL
Miguel Sena Miguel Sena 84 años DEL
Rezola Rezola DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,379,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.0612
Total Execution Time  0.0634
  CADENA URL  
/copa_del_rey1913/grupo1/jugadores
  GET DATOS  
$_GET['/copa_del_rey1913/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0017  SELECT type FROM routes WHERE alias = 'copa_del_rey1913'
0.0046  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1913 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
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 = 68368 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 68368 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0025  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 = 68368 AND dt.id IN (429,2120) 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-05-03 06:42:08' 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-03 06:42:08' 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-03 06:42:08' 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-03 06:42:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 1913 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1913
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1913 e WHERE e.league_id IN (22187,68368) 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.0024  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 (22187,68368) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (399942,399937,1026652,1026662,400012,1026369,1026406,1026637,1026649,1026683) ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1913
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1913 e WHERE e.league_id IN (22187,68368) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1913
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1913 e WHERE e.league_id IN (22187,68368) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10