4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2023
 
Copa Santa Fe 2023
2022/2023

Eliminatorias

Copa Santa Fe 2023

18 jugadores
Rosario Central Rosario Central
L. Cuevas L. Cuevas 21 años 197cm POR
V. Quintero V. Quintero 21 años 193cm POR
Ulises Ciccioli Ulises Ciccioli 20 años 173cm 66kg DEF
Luca Raffin Luca Raffin 18 años 186cm 71kg DEF
J. Cerrudo J. Cerrudo 20 años 168cm 65kg DEF
K. Silva K. Silva 21 años 185cm 79kg DEF
S. Contreras S. Contreras 19 años 186cm 75kg DEF
Ramiro Peralta Ramiro Peralta 21 años 170cm 64kg MED
L. Iglesias L. Iglesias 23 años 170cm 68kg MED
M. Serra M. Serra 19 años 174cm MED
Lautaro Figueroa Lautaro Figueroa 22 años 165cm MED
S. Beltrán S. Beltrán 20 años MED
Carlos Campos Carlos Campos 20 años 169cm 71kg MED
G. Gonzalez G. Gonzalez 19 años DEL
Agustín Módica Agustín Módica 21 años 180cm DEL
G. Duarte G. Duarte 21 años 173cm DEL
Santiago García Santiago García 21 años 172cm 65kg DEL
C. Bonesso C. Bonesso 20 años 180cm DEL
18 jugadores
Unión Santa Fe Unión Santa Fe
D. González D. González 21 años 180cm 74kg POR
Lucas Meuli Lucas Meuli 22 años 185cm 71kg POR
Rafael Profini Rafael Profini 20 años 183cm 81kg DEF
J. Ludueña J. Ludueña 21 años 185cm DEF
Mateo Franzotti Mateo Franzotti 21 años 184cm 69kg DEF
L. Morales L. Morales 20 años 175cm DEF
J. O'Neill J. O'Neill 22 años 169cm 70kg DEF
J. Sánchez J. Sánchez 19 años 182cm DEF
L. Pérez L. Pérez 20 años 186cm MED
L. Verde L. Verde 19 años 178cm 65kg MED
Santino Sottocorno Santino Sottocorno 18 años 179cm MED
Juan Bircher Juan Bircher 19 años 177cm MED
Jeremías González Jeremías González 19 años 170cm MED
T. González T. González 20 años 168cm 75kg DEL
Tomás Romero Tomás Romero 19 años 186cm DEL
Mariano Meynier Mariano Meynier 21 años 178cm DEL
F. Pumpido F. Pumpido 19 años 185cm DEL
T. Aballay T. Aballay 21 años 185cm DEL

  USO DE MEMORIA  
4,343,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4121
Total Execution Time  0.4141
  CADENA URL  
/copa_santa_fe2023/grupo0/jugadores
  GET DATOS  
$_GET['/copa_santa_fe2023/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0148  SELECT type FROM routes WHERE alias = 'copa_santa_fe2023'
0.0304  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_santa_fe' 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.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2101 ORDER BY order_id ASC
0.0145  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2101 GROUP BY l.categoryId
0.0145  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=2101 GROUP BY l.year ORDER BY l.year DESC
0.0148  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 = 72846 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72846 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0151  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 = 72846 AND dt.id IN (4344,595,5896,815,3069,6600,6609,6566,16764,9217,16762,16757,16761,120706,16763,90569,88325,120718,16775,16759,102244,119191,154325,120697,151585,151612,120698,119194,159307,127899,120701,159312,119200,151591,119201,154330) ORDER BY dt.relations DESC,dp.role ASC
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 05:13:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-06 05:13:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-06 05:13:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-06 05:13:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2101 AND l.year = 2023
0.0153  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (72846) 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.0158  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 (72846) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (923935,3249255) ORDER BY rp.in_squad = 1 DESC
0.0151  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2101 AND l.year = 2023
0.0152  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (72846) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0151  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2101 AND l.year = 2023
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (72846) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0147  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 (72846) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3140004,3179827) ORDER BY rp.in_squad = 1 DESC