4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Copa del Rey 2006
2005/2006

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

Copa del Rey 2006

Jornada 1
11 Ago 05 AgD CeutaAgD Ceuta 1 - 0 Algeciras CFAlgeciras ...
12 Ago 05 CF GandiaCF Gandia 1 - 1 VillajoyosaVillajoyosa ...
13 Ago 05 Universidad LPGCUniversidad 0 - 0 Las PalmasLas Palmas ...
13 Ago 05 Águilas CFÁguilas 2 - 0 LeganésLeganés ...
13 Ago 05 UD AlmansaUD Almansa 1 - 0 CD VillanuevaVillanueva ...
13 Ago 05 Las RozasLas Rozas 0 - 2 RSD AlcaláAlcalá ...
13 Ago 05 CD Valle de EgüésValle 1 - 2 Logroñes CFLogroñes ...
13 Ago 05 Rápido de BouzasRápido 1 - 0 Rayo VallecanoRayo ...
14 Ago 05 BarbastroBarbastro 1 - 3 AlcoyanoAlcoyano ...
14 Ago 05 CD CalahorraCalahorra 1 - 3 L´HospitaletL´Hospital ...
14 Ago 05 UM EscobedoEscobedo 0 - 2 Real OviedoReal Oviedo ...
14 Ago 05 TeniscaTenisca 0 - 0 CD OurenseCD Ourense ...
14 Ago 05 ConstànciaConstància 0 - 5 AlicanteAlicante ...
14 Ago 05 Mérida UDMérida UD 2 - 0 UB ConquenseConquense ...
14 Ago 05 BazaBaza 0 - 0 Marbella FCMarbella ...
14 Ago 05 BarakaldoBarakaldo 1 - 1 LemonaLemona ...
14 Ago 05 PortugaletePortugalete 0 - 1 PonferradinaPonferradin ...
20 Ago 05 RSD AlcaláAlcalá 1 - 1 Las RozasLas Rozas ...
20 Ago 05 VillajoyosaVillajoyosa 4 - 0 CF GandiaCF Gandia ...
20 Ago 05 UB ConquenseConquense 0 - 0 Mérida UDMérida UD ...
21 Ago 05 Marbella FCMarbella 2 - 3 BazaBaza ...
21 Ago 05 L´HospitaletL´Hospital 3 - 0 CD CalahorraCalahorra ...
21 Ago 05 LeganésLeganés 2 - 2 Águilas CFÁguilas ...
21 Ago 05 CD VillanuevaVillanueva 1 - 1 UD AlmansaUD Almansa ...
21 Ago 05 Algeciras CFAlgeciras 1 - 0 AgD CeutaAgD Ceuta ...
21 Ago 05 AlicanteAlicante 4 - 1 ConstànciaConstància ...
21 Ago 05 Logroñes CFLogroñes 3 - 1 CD Valle de EgüésValle ...
21 Ago 05 Rayo VallecanoRayo 2 - 0 Rápido de BouzasRápido 1
21 Ago 05 Real OviedoReal Oviedo 2 - 0 UM EscobedoEscobedo ...
21 Ago 05 Las PalmasLas Palmas 1 - 0 Universidad LPGCUniversidad ...
21 Ago 05 LemonaLemona 1 - 0 BarakaldoBarakaldo ...
21 Ago 05 CD OurenseCD Ourense 1 - 2 TeniscaTenisca ...
21 Ago 05 PonferradinaPonferradin 1 - 2 PortugaletePortugalete ...
21 Ago 05 AlcoyanoAlcoyano 3 - 0 BarbastroBarbastro ...
Jornada 2
31 Ago 05 Real MurciaReal Murcia 1 - 0 TenerifeTenerife ...
31 Ago 05 Lorca DeportivaLorca 1 - 2 Ciudad de MurciaCiudad ...
31 Ago 05 RecreativoRecreativo 3 - 2 ElcheElche ...
31 Ago 05 Racing FerrolRacing 2 - 0 Real SportingReal ...
31 Ago 05 CD CastellónCastellón 0 - 2 LleidaLleida ...
31 Ago 05 HérculesHércules 0 - 1 Gimnàstic TarragonaGimnàstic ...
31 Ago 05 AlbaceteAlbacete 2 - 1 Poli EjidoPoli Ejido ...
31 Ago 05 AlmeríaAlmería 0 - 0 NumanciaNumancia ...
31 Ago 05 Xerez CDXerez CD 1 - 1 Real ValladolidReal ...
31 Ago 05 LevanteLevante 0 - 1 EibarEibar ...
Jornada 3
14 Sep 05 BazaBaza 2 - 1 Ciudad de MurciaCiudad ...
14 Sep 05 Córdoba CFCórdoba 0 - 3 Gimnàstic TarragonaGimnàstic ...
15 Sep 05 Águilas CFÁguilas 1 - 1 NumanciaNumancia ...
15 Sep 05 RSD AlcaláAlcalá 2 - 4 Xerez CDXerez CD ...
15 Sep 05 AlcoyanoAlcoyano 3 - 0 Racing FerrolRacing ...
15 Sep 05 AlicanteAlicante 2 - 0 RecreativoRecreativo ...
15 Sep 05 UD AlmansaUD Almansa 1 - 2 Las PalmasLas Palmas ...
15 Sep 05 BurgosBurgos 3 - 1 UD SalamancaSalamanca ...
15 Sep 05 AgD CeutaAgD Ceuta 0 - 1 EibarEibar ...
15 Sep 05 L´HospitaletL´Hospital 2 - 0 PontevedraPontevedra ...
15 Sep 05 LemonaLemona 0 - 2 LleidaLleida ...
15 Sep 05 Mérida UDMérida UD 2 - 3 AlbaceteAlbacete ...
15 Sep 05 PortugaletePortugalete 0 - 1 Real Unión ClubReal Unión ...
15 Sep 05 Rayo VallecanoRayo 1 - 0 Real OviedoReal Oviedo ...
15 Sep 05 TeniscaTenisca 0 - 0 Real MurciaReal Murcia ...
15 Sep 05 Terrassa FCTerrassa 2 - 3 Logroñes CFLogroñes ...
15 Sep 05 ZamoraZamora 1 - 0 VillajoyosaVillajoyosa ...
Jornada 4
19 Oct 05 EibarEibar 1 - 0 Deportivo AlavésDeportivo ...
20 Oct 05 Rayo VallecanoRayo 1 - 2 GetafeGetafe ...
20 Oct 05 Real Unión ClubReal Unión 0 - 1 AthleticAthletic ...
20 Oct 05 BurgosBurgos 1 - 0 RacingRacing ...
20 Oct 05 TeniscaTenisca 1 - 3 CeltaCelta ...
20 Oct 05 Las PalmasLas Palmas 0 - 1 AtléticoAtlético ...
20 Oct 05 ZamoraZamora 1 - 1 Real SociedadReal ...
20 Oct 05 AlicanteAlicante 1 - 1 Real ZaragozaReal ...
20 Oct 05 AlcoyanoAlcoyano 4 - 1 MallorcaMallorca 1
20 Oct 05 Logroñes CFLogroñes 0 - 1 LleidaLleida ...
20 Oct 05 L´HospitaletL´Hospital 4 - 3 Gimnàstic TarragonaGimnàstic ...
20 Oct 05 BazaBaza 1 - 1 MálagaMálaga ...
20 Oct 05 AlbaceteAlbacete 1 - 3 CádizCádiz ...
20 Oct 05 Xerez CDXerez CD 3 - 2 NumanciaNumancia ...
Jornada 5
09 Nov 05 BazaBaza 0 - 1 CeltaCelta ...
09 Nov 05 LleidaLleida 2 - 4 GetafeGetafe ...
09 Nov 05 L´HospitaletL´Hospital 1 - 3 AthleticAthletic ...
09 Nov 05 BurgosBurgos 0 - 2 CádizCádiz ...
09 Nov 05 ZamoraZamora 1 - 1 EibarEibar 1
30 Nov 05 AlcoyanoAlcoyano 0 - 1 AtléticoAtlético ...
30 Nov 05 Xerez CDXerez CD 2 - 2 Real ZaragozaReal ...
Jornada 6
03 Ene 06 ZamoraZamora 1 - 3 BarcelonaBarcelona 1
11 Ene 06 BarcelonaBarcelona 6 - 0 ZamoraZamora ...
03 Ene 06 AthleticAthletic 0 - 1 Real MadridReal Madrid ...
12 Ene 06 Real MadridReal Madrid 4 - 0 AthleticAthletic ...
04 Ene 06 GetafeGetafe 0 - 1 EspanyolEspanyol ...
11 Ene 06 EspanyolEspanyol 3 - 3 GetafeGetafe ...
04 Ene 06 RC DeportivoDeportivo 3 - 0 OsasunaOsasuna ...
11 Ene 06 OsasunaOsasuna 2 - 1 RC DeportivoDeportivo ...
04 Ene 06 CádizCádiz 3 - 2 SevillaSevilla ...
11 Ene 06 SevillaSevilla 0 - 0 CádizCádiz ...
04 Ene 06 VillarrealVillarreal 0 - 2 ValenciaValencia ...
11 Ene 06 ValenciaValencia 1 - 0 VillarrealVillarreal ...
04 Ene 06 CeltaCelta 1 - 1 Real BetisReal Betis ...
11 Ene 06 Real BetisReal Betis 0 - 0 CeltaCelta ...
11 Ene 06 AtléticoAtlético 0 - 1 Real ZaragozaReal ...
18 Ene 06 Real ZaragozaReal 2 - 2 AtléticoAtlético ...
Jornada 7
18 Ene 06 Real BetisReal Betis 0 - 1 Real MadridReal Madrid ...
25 Ene 06 Real MadridReal Madrid 1 - 0 Real BetisReal Betis ...
18 Ene 06 CádizCádiz 0 - 2 EspanyolEspanyol 1
25 Ene 06 EspanyolEspanyol 2 - 0 CádizCádiz 1
19 Ene 06 RC DeportivoDeportivo 1 - 0 ValenciaValencia ...
01 Feb 06 ValenciaValencia 1 - 1 RC DeportivoDeportivo ...
26 Ene 06 Real ZaragozaReal 4 - 2 BarcelonaBarcelona 3
01 Feb 06 BarcelonaBarcelona 2 - 1 Real ZaragozaReal ...
Jornada 8
08 Feb 06 Real ZaragozaReal 6 - 1 Real MadridReal Madrid 22
14 Feb 06 Real MadridReal Madrid 4 - 0 Real ZaragozaReal 3
09 Feb 06 EspanyolEspanyol 2 - 1 RC DeportivoDeportivo ...
15 Mar 06 RC DeportivoDeportivo 0 - 0 EspanyolEspanyol ...
Jornada 9
12 Abr 06 EspanyolEspanyol 4 - 1 Real ZaragozaReal 5

  USO DE MEMORIA  
5,120,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0038
Controller Execution Time ( Home / Category )  0.4577
Total Execution Time  0.4615
  CADENA URL  
/copa_del_rey2006/grupo0/calendario
  GET DATOS  
$_GET['/copa_del_rey2006/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0125  SELECT type FROM routes WHERE alias = 'copa_del_rey2006'
0.0254  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 = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0129  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 = 20577 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0191  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 calendars2006 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 20577 ORDER BY round ASC
0.0135  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 18:08:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 18:08:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 18:08:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 18:08:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2006
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (20577) 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.0128  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 (20577) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (23363,28271,77499,23632,27171,7553,9474,23364,29234,71296) ORDER BY rp.in_squad = 1 DESC
0.0131  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2006
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (20577) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0129  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 (20577) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (7271,16956,11439,23466,7367,11057,17670,23341,23346,23477) ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2006
0.0148  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (20577) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0127  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 (20577) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (166,7202,7451,10999,11013,11057,11120,11439,23378,23538) ORDER BY rp.in_squad = 1 DESC