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 2009

Temporada Siguiente »

2008/2009

copa de su majestad el rey, copa del rey, campeonato de españa, la copa de españa,

Copa del Rey 2009

Primera División

Ver jornada

Jornada 1

Ver jornada

Jornada 2

Ver jornada

Jornada 3

08 Oct 08	Portugalete	Portugalete - Benito 2008-10-08T20:00:00 La Florida 2 - 0	Benito	...
08 Oct 08	Real Unión	Real Unión - Barakaldo 2008-10-08T20:15:00 Stadium Gal 2 - 1	Barakaldo	...
08 Oct 08	Celta	Celta - Real 2008-10-08T20:30:00 Abanca Balaídos 2 - 0	Real	...
08 Oct 08	Ponferradin	Ponferradin - Universidad 2008-10-08T20:30:00 Municipal El Toralín 1 - 1	Universidad	1
08 Oct 08	Granada 74	Granada 74 - Benidorm 2008-10-08T21:00:00 No disponible 0 - 2	Benidorm	...
08 Oct 08	Salamanca	Salamanca - Castellón 2008-10-08T21:00:00 Helmántico 0 - 1	Castellón	...
08 Oct 08	Orihuela	Orihuela - CD Toledo 2008-10-08T00:00:00 Municipal Los Arcos 3 - 1	CD Toledo	...
08 Oct 08	Rayo	Rayo - Albacete 2008-10-08T21:00:00 Vallecas 2 - 1	Albacete	...
08 Oct 08	UD Melilla	UD Melilla - Poli Ejido 2008-10-08T21:15:00 Municipal Álvarez Claro 2 - 3	Poli Ejido	...
08 Oct 08	Hércules	Hércules - Girona 2008-10-08T21:30:00 José Rico Pérez 1 - 0	Girona	...
09 Oct 08	Elche	Elche - Tenerife 2008-10-09T21:30:00 Martínez Valero 1 - 1	Tenerife	...

Ver jornada

Jornada 4

Ver jornada

Jornada 5

Ver jornada

Jornada 6

21 Ene 09	Valencia	Valencia - Sevilla 2009-01-21T21:00:00 Mestalla 3 - 2	Sevilla	...
29 Ene 09	Sevilla	Sevilla - Valencia 2009-01-29T20:00:00 Ramón Sánchez Pizjuán 2 - 1	Valencia	...
21 Ene 09	Espanyol	Espanyol - Barcelona 2009-01-21T22:00:00 RCDE Stadium 0 - 0	Barcelona	...
29 Ene 09	Barcelona	Barcelona - Espanyol 2009-01-29T21:30:00 Spotify Camp Nou 3 - 2	Espanyol	...
22 Ene 09	Athletic	Athletic - Real 2009-01-22T20:00:00 San Mamés 0 - 0	Real	...
28 Ene 09	Real	Real - Athletic 2009-01-28T21:00:00 El Molinón-Enrique Castro Quini 1 - 2	Athletic	...
22 Ene 09	Mallorca	Mallorca - Real Betis 2009-01-22T21:00:00 Visit Mallora Estadi 1 - 0	Real Betis	...
28 Ene 09	Real Betis	Real Betis - Mallorca 2009-01-28T21:00:00 Benito Villamarín 0 - 0	Mallorca	...

Ver jornada

Jornada 7

04 Feb 09	Sevilla	Sevilla - Athletic 2009-02-04T21:15:00 Ramón Sánchez Pizjuán 2 - 1	Athletic	...
04 Mar 09	Athletic	Athletic - Sevilla 2009-03-04T20:00:00 San Mamés 3 - 0	Sevilla	1
05 Feb 09	Barcelona	Barcelona - Mallorca 2009-02-05T21:30:00 Spotify Camp Nou 2 - 0	Mallorca	...
04 Mar 09	Mallorca	Mallorca - Barcelona 2009-03-04T22:00:00 Visit Mallora Estadi 1 - 1	Barcelona	...

Ver jornada

Jornada 8

13 May 09

Athletic

1 - 4

Barcelona

Equipos de esta liga

USO DE MEMORIA

5,138,960 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.4377
Total Execution Time	0.4396

CADENA URL

/copa_del_rey2009/grupo0/calendario

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (17)

0.0105	SELECT type FROM routes WHERE alias = 'copa_del_rey2009'
0.1212	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_del_rey' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 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 = 805 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 calendars2009 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 805 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-05-02 01:21:50' 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=2 AND last_update > '2024-05-02 01:21:51' 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-05-02 01:21:51' 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=3 AND last_update > '2024-05-02 01:21:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0117	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2009
0.0153	SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (805) 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.0110	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 (805) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (23487,30563,23569,23568,69420,23507,27025,29511,29980,23347) ORDER BY rp.in_squad = 1 DESC
0.0115	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2009
0.0253	SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (805) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0122	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 (805) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (8497,29497,29959,1581,3418,7280,7380,13281,23359,23378) ORDER BY rp.in_squad = 1 DESC
0.0157	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2009
0.0128	SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (805) AND (e.action = 3 or e.action = 4) 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 (805) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (1410,7382,11072,11090,13321,19387,23333,23354,23359,23376) 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

23 Ago 08	Ejea	Ejea - UD Alzira 2008-08-23T18:00:00 Estadio Municipal de Luchán 1 - 3	UD Alzira	...
25 Ago 08	UD Melilla	UD Melilla - AgD Ceuta 2008-08-25T20:30:00 Municipal Álvarez Claro 2 - 1	AgD Ceuta	...
26 Ago 08	Real Oviedo	Real Oviedo - Pontevedra 2008-08-26T00:00:00 Carlos Tartiere 2 - 0	Pontevedra	...
26 Ago 08	CD Toledo	CD Toledo - Granada 2008-08-26T00:00:00 Municipal Salto del Caballo 3 - 1	Granada	...
27 Ago 08	Izarra	Izarra - CF Gavá 2008-08-27T18:30:00 Merkatondoa 0 - 1	CF Gavá	...
27 Ago 08	Sant Andreu	Sant Andreu - Mirandés 2008-08-27T19:00:00 Narcís Sala 2 - 1	Mirandés	...
27 Ago 08	Ciudad	Ciudad - Portugalete 2008-08-27T00:00:00 No disponible 0 - 1	Portugalete	...
27 Ago 08	Barakaldo	Barakaldo - Gimnástica 2008-08-27T20:30:00 Nuevo Lasesarre 2 - 0	Gimnástica	...
27 Ago 08	CD Lugo	CD Lugo - Real Unión 2008-08-27T20:30:00 Estadio Anxo Carro 0 - 3	Real Unión	...
27 Ago 08	Ponferradin	Ponferradin - Racing 2008-08-27T20:30:00 Municipal El Toralín 1 - 0	Racing	...
27 Ago 08	Orihuela	Orihuela - Atlético 2008-08-27T20:30:00 Municipal Los Arcos 2 - 0	Atlético	...
27 Ago 08	Roquetas	Roquetas - Atlético 2008-08-27T21:00:00 No disponible 1 - 0	Atlético	...
27 Ago 08	Fernando	Fernando - Poli Ejido 2008-08-27T21:00:00 No disponible 0 - 3	Poli Ejido	...
27 Ago 08	Granadilla	Granadilla - Benito 2008-08-27T21:30:00 Francisco Suárez 0 - 1	Benito	...
27 Ago 08	Universidad	Universidad - Ciempozuelo 2008-08-27T21:30:00 Alfonso Silva 1 - 0	Ciempozuelo	...
27 Ago 08	Conquense	Conquense - Cádiz 2008-08-27T21:45:00 Municipal La Fuensanta 3 - 2	Cádiz	1
27 Ago 08	CD Linares	CD Linares - Écija 2008-08-27T22:00:00 No disponible 1 - 2	Écija	...
28 Ago 08	CD Alfaro	CD Alfaro - Águilas 2008-08-28T21:00:00 La Molineta 1 - 0	Águilas	...

03 Sep 08	Real	Real - Real 2008-09-03T20:00:00 Anoeta 1 - 0	Real	...
03 Sep 08	Huesca	Huesca - Rayo 2008-09-03T20:15:00 El Alcoraz 1 - 3	Rayo	...
03 Sep 08	Real Unión	Real Unión - Sant Andreu 2008-09-03T20:15:00 Stadium Gal 2 - 1	Sant Andreu	...
03 Sep 08	Real Oviedo	Real Oviedo - Ponferradin 2008-09-03T00:00:00 Carlos Tartiere 2 - 3	Ponferradin	...
03 Sep 08	Barakaldo	Barakaldo - Roquetas 2008-09-03T20:30:00 Nuevo Lasesarre 1 - 0	Roquetas	...
03 Sep 08	Orihuela	Orihuela - Fuerteventu 2008-09-03T20:30:00 Municipal Los Arcos 1 - 0	Fuerteventu	...
03 Sep 08	CD Toledo	CD Toledo - Zamora 2008-09-03T20:30:00 Municipal Salto del Caballo 1 - 0	Zamora	...
03 Sep 08	Salamanca	Salamanca - Las Palmas 2008-09-03T20:45:00 Helmántico 2 - 1	Las Palmas	...
03 Sep 08	Benidorm	Benidorm - Lemona 2008-09-03T21:00:00 Guillermo Amor 4 - 2	Lemona	...
03 Sep 08	Castellón	Castellón - Eibar 2008-09-03T21:00:00 Municipal de Castalia 1 - 0	Eibar	...
03 Sep 08	Elche	Elche - Deportivo 2008-09-03T21:00:00 Martínez Valero 2 - 0	Deportivo	...
03 Sep 08	Gimnàstic	Gimnàstic - Girona 2008-09-03T21:00:00 Nou Estadi 0 - 2	Girona	...
03 Sep 08	CD Alfaro	CD Alfaro - Benito 2008-09-03T00:00:00 La Molineta 1 - 2	Benito	...
03 Sep 08	UD Alzira	UD Alzira - Granada 74 2008-09-03T21:00:00 Luis Suñer Picó 0 - 0	Granada 74	...
03 Sep 08	Xerez CD	Xerez CD - Real Murcia 2008-09-03T21:00:00 Estadio de la Juventud 1 - 1	Real Murcia	...
03 Sep 08	Hércules	Hércules - Levante 2008-09-03T21:30:00 José Rico Pérez 2 - 1	Levante	...
03 Sep 08	Écija	Écija - Portugalete 2008-09-03T21:30:00 Municipal San Pablo 0 - 1	Portugalete	...
03 Sep 08	Poli Ejido	Poli Ejido - Conquense 2008-09-03T21:30:00 Municipal De Santo Domingo 2 - 0	Conquense	...
03 Sep 08	UD Melilla	UD Melilla - Mérida UD 2008-09-03T21:50:00 Municipal Álvarez Claro 5 - 2	Mérida UD	...
03 Sep 08	Tenerife	Tenerife - Córdoba 2008-09-03T22:00:00 Heliodoro Rodríguez López 2 - 1	Córdoba	1
04 Sep 08	Alicante	Alicante - Celta 2008-09-04T00:00:00 José Rico Pérez 0 - 1	Celta	...
03 Sep 08	CF Gavá	CF Gavá - Universidad 2008-09-03T12:00:00 Estadi Municipal La Bòbila 1 - 3	Universidad	...

28 Oct 08	Benidorm	Benidorm - Barcelona 2008-10-28T21:00:00 Guillermo Amor 0 - 1	Barcelona	...
12 Nov 08	Barcelona	Barcelona - Benidorm 2008-11-12T21:00:00 Spotify Camp Nou 1 - 0	Benidorm	...
29 Oct 08	Portugalete	Portugalete - Valencia 2008-10-29T20:30:00 La Florida 1 - 4	Valencia	...
12 Nov 08	Valencia	Valencia - Portugalete 2008-11-12T21:00:00 Mestalla 3 - 0	Portugalete	...
29 Oct 08	Poli Ejido	Poli Ejido - Villarreal 2008-10-29T21:00:00 Municipal De Santo Domingo 5 - 0	Villarreal	2
12 Nov 08	Villarreal	Villarreal - Poli Ejido 2008-11-12T20:00:00 Estadio de la Cerámica 1 - 1	Poli Ejido	...
29 Oct 08	Celta	Celta - Espanyol 2008-10-29T21:00:00 Abanca Balaídos 2 - 2	Espanyol	...
12 Nov 08	Espanyol	Espanyol - Celta 2008-11-12T20:00:00 RCDE Stadium 3 - 0	Celta	...
29 Oct 08	Hércules	Hércules - Real 2008-10-29T21:00:00 José Rico Pérez 1 - 5	Real	...
12 Nov 08	Real	Real - Hércules 2008-11-12T20:00:00 Municipal José Zorrilla 2 - 2	Hércules	...
29 Oct 08	Orihuela	Orihuela - Atlético 2008-10-29T21:00:00 Municipal Los Arcos 0 - 1	Atlético	1
12 Nov 08	Atlético	Atlético - Orihuela 2008-11-12T21:00:00 Wanda Metropolitano 0 - 0	Orihuela	1
29 Oct 08	Elche	Elche - Deportivo 2008-10-29T21:00:00 Martínez Valero 0 - 2	Deportivo	...
12 Nov 08	Deportivo	Deportivo - Elche 2008-11-12T21:00:00 Municipal Riazor 2 - 0	Elche	...
29 Oct 08	Castellón	Castellón - Real Betis 2008-10-29T21:00:00 Municipal de Castalia 0 - 2	Real Betis	...
12 Nov 08	Real Betis	Real Betis - Castellón 2008-11-12T21:00:00 Benito Villamarín 2 - 0	Castellón	...
29 Oct 08	Athletic	Athletic - Recreativo 2008-10-29T21:00:00 San Mamés 2 - 0	Recreativo	...
12 Nov 08	Recreativo	Recreativo - Athletic 2008-11-12T21:00:00 Nuevo Colombino 2 - 1	Athletic	...
29 Oct 08	Real Murcia	Real Murcia - Racing 2008-10-29T21:00:00 Enrique Roca de Murcia 2 - 1	Racing	...
12 Nov 08	Racing	Racing - Real Murcia 2008-11-12T21:00:00 Campos de Sport de El Sardinero 2 - 0	Real Murcia	...
29 Oct 08	Rayo	Rayo - Almería 2008-10-29T21:00:00 Vallecas 1 - 2	Almería	...
12 Nov 08	Almería	Almería - Rayo 2008-11-12T21:00:00 Juegos del Mediterráneo 3 - 0	Rayo	...
29 Oct 08	Numancia	Numancia - Real 2008-10-29T21:00:00 Nuevo Los Pajaritos 0 - 1	Real	...
12 Nov 08	Real	Real - Numancia 2008-11-12T21:00:00 El Molinón-Enrique Castro Quini 2 - 0	Numancia	...
29 Oct 08	Málaga	Málaga - Mallorca 2008-10-29T21:00:00 La Rosaleda 1 - 1	Mallorca	...
12 Nov 08	Mallorca	Mallorca - Málaga 2008-11-12T21:00:00 Visit Mallora Estadi 2 - 0	Málaga	...
29 Oct 08	Ponferradin	Ponferradin - Sevilla 2008-10-29T21:00:00 Municipal El Toralín 1 - 0	Sevilla	...
13 Nov 08	Sevilla	Sevilla - Ponferradin 2008-11-13T21:30:00 Ramón Sánchez Pizjuán 4 - 0	Ponferradin	...
29 Oct 08	Getafe	Getafe - Osasuna 2008-10-29T22:00:00 Coliseum Alfonso Pérez 0 - 0	Osasuna	...
13 Nov 08	Osasuna	Osasuna - Getafe 2008-11-13T21:00:00 El Sadar 1 - 0	Getafe	...
30 Oct 08	Real Unión	Real Unión - Real Madrid 2008-10-30T21:00:00 Stadium Gal 3 - 2	Real Madrid	1
11 Nov 08	Real Madrid	Real Madrid - Real Unión 2008-11-11T21:00:00 Santiago Bernabéu 4 - 3	Real Unión	5

06 Ene 09	Atlético	Atlético - Barcelona 2009-01-06T20:00:00 Wanda Metropolitano 1 - 3	Barcelona	1
14 Ene 09	Barcelona	Barcelona - Atlético 2009-01-14T22:00:00 Spotify Camp Nou 2 - 1	Atlético	1
07 Ene 09	Real	Real - Real 2009-01-07T21:00:00 El Molinón-Enrique Castro Quini 3 - 1	Real	...
14 Ene 09	Real	Real - Real 2009-01-14T20:00:00 Municipal José Zorrilla 2 - 1	Real	...
07 Ene 09	Poli Ejido	Poli Ejido - Espanyol 2009-01-07T21:00:00 Municipal De Santo Domingo 3 - 2	Espanyol	...
14 Ene 09	Espanyol	Espanyol - Poli Ejido 2009-01-14T20:00:00 RCDE Stadium 1 - 0	Poli Ejido	...
07 Ene 09	Racing	Racing - Valencia 2009-01-07T21:00:00 Campos de Sport de El Sardinero 1 - 1	Valencia	...
14 Ene 09	Valencia	Valencia - Racing 2009-01-14T20:00:00 Mestalla 3 - 1	Racing	8
07 Ene 09	Real Unión	Real Unión - Real Betis 2009-01-07T21:00:00 Stadium Gal 0 - 1	Real Betis	...
14 Ene 09	Real Betis	Real Betis - Real Unión 2009-01-14T20:00:00 Benito Villamarín 1 - 0	Real Unión	...
07 Ene 09	Sevilla	Sevilla - Deportivo 2009-01-07T21:00:00 Ramón Sánchez Pizjuán 2 - 1	Deportivo	...
14 Ene 09	Deportivo	Deportivo - Sevilla 2009-01-14T20:00:00 Municipal Riazor 0 - 3	Sevilla	...
08 Ene 09	Mallorca	Mallorca - Almería 2009-01-08T21:00:00 Visit Mallora Estadi 3 - 1	Almería	...
14 Ene 09	Almería	Almería - Mallorca 2009-01-14T20:00:00 Juegos del Mediterráneo 1 - 1	Mallorca	...
08 Ene 09	Osasuna	Osasuna - Athletic 2009-01-08T21:00:00 El Sadar 1 - 1	Athletic	...
15 Ene 09	Athletic	Athletic - Osasuna 2009-01-15T20:00:00 San Mamés 2 - 0	Osasuna	...