14 Ene 98	Finalizado	Sheffield Wednesday	0 - 0	Watford
03 Ene 98	Finalizado	Watford	1 - 1	Sheffield Wednesday
16 Dic 97	Finalizado	Watford	2 - 1	Torquay United
06 Dic 97	Finalizado	Torquay United	1 - 1	Watford
15 Nov 97	Finalizado	Barnet	1 - 2	Watford

EFL Cup »

23 Sep 97	Finalizado	Sheffield United	4 - 0	Watford
16 Sep 97	Finalizado	Watford	1 - 1	Sheffield United
26 Ago 97	Finalizado	Watford	1 - 1	Swindon Town
13 Ago 97	Finalizado	Swindon Town	0 - 2	Watford

League One »

02 May 98	Finalizado	Fulham	1 - 2	Watford
28 Abr 98	Finalizado	Watford	2 - 1	AFC Bournemouth
25 Abr 98	Finalizado	Watford	0 - 0	Grimsby Town
13 Abr 98	Finalizado	Bristol City	1 - 1	Watford
11 Abr 98	Finalizado	Watford	1 - 0	Wrexham AFC
04 Abr 98	Finalizado	Wigan Athletic	3 - 2	Watford
28 Mar 98	Finalizado	Watford	1 - 1	Northampton
21 Mar 98	Finalizado	Oldham Athletic AFC	2 - 2	Watford
17 Mar 98	Finalizado	Watford	2 - 1	Carlisle United
07 Mar 98	Finalizado	Blackpool	1 - 1	Watford
03 Mar 98	Finalizado	Watford	1 - 2	Walsall
28 Feb 98	Finalizado	Watford	3 - 2	Bristol Rovers
25 Feb 98	Finalizado	Millwall	1 - 1	Watford
21 Feb 98	Finalizado	York City	1 - 1	Watford
14 Feb 98	Finalizado	Watford	1 - 1	Luton Town
08 Feb 98	Finalizado	Watford	0 - 2	Gillingham
31 Ene 98	Finalizado	Chesterfield	0 - 1	Watford
24 Ene 98	Finalizado	Brentford	1 - 2	Watford
17 Ene 98	Finalizado	Watford	3 - 1	Preston North End
28 Dic 97	Finalizado	Watford	1 - 1	Plymouth Argyle
20 Dic 97	Finalizado	AFC Bournemouth	0 - 1	Watford
13 Dic 97	Finalizado	Watford	1 - 1	Bristol City
02 Dic 97	Finalizado	Wrexham AFC	1 - 1	Watford
29 Nov 97	Finalizado	Watford	2 - 1	Wigan Athletic
22 Nov 97	Finalizado	Northampton	0 - 1	Watford
18 Nov 97	Finalizado	Watford	2 - 1	Oldham Athletic AFC
08 Nov 97	Finalizado	Walsall	0 - 0	Watford
04 Nov 97	Finalizado	Southend United	0 - 3	Watford
01 Nov 97	Finalizado	Watford	4 - 1	Blackpool
25 Oct 97	Finalizado	Grimsby Town	0 - 1	Watford
21 Oct 97	Finalizado	Watford	2 - 0	Fulham
18 Oct 97	Finalizado	Watford	0 - 1	Millwall
14 Oct 97	Finalizado	Bristol Rovers	1 - 2	Watford
04 Oct 97	Finalizado	Luton Town	0 - 4	Watford
27 Sep 97	Finalizado	Watford	1 - 1	York City
20 Sep 97	Finalizado	Gillingham	2 - 2	Watford
13 Sep 97	Finalizado	Watford	2 - 1	Chesterfield
07 Sep 97	Finalizado	Watford	2 - 1	Wycombe Wanderers
02 Sep 97	Finalizado	Plymouth Argyle	0 - 1	Watford
30 Ago 97	Finalizado	Preston North End	2 - 0	Watford
23 Ago 97	Finalizado	Watford	3 - 1	Brentford
16 Ago 97	Finalizado	Carlisle United	0 - 2	Watford
09 Ago 97	Finalizado	Watford	1 - 0	Burnley

Noticias del Watford

Ver últimas noticias

"Solo queda firmar"

BeSoccer - Viernes, 03 Julio 2015

0 254

Allan Nyom fichará en las próximas horas por el Watford.

"Solo firmaré después de leer los términos de la operación"

BeSoccer - Viernes, 03 Julio 2015

0 579

Holebas no sabía que la Roma estaba negociando con el Watford su traspaso y se ha enterado cuando los dos equipos lo han anunciado.

El Watford se queda con Matej Vydra

BeSoccer - Miércoles, 01 Julio 2015

0 322

El delantero centro fue uno de los artífices del ascenso del Watford a la Premier League.

"Entrenar en la Premier es un sueño hecho realidad"

BeSoccer - Miércoles, 01 Julio 2015

0 130

Quique Sánchez Flores ya es el nuevo técnico del Watford y dirigirá al equipo en esta nueva etapa en la Premier League.

El Sevilla hará una concentración de pretemporada de diez días en La Manga

BeSoccer - Lunes, 22 Junio 2015

0 189

La plantilla del Sevilla llevará a cabo una concentración de pretemporada de diez días de duración, del 10 al 20 de julio, en La Manga del Mar Menor (Murcia), anunció este viernes el club.

Ver más noticias del equipo»

Competiciones que juega

League One

Pos	Equipos		Pts
1		Watford	86
2		Bristol City	73
3		Grimsby Town	68
4		Fulham	64
5		Northampton	61
6		Gillingham	60
7		Chesterfield	55
8		Bristol Rovers	61
9		Oldham Athletic AFC	53
10		AFC Bournemouth	50
11		Wrexham AFC	57
12		Wycombe Wanderers	51
13		Preston North End	46
14		York City	49
15		Wigan Athletic	52
16		Carlisle United	41
17		Walsall	48
18		Blackpool	55
19		Burnley	46
20		Plymouth Argyle	46
21		Millwall	42
22		Luton Town	37
23		Brentford	43
24		Southend United	38

RIVALES EN EFL Cup

RIVALES EN League One

RIVALES EN FA Cup

USO DE MEMORIA

5,771,176 bytes

BENCHMARKS

Loading Time Base Classes	0.0022
Controller Execution Time ( Home / Category )	0.5625
Total Execution Time	0.5647

CADENA URL

/Watford-Fc/1998

GET DATOS

$_GET['/Watford-Fc/1998']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0125	SELECT type FROM routes WHERE alias = 'watford-fc'
0.0143	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 = 'Watford-Fc' AND l.year = 1998 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.0128	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=2743 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=2743 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=2743 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=2743 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2743 AND type_rel = 2
0.0143	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2743 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 (492,1161,1202,1491,1493) ORDER BY n.cover_points DESC, update_date DESC
0.0146	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 = '2743' AND l.year = 1998 ORDER BY l.year DESC,cat.coefficient DESC
0.0143	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 = '2743' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0282	(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 calendars1998 as c ON c.league_id = l.id WHERE (c.datateam1 = 2743 or c.datateam2 = 2743) AND l.year = 1998 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0286	(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 calendars1998 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 = 2743 or c.datateam2 = 2743) AND l.year = 1998 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0282	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1998 as c ON c.league_id = l.id INNER JOIN events1998 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 = 2743 or c.datateam2 = 2743) AND l.year = 1998)
0.0136	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=2743 AND l.year in (1997,1998,1999) 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 (56341,23237,14536,487) 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.0144	SELECT count(id) as num_players from rel_players WHERE league_id = 56341 AND teamId = 2743
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 487 AND teamId = 2743
0.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 14536 AND teamId = 2743
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 23237 AND teamId = 2743
0.0128	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2743' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2743' and rp.type = 4
0.0128	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2743' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127	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 events1998 e ON e.player_id = p.id AND e.league_id = 486 WHERE rp.league_id = 486 AND rp.teamId = 2743 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.0128	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 events1998 e ON e.player_id = p.id AND e.league_id = 486 WHERE rp.league_id = 486 AND rp.teamId = 2743 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 events1998 e ON e.player_id = p.id AND e.league_id = 486 WHERE rp.league_id = 486 AND rp.teamId = 2743 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 2743 AND rp.league_id = 486 AND l.year= 1998 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0135	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 = 2743 AND rp.league_id = 486 AND l.year= 1998 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0141	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 = 2743 AND rp.league_id = 486 AND l.year= 1998 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1

Resultados de Fútbol

Watford

Información sobre Watford

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

Partidos Amistosos

Championship - Play Offs Ascenso

League One

Trofeo Ciutat de Palma

Europa League

Partidos del Watford

Noticias del Watford

"Solo queda firmar"

"Solo firmaré después de leer los términos de la operación"

El Watford se queda con Matej Vydra

"Entrenar en la Premier es un sueño hecho realidad"

El Sevilla hará una concentración de pretemporada de diez días en La Manga

Watford

Selecciona un equipo

Competiciones que juega

League One

RIVALES EN EFL Cup

RIVALES EN League One

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