4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
6 jugadores
Sportivo Italiano Sportivo
N. Merzario N. Merzario 21 años DEF
S. Apa S. Apa 24 años MED
F. Benítez F. Benítez 32 años MED
M. Britez Ojeda M. Britez Ojeda 37 años 186cm 85kg MED
A. Noriega A. Noriega 39 años 186cm 78kg DEL
V. Robaldo V. Robaldo 23 años 186cm DEL
5 jugadores
Liniers Liniers
R. Dimotta R. Dimotta 26 años DEF
A. Torres A. Torres 21 años MED
N. Varela N. Varela 30 años 171cm 62kg MED
S. Palacio S. Palacio 26 años MED
J. Rodríguez J. Rodríguez 27 años DEL
4 jugadores
CA Atlas CA Atlas
F. Gómez F. Gómez 29 años MED
B. Ceballos B. Ceballos 30 años MED
G. Ronconi G. Ronconi 26 años MED
M. Cosentino M. Cosentino 23 años MED
7 jugadores
Midland Midland
A. Siliman A. Siliman 28 años DEF
I. Ruano I. Ruano 35 años 183cm 80kg MED
F. Molina F. Molina 25 años DEL
F. Méndez F. Méndez 23 años DEL
G. Gómez G. Gómez 26 años 170cm DEL
G. Vivanco G. Vivanco 34 años 187cm DEL
A. Visco A. Visco 26 años 176cm DEL
3 jugadores
General Lamadrid General Lamadrid
R. Matías R. Matías 25 años MED
S. Apa S. Apa 24 años MED
C. Campostrini C. Campostrini 24 años DEL
1 jugadores
Claypole Claypole
S. Acosta S. Acosta 31 años 173cm 71kg MED
5 jugadores
JJ Urquiza JJ Urquiza
N. Montoya N. Montoya 26 años 169cm DEF
C. Rivero C. Rivero 22 años DEF
J. Villalba J. Villalba 23 años MED
G. Cueto G. Cueto 27 años DEL
A. Alonso A. Alonso 25 años 190cm 74kg DEL
2 jugadores
Real Pilar Real Pilar
M. Crocco M. Crocco 32 años 176cm 70kg MED
A. Samaniego A. Samaniego 29 años DEL

JUGADORES DESTACADOS


  USO DE MEMORIA  
4,432,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0545
Total Execution Time  0.0564
  CADENA URL  
/primera_c_metropolitana2023/grupo3/jugadores
  GET DATOS  
$_GET['/primera_c_metropolitana2023/grupo3/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0038  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 = 3 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=3 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=208 AND type_rel = 3
0.0025  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.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 (1217126,1190853,1162930,1088584,1060413) ORDER BY n.cover_points DESC, update_date DESC
0.0019  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 = 74313 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74313 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0026  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 = 74313 AND dt.id IN (6549,6592,11873,6594,6604,6553,9693,102910) ORDER BY dt.relations DESC,dp.role ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 22:18:03' 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-04-27 22:18:03' 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-04-27 22:18:03' 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-04-27 22:18:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  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 events2023 e ON e.player_id = p.id AND e.league_id = 74313 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74313 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.0019  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 events2023 e ON e.player_id = p.id AND e.league_id = 74313 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74313 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0021  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 events2023 e ON e.player_id = p.id AND e.league_id = 74313 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74313 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10