4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
14 jugadores
Manchester United Manchester
A. Stepney A. Stepney 81 años POR
S. Brennan S. Brennan 86 años DEF
Francis Burns Francis Burns 75 años DEF
Bill Foulkes Bill Foulkes 92 años DEF
Pat Crerand Pat Crerand 85 años DEF
Nobby Stiles Nobby Stiles 78 años DEF
Tony Dunne Tony Dunne 78 años DEF
G. Best G. Best 59 años 175cm MED
B. Kidd B. Kidd 74 años MED
Carlo Sartori Carlo Sartori 76 años 172cm 68kg MED
D. Law D. Law 84 años 175cm 71kg DEL
D. Sadler D. Sadler 78 años DEL
Bobby Charlton Bobby Charlton 86 años DEL
W. Morgan W. Morgan 79 años 175cm 71kg DEL
12 jugadores
Estudiantes La Plata Estudiantes
Alberto Poletti Alberto Poletti 77 años 182cm 75kg POR
Hugo Medina Hugo Medina 78 años DEF
Oscar Malbernat Oscar Malbernat 80 años DEF
Aguirre Suárez Aguirre Suárez 68 años 174cm 71kg DEF
Echecopar Echecopar 77 años MED
Raúl Madero Raúl Madero 84 años MED
Felipe Ribaudo Felipe Ribaudo 83 años MED
Néstor Togneri Néstor Togneri 57 años MED
Carlos Bilardo Carlos Bilardo 85 años 174cm 63kg MED
Carlos Pachamé Carlos Pachamé 80 años 173cm MED
Marcos Conigliaro Marcos Conigliaro 81 años DEL
Juan Veron Juan Veron 80 años DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,305,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3109
Total Execution Time  0.3128
  CADENA URL  
/copa_intercontinental1969/grupo0/jugadores
  GET DATOS  
$_GET['/copa_intercontinental1969/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0105  SELECT type FROM routes WHERE alias = 'copa_intercontinental1969'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_intercontinental' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1969 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1747 AND type_rel = 3
0.0112  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1747 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107  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 (559052,1010647,953722,924520,923458) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1747 ORDER BY order_id ASC
0.0106  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 = 11950 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0105  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 11950 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0108  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 = 11950 AND dt.id IN (1010,1635) ORDER BY dt.relations DESC,dp.role ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:56:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 06:56:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 06:56:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 06:56:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1747 AND l.year = 1969
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1969 e WHERE e.league_id IN (11950) 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.0108  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 (11950) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (388146,452966,532832) ORDER BY rp.in_squad = 1 DESC
0.0109  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1747 AND l.year = 1969
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1969 e WHERE e.league_id IN (11950) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0109  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1747 AND l.year = 1969
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events1969 e WHERE e.league_id IN (11950) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0114  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 (11950) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (372874,372875,533297) ORDER BY rp.in_squad = 1 DESC