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

Bradford City

Entrenador: Graham Alexander

Temporada 2023/2024

Estadísticas

ASISTENCIAS
A. Cook8
J. Walker5
J. Young4
B. Halliday4
C. Oduor3
K. Mcdonald3
Bobby Pointon3
Lewis Richards2
C. Kelly2
Calum Kavanagh2
H. Chapman2
R. Smallwood2
M. Platt1
Alex Gilliead1
Rayhaan Tulloch1
A. Taylor1
L. Ridehalgh1
ENTRA
T. Smith19
C. Oduor12
H. Chapman12
E. Osadebe12
K. Mcdonald9
Daniel Oyegoke9
Bobby Pointon8
M. Derbyshire8
Jonathan Tomkinson6
L. Ridehalgh6
Adam Wilson6
J. Young6
Lewis Richards6
V. Oliver6
Rayhaan Tulloch6
Alex Gilliead5
Calum Kavanagh4
S. Stubbs4
R. Smallwood3
Tyreik Wright3
J. Walker3
B. Halliday3
A. Pattison3
M. Platt2
C. Kelly2
A. Taylor2
A. Cook2
N. Wadsworth2
Chisom Afoka1
SALE
T. Smith18
J. Walker17
E. Osadebe14
Bobby Pointon14
C. Oduor12
C. Kelly10
A. Cook9
J. Young8
Calum Kavanagh8
R. Smallwood7
Lewis Richards7
L. Ridehalgh7
Tyreik Wright7
Alex Gilliead7
K. Mcdonald7
Daniel Oyegoke4
H. Chapman4
M. Platt4
B. Halliday3
Rayhaan Tulloch3
Adam Wilson3
A. Taylor2
A. Pattison2
Jonathan Tomkinson2
S. Stubbs2
M. Derbyshire1
Chisom Afoka1

  USO DE MEMORIA  
5,944,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2772
Total Execution Time  0.2784
  CADENA URL  
/estadisticas/Bradford-City/2024
  GET DATOS  
$_GET['/estadisticas/Bradford-City/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9208 AND type_rel = 2
0.0142  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9208 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130  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 (14726,50205,78627,82383,90054) ORDER BY n.cover_points DESC, update_date DESC
0.0146  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 = '9208' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0162  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 = 72036 WHERE rp.league_id = 72036 AND rp.teamId = 9208 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0183  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 = 72036 WHERE rp.league_id = 72036 AND rp.teamId = 9208 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0174  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 = 72036 WHERE rp.league_id = 72036 AND rp.teamId = 9208 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0201  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 = 72036 WHERE rp.league_id = 72036 AND rp.teamId = 9208 AND (e.action = 22) 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 = 72036 WHERE rp.league_id = 72036 AND rp.teamId = 9208 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0208  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 = 72036 WHERE rp.league_id = 72036 AND rp.teamId = 9208 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30