02 May 92	Finalizado	Notts County	2 - 1	Luton Town	2
25 Abr 92	Finalizado	Manchester City	2 - 0	Notts County	0
20 Abr 92	Finalizado	Notts County	1 - 3	Sheffield United	0
18 Abr 92	Finalizado	Norwich City	0 - 1	Notts County	0
11 Abr 92	Finalizado	Notts County	1 - 0	Coventry City	0
07 Abr 92	Finalizado	Notts County	0 - 2	Tottenham Hotspur	0
31 Mar 92	Finalizado	Liverpool	4 - 0	Notts County	0
28 Mar 92	Finalizado	Notts County	2 - 3	Crystal Palace	0
21 Mar 92	Finalizado	Sheffield Wednesday	1 - 0	Notts County	0
17 Mar 92	Finalizado	Notts County	0 - 0	Everton	0
14 Mar 92	Finalizado	Oldham Athletic AFC	4 - 3	Notts County	0
10 Mar 92	Finalizado	Notts County	0 - 0	Aston Villa	0
07 Mar 92	Finalizado	Wimbledon FC	2 - 0	Notts County	0
25 Feb 92	Finalizado	Notts County	1 - 1	Wimbledon FC	0
22 Feb 92	Finalizado	Queens Park Rangers	1 - 1	Notts County	0
08 Feb 92	Finalizado	Notts County	0 - 1	Arsenal	0
01 Feb 92	Finalizado	Leeds United	3 - 0	Notts County	0
18 Ene 92	Finalizado	Notts County	1 - 1	Manchester United	0
11 Ene 92	Finalizado	Nottingham Forest	1 - 1	Notts County	0
01 Ene 92	Finalizado	Crystal Palace	1 - 0	Notts County	0
28 Dic 91	Finalizado	Notts County	3 - 0	West Ham	0
26 Dic 91	Finalizado	Notts County	2 - 0	Chelsea	0
20 Dic 91	Finalizado	Southampton	1 - 1	Notts County	0
07 Dic 91	Finalizado	Tottenham Hotspur	2 - 1	Notts County	0
30 Nov 91	Finalizado	Notts County	0 - 1	Queens Park Rangers	0
23 Nov 91	Finalizado	Everton	1 - 0	Notts County	0
16 Nov 91	Finalizado	Aston Villa	1 - 0	Notts County	0
02 Nov 91	Finalizado	Notts County	2 - 0	Oldham Athletic AFC	0
26 Oct 91	Finalizado	Arsenal	2 - 0	Notts County	0
19 Oct 91	Finalizado	Notts County	2 - 4	Leeds United	0
06 Oct 91	Finalizado	Notts County	1 - 3	Manchester City	0
28 Sep 91	Finalizado	Luton Town	1 - 1	Notts County	0
21 Sep 91	Finalizado	Notts County	2 - 2	Norwich City	0
17 Sep 91	Finalizado	Sheffield United	1 - 3	Notts County	0
14 Sep 91	Finalizado	Coventry City	1 - 0	Notts County	0
07 Sep 91	Finalizado	Notts County	1 - 2	Liverpool	0
03 Sep 91	Finalizado	Notts County	2 - 1	Sheffield Wednesday	0
31 Ago 91	Finalizado	West Ham	0 - 2	Notts County	0
28 Ago 91	Finalizado	Chelsea	2 - 2	Notts County	0
24 Ago 91	Finalizado	Notts County	0 - 4	Nottingham Forest	0
20 Ago 91	Finalizado	Notts County	1 - 0	Southampton	0
17 Ago 91	Finalizado	Manchester United	2 - 0	Notts County	0

FA Cup »

15 Feb 92	Finalizado	Norwich City	3 - 0	Notts County
04 Feb 92	Finalizado	Notts County	2 - 1	Blackburn Rovers
05 Ene 92	Finalizado	Notts County	2 - 0	Wigan Athletic

EFL Cup »

	09 Oct 91	Finalizado	Notts County	3 - 2	Port Vale			0
	24 Sep 91	Finalizado	Port Vale	2 - 1	Notts County			0

Estadísticas

GOLEADORES

Plantilla del Notts County Temporada 1991/1992

		Edad	Altura	Peso
Portero
	Steven Cherry	63	-	-	-	-	-
Defensa
	Alan Paris	59	-	-	-	-	-
	Charlie Palmer	60	-	-	-	-	-
	Craig Short	55	183	89	2	-	-
	Dryden	54	183	93	1	-	-
	J. McClelland	68	185	72	-	-	-
	Michael Johnson	50	180	70	-	-	-
	Yates	56	185	80	2	-	-
Centrocampista
	Andy Williams	61	-	-	1	-	-
	Christian Short	53	178	77	1	-	-
	Dave Regis	60	185	-	-	-	-
	Dean Thomas	62	174	-	1	-	-
	Don O'riordan	66	-	-	-	-	-
	Gary Lund	59	180	71	2	-	-
	Kevin Bartlett	61	-	-	7	-	-
	Mark Draper	53	178	71	1	-	-
	Mark Wells	52	173	-	-	-	-
	Paul Cox	52	180	-	-	-	-
	Paul Devlin	52	173	70	-	-	-
	Paul Harding	60	-	-	1	-	-
	Philip Robinson	57	178	73	-	-	-
	Philip Turner	62	-	-	1	-	-
	Rob Matthews	53	183	78	3	-	-
	Steve Slawson	51	182	-	1	-	-
	Tony Agana	60	183	77	5	-	-
Delantero
	Frank Farina	59	-	-	-	-	-
	Johnson	53	180	79	9	-	-
	K. Wilson	63	-	-	4	-	-
	Rideout	59	180	76	3	-	-

Noticias del Notts County

Ver últimas noticias

Los 14 estadios vecinos

Ángel Mateo - Sábado, 15 Octubre 2016

12 132.059

Hay aficiones que se encuentran a pocos metros unas de otras, estadios que se envuelven del aroma del vecino... Estos son los 14 estadios que se encuentran más cercanos el uno del otro.

Sheridan cambia el Oldham Athletic por el Notts County

BeSoccer - Viernes, 27 Mayo 2016

0 134

John Sheridan ha dejado de ser entrenador del Oldham Athletic.

El Notts County destituye a Mark Cooper

BeSoccer - Domingo, 08 Mayo 2016

0 178

La 'manita' que el Carlisle United endosó al Notts County fue suficiente para que la directiva decidiera prescindir de los servicios del técnico Mark Cooper.

Mark Cooper, nuevo entrenador de Notts County

BeSoccer - Domingo, 20 Marzo 2016

0 96

El Notts Country acaba de anunciar su nueva contratación para dirigir el banquillo durante los próximos dos años.

Uno de los goles más tontos del año

Enrique Salvatierra - Martes, 01 Diciembre 2015

0 1.781

Carroll, portero del Notts County, intentó forzar la amarilla del delantero y acabó sacando el balón del fondo de la portería. Surrealista, pero cierto.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Leeds United	82
2		Manchester United	78
3		Sheffield Wednesday	75
4		Arsenal	72
5		Manchester City	70
6		Liverpool	64
7		Aston Villa	60
8		Nottingham Forest	59
9		Sheffield United	57
10		Crystal Palace	57
11		Queens Park Rangers	54
12		Everton	53
13		Wimbledon FC	53
14		Chelsea	53
15		Tottenham Hotspur	52
16		Southampton	52
17		Oldham Athletic AFC	51
18		Norwich City	45
19		Coventry City	44
20		Luton Town	42
21		Notts County	40
22		West Ham	38

Pos

Equipos

Pts

	Champions League : Leeds United
	UEFA : Manchester United, Sheffield Wednesday
	Recopa : Liverpool
	Descenso : Luton Town, Notts County, West Ham

Champions League : Leeds United

UEFA : Manchester United, Sheffield Wednesday

Recopa : Liverpool

Descenso : Luton Town, Notts County, West Ham

USO DE MEMORIA

6,092,760 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.7284
Total Execution Time	0.7304

CADENA URL

/Notts-County/1992

GET DATOS

$_GET['/Notts-County/1992']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0274	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Notts-County' AND l.year = 1992 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0148	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9187 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9187 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9187 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9187 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9187 AND type_rel = 2
0.0158	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.0159	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.0172	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '9187' AND l.year = 1992 ORDER BY l.year DESC,cat.coefficient DESC
0.0163	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.0276	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1992 as c ON c.league_id = l.id WHERE (c.datateam1 = 9187 or c.datateam2 = 9187) AND l.year = 1992 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0303	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1992 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 9187 or c.datateam2 = 9187) AND l.year = 1992 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0798	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1992 as c ON c.league_id = l.id INNER JOIN events1992 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 9187 or c.datateam2 = 9187) AND l.year = 1992)
0.0158	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 (1991,1992,1993) ORDER BY l.id DESC, l.year DESC ;
0.0148	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 (23239,22825,14681,339) 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.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 339 AND teamId = 9187
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 22825 AND teamId = 9187
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 14681 AND teamId = 9187
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 23239 AND teamId = 9187
0.0156	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 events1992 e ON e.player_id = p.id AND e.league_id = 339 WHERE rp.league_id = 339 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.0154	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 events1992 e ON e.player_id = p.id AND e.league_id = 339 WHERE rp.league_id = 339 AND rp.teamId = 9187 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 events1992 e ON e.player_id = p.id AND e.league_id = 339 WHERE rp.league_id = 339 AND rp.teamId = 9187 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 9187 AND rp.league_id = 339 AND l.year= 1992 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0156	SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=7617 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0147	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=7617
0.0173	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1992 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7617 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0159	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1992 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7617 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0155	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1992 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7617 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0157	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1992 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7617 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0156	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1992 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7617 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Notts County

Información sobre Notts County

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

FA Cup

EFL Cup

Championship

Premier League

EFL Trophy

Partidos Amistosos

League One

League Two

National League - Play Offs Ascenso

National League

FA Trophy

League Two - Play Offs Ascenso

Partidos del Notts County

Estadísticas

Plantilla del Notts County Temporada 1991/1992

Noticias del Notts County

Los 14 estadios vecinos

Sheridan cambia el Oldham Athletic por el Notts County

El Notts County destituye a Mark Cooper

Mark Cooper, nuevo entrenador de Notts County

Uno de los goles más tontos del año

Notts County

Selecciona un equipo

Competiciones que juega

Premier League

RIVALES EN EFL Cup

RIVALES EN FA Cup

RIVALES EN Premier League