4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SD Logroñés

SD Logroñés

Entrenador: Aitor Larrazabal

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Ó. Fernández3
Jordi Escobar3
Dani Garrido2
Gexan2
Toni García1
Rubio1
M. Schmerböck1
Damià1
Adrián Cova1
ENTRA
Ó. Fernández18
Fabián Luzzi17
Damià13
Alex Jaráiz10
Manny9
Jon Aurtenetxe7
Pepe Carmona7
M. Schmerböck7
A. Trespalacios6
Michael6
Edu Martínez6
Dani Garrido5
Adrián Cova5
Curro4
I. Ezkurdia4
Gexan3
Alessio Miceli3
Javi Castellano3
Ferni3
Jesús Márquez2
Jordi Escobar2
Jannick Buyla2
Sergio Arratia2
Toni García1
Rubio1
Salado1
Javier Murua1
SALE
Dani Garrido14
Ó. Fernández14
Jordi Escobar12
Damià10
Ferni10
Manny8
Rubio7
Alessio Miceli7
Jaime Paredes6
Toni García6
Salado6
I. Ezkurdia5
Adrián Cova5
Javi Castellano5
Fabián Luzzi5
Alex Jaráiz4
Pepe Carmona3
Jannick Buyla3
M. Schmerböck3
Jon Aurtenetxe3
Javier Murua3
A. Trespalacios2
Curro2
Gexan2
Jesús Márquez1
Michael1
Sergio Arratia1

  USO DE MEMORIA  
5,240,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0537
Total Execution Time  0.0549
  CADENA URL  
/estadisticas/Sd-Logrones/2024
  GET DATOS  
$_GET['/estadisticas/Sd-Logrones/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4823 AND type_rel = 2
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4823 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 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 (755,1236,38399,50954,70823) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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.0033  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.0038  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.0033  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