4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ñublense

Ñublense

Entrenador: Mario Salas

Temporada 2023/2024

Estadísticas

ASISTENCIAS
V. Sosa4
I. Rozas1
G. Graciani1
M. Rivera1
A. Valdés1
B. Oyarzo1
ENTRA
A. Valdés7
F. Moya4
V. Sosa4
Matías Plaza4
C. Medina3
M. Rivera3
E. Herrera2
M. Torrealba2
P. Sánchez2
G. Graciani2
F. Yáñez1
R. Caroca1
SALE
I. Rozas7
F. Yáñez6
B. Oyarzo5
V. Sosa4
E. Herrera3
M. Rivera2
P. Sánchez2
C. Medina1
F. Moya1
G. Campusano1
O. Bosso1
L. Reyes1
P. Rubio1

  USO DE MEMORIA  
4,857,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2550
Total Execution Time  0.2562
  CADENA URL  
/estadisticas/Nublense
  GET DATOS  
$_GET['/estadisticas/Nublense']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0153  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '9135' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0154  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75067 WHERE rp.league_id = 75067 AND rp.teamId = 9135 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75067 WHERE rp.league_id = 75067 AND rp.teamId = 9135 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75067 WHERE rp.league_id = 75067 AND rp.teamId = 9135 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30