4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
31 jugadores
Boca Juniors Boca Juniors
Roberto Rigante Roberto Rigante 70 años POR
Hugo Gatti Hugo Gatti 79 años POR
Carlos Rodríguez Carlos Rodríguez 72 años POR
Carlos Córdoba Carlos Córdoba 65 años DEF
Pedro Sa Pedro Sa 78 años 178cm 72kg DEF
Roberto Mouzo Roberto Mouzo 71 años DEF
Hugo Alves Hugo Alves 64 años DEF
Vicente Pernía Vicente Pernía 75 años DEF
Rúben Acevedo Rúben Acevedo 64 años DEF
José Suárez José Suárez 73 años DEF
O. Ruggeri O. Ruggeri 62 años 184cm 80kg DEF
José Tesare José Tesare 69 años DEF
Carlos Randazzo Carlos Randazzo 64 años MED
N. Iturrieta N. Iturrieta MED
Brindisi Brindisi 73 años 176cm 72kg MED
Ariel Krasouski Ariel Krasouski 65 años MED
Sergio Sánchez Sergio Sánchez 63 años MED
Abel Alves Abel Alves 66 años MED
Norberto Outes Norberto Outes 70 años 170cm MED
Jorge Benítez Jorge Benítez 73 años MED
Quiróz Quiróz 64 años MED
Jorge Ramoa Jorge Ramoa 61 años MED
Oswaldo Escudero Oswaldo Escudero 63 años 160cm MED
Passucci Passucci 67 años MED
D. Maradona D. Maradona 60 años 167cm 70kg MED
Ribolzi Ribolzi 71 años 177cm 73kg MED
Ricardo Gareca Ricardo Gareca 66 años DEL
Hugo Perotti Hugo Perotti 65 años DEL
Ernesto Mastrángelo Ernesto Mastrángelo 75 años DEL
M. Trobbiani M. Trobbiani 69 años 175cm 76kg DEL
Morete Morete 72 años DEL
1 jugadores
Flamengo Flamengo
Zico Zico 71 años MED
1 jugadores
Milan Milan
Roberto Mandressi Roberto Mandressi 63 años 180cm 71kg DEL
2 jugadores
Barcelona SC Barcelona SC
Flavio Perlaza Flavio Perlaza 71 años DEF
Galo Vásquez Galo Vásquez 67 años MED
2 jugadores
Universitario de Deportes Universitario
Walter Escobar Walter Escobar 75 años MED
Eduardo Rey Muñoz Eduardo Rey Muñoz 66 años DEL

  USO DE MEMORIA  
4,375,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.0919
Total Execution Time  0.0941
  CADENA URL  
/partidos_amistosos1981/grupo1/jugadores
  GET DATOS  
$_GET['/partidos_amistosos1981/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0017  SELECT type FROM routes WHERE alias = 'partidos_amistosos1981'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'partidos_amistosos' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1981 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  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 = 56523 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 56523 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0041  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 = 56523 AND dt.id IN (583,998,1155,1692,2136,1924,252,432,2612,172,3064,6538,3716,6204,5301,87687,16742) 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 20:21:18' 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 20:21:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 20:21:18' 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 20:21:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'partidos_amistosos' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1981 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0025  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 153 AND l.year = 1981
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1981 e WHERE e.league_id IN (56523) 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.0033  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 (56523) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (256710,537210,534875,938696,252637,256241,256254,359256,533801,534715) ORDER BY rp.in_squad = 1 DESC
0.0028  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 153 AND l.year = 1981
0.0047  SELECT e.action, count(e.action) as total, e.player_id FROM events1981 e WHERE e.league_id IN (56523) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0041  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 (56523) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (939077) ORDER BY rp.in_squad = 1 DESC
0.0026  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 153 AND l.year = 1981
0.0097  SELECT e.action, count(e.action) as total, e.player_id FROM events1981 e WHERE e.league_id IN (56523) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0040  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 (56523) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (410180,534110,534473,534875) ORDER BY rp.in_squad = 1 DESC