04 May 97	Finalizado	Wolves	0 - 1	Portsmouth
27 Abr 97	Finalizado	Port Vale	1 - 2	Wolves
23 Abr 97	Finalizado	Wolves	1 - 1	Grimsby Town
19 Abr 97	Finalizado	Wolves	4 - 1	Southend United
12 Abr 97	Finalizado	Reading	2 - 1	Wolves
05 Abr 97	Finalizado	Wolves	3 - 2	Norwich City
31 Mar 97	Finalizado	Queens Park Rangers	2 - 2	Wolves
22 Mar 97	Finalizado	Bradford City	2 - 1	Wolves
18 Mar 97	Finalizado	Stoke City	1 - 0	Wolves
15 Mar 97	Finalizado	Oldham Athletic AFC	3 - 2	Wolves
08 Mar 97	Finalizado	Wolves	3 - 2	Tranmere Rovers
04 Mar 97	Finalizado	Birmingham City	1 - 2	Wolves
01 Mar 97	Finalizado	Wolves	0 - 0	Ipswich Town
22 Feb 97	Finalizado	Barnsley	1 - 3	Wolves
15 Feb 97	Finalizado	Wolves	0 - 3	Crystal Palace
08 Feb 97	Finalizado	Huddersfield Town	0 - 2	Wolves
01 Feb 97	Finalizado	Wolves	2 - 0	Stoke City
29 Ene 97	Finalizado	Wolves	1 - 0	Swindon Town
24 Ene 97	Finalizado	Sheffield United	2 - 3	Wolves
18 Ene 97	Finalizado	Bolton Wanderers	3 - 0	Wolves
12 Ene 97	Finalizado	Wolves	2 - 0	West Bromwich Albion
28 Dic 96	Finalizado	Charlton Athletic	0 - 0	Wolves
26 Dic 96	Finalizado	Wolves	3 - 1	Oxford United
21 Dic 96	Finalizado	Tranmere Rovers	0 - 2	Wolves
14 Dic 96	Finalizado	Wolves	0 - 1	Oldham Athletic AFC
07 Dic 96	Finalizado	Ipswich Town	0 - 0	Wolves
01 Dic 96	Finalizado	Wolves	3 - 0	Manchester City
23 Nov 96	Finalizado	Crystal Palace	2 - 3	Wolves
17 Nov 96	Finalizado	Wolves	1 - 2	Birmingham City
02 Nov 96	Finalizado	Wolves	3 - 3	Barnsley
30 Oct 96	Finalizado	Wolves	0 - 0	Huddersfield Town
27 Oct 96	Finalizado	Manchester City	0 - 1	Wolves
19 Oct 96	Finalizado	Wolves	0 - 1	Port Vale
15 Oct 96	Finalizado	Portsmouth	0 - 2	Wolves
13 Oct 96	Finalizado	Southend United	1 - 1	Wolves
05 Oct 96	Finalizado	Wolves	0 - 1	Reading
02 Oct 96	Finalizado	Wolves	1 - 2	Bolton Wanderers
27 Sep 96	Finalizado	Swindon Town	1 - 2	Wolves
21 Sep 96	Finalizado	Wolves	1 - 2	Sheffield United
15 Sep 96	Finalizado	West Bromwich Albion	2 - 4	Wolves
10 Sep 96	Finalizado	Oxford United	1 - 1	Wolves
06 Sep 96	Finalizado	Wolves	1 - 0	Charlton Athletic
31 Ago 96	Finalizado	Norwich City	1 - 0	Wolves
28 Ago 96	Finalizado	Wolves	1 - 1	Queens Park Rangers
24 Ago 96	Finalizado	Wolves	1 - 0	Bradford City
17 Ago 96	Finalizado	Grimsby Town	1 - 3	Wolves

Estadísticas

GOLEADORES

S. Bull23

AMARILLAS

ROJAS

S. Bull1

Plantilla del Wolves Temporada 1996/1997

		Edad	Altura	Peso
Portero
1	Mike Stowell	59	188	74	-	-	3
Defensa
19	Adrian Williams	52	-	-	-	-	2
	D. Richards	49	188	86	1	-	4
	Eric Young	64	-	-	-	-	1
	Jamie Smith	49	173	71	-	-	5
5	K. Curle	60	183	79	2	-	1
	Serge Romano	59	-	-	-	-	-
	Venus	57	185	82	-	-	1
Centrocampista
3	Andy Thompson	56	165	66	2	-	4
	Brian Law	54	-	-	-	-	1
4	Carl Robinson	47	178	70	-	-	-
	Darren Ferguson	52	178	65	3	1	3
	Dennis Pearce	49	183	73	-	-	1
	Dowe	55	183	80	-	-	-
	Emblen	52	185	84	-	-	3
	Froggatt	51	180	70	2	-	2
	Geoff Thomas	59	185	86	3	-	4
	Jermaine Wright	48	178	70	-	-	-
	Mark Atkins	55	185	78	4	-	2
	Michael Gilkes	58	173	68	2	-	1
8	Osborn	52	178	72	5	-	4
	R. Dennison	60	-	-	1	-	3
	Richard Leadbeater	46	188	79	-	-	-
14	Steve Corica	51	-	-	2	-	5
	Van Der Laan	55	180	86	-	-	1
Delantero
	Dominic Foley	47	185	79	1	-	-
	Don Goodman	57	178	82	6	-	1
	G. Crowe	46	-	-	-	-	-
	Iwan Roberts	55	-	-	12	-	4
	S. Bull	59	-	-	23	1	4

Noticias del Wolves

Ver últimas noticias

Los Wolves muerden al Luton y Schlupp salva los muebles en Londres

BeSoccer - Sábado, 27 Abril 2024

0 188

Los Wolves vencieron al Luton Town por 2-1, mientras que el Crystal Palace rescató el empate ante el Fulham en Craven Cottage (1-1). Los 'hatters' se complican sus aspiraciones de permanencia en la Premier League.

El Bournemouth se deja más de 13 millones de euros por un delantero del Championship

BeSoccer - Domingo, 10 Enero 2016

3 1.877

El Bournemouth ha hecho oficial este domingo la contratación del delantero inglés Benik Afobé por 10 millones de libras (13,3 millones de euros).

Ojo vuelve al Liverpool

BeSoccer - Domingo, 10 Enero 2016

1 981

Sheyoi Ojo va a volver a Anfield tras abandonar el Wolverhampton Wanderers, club donde ha estado cedido.

El Crystal Palace quiere pescar en el Swansea y el Wolverhampton

Isabel Ruiz - Sábado, 09 Enero 2016

0 226

El Crystal Palace no va a escatimar en refuerzos en este mercado invernal, ya que está decidido a entrar en Europa la próxima temporada, por lo que está preparando 27 millones de euros.

Emiliano Martínez jugará en los 'wolves' en calidad de cedido

BeSoccer - Martes, 11 Agosto 2015

0 719

El guardameta argentino del Arsenal, Emiliano Martínez, probará suerte en el Wolverhampton, conjunto del Championship. El jugador ha firmado por una temporada, según hizo oficial el club a través de un comunicado.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Bolton Wanderers	98
2		Barnsley	80
3		Wolves	76
4		Ipswich Town	74
5		Sheffield United	73
6		Crystal Palace	71
7		Portsmouth	68
8		Port Vale	67
9		Queens Park Rangers	66
10		Birmingham City	66
11		Tranmere Rovers	65
12		Stoke City	64
13		Norwich City	63
14		Manchester City	61
15		Charlton Athletic	59
16		West Bromwich Albion	57
17		Oxford United	57
18		Reading	57
19		Huddersfield Town	54
20		Swindon Town	54
21		Bradford City	48
22		Grimsby Town	46
23		Oldham Athletic AFC	43
24		Southend United	39

Pos

Equipos

Pts

USO DE MEMORIA

6,339,568 bytes

BENCHMARKS

Loading Time Base Classes	0.0029
Controller Execution Time ( Home / Category )	0.6282
Total Execution Time	0.6312

CADENA URL

/Wolverhampton/1997

GET DATOS

$_GET['/Wolverhampton/1997']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0185	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 = 'Wolverhampton' AND l.year = 1997 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.0126	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=5651 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=5651 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=5651 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=5651 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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 = 472
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5651 AND type_rel = 2
0.0143	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5651 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128	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 (1312842,6016,32966,33057,33166) ORDER BY n.cover_points DESC, update_date DESC
0.0142	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 = '5651' AND l.year = 1997 ORDER BY l.year DESC,cat.coefficient DESC
0.0142	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 = '5651' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	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 = 472 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0271	(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 calendars1997 as c ON c.league_id = l.id WHERE (c.datateam1 = 5651 or c.datateam2 = 5651) AND l.year = 1997 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0293	(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 calendars1997 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 = 5651 or c.datateam2 = 5651) AND l.year = 1997 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0289	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1997 as c ON c.league_id = l.id INNER JOIN events1997 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 = 5651 or c.datateam2 = 5651) AND l.year = 1997)
0.0140	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=5651 AND l.year in (1996,1997,1998) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (23240,14537,473) 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.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 473 AND teamId = 5651
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 14537 AND teamId = 5651
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 23240 AND teamId = 5651
0.0132	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1997` 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 = 472 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0143	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 events1997 e ON e.player_id = p.id AND e.league_id = 472 WHERE rp.league_id = 472 AND rp.teamId = 5651 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.0138	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 events1997 e ON e.player_id = p.id AND e.league_id = 472 WHERE rp.league_id = 472 AND rp.teamId = 5651 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138	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 events1997 e ON e.player_id = p.id AND e.league_id = 472 WHERE rp.league_id = 472 AND rp.teamId = 5651 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 5651 AND rp.league_id = 472 AND l.year= 1997 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0129	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=10550 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0125	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=10550
0.0132	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 events1997 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=10550 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.0132	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 events1997 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=10550 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0141	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 events1997 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=10550 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	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 events1997 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=10550 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	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 events1997 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=10550 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Resultados de Fútbol

Wolves

Información sobre Wolves

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

FA Cup

Premier League

Championship

EFL Cup

Partidos Amistosos

Europa League Grupo 11

Community Shield

Fase Previa Europa League Grupo 5

Champions League

Championship - Play Offs Ascenso

League One

EFL Trophy

Trofeo Premier League Asia

Recopa de Europa

Partidos del Wolves

Estadísticas

Plantilla del Wolves Temporada 1996/1997

Noticias del Wolves

Los Wolves muerden al Luton y Schlupp salva los muebles en Londres

El Bournemouth se deja más de 13 millones de euros por un delantero del Championship

Ojo vuelve al Liverpool

El Crystal Palace quiere pescar en el Swansea y el Wolverhampton

Emiliano Martínez jugará en los 'wolves' en calidad de cedido

Wolves

Selecciona un equipo

Competiciones que juega

Championship

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos