4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sporting Atlético

Sporting Atlético

Entrenador: Aitor Zulaika

Temporada 2023/2024

Estadísticas

ENTRA
Marcos Fernández12
Sergio Dacal11
Cris Acerete11
Diego Boza11
Joshua Mancha10
Kevin Picón10
Enol Prendes9
Damián Cáceres9
Dani Sáez7
Samu Montes6
Tomás Fuentes6
B. Montes4
Cristian Ebea4
Pierre Mbemba4
P. Pérez3
Aarón Quintana3
Leonel Miguel2
Iker Martínez2
Esteban Lozano2
Ó. Castro2
Álex Lozano1
Lucho Arroyo1
Jorge Gutiérrez1
SALE
Esteban Lozano14
Diego Boza12
Sergio Dacal12
Cris Acerete12
P. Pérez11
Joshua Mancha10
Damián Cáceres9
Álex Lozano9
Enol Prendes8
Kevin Picón5
Ó. Castro5
Dani Sáez4
Cristian Ebea4
Samu Montes2
Álex Oyón2
Leonel Miguel2
Pierre Mbemba2
Jorge Montes2
Yann Kembo1
B. Montes1
Marcos Fernández1
Tomás Fuentes1
Aarón Quintana1
Lucho Arroyo1

  USO DE MEMORIA  
5,214,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0655
Total Execution Time  0.0667
  CADENA URL  
/estadisticas/Real-Sporting-B/2024
  GET DATOS  
$_GET['/estadisticas/Real-Sporting-B/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2124 AND type_rel = 2
0.0033  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2124 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0037  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 (2598,2826,9629,14493,22127) ORDER BY n.cover_points DESC, update_date DESC
0.0072  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 = '2124' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0040  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 = 2124 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0096  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 = 2124 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0073  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 = 2124 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30