4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
29 jugadores
Deportivo Saprissa Deportivo
Abraham Madriz Abraham Madriz 20 años 191cm POR
E. Alvarado E. Alvarado 35 años 193cm 85kg POR
K. Chamorro K. Chamorro 24 años 187cm POR
R. Blanco R. Blanco 34 años 170cm 71kg DEF
Samir Taylor Samir Taylor 20 años DEF
R. Bolaños R. Bolaños 25 años 178cm 72kg DEF
K. Waston K. Waston 36 años 196cm 97kg DEF
C. Villegas C. Villegas 25 años 170cm 70kg DEF
Douglas Sequeira Douglas Sequeira 20 años 187cm DEF
Jorkaeff Azofeifa Jorkaeff Azofeifa 23 años 181cm 78kg DEF
Gerald Taylor Gerald Taylor 22 años 182cm 70kg DEF
J. Valverde J. Valverde 28 años 169cm DEF
F. Escobar F. Escobar 29 años 184cm 74kg DEF
P. Arboine P. Arboine 26 años 178cm 76kg DEF
M. Torres M. Torres 36 años 182cm 76kg MED
U. Segura U. Segura 30 años 183cm 78kg MED
J. Brenes J. Brenes 27 años 173cm 75kg MED
Y. Salas Y. Salas 27 años 173cm MED
D. Guzmán D. Guzmán 34 años 176cm 71kg MED
L. Paradela L. Paradela 27 años 170cm 68kg MED
J. Monge J. Monge 21 años 180cm DEL
C. Bolaños C. Bolaños 39 años 178cm 67kg DEL
O. Sinclair O. Sinclair 26 años 187cm 71kg DEL
J. Cordero J. Cordero 22 años 178cm 68kg DEL
Álvaro Zamora Álvaro Zamora 22 años 180cm DEL
J. East J. East 29 años 173cm 73kg DEL
A. Rodríguez A. Rodríguez 34 años 176cm 77kg DEL
F. Alemán F. Alemán 20 años DEL
W. Madrigal W. Madrigal 19 años 172cm DEL
35 jugadores
CS Herediano CS Herediano
Alexander Lezcano Alexander Lezcano 22 años 190cm POR
D. Rojas D. Rojas 24 años POR
S. Orias S. Orias 20 años 190cm POR
B. Segura B. Segura 27 años 178cm POR
Aaron Cruz Aaron Cruz 32 años 187cm 78kg POR
J. Bolaños J. Bolaños 25 años 175cm DEF
G. Torres G. Torres 26 años 171cm 63kg DEF
F. Faerrón F. Faerrón 23 años 188cm 78kg DEF
John Ruiz John Ruiz 19 años 174cm DEF
A. Salazar A. Salazar 24 años 181cm 67kg DEF
K. Brown K. Brown 32 años 187cm 84kg DEF
D. Araya D. Araya 23 años 174cm 72kg DEF
H. Quirós H. Quirós 25 años DEF
Jesús Rubio Jesús Rubio 27 años 182cm 72kg DEF
J. Basulto J. Basulto 32 años 183cm 78kg DEF
K. Fuller K. Fuller 29 años 183cm 78kg DEF
A. Murillo A. Murillo 26 años 178cm 72kg MED
Alejandro Bran Alejandro Bran 23 años 187cm MED
Y. Tejeda Y. Tejeda 32 años 179cm 66kg MED
A. Cruz A. Cruz 28 años 165cm 52kg MED
R. Araya R. Araya 24 años 176cm 70kg MED
E. Juárez E. Juárez 25 años 172cm MED
O. Galo O. Galo 23 años 176cm 72kg MED
J. Hadden J. Hadden 26 años 176cm MED
E. Aguilar E. Aguilar 32 años 177cm 79kg MED
K. Rocha K. Rocha 27 años 158cm DEL
A. Contreras A. Contreras 24 años 180cm 73kg DEL
Y. Ruiz Y. Ruiz 37 años 180cm 78kg DEL
J. Ortiz J. Ortiz 31 años 180cm 69kg DEL
J. Godínez J. Godínez 27 años 183cm 79kg DEL
D. Vega D. Vega 31 años 178cm 72kg DEL
G. Campos G. Campos 28 años 179cm 77kg DEL
J. J. Ruiz J. J. Ruiz 30 años 175cm 66kg DEL
Kenneth Vargas Kenneth Vargas 22 años 178cm 74kg DEL
Enyel Escoe Enyel Escoe 20 años DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,415,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3806
Total Execution Time  0.3825
  CADENA URL  
/supercopa_costa_rica2024/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_costa_rica2024/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0124  SELECT type FROM routes WHERE alias = 'supercopa_costa_rica2024'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_costa_rica' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 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=1685 AND type_rel = 3
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1685 ORDER BY order_id ASC
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1685 GROUP BY l.categoryId
0.0125  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1685 GROUP BY l.year ORDER BY l.year DESC
0.0126  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 = 72539 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 = 72539 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0133  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 = 72539 AND dt.id IN (4400,4395) 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-29 05:26:40' 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-29 05:26:40' 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-29 05:26:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-29 05:26:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1685 AND l.year = 2024
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72539) 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.0131  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 (72539) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (77943) ORDER BY rp.in_squad = 1 DESC
0.0134  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1685 AND l.year = 2024
0.0133  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72539) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0140  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 (72539) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (68938,151598,151862,484320,914374,961764,3240051) ORDER BY rp.in_squad = 1 DESC
0.0131  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1685 AND l.year = 2024
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72539) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0126  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 (72539) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (151869,771963) ORDER BY rp.in_squad = 1 DESC