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

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

Copa del Rey 1996

Jornada 1
20 Sep 95 Deportivo AlavésDeportivo 3 - 3 Sestao Sport ClubSestao ...
06 Sep 95 Sestao Sport ClubSestao 0 - 1 Deportivo AlavésDeportivo ...
07 Sep 95 AndorraAndorra 3 - 0 VillarrealVillarreal ...
21 Sep 95 VillarrealVillarreal 4 - 1 AndorraAndorra ...
07 Sep 95 Beasain KEBeasain KE 1 - 1 CD LogroñésLogroñés ...
21 Sep 95 CD LogroñésLogroñés 4 - 0 Beasain KEBeasain KE ...
07 Sep 95 CD Colonia MoscardóColonia 3 - 2 LeganésLeganés ...
21 Sep 95 LeganésLeganés 2 - 1 CD Colonia MoscardóColonia ...
07 Sep 95 UtreraUtrera 1 - 1 Córdoba CFCórdoba ...
21 Sep 95 Córdoba CFCórdoba 4 - 0 UtreraUtrera ...
07 Sep 95 SCD DurangoDurango 1 - 0 HuescaHuesca ...
21 Sep 95 HuescaHuesca 1 - 1 SCD DurangoDurango ...
07 Sep 95 DAV Santa AnaSanta 0 - 3 GetafeGetafe ...
21 Sep 95 GetafeGetafe 3 - 1 DAV Santa AnaSanta ...
07 Sep 95 CD Aurrera VitoriaAurrera 0 - 0 EibarEibar ...
21 Sep 95 EibarEibar 2 - 1 CD Aurrera VitoriaAurrera ...
07 Sep 95 Real Unión ClubReal Unión 0 - 1 OsasunaOsasuna ...
21 Sep 95 OsasunaOsasuna 4 - 0 Real Unión ClubReal Unión ...
07 Sep 95 FC AndorraFC Andorra 1 - 0 PalamósPalamós ...
21 Sep 95 PalamósPalamós 1 - 2 FC AndorraFC Andorra ...
07 Sep 95 UDA GramanetGramanet 0 - 2 LleidaLleida ...
20 Sep 95 LleidaLleida 4 - 1 UDA GramanetGramanet ...
07 Sep 95 CD CastellónCastellón 1 - 0 LevanteLevante ...
21 Sep 95 LevanteLevante 3 - 0 CD CastellónCastellón ...
07 Sep 95 UD SanseUD Sanse 2 - 2 NumanciaNumancia ...
21 Sep 95 NumanciaNumancia 0 - 0 UD SanseUD Sanse ...
07 Sep 95 Yeclano CFYeclano CF 0 - 0 Novelda CFNovelda CF ...
21 Sep 95 Novelda CFNovelda CF 2 - 0 Yeclano CFYeclano CF ...
07 Sep 95 CD ToledoCD Toledo 0 - 1 Real ValladolidReal ...
21 Sep 95 Real ValladolidReal 2 - 0 CD ToledoCD Toledo ...
07 Sep 95 PontevedraPontevedra 2 - 2 As PontesAs Pontes ...
21 Sep 95 As PontesAs Pontes 1 - 0 PontevedraPontevedra ...
07 Sep 95 Las PalmasLas Palmas 2 - 1 CD MensajeroMensajero ...
21 Sep 95 CD MensajeroMensajero 0 - 0 Las PalmasLas Palmas 1
07 Sep 95 UD San PedroPedro 2 - 1 Atlético MarbellaAtlético ...
21 Sep 95 Atlético MarbellaAtlético 2 - 0 UD San PedroPedro ...
07 Sep 95 ManlleuManlleu 0 - 1 MallorcaMallorca ...
21 Sep 95 MallorcaMallorca 2 - 1 ManlleuManlleu ...
07 Sep 95 Talavera CFTalavera 2 - 2 Cultural LeonesaCultural ...
21 Sep 95 Cultural LeonesaCultural 1 - 1 Talavera CFTalavera ...
07 Sep 95 CF ExtremaduraExtremadura 2 - 0 CD BadajozCD Badajoz ...
21 Sep 95 CD BadajozCD Badajoz 0 - 2 CF ExtremaduraExtremadura ...
07 Sep 95 Vélez CFVélez CF 1 - 1 Real JaénReal Jaén ...
21 Sep 95 Real JaénReal Jaén 2 - 2 Vélez CFVélez CF ...
07 Sep 95 MálagaMálaga 1 - 0 Écija BalompiéÉcija ...
21 Sep 95 Écija BalompiéÉcija 1 - 0 MálagaMálaga ...
07 Sep 95 ElcheElche 0 - 1 HérculesHércules ...
20 Sep 95 HérculesHércules 0 - 0 ElcheElche ...
07 Sep 95 Racing FerrolRacing 1 - 0 CD OurenseCD Ourense ...
21 Sep 95 CD OurenseCD Ourense 1 - 2 Racing FerrolRacing ...
21 Sep 95 AlmeríaAlmería 4 - 1 AlbaceteAlbacete ...
12 Oct 95 AlbaceteAlbacete 0 - 1 AlmeríaAlmería ...
Jornada 2
24 Oct 95 Racing FerrolRacing 1 - 1 Real SportingReal ...
08 Nov 95 Real SportingReal 4 - 0 Racing FerrolRacing ...
25 Oct 95 FC AndorraFC Andorra 3 - 0 GetafeGetafe ...
08 Nov 95 GetafeGetafe 2 - 1 FC AndorraFC Andorra ...
25 Oct 95 Atlético MarbellaAtlético 0 - 0 Rayo VallecanoRayo ...
09 Nov 95 Rayo VallecanoRayo 3 - 1 Atlético MarbellaAtlético ...
25 Oct 95 CF ExtremaduraExtremadura 1 - 1 EspanyolEspanyol ...
08 Nov 95 EspanyolEspanyol 3 - 1 CF ExtremaduraExtremadura ...
25 Oct 95 Vélez CFVélez CF 1 - 2 TenerifeTenerife ...
08 Nov 95 TenerifeTenerife 8 - 0 Vélez CFVélez CF ...
25 Oct 95 Las PalmasLas Palmas 1 - 1 LeganésLeganés ...
08 Nov 95 LeganésLeganés 0 - 0 Las PalmasLas Palmas ...
25 Oct 95 Deportivo AlavésDeportivo 0 - 1 AthleticAthletic ...
08 Nov 95 AthleticAthletic 4 - 1 Deportivo AlavésDeportivo ...
25 Oct 95 AlmeríaAlmería 1 - 4 AtléticoAtlético ...
08 Nov 95 AtléticoAtlético 2 - 1 AlmeríaAlmería ...
25 Oct 95 AndorraAndorra 1 - 1 LevanteLevante ...
08 Nov 95 LevanteLevante 4 - 1 AndorraAndorra ...
25 Oct 95 NumanciaNumancia 2 - 0 Real SociedadReal ...
08 Nov 95 Real SociedadReal 2 - 0 NumanciaNumancia ...
25 Oct 95 CD LogroñésLogroñés 1 - 2 RacingRacing ...
08 Nov 95 RacingRacing 3 - 1 CD LogroñésLogroñés ...
25 Oct 95 EibarEibar 1 - 0 SD CompostelaCompostela ...
08 Nov 95 SD CompostelaCompostela 2 - 0 EibarEibar ...
25 Oct 95 OsasunaOsasuna 3 - 3 Real OviedoReal Oviedo ...
08 Nov 95 Real OviedoReal Oviedo 4 - 1 OsasunaOsasuna ...
25 Oct 95 Córdoba CFCórdoba 1 - 3 Mérida CPMérida CP ...
08 Nov 95 Mérida CPMérida CP 2 - 0 Córdoba CFCórdoba ...
25 Oct 95 LleidaLleida 0 - 2 Écija BalompiéÉcija ...
08 Nov 95 Écija BalompiéÉcija 0 - 1 LleidaLleida ...
25 Oct 95 MallorcaMallorca 0 - 0 ValenciaValencia ...
08 Nov 95 ValenciaValencia 0 - 0 MallorcaMallorca ...
25 Oct 95 Novelda CFNovelda CF 0 - 0 HérculesHércules ...
08 Nov 95 HérculesHércules 2 - 0 Novelda CFNovelda CF ...
25 Oct 95 Cultural LeonesaCultural 1 - 1 Real ValladolidReal ...
08 Nov 95 Real ValladolidReal 3 - 1 Cultural LeonesaCultural 1
25 Oct 95 As PontesAs Pontes 0 - 0 CeltaCelta ...
07 Nov 95 CeltaCelta 2 - 1 As PontesAs Pontes ...
25 Oct 95 SCD DurangoDurango 0 - 2 UD SalamancaSalamanca ...
08 Nov 95 UD SalamancaSalamanca 4 - 0 SCD DurangoDurango ...
Jornada 3
28 Nov 95 AtléticoAtlético 4 - 1 Mérida CPMérida CP ...
13 Dic 95 Mérida CPMérida CP 4 - 4 AtléticoAtlético ...
29 Nov 95 UD SalamancaSalamanca 0 - 0 AthleticAthletic ...
14 Dic 95 AthleticAthletic 3 - 1 UD SalamancaSalamanca ...
29 Nov 95 SD CompostelaCompostela 1 - 0 Real ValladolidReal ...
13 Dic 95 Real ValladolidReal 1 - 1 SD CompostelaCompostela ...
29 Nov 95 LeganésLeganés 0 - 1 EspanyolEspanyol ...
13 Dic 95 EspanyolEspanyol 5 - 1 LeganésLeganés ...
29 Nov 95 NumanciaNumancia 0 - 0 RacingRacing ...
13 Dic 95 RacingRacing 0 - 1 NumanciaNumancia ...
29 Nov 95 Écija BalompiéÉcija 2 - 0 Real SportingReal 1
13 Dic 95 Real SportingReal 5 - 0 Écija BalompiéÉcija 1
29 Nov 95 LevanteLevante 1 - 0 TenerifeTenerife ...
13 Dic 95 TenerifeTenerife 6 - 1 LevanteLevante ...
29 Nov 95 FC AndorraFC Andorra 0 - 5 CeltaCelta ...
13 Dic 95 CeltaCelta 2 - 0 FC AndorraFC Andorra ...
29 Nov 95 HérculesHércules 1 - 1 Rayo VallecanoRayo ...
13 Dic 95 Rayo VallecanoRayo 0 - 1 HérculesHércules ...
30 Nov 95 Real OviedoReal Oviedo 1 - 1 ValenciaValencia ...
12 Dic 95 ValenciaValencia 1 - 0 Real OviedoReal Oviedo ...
Jornada 4
10 Ene 96 SevillaSevilla 2 - 1 SD CompostelaCompostela ...
17 Ene 96 SD CompostelaCompostela 0 - 1 SevillaSevilla ...
10 Ene 96 CeltaCelta 1 - 1 ValenciaValencia ...
17 Ene 96 ValenciaValencia 3 - 0 CeltaCelta ...
10 Ene 96 RC DeportivoDeportivo 1 - 1 TenerifeTenerife ...
17 Ene 96 TenerifeTenerife 2 - 1 RC DeportivoDeportivo ...
09 Ene 96 AtléticoAtlético 1 - 1 Real BetisReal Betis ...
16 Ene 96 Real BetisReal Betis 1 - 2 AtléticoAtlético ...
10 Ene 96 NumanciaNumancia 2 - 1 Real SportingReal 2
17 Ene 96 Real SportingReal 0 - 0 NumanciaNumancia ...
10 Ene 96 HérculesHércules 0 - 0 BarcelonaBarcelona 2
17 Ene 96 BarcelonaBarcelona 4 - 1 HérculesHércules 4
11 Ene 96 EspanyolEspanyol 4 - 1 Real MadridReal Madrid 2
18 Ene 96 Real MadridReal Madrid 2 - 1 EspanyolEspanyol ...
10 Ene 96 AthleticAthletic 2 - 3 Real ZaragozaReal ...
17 Ene 96 Real ZaragozaReal 0 - 1 AthleticAthletic ...
Jornada 5
30 Ene 96 SevillaSevilla 1 - 1 ValenciaValencia ...
13 Feb 96 ValenciaValencia 2 - 0 SevillaSevilla ...
31 Ene 96 TenerifeTenerife 0 - 0 AtléticoAtlético ...
15 Feb 96 AtléticoAtlético 3 - 0 TenerifeTenerife ...
01 Feb 96 NumanciaNumancia 2 - 2 BarcelonaBarcelona 2
14 Feb 96 BarcelonaBarcelona 3 - 1 NumanciaNumancia 1
31 Ene 96 EspanyolEspanyol 0 - 0 Real ZaragozaReal ...
14 Feb 96 Real ZaragozaReal 1 - 1 EspanyolEspanyol ...
Jornada 6
21 Feb 96 ValenciaValencia 3 - 5 AtléticoAtlético 1
29 Feb 96 AtléticoAtlético 1 - 2 ValenciaValencia ...
22 Feb 96 BarcelonaBarcelona 1 - 0 EspanyolEspanyol ...
28 Feb 96 EspanyolEspanyol 2 - 3 BarcelonaBarcelona ...
Jornada 7
10 Abr 96 AtléticoAtlético 1 - 0 BarcelonaBarcelona 3

  USO DE MEMORIA  
5,339,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4661
Total Execution Time  0.4680
  CADENA URL  
/copa_del_rey1996/grupo0/calendario
  GET DATOS  
$_GET['/copa_del_rey1996/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0144  SELECT type FROM routes WHERE alias = 'copa_del_rey1996'
0.0291  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 = 1996 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0271  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 129 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1313202,801142,1286949,1244521,905062) ORDER BY n.cover_points DESC, update_date DESC
0.0148  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 = 21699 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0156  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 calendars1996 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 21699 ORDER BY round ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 09:28:01' 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=2 AND last_update > '2024-05-05 09:28:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 09:28:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 09:28:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1996
0.0189  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (21699) 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.0148  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 (21699) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (258529,252430,258421,258088,258174,258722,7581,252261,252425,258171) ORDER BY rp.in_squad = 1 DESC
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1996
0.0174  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (21699) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0163  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 (21699) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (10999,252295,252345,257203,257728,258174,258231,258598,261067,589831) ORDER BY rp.in_squad = 1 DESC
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1996
0.0166  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (21699) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0148  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 (21699) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (252221,257203,258118,297,10963,11000,11008,23583,29962,252205) ORDER BY rp.in_squad = 1 DESC