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

Condal

Entrenador: Dani Roces

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Rober Díaz1
ENTRA
P. Vigil22
A. Blanco16
Antón14
Álvaro10
Wilmer Castañeda10
F. Kevin8
Roberto Vigil7
H. Sobrino7
Rober Díaz5
A. Rodríguez5
Rodri5
M. Ordóñez4
D. Pérez3
P. Martínez3
J. Rio3
I. Roza2
Rueda2
A. García1
A. Cuesta1
SALE
A. Rodríguez17
Wilmer Castañeda16
Rober Díaz15
Rueda14
D. Pérez12
Antón11
Álvaro Del Rio8
M. Ordóñez6
Roberto Vigil5
Beneitez4
Juanma4
Rodri3
F. Kevin3
A. Blanco3
P. Martínez3
Nacho2
P. Vigil1
Álvaro1

  USO DE MEMORIA  
4,801,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0410
Total Execution Time  0.0423
  CADENA URL  
/estadisticas/Condal
  GET DATOS  
$_GET['/estadisticas/Condal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0030  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 = '824' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 824 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041  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 = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 824 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 824 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30