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

Tottenham Hotspur

Entrenador: Ange Postecoglou

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Heung-Min Son9
J. Maddison7
Pedro Porro7
B. Johnson7
Timo Werner3
Pape Sarr3
Richarlison3
Destiny Udogie3
D. Kulusevski3
M. Solomon2
G. Lo Celso2
R. Bentancur1
Ivan Perišić1
ENTRA
P. Højbjerg25
Oliver Skipp13
G. Lo Celso13
Emerson Royal10
Alejo Véliz8
Bryan Gil8
Richarlison8
B. Johnson8
R. Bentancur8
Pape Sarr6
Ivan Perišić5
Ben Davies5
D. Kulusevski4
R. Drăgușin4
Timo Werner3
M. Solomon3
Jamie Donley3
Eric Dier3
Dane Scarlett2
D. Sánchez1
Y. Bissouma1
Heung-Min Son1
SALE
J. Maddison18
Pape Sarr18
B. Johnson17
Y. Bissouma14
Heung-Min Son14
Richarlison11
D. Kulusevski8
R. Bentancur8
Timo Werner7
Destiny Udogie6
G. Lo Celso4
M. Van De Ven4
Oliver Skipp3
Pedro Porro3
Cristian Romero2
Bryan Gil2
P. Højbjerg2
M. Solomon2
Emerson Royal1
Ben Davies1

  USO DE MEMORIA  
5,917,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1044
Total Execution Time  0.1056
  CADENA URL  
/estadisticas/Tottenham-Hotspur-Fc
  GET DATOS  
$_GET['/estadisticas/Tottenham-Hotspur-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2523 AND type_rel = 2
0.0410  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2523 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  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 (1312744,1311175,1311046,1310742,1310481) ORDER BY n.cover_points DESC, update_date DESC
0.0063  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 = '2523' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0051  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 = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 2523 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0055  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 = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 2523 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0049  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 = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 2523 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30