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

Notts County

Entrenador: Stuart Maynard

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Jodi Jones23
Dan Crowley11
Macca6
Aaron Nemane3
S. Austin3
D. Mcgoldrick3
K. Cameron3
M. Palmer2
Scott Robertson2
A. Jatta2
J. Bostock1
W. Randall1
T. Adebayo-Rowling1
R. Brindley1
L. Ashby-Hammond1
A. Chicksen1
ENTRA
J. O'Brien23
S. Austin18
T. Adebayo-Rowling16
A. Chicksen11
W. Randall9
C. Scott9
C. Rawlinson9
J. Morias8
D. Gosling6
J. Bostock6
D. Mcgoldrick5
R. Brindley5
Aaron Nemane5
Aden Baldwin4
Charlie Colkett4
Lewis Macari4
A. Jatta4
Jodi Jones3
Dan Crowley3
Oliver Tipton2
James Sanderson2
Jaden Warner2
A. Stone1
Scott Robertson1
L. Mahovo1
S. Slocombe1
M. Cisse1
SALE
J. Bostock19
Jodi Jones16
S. Austin15
D. Mcgoldrick13
Aaron Nemane13
Dan Crowley9
J. O'Brien9
Macca8
C. Rawlinson8
Scott Robertson7
K. Cameron7
Aden Baldwin5
Lewis Macari5
A. Chicksen5
M. Palmer5
A. Jatta5
R. Brindley4
Jaden Warner3
T. Adebayo-Rowling2
J. Morias1
W. Randall1
S. Slocombe1
D. Gosling1

  USO DE MEMORIA  
5,836,992 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1110
Total Execution Time  0.1124
  CADENA URL  
/estadisticas/Notts-County
  GET DATOS  
$_GET['/estadisticas/Notts-County']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0038  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73197
0.0042  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 = '9187' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72258 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=9187 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0041  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73197,72728,72258,72036,71574,71432,68333,68217) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72036 AND teamId = 9187
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 68217 AND teamId = 9187
0.0043  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 9187
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 72258 AND teamId = 9187
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 68333 AND teamId = 9187
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71574 AND teamId = 9187
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 73197 AND teamId = 9187
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9187
0.0041  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 = 9187 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.0035  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 = 9187 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 9187 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 9187 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 9187 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 9187 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30