4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
16 jugadores
Boca Juniors Boca Juniors
Hugo Gatti Hugo Gatti 79 años POR
Vicente Pernía Vicente Pernía 75 años DEF
José Tesare José Tesare 69 años DEF
A. Tarantini A. Tarantini 68 años DEF
Roberto Mouzo Roberto Mouzo 71 años DEF
Pedro Sa Pedro Sa 78 años 178cm 72kg DEF
Jorge Benítez Jorge Benítez 73 años MED
Rubén Suñé Rubén Suñé 72 años MED
Ribolzi Ribolzi 71 años 177cm 73kg MED
Héctor Bernabitti Héctor Bernabitti 72 años MED
Mario Zanabria Mario Zanabria 75 años MED
Carlos Veglio Carlos Veglio 77 años DEL
Carlos Ortíz Carlos Ortíz 71 años DEL
Ernesto Mastrángelo Ernesto Mastrángelo 75 años DEL
Felman Felman 72 años DEL
Pavón Pavón 69 años DEL
13 jugadores
Cruzeiro Cruzeiro
Raul Raul 79 años 185cm 82kg POR
Nelinho Nelinho 73 años DEF
Vanderlei Vanderlei 76 años DEF
Morais Morais 51 años DEF
Eduardo Eduardo 73 años MED
Neca Neca 74 años MED
Lívio Damião Lívio Damião 69 años MED
Ely Mendes Ely Mendes MED
Zé Carlos Zé Carlos 79 años 177cm 78kg MED
Eli Carlos Eli Carlos 70 años MED
Mariano Mariano MED
Darci Darci 74 años MED
Joãozinho Joãozinho 70 años DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,308,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3661
Total Execution Time  0.3679
  CADENA URL  
/copa_libertadores1977/grupo0/jugadores
  GET DATOS  
$_GET['/copa_libertadores1977/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0125  SELECT type FROM routes WHERE alias = 'copa_libertadores1977'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_libertadores' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1977 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=204 AND type_rel = 3
0.0209  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 204 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (1314483,1314422,1314418,1314393,1313284) ORDER BY n.cover_points DESC, update_date DESC
0.0125  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 = 11568 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 11568 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0130  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 = 11568 AND dt.id IN (583,858) ORDER BY dt.relations DESC,dp.role ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 17:22:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 17:22:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 17:22:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 17:22:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0133  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 204 AND l.year = 1977
0.0140  SELECT e.action, count(e.action) as total, e.player_id FROM events1977 e WHERE e.league_id IN (11478,11496,11460,11442,11514,11532,11550,11568) 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.0138  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 (11478,11496,11460,11442,11514,11532,11550,11568) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (533896,408905,532036,532885,533378,406320,533025,533843,534112,534177) ORDER BY rp.in_squad = 1 DESC
0.0128  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 204 AND l.year = 1977
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events1977 e WHERE e.league_id IN (11478,11496,11460,11442,11514,11532,11550,11568) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 204 AND l.year = 1977
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events1977 e WHERE e.league_id IN (11478,11496,11460,11442,11514,11532,11550,11568) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0130  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 (11478,11496,11460,11442,11514,11532,11550,11568) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (358986,401994,262584,359259,387748,388105,411563,532036,533142,533166) ORDER BY rp.in_squad = 1 DESC