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
Diego Boza11
Sergio Dacal11
Cris Acerete11
Joshua Mancha10
Kevin Picón10
Enol Prendes9
Damián Cáceres9
Dani Sáez7
Tomás Fuentes6
Samu Montes6
Cristian Ebea4
Pierre Mbemba4
B. Montes4
Aarón Quintana3
P. Pérez3
Esteban Lozano2
Ó. Castro2
Leonel Miguel2
Iker Martínez2
Á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
Cristian Ebea4
Dani Sáez4
Álex Oyón2
Leonel Miguel2
Pierre Mbemba2
Jorge Montes2
Samu Montes2
Marcos Fernández1
Tomás Fuentes1
Aarón Quintana1
Lucho Arroyo1
Yann Kembo1
B. Montes1

  USO DE MEMORIA  
5,202,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.2011
Total Execution Time  0.2023
  CADENA URL  
/estadisticas/real-sporting-b
  GET DATOS  
$_GET['/estadisticas/real-sporting-b']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2124 AND type_rel = 2
0.0137  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.0138  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.0168  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.0139  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.0191  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.0189  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