4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
27 jugadores
América América
Hugo Pineda Hugo Pineda 61 años 185cm 80kg POR
Alberto Becerra Alberto Becerra 45 años 180cm 73kg POR
Adolfo Ríos Adolfo Ríos 57 años POR
R. Salinas R. Salinas 45 años DEF
Á. Ortiz Á. Ortiz 46 años 168cm 67kg DEF
D. Davino D. Davino 48 años 180cm 76kg DEF
R. Rojas R. Rojas 49 años DEF
J. Castro J. Castro 43 años 175cm 73kg DEF
Manuel Ríos Manuel Ríos 47 años 175cm 67kg MED
F. Oviedo F. Oviedo 50 años 185cm 74kg MED
O. Valdez O. Valdez 50 años MED
M. Reyna M. Reyna 44 años MED
Moctezuma Serrato Moctezuma Serrato 47 años 184cm 80kg MED
Christian Patiño Christian Patiño 48 años MED
G. Villa G. Villa 51 años 172cm 72kg MED
Hugo Castillo Hugo Castillo 53 años 175cm 75kg MED
Jesús López Jesús López 52 años 178cm 73kg MED
P. Pardo P. Pardo 47 años 175cm 68kg MED
Andrés Silva Andrés Silva 53 años 187cm 87kg MED
Raúl Lara Raúl Lara 51 años 177cm MED
Veiga Veiga 51 años MED
I. Zamorano I. Zamorano 57 años 178cm 72kg DEL
Reinaldo Navia Reinaldo Navia 45 años 172cm DEL
L. Hernandez L. Hernandez 55 años DEL
Chuy Mendoza Chuy Mendoza 45 años DEL
Marcelo Lipatín Marcelo Lipatín 47 años DEL
R. Paez R. Paez 45 años 172cm 71kg DEL
26 jugadores
CA Morelia CA Morelia
M. Muñoz M. Muñoz 44 años 185cm 82kg POR
Buljubasich Buljubasich 52 años 192cm 83kg POR
M. Ruiz M. Ruiz 47 años DEF
J. Salgado J. Salgado 58 años DEF
H. Cervantes H. Cervantes 42 años 198cm 93kg DEF
H. Morales H. Morales 49 años 182cm DEF
J. Sánchez J. Sánchez 49 años DEF
O. Trujillo O. Trujillo 45 años DEF
M. Hernández M. Hernández 48 años DEF
Alex Fernandes Alex Fernandes 51 años DEF
C. Morales C. Morales 44 años 173cm 70kg DEF
Omar Rodríguez Omar Rodríguez 48 años 176cm 65kg MED
Robsón Robsón 48 años MED
J. A. Noriega J. A. Noriega 54 años MED
D. Galván D. Galván 42 años 180cm 78kg MED
Jorge Almirón Jorge Almirón 52 años 182cm 80kg MED
Jaime Alarcón Jaime Alarcón 53 años 173cm 72kg MED
Roberto Hernández Roberto Hernández 56 años 173cm 74kg MED
Alejandro Glaría Alejandro Glaría 53 años MED
A. Chitiva A. Chitiva 44 años MED
Flavio Davino Flavio Davino 49 años 183cm 76kg MED
Franco Franco 55 años MED
Eduardo Rodríguez Eduardo Rodríguez 44 años 172cm 70kg MED
J. Lozano J. Lozano 53 años 171cm MED
Hugo Chávez Hugo Chávez 47 años 177cm 71kg MED
I. Íñiguez I. Íñiguez 42 años DEL

Equipos de esta liga

4

  USO DE MEMORIA  
4,449,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0641
Total Execution Time  0.0661
  CADENA URL  
/fase_previa_copa_libertadores2002/grupo1/jugadores
  GET DATOS  
$_GET['/fase_previa_copa_libertadores2002/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT type FROM routes WHERE alias = 'fase_previa_copa_libertadores2002'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'fase_previa_copa_libertadores' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2029 AND type_rel = 3
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2029 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1306373,1305335,1304271,1304096,1303258) ORDER BY n.cover_points DESC, update_date DESC
0.0027  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=204 ORDER BY l.group_code ASC
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 = 43070 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 = 43070 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0027  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 = 43070 AND dt.id IN (10276,10273,5602,3618) ORDER BY dt.relations DESC,dp.role ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 09:35:12' 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=2 AND last_update > '2024-05-01 09:35:12' 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-01 09:35:12' 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-01 09:35:12' 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 = 'fase_previa_copa_libertadores' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2029 AND l.year = 2002
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (43070) 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.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2029 AND l.year = 2002
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (43070) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2029 AND l.year = 2002
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (43070) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10