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 su majestad el rey, copa del rey, campeonato de españa, la copa de españa,

Copa del Rey 2008

Primera División

Ver jornada

Jornada 1

Ver jornada

Jornada 2

Ver jornada

Jornada 3

10 Oct 07	Tenerife	Tenerife - Málaga 2007-10-10T22:00:00 Heliodoro Rodríguez López 1 - 2	Málaga	...
10 Oct 07	Talavera	Talavera - Alicante 2007-10-10T21:35:00 El Prado 0 - 2	Alicante	...
10 Oct 07	Hércules	Hércules - Deportivo 2007-10-10T21:30:00 José Rico Pérez 2 - 1	Deportivo	...
10 Oct 07	Pontevedra	Pontevedra - Puertollano 2007-10-10T21:00:00 Estadio Municipal de Pasarón 2 - 0	Puertollano	...
10 Oct 07	Alcoyano	Alcoyano - Rayo 2007-10-10T21:00:00 El Collao 1 - 1	Rayo	...
10 Oct 07	Albacete	Albacete - Xerez CD 2007-10-10T21:00:00 Carlos Belmonte 0 - 2	Xerez CD	...
10 Oct 07	Cádiz	Cádiz - Granada 74 2007-10-10T21:00:00 Nuevo Mirandilla 2 - 3	Granada 74	...
10 Oct 07	Elche	Elche - Eibar 2007-10-10T21:00:00 Martínez Valero 2 - 1	Eibar	...
10 Oct 07	Dénia	Dénia - Portuense 2007-10-10T20:45:00 Diego Mena Cuesta 3 - 1	Portuense	...
10 Oct 07	Burgos	Burgos - Ponferradin 2007-10-10T20:30:00 Municipal de El Plantío 2 - 0	Ponferradin	...
10 Oct 07	Real Unión	Real Unión - L´Hospital 2007-10-10T20:00:00 Stadium Gal 2 - 1	L´Hospital	...

Ver jornada

Jornada 4

Ver jornada

Jornada 5

Ver jornada

Jornada 6

31 Ene 08	Athletic	Athletic - Racing 2008-01-31T20:00:00 San Mamés 3 - 3	Racing	1
31 Ene 08	Barcelona	Barcelona - Villarreal 2008-01-31T22:00:00 Spotify Camp Nou 1 - 0	Villarreal	...
30 Ene 08	Mallorca	Mallorca - Getafe 2008-01-30T21:00:00 Visit Mallora Estadi 2 - 1	Getafe	...
30 Ene 08	Atlético	Atlético - Valencia 2008-01-30T20:45:00 Wanda Metropolitano 3 - 2	Valencia	1
24 Ene 08	Villarreal	Villarreal - Barcelona 2008-01-24T22:00:00 Estadio de la Cerámica 0 - 0	Barcelona	...
24 Ene 08	Racing	Racing - Athletic 2008-01-24T20:00:00 Campos de Sport de El Sardinero 2 - 0	Athletic	...
23 Ene 08	Valencia	Valencia - Atlético 2008-01-23T22:00:00 Mestalla 1 - 0	Atlético	...
23 Ene 08	Getafe	Getafe - Mallorca 2008-01-23T20:00:00 Coliseum Alfonso Pérez 1 - 0	Mallorca	...

Ver jornada

Jornada 7

27 Feb 08	Barcelona	Barcelona - Valencia 2008-02-27T22:00:00 Spotify Camp Nou 1 - 1	Valencia	1
28 Feb 08	Getafe	Getafe - Racing 2008-02-28T21:00:00 Coliseum Alfonso Pérez 3 - 1	Racing	...
19 Mar 08	Racing	Racing - Getafe 2008-03-19T20:45:00 Campos de Sport de El Sardinero 1 - 1	Getafe	1
20 Mar 08	Valencia	Valencia - Barcelona 2008-03-20T20:45:00 Mestalla 3 - 2	Barcelona	3

Ver jornada

Jornada 8

16 Abr 08

Valencia

3 - 1

Getafe

Equipos de esta liga

USO DE MEMORIA

5,136,912 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.3881
Total Execution Time	0.3900

CADENA URL

/copa_del_rey2008/grupo0/calendario

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (17)

0.0125	SELECT type FROM routes WHERE alias = 'copa_del_rey2008'
0.0261	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 = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0130	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 = 20575 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0141	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 = 20575 ORDER BY round ASC
0.0126	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 04:34:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-06 04:34:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-06 04:34:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-06 04:34:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0136	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2008
0.0201	SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (20575) 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.0147	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 (20575) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (78250,7585,23384,23385,23567,4798,7348,10936,23345,23479) ORDER BY rp.in_squad = 1 DESC
0.0145	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2008
0.0243	SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (20575) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0147	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 (20575) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (10218,69871,72153,7445,23346,23389,23479,23511,23561,28863) ORDER BY rp.in_squad = 1 DESC
0.0143	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2008
0.0233	SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (20575) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0140	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 (20575) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (7257,7368,7445,10218,11010,23364,23369,23404,23479,23648) 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

29 Ago 07	Lorca	Lorca - Real Jaén 2007-08-29T00:00:00 No disponible 2 - 3	Real Jaén	1
29 Ago 07	Portuense	Portuense - Jerez 2007-08-29T00:00:00 No disponible 4 - 1	Jerez	...
29 Ago 07	Puertollano	Puertollano - CD Linares 2007-08-29T00:00:00 Ciudad de Puertollano 2 - 1	CD Linares	...
29 Ago 07	Granada	Granada - Cartagena 2007-08-29T00:00:00 Nuevo Los Carmenes 0 - 1	Cartagena	...
29 Ago 07	Algeciras	Algeciras - Mazarrón 2007-08-29T00:00:00 Nuevo Mirador 1 - 0	Mazarrón	...
29 Ago 07	Coruxo	Coruxo - Badalona 2007-08-29T00:00:00 Campo do Vao 2 - 4	Badalona	...
29 Ago 07	UD Ibiza	UD Ibiza - Alicante 2007-08-29T00:00:00 Estadi Can Misses 0 - 2	Alicante	...
29 Ago 07	Dénia	Dénia - Reus 2007-08-29T00:00:00 Diego Mena Cuesta 2 - 1	Reus	...
29 Ago 07	Huesca	Huesca - Sestao 2007-08-29T00:00:00 El Alcoraz 1 - 0	Sestao	...
29 Ago 07	Utebo	Utebo - Valle 2007-08-29T00:00:00 Santa Ana 1 - 2	Valle	...
29 Ago 07	Burgos	Burgos - Haro 2007-08-29T00:00:00 Municipal de El Plantío 2 - 0	Haro	...
29 Ago 07	Zalla	Zalla - Real Unión 2007-08-29T00:00:00 Landaberri 1 - 3	Real Unión	...
29 Ago 07	Lemona	Lemona - Palencia 2007-08-29T00:00:00 Arlonagusia Futbol Zelaia 1 - 2	Palencia	...
29 Ago 07	Barakaldo	Barakaldo - Mirandés 2007-08-29T00:00:00 Nuevo Lasesarre 1 - 1	Mirandés	...
29 Ago 07	Noja	Noja - Conquense 2007-08-29T00:00:00 La Caseta 1 - 2	Conquense	...
29 Ago 07	Caudal	Caudal - Raqui 2007-08-29T00:00:00 Estadio Municipal Hermanos Antuña 0 - 1	Raqui	...
29 Ago 07	Alcalá	Alcalá - Pontevedra 2007-08-29T00:00:00 Municipal Virgen del Val 1 - 5	Pontevedra	...
29 Ago 07	Universidad	Universidad - UD Sanse 2007-08-29T00:00:00 Alfonso Silva 2 - 0	UD Sanse	...

05 Sep 07	Tenerife	Tenerife - Poli Ejido 2007-09-05T22:00:00 Heliodoro Rodríguez López 1 - 0	Poli Ejido	...
05 Sep 07	Hércules	Hércules - Numancia 2007-09-05T21:30:00 José Rico Pérez 2 - 0	Numancia	...
05 Sep 07	Granada 74	Granada 74 - Real 2007-09-05T21:20:00 No disponible 1 - 0	Real	...
05 Sep 07	Real Unión	Real Unión - Vecindario 2007-09-05T20:00:00 Stadium Gal 3 - 0	Vecindario	...
05 Sep 07	Deportivo	Deportivo - Gimnàstic 2007-09-05T20:30:00 Mendizorroza 1 - 0	Gimnàstic	...
05 Sep 07	Puertollano	Puertollano - Badalona 2007-09-05T20:45:00 Ciudad de Puertollano 2 - 1	Badalona	...
05 Sep 07	Salamanca	Salamanca - Elche 2007-09-05T20:45:00 Helmántico 1 - 2	Elche	...
05 Sep 07	Alcoyano	Alcoyano - Conquense 2007-09-05T21:00:00 El Collao 2 - 0	Conquense	...
05 Sep 07	Pontevedra	Pontevedra - Cartagena 2007-09-05T21:00:00 Estadio Municipal de Pasarón 1 - 0	Cartagena	...
05 Sep 07	Real Jaén	Real Jaén - Rayo 2007-09-05T21:00:00 Municipal La Victoria 0 - 2	Rayo	...
05 Sep 07	Raqui	Raqui - Portuense 2007-09-05T21:00:00 La Palmera 2 - 5	Portuense	...
05 Sep 07	Algeciras	Algeciras - Dénia 2007-09-05T21:00:00 Nuevo Mirador 0 - 1	Dénia	...
05 Sep 07	Talavera	Talavera - Barakaldo 2007-09-05T21:00:00 El Prado 2 - 1	Barakaldo	...
05 Sep 07	Albacete	Albacete - Castellón 2007-09-05T21:00:00 Carlos Belmonte 1 - 0	Castellón	...
05 Sep 07	Xerez CD	Xerez CD - Racing 2007-09-05T21:00:00 Estadio de la Juventud 3 - 1	Racing	...
05 Sep 07	Córdoba	Córdoba - Cádiz 2007-09-05T21:00:00 Municipal Nuevo Arcángel 2 - 3	Cádiz	...
05 Sep 07	Málaga	Málaga - Celta 2007-09-05T21:00:00 La Rosaleda 2 - 1	Celta	...
05 Sep 07	Palencia	Palencia - Ponferradin 2007-09-05T21:15:00 Nueva Balastera 0 - 0	Ponferradin	...
05 Sep 07	Universidad	Universidad - Alicante 2007-09-05T20:00:00 Alfonso Silva 0 - 1	Alicante	...
05 Sep 07	L´Hospital	L´Hospital - Huesca 2007-09-05T19:30:00 Municipal Feixa Llarga 1 - 0	Huesca	...
05 Sep 07	Valle	Valle - Burgos 2007-09-05T00:00:00 Sarriguren 1 - 2	Burgos	...
04 Sep 07	Las Palmas	Las Palmas - Real 2007-09-04T22:00:00 Gran Canaria 1 - 0	Real	...

03 Ene 08	Real	Real - Pontevedra 2008-01-03T21:00:00 La Romareda 3 - 1	Pontevedra	...
03 Ene 08	Almería	Almería - Levante 2008-01-03T20:30:00 Juegos del Mediterráneo 1 - 1	Levante	1
02 Ene 08	Athletic	Athletic - Hércules 2008-01-02T22:00:00 San Mamés 2 - 0	Hércules	...
02 Ene 08	Valencia	Valencia - Real Unión 2008-01-02T22:00:00 Mestalla 3 - 0	Real Unión	...
02 Ene 08	Deportivo	Deportivo - Espanyol 2008-01-02T21:00:00 Municipal Riazor 1 - 2	Espanyol	...
02 Ene 08	Mallorca	Mallorca - Osasuna 2008-01-02T21:30:00 Visit Mallora Estadi 4 - 0	Osasuna	...
02 Ene 08	Racing	Racing - Málaga 2008-01-02T21:00:00 Campos de Sport de El Sardinero 2 - 0	Málaga	...
02 Ene 08	Real Betis	Real Betis - Elche 2008-01-02T21:00:00 Benito Villamarín 3 - 0	Elche	...
02 Ene 08	Atlético	Atlético - Granada 74 2008-01-02T21:00:00 Wanda Metropolitano 1 - 1	Granada 74	...
02 Ene 08	Sevilla	Sevilla - Dénia 2008-01-02T21:00:00 Ramón Sánchez Pizjuán 4 - 3	Dénia	1
02 Ene 08	Real Murcia	Real Murcia - Real 2008-01-02T20:45:00 Enrique Roca de Murcia 2 - 3	Real	...
02 Ene 08	Recreativo	Recreativo - Xerez CD 2008-01-02T20:45:00 Nuevo Colombino 1 - 1	Xerez CD	...
02 Ene 08	Real Madrid	Real Madrid - Alicante 2008-01-02T20:00:00 Santiago Bernabéu 2 - 1	Alicante	...
02 Ene 08	Villarreal	Villarreal - Las Palmas 2008-01-02T20:00:00 Estadio de la Cerámica 2 - 1	Las Palmas	...
02 Ene 08	Getafe	Getafe - Burgos 2008-01-02T17:00:00 Coliseum Alfonso Pérez 4 - 1	Burgos	...
02 Ene 08	Barcelona	Barcelona - Alcoyano 2008-01-02T18:00:00 Spotify Camp Nou 2 - 2	Alcoyano	2
19 Dic 07	Real Unión	Real Unión - Valencia 2007-12-19T21:30:00 Stadium Gal 1 - 2	Valencia	...
19 Dic 07	Alicante	Alicante - Real Madrid 2007-12-19T20:45:00 José Rico Pérez 1 - 1	Real Madrid	...
19 Dic 07	Espanyol	Espanyol - Deportivo 2007-12-19T20:45:00 RCDE Stadium 1 - 1	Deportivo	...
12 Dic 07	Osasuna	Osasuna - Mallorca 2007-12-12T21:30:00 El Sadar 2 - 0	Mallorca	...
12 Dic 07	Elche	Elche - Real Betis 2007-12-12T21:00:00 Martínez Valero 1 - 1	Real Betis	...
12 Dic 07	Granada 74	Granada 74 - Atlético 2007-12-12T21:00:00 No disponible 1 - 2	Atlético	1
12 Dic 07	Burgos	Burgos - Getafe 2007-12-12T20:45:00 Municipal de El Plantío 0 - 1	Getafe	...
14 Nov 07	Las Palmas	Las Palmas - Villarreal 2007-11-14T22:00:00 Gran Canaria 2 - 4	Villarreal	...
14 Nov 07	Xerez CD	Xerez CD - Recreativo 2007-11-14T21:00:00 Estadio de la Juventud 0 - 1	Recreativo	...
14 Nov 07	Levante	Levante - Almería 2007-11-14T21:30:00 Ciutat de València 2 - 1	Almería	...
14 Nov 07	Málaga	Málaga - Racing 2007-11-14T21:00:00 La Rosaleda 0 - 0	Racing	...
14 Nov 07	Pontevedra	Pontevedra - Real 2007-11-14T20:30:00 Estadio Municipal de Pasarón 1 - 0	Real	...
14 Nov 07	Real	Real - Real Murcia 2007-11-14T20:00:00 Municipal José Zorrilla 1 - 1	Real Murcia	...
13 Nov 07	Hércules	Hércules - Athletic 2007-11-13T21:30:00 José Rico Pérez 2 - 2	Athletic	...
13 Nov 07	Alcoyano	Alcoyano - Barcelona 2007-11-13T21:00:00 El Collao 0 - 3	Barcelona	...
13 Nov 07	Dénia	Dénia - Sevilla 2007-11-13T21:00:00 Diego Mena Cuesta 1 - 1	Sevilla	...

16 Ene 08	Valencia	Valencia - Real Betis 2008-01-16T22:00:00 Mestalla 2 - 1	Real Betis	...
16 Ene 08	Levante	Levante - Getafe 2008-01-16T20:00:00 Ciutat de València 0 - 1	Getafe	...
16 Ene 08	Real Madrid	Real Madrid - Mallorca 2008-01-16T21:00:00 Santiago Bernabéu 0 - 1	Mallorca	1
16 Ene 08	Real	Real - Atlético 2008-01-16T20:00:00 Municipal José Zorrilla 1 - 1	Atlético	...
16 Ene 08	Espanyol	Espanyol - Athletic 2008-01-16T20:00:00 RCDE Stadium 1 - 1	Athletic	...
16 Ene 08	Racing	Racing - Real 2008-01-16T20:00:00 Campos de Sport de El Sardinero 4 - 2	Real	...
16 Ene 08	Villarreal	Villarreal - Recreativo 2008-01-16T20:00:00 Estadio de la Cerámica 2 - 0	Recreativo	...
15 Ene 08	Barcelona	Barcelona - Sevilla 2008-01-15T21:00:00 Spotify Camp Nou 0 - 0	Sevilla	...
10 Ene 08	Mallorca	Mallorca - Real Madrid 2008-01-10T22:00:00 Visit Mallora Estadi 2 - 1	Real Madrid	...
10 Ene 08	Atlético	Atlético - Real 2008-01-10T20:00:00 Wanda Metropolitano 0 - 0	Real	...
09 Ene 08	Sevilla	Sevilla - Barcelona 2008-01-09T22:00:00 Ramón Sánchez Pizjuán 1 - 1	Barcelona	...
09 Ene 08	Real Betis	Real Betis - Valencia 2008-01-09T20:00:00 Benito Villamarín 1 - 2	Valencia	...
09 Ene 08	Getafe	Getafe - Levante 2008-01-09T20:00:00 Coliseum Alfonso Pérez 3 - 0	Levante	...
09 Ene 08	Athletic	Athletic - Espanyol 2008-01-09T20:00:00 San Mamés 1 - 1	Espanyol	...
09 Ene 08	Real	Real - Racing 2008-01-09T20:00:00 La Romareda 1 - 1	Racing	...
09 Ene 08	Recreativo	Recreativo - Villarreal 2008-01-09T20:00:00 Nuevo Colombino 1 - 0	Villarreal	...