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

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

Copa del Rey 1997

Jornada 1
05 Sep 96 Racing FerrolRacing 1 - 1 CD OurenseCD Ourense ...
19 Sep 96 CD OurenseCD Ourense 0 - 1 Racing FerrolRacing ...
05 Sep 96 Real Avilés IndustrialReal 3 - 1 Marino de LuancoMarino ...
19 Sep 96 Marino de LuancoMarino 0 - 3 Real Avilés IndustrialReal ...
04 Sep 96 Cultural LeonesaCultural 0 - 1 Deportivo AlavésDeportivo ...
18 Sep 96 Deportivo AlavésDeportivo 2 - 0 Cultural LeonesaCultural ...
04 Sep 96 SD GernikaSD Gernika 2 - 2 EibarEibar ...
18 Sep 96 EibarEibar 4 - 0 SD GernikaSD Gernika ...
05 Sep 96 Gimnástica TorrelavegaGimnástica 0 - 1 OsasunaOsasuna ...
19 Sep 96 OsasunaOsasuna 2 - 0 Gimnástica TorrelavegaGimnástica ...
05 Sep 96 BarakaldoBarakaldo 1 - 2 Real Unión ClubReal Unión ...
18 Sep 96 Real Unión ClubReal Unión 0 - 1 BarakaldoBarakaldo ...
04 Sep 96 Gimnàstic TarragonaGimnàstic 0 - 2 LleidaLleida ...
18 Sep 96 LleidaLleida 4 - 2 Gimnàstic TarragonaGimnàstic ...
11 Sep 96 Terrassa FCTerrassa 1 - 0 UE FigueresFigueres ...
19 Sep 96 UE FigueresFigueres 0 - 1 Terrassa FCTerrassa ...
05 Sep 96 Talavera CFTalavera 0 - 1 CD BadajozCD Badajoz ...
19 Sep 96 CD BadajozCD Badajoz 1 - 3 Talavera CFTalavera ...
05 Sep 96 RCD CarabanchelCarabanchel 1 - 2 LeganésLeganés ...
19 Sep 96 LeganésLeganés 2 - 0 RCD CarabanchelCarabanchel ...
04 Sep 96 CP CacereñoCacereño 1 - 5 Mérida CPMérida CP ...
18 Sep 96 Mérida CPMérida CP 2 - 1 CP CacereñoCacereño ...
05 Sep 96 GetafeGetafe 2 - 2 CD ToledoCD Toledo ...
18 Sep 96 CD ToledoCD Toledo 0 - 0 GetafeGetafe ...
04 Sep 96 CD ManchegoManchego 0 - 0 UD SalamancaSalamanca ...
18 Sep 96 UD SalamancaSalamanca 2 - 1 CD ManchegoManchego ...
05 Sep 96 CF GandiaCF Gandia 1 - 4 MallorcaMallorca ...
19 Sep 96 MallorcaMallorca 5 - 2 CF GandiaCF Gandia ...
04 Sep 96 Lliria UDLliria UD 0 - 3 VillarrealVillarreal ...
18 Sep 96 VillarrealVillarreal 2 - 1 Lliria UDLliria UD ...
05 Sep 96 Real MurciaReal Murcia 1 - 1 AlbaceteAlbacete ...
19 Sep 96 AlbaceteAlbacete 2 - 0 Real MurciaReal Murcia ...
05 Sep 96 ElcheElche 0 - 0 AD Mar MenorMenor ...
19 Sep 96 AD Mar MenorMenor 1 - 0 ElcheElche ...
04 Sep 96 CD MensajeroMensajero 0 - 1 AlmeríaAlmería ...
19 Sep 96 AlmeríaAlmería 1 - 0 CD MensajeroMensajero ...
05 Sep 96 Real JaénReal Jaén 0 - 1 Las PalmasLas Palmas ...
19 Sep 96 Las PalmasLas Palmas 3 - 1 Real JaénReal Jaén ...
05 Sep 96 Atlético MarbellaAtlético 1 - 2 Écija BalompiéÉcija ...
18 Sep 96 Écija BalompiéÉcija 2 - 1 Atlético MarbellaAtlético ...
05 Sep 96 MálagaMálaga 1 - 0 RealejosRealejos ...
19 Sep 96 RealejosRealejos 0 - 0 MálagaMálaga ...
05 Sep 96 Guadix CFGuadix CF 0 - 1 GranadaGranada ...
19 Sep 96 GranadaGranada 0 - 0 Guadix CFGuadix CF ...
05 Sep 96 Córdoba CFCórdoba 0 - 1 Poli EjidoPoli Ejido ...
19 Sep 96 Poli EjidoPoli Ejido 1 - 1 Córdoba CFCórdoba ...
05 Sep 96 CD CastellónCastellón 0 - 3 LevanteLevante ...
18 Sep 96 LevanteLevante 3 - 1 CD CastellónCastellón ...
04 Sep 96 ZallaZalla Apl Sestao Sport ClubSestao ...
18 Sep 96 Sestao Sport ClubSestao Apl ZallaZalla ...
Jornada 2
06 Nov 96 Racing FerrolRacing 1 - 3 CeltaCelta 1
26 Nov 96 CeltaCelta 1 - 1 Racing FerrolRacing 1
06 Nov 96 Real Avilés IndustrialReal 1 - 5 Real OviedoReal Oviedo ...
27 Nov 96 Real OviedoReal Oviedo 3 - 0 Real Avilés IndustrialReal ...
06 Nov 96 ZallaZalla 0 - 3 AthleticAthletic ...
27 Nov 96 AthleticAthletic 2 - 1 ZallaZalla ...
05 Nov 96 OsasunaOsasuna 1 - 0 Real SociedadReal ...
27 Nov 96 Real SociedadReal 1 - 1 OsasunaOsasuna ...
06 Nov 96 EibarEibar 1 - 1 RacingRacing ...
27 Nov 96 RacingRacing 0 - 0 EibarEibar ...
06 Nov 96 Deportivo AlavésDeportivo 1 - 1 CD LogroñésLogroñés ...
27 Nov 96 CD LogroñésLogroñés 0 - 0 Deportivo AlavésDeportivo ...
06 Nov 96 Real Unión ClubReal Unión 0 - 4 Real ZaragozaReal ...
27 Nov 96 Real ZaragozaReal 2 - 1 Real Unión ClubReal Unión ...
06 Nov 96 AlbaceteAlbacete 0 - 0 Rayo VallecanoRayo ...
27 Nov 96 Rayo VallecanoRayo 5 - 1 AlbaceteAlbacete ...
06 Nov 96 LeganésLeganés 1 - 1 SD CompostelaCompostela ...
27 Nov 96 SD CompostelaCompostela 1 - 0 LeganésLeganés ...
06 Nov 96 UD SalamancaSalamanca 0 - 2 Real MadridReal Madrid ...
27 Nov 96 Real MadridReal Madrid 2 - 0 UD SalamancaSalamanca ...
06 Nov 96 Talavera CFTalavera 0 - 3 Real ValladolidReal ...
27 Nov 96 Real ValladolidReal 1 - 1 Talavera CFTalavera ...
06 Nov 96 MallorcaMallorca 1 - 0 RC DeportivoDeportivo ...
27 Nov 96 RC DeportivoDeportivo 3 - 0 MallorcaMallorca ...
07 Nov 96 CD ToledoCD Toledo 0 - 0 Real SportingReal ...
26 Nov 96 Real SportingReal 1 - 0 CD ToledoCD Toledo ...
06 Nov 96 Mérida CPMérida CP 1 - 0 CF ExtremaduraExtremadura ...
27 Nov 96 CF ExtremaduraExtremadura 5 - 1 Mérida CPMérida CP ...
06 Nov 96 MálagaMálaga 0 - 1 SevillaSevilla 1
27 Nov 96 SevillaSevilla 0 - 0 MálagaMálaga 1
06 Nov 96 Écija BalompiéÉcija 1 - 2 Real BetisReal Betis 2
27 Nov 96 Real BetisReal Betis 2 - 0 Écija BalompiéÉcija ...
06 Nov 96 Poli EjidoPoli Ejido 0 - 0 GranadaGranada ...
27 Nov 96 GranadaGranada 0 - 0 Poli EjidoPoli Ejido ...
06 Nov 96 Las PalmasLas Palmas 2 - 0 AlmeríaAlmería ...
27 Nov 96 AlmeríaAlmería 2 - 3 Las PalmasLas Palmas ...
06 Nov 96 Terrassa FCTerrassa 1 - 0 LleidaLleida ...
27 Nov 96 LleidaLleida 2 - 0 Terrassa FCTerrassa ...
06 Nov 96 LevanteLevante 1 - 0 HérculesHércules ...
27 Nov 96 HérculesHércules 2 - 0 LevanteLevante ...
06 Nov 96 AD Mar MenorMenor 0 - 1 VillarrealVillarreal ...
27 Nov 96 VillarrealVillarreal 2 - 0 AD Mar MenorMenor ...
Jornada 3
08 Ene 97 SevillaSevilla 2 - 0 RC DeportivoDeportivo 1
16 Ene 97 RC DeportivoDeportivo 2 - 0 SevillaSevilla ...
08 Ene 97 EspanyolEspanyol 4 - 1 Real SportingReal ...
15 Ene 97 Real SportingReal 2 - 2 EspanyolEspanyol ...
08 Ene 97 Real OviedoReal Oviedo 1 - 0 SD CompostelaCompostela ...
15 Ene 97 SD CompostelaCompostela 3 - 0 Real OviedoReal Oviedo ...
09 Ene 97 Real MadridReal Madrid 2 - 1 Real ValladolidReal ...
15 Ene 97 Real ValladolidReal 0 - 2 Real MadridReal Madrid ...
08 Ene 97 GranadaGranada 0 - 1 Real BetisReal Betis ...
15 Ene 97 Real BetisReal Betis 3 - 0 GranadaGranada ...
08 Ene 97 OsasunaOsasuna 3 - 2 Rayo VallecanoRayo ...
15 Ene 97 Rayo VallecanoRayo 3 - 1 OsasunaOsasuna ...
08 Ene 97 Real ZaragozaReal 1 - 1 RacingRacing ...
15 Ene 97 RacingRacing 1 - 0 Real ZaragozaReal ...
08 Ene 97 VillarrealVillarreal 0 - 1 AthleticAthletic ...
15 Ene 97 AthleticAthletic 2 - 2 VillarrealVillarreal ...
16 Ene 97 LleidaLleida 1 - 0 HérculesHércules ...
22 Ene 97 HérculesHércules 2 - 1 LleidaLleida ...
08 Ene 97 CeltaCelta 2 - 0 CD LogroñésLogroñés ...
15 Ene 97 CD LogroñésLogroñés 2 - 2 CeltaCelta ...
Jornada 4
29 Ene 97 Las PalmasLas Palmas 0 - 2 ValenciaValencia 1
05 Feb 97 ValenciaValencia 0 - 2 Las PalmasLas Palmas ...
28 Ene 97 RC DeportivoDeportivo 2 - 2 EspanyolEspanyol ...
05 Feb 97 EspanyolEspanyol 0 - 0 RC DeportivoDeportivo ...
29 Ene 97 AtléticoAtlético 2 - 0 SD CompostelaCompostela ...
04 Feb 97 SD CompostelaCompostela 2 - 3 AtléticoAtlético ...
30 Ene 97 BarcelonaBarcelona 3 - 2 Real MadridReal Madrid 2
06 Feb 97 Real MadridReal Madrid 1 - 1 BarcelonaBarcelona 1
30 Ene 97 TenerifeTenerife 0 - 2 Real BetisReal Betis ...
05 Feb 97 Real BetisReal Betis 3 - 0 TenerifeTenerife ...
29 Ene 97 Rayo VallecanoRayo 2 - 2 CF ExtremaduraExtremadura ...
06 Feb 97 CF ExtremaduraExtremadura 1 - 2 Rayo VallecanoRayo ...
29 Ene 97 RacingRacing 1 - 0 AthleticAthletic ...
05 Feb 97 AthleticAthletic 1 - 1 RacingRacing ...
29 Ene 97 LleidaLleida 1 - 1 CeltaCelta ...
05 Feb 97 CeltaCelta 0 - 0 LleidaLleida ...
Jornada 5
27 Feb 97 Las PalmasLas Palmas 0 - 0 EspanyolEspanyol ...
12 Mar 97 EspanyolEspanyol 1 - 1 Las PalmasLas Palmas 1
26 Feb 97 AtléticoAtlético 2 - 2 BarcelonaBarcelona 1
12 Mar 97 BarcelonaBarcelona 5 - 4 AtléticoAtlético 4
26 Feb 97 Real BetisReal Betis 2 - 0 Rayo VallecanoRayo ...
13 Mar 97 Rayo VallecanoRayo 1 - 2 Real BetisReal Betis ...
27 Feb 97 RacingRacing 1 - 2 CeltaCelta ...
13 Mar 97 CeltaCelta 1 - 0 RacingRacing ...
Jornada 6
26 Mar 97 Las PalmasLas Palmas 0 - 4 BarcelonaBarcelona ...
03 Abr 97 BarcelonaBarcelona 3 - 0 Las PalmasLas Palmas ...
25 Mar 97 Real BetisReal Betis 1 - 0 CeltaCelta 1
02 Abr 97 CeltaCelta 1 - 1 Real BetisReal Betis 2
Jornada 7
28 Jun 97 BarcelonaBarcelona 3 - 2 Real BetisReal Betis 5

  USO DE MEMORIA  
5,310,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.1028
Total Execution Time  0.1051
  CADENA URL  
/copa_del_rey1997/grupo0/calendario
  GET DATOS  
$_GET['/copa_del_rey1997/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'copa_del_rey1997'
0.0040  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 = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0024  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 = 21697 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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 calendars1997 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 21697 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-05-09 07:59:13' 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=2 AND last_update > '2024-05-09 07:59:13' 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=4 AND last_update > '2024-05-09 07:59:13' 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-05-09 07:59:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1997
0.0043  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (21697) 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.0022  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 (21697) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (64314,258365,257984,258088,258363,252400,252430,258529,258607,259324) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1997
0.0041  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (21697) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0024  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 (21697) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (252468,256870,257709,257731,257740,258061,258348,258472,258588,195545) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1997
0.0039  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (21697) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0022  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 (21697) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (257731,258530,261238,271083,7421,11328,23377,252250,252295,252316) ORDER BY rp.in_squad = 1 DESC