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

Plantilla del Notts County Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
26 24 gb 186 75 - 1 1
31 23 gb 191 75 - - 1
1 35 gb 183 75 - - 1
Defensa
23 32 zw 173 74 - - 1
15 26 gb 183 70 1 - 11
5 32 wa 191 89 1 - -
24 24 al 187 80 - - -
32 21 gb - - - - -
4 27 ss 190 76 1 - 10
25 18 gb - - - - -
28 22 ss - - 1 - 2
2 30 gb 178 70 - - 3
21 27 gb 184 68 - - 5
Centrocampista
44 27 gb 176 65 - - -
7 26 gb 174 68 15 - 5
16 32 tt 188 67 2 - 8
6 36 ss 183 63 4 - 9
43 - - - - - -
18 29 gb 178 79 - - 2
8 27 gb 182 70 4 - 1
20 22 ss 186 - - 1 5
Delantero
29 25 gm 192 87 5 - 1
11 26 fr 170 62 8 1 5
19 25 gb 178 73 - - -
17 36 ie 184 74 12 - 8
27 28 gb 173 68 1 - -
10 26 mt 177 73 5 - 8
9 27 gb 178 - 28 - 4
14 26 gb 180 65 - - 1

  USO DE MEMORIA  
5,786,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.1254
Total Execution Time  0.1276
  CADENA URL  
/plantilla/Notts-County
  GET DATOS  
$_GET['/plantilla/Notts-County']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9187 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9187 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (25699,52957,67895,74365,121853) ORDER BY n.cover_points DESC, update_date DESC
0.0045  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.0039  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.0019  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.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 72036 AND teamId = 9187
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 68217 AND teamId = 9187
0.0035  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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 68333 AND teamId = 9187
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71574 AND teamId = 9187
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 73197 AND teamId = 9187
0.0170  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9187
0.0053  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72036 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC