4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
21 jugadores
Cañuelas Cañuelas
W. Silva W. Silva
G. Brambatti G. Brambatti 32 años 198cm 83kg POR
B. De Tellería B. De Tellería 32 años POR
F. Quinteros F. Quinteros 30 años DEF
I. Fassione I. Fassione 40 años DEF
C. Madeo C. Madeo 42 años 187cm 80kg DEF
E. Sánchez E. Sánchez 29 años DEF
J. Cano J. Cano 36 años 172cm 74kg DEF
M. Maidana M. Maidana 37 años 177cm 76kg DEF
C. Aguirre C. Aguirre 26 años 190cm DEF
A. Galleguillo A. Galleguillo 22 años DEF
M. Ceccotti M. Ceccotti 25 años MED
U. Ojeda U. Ojeda 28 años MED
M. Frattini M. Frattini 33 años 170cm 73kg MED
S. Sosa S. Sosa 25 años MED
E. Trejo E. Trejo 29 años MED
M. Macchione M. Macchione 27 años MED
A. Visco A. Visco 26 años 176cm DEL
G. Ottaviani G. Ottaviani 27 años DEL
F. Krüger F. Krüger 23 años 184cm DEL
G. Sosa G. Sosa 33 años 187cm 87kg DEL
27 jugadores
Real Pilar Real Pilar
T. Sultani T. Sultani 25 años 185cm POR
G. Cheppi G. Cheppi 28 años POR
I. González I. González 29 años DEF
F. Maraia F. Maraia 31 años DEF
J. Díaz J. Díaz 27 años DEF
G. Pérez G. Pérez 35 años 178cm 75kg DEF
R. Barrios R. Barrios 26 años DEF
F. Cabral F. Cabral 29 años DEF
D. Sueldo D. Sueldo 29 años DEF
A. Otermin A. Otermin 38 años 180cm 74kg DEF
L. Villafañe L. Villafañe 27 años MED
N. Fittaioli N. Fittaioli 29 años MED
B. Guerra B. Guerra 28 años 177cm MED
Á. Rojas Á. Rojas 29 años MED
H. Lillo H. Lillo 37 años 181cm 78kg MED
N. Ríos N. Ríos 26 años MED
L. Chambi L. Chambi 30 años 170cm 66kg MED
E. Flores E. Flores 26 años MED
Y. Galli Y. Galli 29 años 174cm 68kg MED
M. Cáceres M. Cáceres 29 años 184cm 78kg MED
F. Gile F. Gile 30 años MED
M. Crocco M. Crocco 32 años 176cm 70kg MED
V. Covalschi V. Covalschi 35 años DEL
E. Tabone E. Tabone 33 años 180cm 80kg DEL
W. Chimeli W. Chimeli 35 años DEL
D. Crego D. Crego 26 años 173cm DEL
A. Schönfeld A. Schönfeld 30 años 180cm DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,426,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3226
Total Execution Time  0.3244
  CADENA URL  
/primera_c_metropolitana2020/grupo0/jugadores
  GET DATOS  
$_GET['/primera_c_metropolitana2020/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0128  SELECT type FROM routes WHERE alias = 'primera_c_metropolitana2020'
0.0256  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_c_metropolitana' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=208 AND type_rel = 3
0.0133  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 208 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1217126,1190853,1162930,1088584,1060413) ORDER BY n.cover_points DESC, update_date DESC
0.0126  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=1661 ORDER BY l.group_code ASC
0.0127  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1661 ORDER BY order_id ASC
0.0127  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 = 61027 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 61027 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0139  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 = 61027 AND dt.id IN (6603,102910) ORDER BY dt.relations DESC,dp.role ASC
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 14:53:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 14:53:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 14:53:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 14:53:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0138  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 61027 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61027 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 LIMIT 10
0.0135  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 61027 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61027 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0131  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 61027 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61027 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10