Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

« Temporada Anterior

Temporada 2004

Temporada Siguiente »

2003/2004

copa de la liga inglesa, carabao cup

EFL Cup 2004

Premier League

Ver jornada

Jornada 1

Ver jornada

Jornada 2

Ver jornada

Jornada 3

Ver jornada

Jornada 4

02 Dic 03	Arsenal	Arsenal - Wolves 2003-12-02T20:45:00 Emirates Stadium 5 - 1	Wolves	...
02 Dic 03	Southampton	Southampton - Portsmouth 2003-12-02T20:45:00 St. Mary's Stadium 2 - 0	Portsmouth	...
03 Dic 03	Aston Villa	Aston Villa - Crystal 2003-12-03T20:45:00 Villa Park 3 - 0	Crystal	...
03 Dic 03	Tottenham	Tottenham - Manchester 2003-12-03T20:45:00 Tottenham Hotspur Stadium 3 - 1	Manchester	...
03 Dic 03	Liverpool	Liverpool - Bolton 2003-12-03T21:00:00 Anfield 2 - 3	Bolton	...
03 Dic 03	Middlesbrou	Middlesbrou - Everton 2003-12-03T21:00:00 Riverside Stadium 0 - 0	Everton	...
03 Dic 03	Reading	Reading - Chelsea 2003-12-03T21:00:00 Madejski Stadium 0 - 1	Chelsea	...
03 Dic 03	West	West - Manchester 2003-12-03T21:00:00 The Hawthorns 2 - 0	Manchester	...

Ver jornada

Jornada 5

16 Dic 03	Bolton	Bolton - Southampton 2003-12-16T21:00:00 Reebok Stadium 1 - 0	Southampton	...
16 Dic 03	West	West - Arsenal 2003-12-16T21:00:00 The Hawthorns 0 - 2	Arsenal	...
17 Dic 03	Tottenham	Tottenham - Middlesbrou 2003-12-17T20:45:00 Tottenham Hotspur Stadium 1 - 1	Middlesbrou	...
17 Dic 03	Aston Villa	Aston Villa - Chelsea 2003-12-17T20:45:00 Villa Park 2 - 1	Chelsea	...

Ver jornada

Jornada 6

20 Ene 04	Arsenal	Arsenal - Middlesbrou 2004-01-20T20:45:00 Emirates Stadium 0 - 1	Middlesbrou	...
21 Ene 04	Bolton	Bolton - Aston Villa 2004-01-21T21:00:00 Reebok Stadium 5 - 2	Aston Villa	...
27 Ene 04	Aston Villa	Aston Villa - Bolton 2004-01-27T20:45:00 Villa Park 2 - 0	Bolton	...
03 Feb 04	Middlesbrou	Middlesbrou - Arsenal 2004-02-03T21:00:00 Riverside Stadium 2 - 1	Arsenal	...

Ver jornada

Jornada 7

29 Feb 04

Bolton

1 - 2

Middlesbrou

Equipos de esta liga

USO DE MEMORIA

4,977,864 bytes

BENCHMARKS

Loading Time Base Classes	0.0022
Controller Execution Time ( Home / Category )	0.3209
Total Execution Time	0.3231

CADENA URL

/capital_one_cup2004/grupo0/calendario

GET DATOS

$_GET['/capital_one_cup2004/grupo0/calendario']

POST DATOS

No hay datos POST existentes

CONSULTAS (17)

0.0105	SELECT type FROM routes WHERE alias = 'capital_one_cup2004'
0.0212	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'capital_one_cup' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0110	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 23218 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114	SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2004 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 23218 ORDER BY round ASC
0.0105	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 00:18:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 00:18:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 00:18:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 00:18:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2004
0.0120	SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (23218) AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0109	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (23218) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (37832,44128,489,524,551,12599,586,9458,9470,9595) ORDER BY rp.in_squad = 1 DESC
0.0109	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2004
0.0188	SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (23218) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0137	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (23218) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (398,248716,156,191,222,297,523,599,608,2832) ORDER BY rp.in_squad = 1 DESC
0.0121	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2004
0.0180	SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (23218) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0116	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (23218) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (43,398,3676,9338,12369,12752,12975,45249,47581,67171) ORDER BY rp.in_squad = 1 DESC


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

12 Ago 03	Barnsley	Barnsley - Blackpool 2003-08-12T20:45:00 Oakwell Stadium 1 - 2	Blackpool	...
12 Ago 03	Bradford	Bradford - Darlington 2003-08-12T20:45:00 Coral Windows Stadium 0 - 0	Darlington	...
12 Ago 03	Bristol	Bristol - Brighton 2003-08-12T20:45:00 Memorial Stadium 0 - 1	Brighton	...
12 Ago 03	Cambridge	Cambridge - Gillingham 2003-08-12T20:45:00 The R Costings Abbey Stadium 1 - 2	Gillingham	...
12 Ago 03	Cardiff	Cardiff - Leyton 2003-08-12T20:45:00 Cardiff City Stadium 4 - 1	Leyton	...
12 Ago 03	Cheltenham	Cheltenham - Queens Park 2003-08-12T20:45:00 Whaddon Road 1 - 2	Queens Park	...
12 Ago 03	Chesterfiel	Chesterfiel - Burnley 2003-08-12T20:45:00 Proact Stadium 0 - 0	Burnley	...
12 Ago 03	Colchester	Colchester - Plymouth 2003-08-12T20:45:00 Weston Homes Community Stadium 2 - 1	Plymouth	...
12 Ago 03	Crewe	Crewe - Wrexham 2003-08-12T20:45:00 Alexandra Stadium 2 - 0	Wrexham	...
12 Ago 03	Doncaster	Doncaster - Grimsby 2003-08-12T20:45:00 Keepmoat Stadium 3 - 2	Grimsby	...
12 Ago 03	Huddersfiel	Huddersfiel - Derby 2003-08-12T20:45:00 The John Smith's Stadium 2 - 1	Derby	...
12 Ago 03	Lincoln	Lincoln - Stockport 2003-08-12T20:45:00 Sincil Bank Stadium 0 - 1	Stockport	...
12 Ago 03	Luton Town	Luton Town - Yeovil Town 2003-08-12T20:45:00 Kenilworth Road Stadium 4 - 1	Yeovil Town	...
12 Ago 03	Macclesfiel	Macclesfiel - Sheffield 2003-08-12T20:45:00 Moss Rose Ground 1 - 2	Sheffield	...
12 Ago 03	Millwall	Millwall - Oxford 2003-08-12T20:45:00 The Den 0 - 1	Oxford	...
12 Ago 03	Northampton	Northampton - Norwich 2003-08-12T20:45:00 Sixfields Stadium 1 - 0	Norwich	...
12 Ago 03	Port Vale	Port Vale - Nottingham 2003-08-12T20:45:00 Vale Park 0 - 0	Nottingham	...
12 Ago 03	Preston	Preston - Notts 2003-08-12T20:45:00 Deepdale Stadium 0 - 0	Notts	...
12 Ago 03	Rotherham	Rotherham - York City 2003-08-12T20:45:00 New York Stadium 2 - 1	York City	...
12 Ago 03	Scunthorpe	Scunthorpe - Oldham 2003-08-12T20:45:00 Glanford Park 2 - 1	Oldham	...
12 Ago 03	Southend	Southend - Swindon 2003-08-12T20:45:00 Roots Hall Stadium 2 - 3	Swindon	...
12 Ago 03	Torquay	Torquay - Crystal 2003-08-12T20:45:00 Plainmoor Ground 1 - 1	Crystal	...
12 Ago 03	Tranmere	Tranmere - Bury 2003-08-12T20:45:00 Prenton Park 1 - 0	Bury	...
12 Ago 03	Walsall	Walsall - Carlisle 2003-08-12T20:45:00 The Banks's Stadium 2 - 1	Carlisle	...
12 Ago 03	Watford	Watford - Bournemouth 2003-08-12T20:45:00 Vicarage Road Stadium 1 - 0	Bournemouth	...
12 Ago 03	West	West - Brentford 2003-08-12T20:45:00 The Hawthorns 4 - 0	Brentford	...
12 Ago 03	Wigan	Wigan - Hull City 2003-08-12T20:45:00 The DW Stadium 2 - 0	Hull City	...
12 Ago 03	Wycombe	Wycombe - Wimbledon 2003-08-12T20:45:00 Adams Park 2 - 0	Wimbledon	...
13 Ago 03	Boston	Boston - Reading 2003-08-13T20:45:00 The Jakemans Stadium 1 - 3	Reading	...
13 Ago 03	Bristol	Bristol - Swansea 2003-08-13T20:45:00 Ashton Gate Stadium 4 - 1	Swansea	...
13 Ago 03	Coventry	Coventry - Peterboroug 2003-08-13T20:45:00 City of Coventry Stadium 2 - 0	Peterboroug	...
13 Ago 03	Ipswich	Ipswich - Kidderminst 2003-08-13T20:45:00 Portman Road Stadium 1 - 0	Kidderminst	...
13 Ago 03	Mansfield	Mansfield - Sunderland 2003-08-13T20:45:00 One Call Stadium 1 - 2	Sunderland	...
13 Ago 03	Sheffield	Sheffield - Hartlepool 2003-08-13T20:45:00 Hillsborough Stadium 2 - 2	Hartlepool	...
13 Ago 03	West Ham	West Ham - Rushden 2003-08-13T20:45:00 London Stadium 3 - 1	Rushden	...
19 Ago 03	Stoke City	Stoke City - Rochdale 2003-08-19T20:45:00 bet365 Stadium 2 - 1	Rochdale	...

23 Sep 03	Scunthorpe	Scunthorpe - Burnley 2003-09-23T20:30:00 Glanford Park 2 - 3	Burnley	...
23 Sep 03	Blackpool	Blackpool - Birmingham 2003-09-23T20:45:00 Bloomfield Road 1 - 0	Birmingham	...
23 Sep 03	Bristol	Bristol - Watford 2003-09-23T20:45:00 Ashton Gate Stadium 1 - 0	Watford	...
23 Sep 03	Cardiff	Cardiff - West Ham 2003-09-23T20:45:00 Cardiff City Stadium 2 - 3	West Ham	...
23 Sep 03	Hartlepool	Hartlepool - West 2003-09-23T20:45:00 Victoria Park 1 - 2	West	...
23 Sep 03	Leicester	Leicester - Crewe 2003-09-23T20:45:00 King Power Stadium 1 - 0	Crewe	...
23 Sep 03	Notts	Notts - Ipswich 2003-09-23T20:45:00 Meadow Lane Stadium 2 - 1	Ipswich	...
23 Sep 03	Portsmouth	Portsmouth - Northampton 2003-09-23T20:45:00 Fratton Park 5 - 2	Northampton	...
23 Sep 03	Rotherham	Rotherham - Colchester 2003-09-23T20:45:00 New York Stadium 1 - 0	Colchester	...
23 Sep 03	Sheffield	Sheffield - Queens Park 2003-09-23T20:45:00 Bramall Lane 0 - 2	Queens Park	...
23 Sep 03	Stoke City	Stoke City - Gillingham 2003-09-23T20:45:00 bet365 Stadium 0 - 2	Gillingham	...
23 Sep 03	Tranmere	Tranmere - Nottingham 2003-09-23T20:45:00 Prenton Park 0 - 0	Nottingham	...
23 Sep 03	Wolves	Wolves - Darlington 2003-09-23T20:45:00 Molineux Stadium 2 - 0	Darlington	...
23 Sep 03	Wycombe	Wycombe - Aston Villa 2003-09-23T20:45:00 Adams Park 0 - 5	Aston Villa	...
23 Sep 03	Crystal	Crystal - Doncaster 2003-09-23T21:00:00 Selhurst Park 2 - 1	Doncaster	...
23 Sep 03	Charlton	Charlton - Luton Town 2003-09-23T21:00:00 The Valley 4 - 4	Luton Town	...
23 Sep 03	Sunderland	Sunderland - Huddersfiel 2003-09-23T21:00:00 Stadium of Light 2 - 4	Huddersfiel	...
23 Sep 03	Wigan	Wigan - Fulham 2003-09-23T21:00:00 The DW Stadium 1 - 0	Fulham	...
24 Sep 03	Coventry	Coventry - Tottenham 2003-09-24T20:45:00 City of Coventry Stadium 0 - 3	Tottenham	...
24 Sep 03	Leeds	Leeds - Swindon 2003-09-24T20:45:00 Elland Road 2 - 2	Swindon	...
24 Sep 03	Oxford	Oxford - Reading 2003-09-24T20:45:00 The Kassam Stadium 1 - 3	Reading	...
24 Sep 03	Bolton	Bolton - Walsall 2003-09-24T21:00:00 Reebok Stadium 3 - 1	Walsall	...
24 Sep 03	Everton	Everton - Stockport 2003-09-24T21:00:00 Goodison Park 3 - 0	Stockport	...
24 Sep 03	Middlesbrou	Middlesbrou - Brighton 2003-09-24T21:00:00 Riverside Stadium 1 - 0	Brighton	...

28 Oct 03	Arsenal	Arsenal - Rotherham 2003-10-28T20:45:00 Emirates Stadium 1 - 1	Rotherham	...
28 Oct 03	Blackpool	Blackpool - Crystal 2003-10-28T20:45:00 Bloomfield Road 1 - 3	Crystal	...
28 Oct 03	Bristol	Bristol - Southampton 2003-10-28T20:45:00 Ashton Gate Stadium 0 - 3	Southampton	...
28 Oct 03	Leeds	Leeds - Manchester 2003-10-28T20:45:00 Elland Road 2 - 3	Manchester	...
28 Oct 03	Queens Park	Queens Park - Manchester 2003-10-28T20:45:00 Loftus Road 0 - 3	Manchester	...
28 Oct 03	Wolves	Wolves - Burnley 2003-10-28T20:45:00 Molineux Stadium 2 - 0	Burnley	...
28 Oct 03	Bolton	Bolton - Gillingham 2003-10-28T21:00:00 Reebok Stadium 2 - 0	Gillingham	...
28 Oct 03	Reading	Reading - Huddersfiel 2003-10-28T21:00:00 Madejski Stadium 1 - 0	Huddersfiel	...
29 Oct 03	Aston Villa	Aston Villa - Leicester 2003-10-29T20:45:00 Villa Park 1 - 0	Leicester	...
29 Oct 03	Chelsea	Chelsea - Notts 2003-10-29T20:45:00 Stamford Bridge 4 - 2	Notts	...
29 Oct 03	Newcastle	Newcastle - West 2003-10-29T20:45:00 St. James' Park 1 - 2	West	...
29 Oct 03	Nottingham	Nottingham - Portsmouth 2003-10-29T20:45:00 The City Ground 2 - 4	Portsmouth	...
29 Oct 03	Tottenham	Tottenham - West Ham 2003-10-29T20:45:00 Tottenham Hotspur Stadium 1 - 0	West Ham	...
29 Oct 03	Blackburn	Blackburn - Liverpool 2003-10-29T21:00:00 Ewood Park 3 - 4	Liverpool	...
29 Oct 03	Everton	Everton - Charlton 2003-10-29T21:00:00 Goodison Park 1 - 0	Charlton	...
29 Oct 03	Wigan	Wigan - Middlesbrou 2003-10-29T21:00:00 The DW Stadium 1 - 2	Middlesbrou	...