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 2008

Temporada Siguiente »

2007/2008

copa de la liga inglesa, carabao cup

EFL Cup 2008

Premier League

Ver jornada

Jornada 1

Ver jornada

Jornada 2

Ver jornada

Jornada 3

Ver jornada

Jornada 4

30 Oct 07	Coventry	Coventry - West Ham 2007-10-30T20:45:00 City of Coventry Stadium 1 - 2	West Ham	...
31 Oct 07	Chelsea	Chelsea - Leicester 2007-10-31T20:45:00 Stamford Bridge 4 - 3	Leicester	...
31 Oct 07	Luton Town	Luton Town - Everton 2007-10-31T20:45:00 Kenilworth Road Stadium 0 - 1	Everton	...
31 Oct 07	Portsmouth	Portsmouth - Blackburn 2007-10-31T20:45:00 Fratton Park 1 - 2	Blackburn	...
31 Oct 07	Sheffield	Sheffield - Arsenal 2007-10-31T20:45:00 Bramall Lane 0 - 3	Arsenal	...
31 Oct 07	Bolton	Bolton - Manchester 2007-10-31T21:00:00 Reebok Stadium 0 - 1	Manchester	...
31 Oct 07	Liverpool	Liverpool - Cardiff 2007-10-31T21:00:00 Anfield 2 - 1	Cardiff	...
31 Oct 07	Tottenham	Tottenham - Blackpool 2007-10-31T21:00:00 Tottenham Hotspur Stadium 2 - 0	Blackpool	...

Ver jornada

Jornada 5

12 Dic 07	West Ham	West Ham - Everton 2007-12-12T20:45:00 London Stadium 1 - 2	Everton	...
18 Dic 07	Manchester	Manchester - Tottenham 2007-12-18T20:45:00 Etihad Stadium 0 - 2	Tottenham	...
18 Dic 07	Blackburn	Blackburn - Arsenal 2007-12-18T21:00:00 Ewood Park 2 - 3	Arsenal	...
19 Dic 07	Chelsea	Chelsea - Liverpool 2007-12-19T20:45:00 Stamford Bridge 2 - 0	Liverpool	...

Ver jornada

Jornada 6

08 Ene 08	Chelsea	Chelsea - Everton 2008-01-08T20:45:00 Stamford Bridge 2 - 1	Everton	...
23 Ene 08	Everton	Everton - Chelsea 2008-01-23T21:00:00 Goodison Park 0 - 1	Chelsea	...
09 Ene 08	Arsenal	Arsenal - Tottenham 2008-01-09T20:45:00 Emirates Stadium 1 - 1	Tottenham	...
22 Ene 08	Tottenham	Tottenham - Arsenal 2008-01-22T21:00:00 Tottenham Hotspur Stadium 5 - 1	Arsenal	...

Ver jornada

Jornada 7

24 Feb 08

Tottenham

2 - 1

Chelsea

Equipos de esta liga

USO DE MEMORIA

4,964,576 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1118
Total Execution Time	0.1138

CADENA URL

/capital_one_cup2008/grupo0/calendario

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (17)

0.0018	SELECT type FROM routes WHERE alias = 'capital_one_cup2008'
0.0038	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 = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0025	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 = 20545 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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 calendars2008 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 20545 ORDER BY round ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:29:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 21:29:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 21:29:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:29:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2008
0.0033	SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (20545) 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.0021	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 (20545) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (382,27165,66860,594,9749,12865,29366,478300,214,315) ORDER BY rp.in_squad = 1 DESC
0.0021	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2008
0.0032	SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (20545) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0021	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 (20545) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (369,391,468,77,142,149,241,299,315,335) ORDER BY rp.in_squad = 1 DESC
0.0035	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2008
0.0110	SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (20545) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0044	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 (20545) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (142,241,315,522,10693,27219,29170,86509,308815,547103) 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

16 Ago 07	Rotherham	Rotherham - Sheffield 2007-08-16T20:45:00 New York Stadium 1 - 3	Sheffield	...
15 Ago 07	Wolves	Wolves - Bradford 2007-08-15T20:45:00 Molineux Stadium 2 - 1	Bradford	...
15 Ago 07	Crewe	Crewe - Hull City 2007-08-15T20:45:00 Alexandra Stadium 0 - 3	Hull City	...
14 Ago 07	West	West - Bournemouth 2007-08-14T20:45:00 The Hawthorns 1 - 0	Bournemouth	...
14 Ago 07	Watford	Watford - Gillingham 2007-08-14T20:45:00 Vicarage Road Stadium 3 - 0	Gillingham	...
14 Ago 07	Swindon	Swindon - Charlton 2007-08-14T20:45:00 County Ground 0 - 2	Charlton	...
14 Ago 07	Swansea	Swansea - Walsall 2007-08-14T20:45:00 Liberty Stadium 2 - 0	Walsall	...
14 Ago 07	Stockport	Stockport - Tranmere 2007-08-14T20:45:00 Edgeley Park 1 - 0	Tranmere	...
14 Ago 07	Southend	Southend - Cheltenham 2007-08-14T20:45:00 Roots Hall Stadium 4 - 1	Cheltenham	...
14 Ago 07	Shrewsbury	Shrewsbury - Colchester 2007-08-14T20:45:00 Greenhous Meadow 1 - 0	Colchester	...
14 Ago 07	Sheffield	Sheffield - Chesterfiel 2007-08-14T20:45:00 Bramall Lane 3 - 1	Chesterfiel	...
14 Ago 07	Scunthorpe	Scunthorpe - Hartlepool 2007-08-14T20:30:00 Glanford Park 1 - 2	Hartlepool	...
14 Ago 07	Rochdale	Rochdale - Stoke City 2007-08-14T20:45:00 Spotland Stadium 2 - 2	Stoke City	...
14 Ago 07	Queens Park	Queens Park - Leyton 2007-08-14T20:45:00 Loftus Road 1 - 2	Leyton	...
14 Ago 07	Preston	Preston - Morecambe 2007-08-14T20:45:00 Deepdale Stadium 1 - 2	Morecambe	...
14 Ago 07	Port Vale	Port Vale - Wrexham 2007-08-14T20:45:00 Vale Park 1 - 1	Wrexham	...
14 Ago 07	Plymouth	Plymouth - Wycombe 2007-08-14T20:45:00 Home Park 2 - 1	Wycombe	...
14 Ago 07	Oldham	Oldham - Mansfield 2007-08-14T20:45:00 Boundary Park 4 - 1	Mansfield	...
14 Ago 07	Norwich	Norwich - Barnet 2007-08-14T20:45:00 Carrow Road 5 - 2	Barnet	...
14 Ago 07	Northampton	Northampton - Millwall 2007-08-14T20:45:00 Sixfields Stadium 2 - 0	Millwall	...
14 Ago 07	Milton	Milton - Ipswich 2007-08-14T20:45:00 Stadium mk 3 - 3	Ipswich	...
14 Ago 07	Macclesfiel	Macclesfiel - Leeds 2007-08-14T20:45:00 Moss Rose Ground 0 - 1	Leeds	...
14 Ago 07	Hereford	Hereford - Yeovil Town 2007-08-14T20:45:00 Edgar Street Athletic Ground 4 - 1	Yeovil Town	...
14 Ago 07	Grimsby	Grimsby - Burnley 2007-08-14T20:45:00 Blundell Park 1 - 1	Burnley	...
14 Ago 07	Doncaster	Doncaster - Lincoln 2007-08-14T20:45:00 Keepmoat Stadium 4 - 1	Lincoln	...
14 Ago 07	Dagenham	Dagenham - Luton Town 2007-08-14T20:45:00 London Borough of Barking & Dagenham Stadium 1 - 2	Luton Town	...
14 Ago 07	Coventry	Coventry - Notts 2007-08-14T20:45:00 City of Coventry Stadium 3 - 0	Notts	...
14 Ago 07	Chester	Chester - Nottingham 2007-08-14T20:45:00 Deva Stadium 0 - 0	Nottingham	...
14 Ago 07	Cardiff	Cardiff - Brighton 2007-08-14T20:45:00 Cardiff City Stadium 1 - 0	Brighton	...
14 Ago 07	Bury	Bury - Carlisle 2007-08-14T20:45:00 Gigg Lane 0 - 1	Carlisle	...
14 Ago 07	Bristol	Bristol - Crystal 2007-08-14T20:45:00 Memorial Stadium 1 - 1	Crystal	...
14 Ago 07	Brentford	Brentford - Bristol 2007-08-14T20:45:00 Griffin Park 0 - 3	Bristol	...
14 Ago 07	Blackpool	Blackpool - Huddersfiel 2007-08-14T20:45:00 Bloomfield Road 1 - 0	Huddersfiel	...
14 Ago 07	Barnsley	Barnsley - Darlington 2007-08-14T20:45:00 Oakwell Stadium 2 - 1	Darlington	...
14 Ago 07	Accrington	Accrington - Leicester 2007-08-14T20:45:00 Store First Stadium 0 - 1	Leicester	...
13 Ago 07	Peterboroug	Peterboroug - Southampton 2007-08-13T20:45:00 London Road Stadium 2 - 1	Southampton	...

18 Sep 07	Nottingham	Nottingham - Leicester 2007-09-18T20:45:00 The City Ground 2 - 3	Leicester	...
29 Ago 07	Middlesbrou	Middlesbrou - Northampton 2007-08-29T21:00:00 Riverside Stadium 2 - 0	Northampton	...
29 Ago 07	Newcastle	Newcastle - Barnsley 2007-08-29T20:45:00 St. James' Park 2 - 0	Barnsley	...
29 Ago 07	Bristol	Bristol - Manchester 2007-08-29T20:45:00 Ashton Gate Stadium 1 - 2	Manchester	1
28 Ago 07	Charlton	Charlton - Stockport 2007-08-28T21:00:00 The Valley 4 - 3	Stockport	...
28 Ago 07	Wrexham	Wrexham - Aston Villa 2007-08-28T20:45:00 Racecourse Ground 0 - 5	Aston Villa	...
28 Ago 07	Wolves	Wolves - Morecambe 2007-08-28T20:45:00 Molineux Stadium 1 - 3	Morecambe	...
28 Ago 07	Wigan	Wigan - Hull City 2007-08-28T20:45:00 The DW Stadium 0 - 1	Hull City	...
28 Ago 07	Swansea	Swansea - Reading 2007-08-28T20:45:00 Liberty Stadium 0 - 1	Reading	...
28 Ago 07	Southend	Southend - Watford 2007-08-28T20:45:00 Roots Hall Stadium 2 - 0	Watford	...
28 Ago 07	Shrewsbury	Shrewsbury - Fulham 2007-08-28T20:45:00 Greenhous Meadow 0 - 1	Fulham	...
28 Ago 07	Sheffield	Sheffield - Hartlepool 2007-08-28T20:45:00 Hillsborough Stadium 2 - 1	Hartlepool	...
28 Ago 07	Rochdale	Rochdale - Norwich 2007-08-28T20:45:00 Spotland Stadium 1 - 1	Norwich	...
28 Ago 07	Portsmouth	Portsmouth - Leeds 2007-08-28T20:45:00 Fratton Park 3 - 0	Leeds	...
28 Ago 07	Plymouth	Plymouth - Doncaster 2007-08-28T20:45:00 Home Park 2 - 0	Doncaster	...
28 Ago 07	Peterboroug	Peterboroug - West 2007-08-28T20:45:00 London Road Stadium 0 - 2	West	...
28 Ago 07	Milton	Milton - Sheffield 2007-08-28T20:45:00 Stadium mk 2 - 3	Sheffield	...
28 Ago 07	Luton Town	Luton Town - Sunderland 2007-08-28T20:45:00 Kenilworth Road Stadium 3 - 0	Sunderland	...
28 Ago 07	Derby	Derby - Blackpool 2007-08-28T20:45:00 iPro Stadium 2 - 2	Blackpool	...
28 Ago 07	Cardiff	Cardiff - Leyton 2007-08-28T20:45:00 Cardiff City Stadium 1 - 0	Leyton	...
28 Ago 07	Burnley	Burnley - Oldham 2007-08-28T20:45:00 Turf Moor 3 - 0	Oldham	...
28 Ago 07	Bristol	Bristol - West Ham 2007-08-28T20:45:00 Memorial Stadium 1 - 2	West Ham	...
28 Ago 07	Birmingham	Birmingham - Hereford 2007-08-28T20:45:00 St. Andrew's Stadium 2 - 1	Hereford	...
28 Ago 07	Carlisle	Carlisle - Coventry 2007-08-28T20:45:00 Brunton Park 0 - 2	Coventry	...

26 Sep 07	Manchester	Manchester - Coventry 2007-09-26T21:00:00 Old Trafford 0 - 2	Coventry	...
26 Sep 07	Fulham	Fulham - Bolton 2007-09-26T21:00:00 Craven Cottage 1 - 2	Bolton	...
26 Sep 07	Blackburn	Blackburn - Birmingham 2007-09-26T21:00:00 Ewood Park 3 - 0	Birmingham	...
26 Sep 07	Aston Villa	Aston Villa - Leicester 2007-09-26T20:45:00 Villa Park 0 - 1	Leicester	...
26 Sep 07	West Ham	West Ham - Plymouth 2007-09-26T20:45:00 London Stadium 1 - 0	Plymouth	...
26 Sep 07	Sheffield	Sheffield - Everton 2007-09-26T20:45:00 Hillsborough Stadium 0 - 3	Everton	...
26 Sep 07	Hull City	Hull City - Chelsea 2007-09-26T20:45:00 Kingston Communications Stadium 0 - 4	Chelsea	...
25 Sep 07	West	West - Cardiff 2007-09-25T20:45:00 The Hawthorns 2 - 4	Cardiff	...
25 Sep 07	Sheffield	Sheffield - Morecambe 2007-09-25T20:45:00 Bramall Lane 5 - 0	Morecambe	...
25 Sep 07	Reading	Reading - Liverpool 2007-09-25T20:45:00 Madejski Stadium 2 - 4	Liverpool	...
25 Sep 07	Manchester	Manchester - Norwich 2007-09-25T20:45:00 Etihad Stadium 1 - 0	Norwich	...
25 Sep 07	Luton Town	Luton Town - Charlton 2007-09-25T20:45:00 Kenilworth Road Stadium 3 - 1	Charlton	...
25 Sep 07	Burnley	Burnley - Portsmouth 2007-09-25T20:45:00 Turf Moor 0 - 1	Portsmouth	...
25 Sep 07	Blackpool	Blackpool - Southend 2007-09-25T20:45:00 Bloomfield Road 2 - 1	Southend	...
25 Sep 07	Arsenal	Arsenal - Newcastle 2007-09-25T20:45:00 Emirates Stadium 2 - 0	Newcastle	...
26 Sep 07	Tottenham	Tottenham - Middlesbrou 2007-09-26T21:00:00 Tottenham Hotspur Stadium 2 - 0	Middlesbrou	...