4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
31 jugadores
Junior Junior
S. Mele S. Mele 26 años 185cm 78kg POR
J. Martínez J. Martínez 30 años 185cm 72kg POR
J. Acosta J. Acosta 22 años 191cm 78kg POR
E. Herrera E. Herrera 25 años 172cm 68kg DEF
E. Olivera E. Olivera 34 años 180cm 73kg DEF
J. Peña J. Peña 24 años 187cm DEF
Y. Moreno Y. Moreno 20 años 184cm DEF
N. Castrillón N. Castrillón 28 años 183cm 70kg DEF
B. Ceballos B. Ceballos 22 años 189cm 80kg DEF
Gabriel Fuentes Gabriel Fuentes 27 años 180cm 70kg DEF
W. Pacheco W. Pacheco 29 años 172cm 60kg DEF
Jhon Vélez Jhon Vélez 20 años 178cm 73kg MED
H. Martínez H. Martínez 26 años 185cm 76kg MED
L. Berdugo L. Berdugo 22 años 176cm 69kg MED
L. Berrío L. Berrío 25 años 175cm MED
F. Ángel F. Ángel 23 años 175cm 78kg MED
K. Padilla K. Padilla 23 años 172cm 65kg MED
D. Moreno D. Moreno 32 años 181cm 73kg MED
D. Mendoza D. Mendoza 23 años 177cm MED
C. Sierra C. Sierra 33 años 183cm 75kg MED
J. Enamorado J. Enamorado 25 años 170cm 55kg DEL
G. Lencina G. Lencina 26 años 178cm 76kg DEL
O. Albornoz O. Albornoz 28 años 183cm 70kg DEL
V. Hernández V. Hernández 35 años 160cm 61kg DEL
C. Bacca C. Bacca 37 años 181cm 76kg DEL
A. Estupiñán A. Estupiñán 29 años 175cm DEL
L. González L. González 33 años 170cm 70kg DEL
S. Rodríguez S. Rodríguez 25 años 177cm 66kg DEL
P. Rojas P. Rojas 32 años 167cm 72kg DEL
F. Hinestroza F. Hinestroza 34 años 178cm 75kg DEL
D. Caicedo D. Caicedo 24 años 165cm 61kg DEL
27 jugadores
Independiente Medellín Independiente
Y. Gómez Y. Gómez 24 años 188cm 72kg POR
J. Chunga J. Chunga 32 años 180cm 80kg POR
B. Benitez B. Benitez 20 años 195cm 84kg POR
A. Mosquera A. Mosquera 32 años 186cm 78kg POR
José Ortiz José Ortiz 25 años 179cm 70kg DEF
J. Palacios J. Palacios 24 años 188cm DEF
V. Moreno V. Moreno 29 años 184cm 78kg DEF
Y. Moreno Y. Moreno 29 años 184cm 74kg DEF
L. Orejuela L. Orejuela 28 años 180cm 70kg DEF
L. Chaverra L. Chaverra 27 años 175cm 70kg DEF
D. Londoño D. Londoño 29 años 185cm 82kg DEF
Yulián Gómez Yulián Gómez 26 años 182cm 63kg DEF
J. Marulanda J. Marulanda 28 años 178cm 70kg DEF
J. Varela J. Varela 25 años 189cm 85kg DEF
A. Ricaurte A. Ricaurte 32 años 182cm 70kg MED
J. Alvarado J. Alvarado 24 años 180cm 76kg MED
J. Cuesta J. Cuesta 22 años 172cm 71kg MED
D. Torres D. Torres 34 años 183cm 80kg MED
D. Moreno D. Moreno 28 años 186cm 74kg MED
D. Loaiza D. Loaiza 30 años 177cm 71kg MED
Miguel Monsalve Miguel Monsalve 20 años 178cm 73kg MED
Déinner Quiñones Déinner Quiñones 28 años 173cm 79kg MED
Brayan Muñiz Brayan Muñiz 23 años 175cm 68kg DEL
A. Plata A. Plata 33 años 172cm 73kg DEL
Edwuin Cetré Edwuin Cetré 26 años 171cm 74kg DEL
A. Ibargüen A. Ibargüen 31 años 175cm 63kg DEL
L. Pons L. Pons 34 años 180cm 75kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,446,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3764
Total Execution Time  0.3784
  CADENA URL  
/clausura_colombia_play_offs2023/grupo0/jugadores
  GET DATOS  
$_GET['/clausura_colombia_play_offs2023/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0126  SELECT type FROM routes WHERE alias = 'clausura_colombia_play_offs2023'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_colombia_play_offs' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1189 AND type_rel = 3
0.0140  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1189 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0138  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 (1294107,1294084,1293626,1293439,1293098) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = 74786 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74786 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0160  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 = 74786 AND dt.id IN (11325,1374) ORDER BY dt.relations DESC,dp.role ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:09:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 06:09:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 06:09:07' 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-04-27 06:09:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1189 AND l.year = 2023
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74524,74786) 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.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 (74524,74786) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (67271,328848,313592,1030947,67427,125533,208867,269155,276753,364305) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1189 AND l.year = 2023
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74524,74786) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0129  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 (74524,74786) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (850768,1030956,273062,331380,390737,861735,919082,3215016,3222724,27064) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1189 AND l.year = 2023
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74524,74786) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0133  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 (74524,74786) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (64699,64700,138482,192207,231056,272897,356964,364305,364309,364888) ORDER BY rp.in_squad = 1 DESC