Escudo del SD Logroñés

SD Logroñés

Entrenador: Aitor Larrazabal

Estadísticas
ENTRA
Ó. Fernández17
Fabián Luzzi16
Damià11
Manny8
Pepe Carmona7
Alex Jaráiz7
Edu Martínez6
A. Trespalacios6
Jon Aurtenetxe6
Adrián Cova5
M. Schmerböck5
I. Ezkurdia4
Michael4
Dani Garrido3
Javi Castellano3
Jesús Márquez2
Curro2
Jannick Buyla2
Sergio Arratia2
Gexan2
Rubio1
Toni García1
Alessio Miceli1
Javier Murua1
Ferni1
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
5,243,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2210
Total Execution Time  0.2230
  CADENA URL  
/estadisticas/Sd-Logrones
  GET DATOS  
$_GET['/estadisticas/Sd-Logrones']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.1506  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 = '4823' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0064  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 4823 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0074  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 4823 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0056  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 4823 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30