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

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

Copa del Rey 1987

Jornada 1
18 Sep 86 Atlético MonzónAtlético 2 - 1 ArnedoArnedo ...
18 Sep 86 CD BasconiaBasconia 1 - 0 SD ErandioSD Erandio ...
18 Sep 86 Atlético BAtlético 2 - 1 Rayo VallecanoRayo ...
18 Sep 86 Deportivo AlavésDeportivo 1 - 2 Bilbao Ath.Bilbao Ath. ...
18 Sep 86 BarakaldoBarakaldo 2 - 1 SD AmorebietaAmorebieta ...
18 Sep 86 ValdepeñasValdepeñas 2 - 3 Real Madrid CReal Madrid 1
18 Sep 86 Júpiter LeonésJúpiter 0 - 2 Real Burgos CFReal Burgos ...
17 Sep 86 ManlleuManlleu 4 - 4 EspanyolEspanyol ...
17 Sep 86 CFJ MollerussaMollerussa 1 - 2 CE SabadellSabadell ...
17 Sep 86 HuescaHuesca x - x OsasunaOsasuna ...
17 Sep 86 Ontinyent CFOntinyent 2 - 1 UD AlziraUD Alzira ...
17 Sep 86 SanturtziSanturtzi 1 - 2 Sestao Sport ClubSestao ...
17 Sep 86 At. ValdemoroValdemoro 2 - 1 LeganésLeganés ...
17 Sep 86 PilasPilas 0 - 0 CádizCádiz 1
17 Sep 86 Coria CFCoria CF 0 - 2 Real BetisReal Betis ...
17 Sep 86 PortonovoPortonovo 1 - 1 RC DeportivoDeportivo ...
17 Sep 86 UB ConquenseConquense 1 - 0 RM CastillaCastilla 1
17 Sep 86 ViveiroViveiro 0 - 4 CeltaCelta ...
17 Sep 86 PonferradinaPonferradin 0 - 2 Real ValladolidReal ...
17 Sep 86 Hospitalet Isla BlancaHospitalet 1 - 4 MallorcaMallorca ...
17 Sep 86 IlicitanoIlicitano 1 - 2 Real MurciaReal Murcia 7
17 Sep 86 CD LaredoCD Laredo 2 - 4 RacingRacing ...
17 Sep 86 EldenseEldense 2 - 0 HérculesHércules ...
17 Sep 86 CF ExtremaduraExtremadura 2 - 1 CD BadajozCD Badajoz ...
17 Sep 86 At. SanluqueñoSanluqueño 3 - 0 CD PozoblancoPozoblanco ...
17 Sep 86 At. MalagueñoMalagueño 0 - 0 Martos CDMartos CD ...
17 Sep 86 Atlético MarbellaAtlético 4 - 1 BazaBaza ...
10 Sep 86 SCD DurangoDurango 1 - 1 EibarEibar ...
17 Sep 86 CD RondaCD Ronda 1 - 0 Poli AlmeríaPoli ...
17 Sep 86 OberenaOberena 1 - 2 Osasuna PromesasOsasuna ...
17 Sep 86 MosconiaMosconia 1 - 2 LangreoLangreo ...
17 Sep 86 Deportivo FabrilDeportivo 0 - 3 As PontesAs Pontes ...
17 Sep 86 Celta C – Gran PeñaCelta Gran 0 - 1 CD LugoCD Lugo ...
17 Sep 86 Sp. MahonèsMahonès 0 - 2 PoblensePoblense ...
17 Sep 86 AlcoyanoAlcoyano 4 - 0 NulesNules ...
17 Sep 86 UD SalamancaSalamanca 7 - 0 TorenoToreno ...
17 Sep 86 CP VillarrobledoVillarroble 1 - 1 Águilas CFÁguilas ...
17 Sep 86 GranadaGranada 0 - 1 CD MálagaCD Málaga ...
17 Sep 86 RB LinenseRB Linense 1 - 1 Xerez CDXerez CD ...
17 Sep 86 AgD CeutaAgD Ceuta 2 - 2 RecreativoRecreativo ...
17 Sep 86 CD San AndrésAndrés 1 - 4 TenerifeTenerife ...
17 Sep 86 UE Sant AndreuSant Andreu 2 - 3 Terrassa FCTerrassa ...
17 Sep 86 BigastroBigastro 1 - 1 TorreviejaTorrevieja ...
17 Sep 86 MaspalomasMaspalomas 1 - 4 Las PalmasLas Palmas ...
17 Sep 86 Cultural LeonesaCultural 2 - 1 Gimnástica SegovianaGimnástica ...
17 Sep 86 Caudal DeportivoCaudal 0 - 1 Real OviedoReal Oviedo ...
17 Sep 86 GironaGirona 2 - 3 Barça AtlèticBarça ...
17 Sep 86 CF GandiaCF Gandia 2 - 0 Valencia MestallaValencia ...
17 Sep 86 AlbaceteAlbacete 1 - 0 ElcheElche ...
17 Sep 86 CE ManresaCE Manresa 6 - 2 UE FigueresFigueres ...
17 Sep 86 Córdoba CFCórdoba 0 - 2 SevillaSevilla ...
17 Sep 86 CD BurrianaBurriana 0 - 1 CD CastellónCastellón ...
17 Sep 86 CD TeruelCD Teruel 1 - 3 CD LogroñésLogroñés ...
17 Sep 86 CP CacereñoCacereño 0 - 2 UD MontijoUD Montijo ...
17 Sep 86 CD Don BenitoBenito 3 - 1 MoraloMoralo ...
17 Sep 86 ConstànciaConstància 0 - 1 SD IbizaSD Ibiza ...
17 Sep 86 ServerenseServerense 2 - 3 Atlético BalearesAtlético ...
17 Sep 86 TeniscaTenisca 0 - 0 CD MensajeroMensajero 1
17 Sep 86 LanzaroteLanzarote 0 - 1 Las Palmas At.Palmas ...
17 Sep 86 UtreraUtrera 1 - 0 Sevilla At.Sevilla ...
02 Sep 86 Alondras CFAlondras 1 - 2 CD OurenseCD Ourense ...
17 Sep 86 VillarrealVillarreal 2 - 2 ValenciaValencia ...
17 Sep 86 Real Avilés IndustrialReal 0 - 4 Real SportingReal ...
17 Sep 86 HuescaHuesca 0 - 1 OsasunaOsasuna ...
Jornada 2
15 Oct 86 EldenseEldense 1 - 1 Cartagena F.C. UCAMCartagena ...
01 Oct 86 Atlético MonzónAtlético 0 - 6 OsasunaOsasuna ...
01 Oct 86 At. ValdemoroValdemoro 2 - 1 UB ConquenseConquense ...
01 Oct 86 CD BasconiaBasconia 0 - 1 Real SociedadReal ...
01 Oct 86 Ontinyent CFOntinyent 0 - 1 CD CastellónCastellón ...
01 Oct 86 UD SalamancaSalamanca 3 - 0 Real Valladolid PromesasReal ...
01 Oct 86 Atl. AstorgaAtl. 0 - 3 Cultural LeonesaCultural ...
01 Oct 86 As PontesAs Pontes 1 - 3 CeltaCelta ...
01 Oct 86 Terrassa FCTerrassa 2 - 1 EspanyolEspanyol ...
01 Oct 86 EibarEibar 2 - 1 Sestao Sport ClubSestao ...
01 Oct 86 SD IbizaSD Ibiza 1 - 4 MallorcaMallorca ...
01 Oct 86 AlcoyanoAlcoyano 3 - 1 Olimpic XátivaOlimpic ...
01 Oct 86 TenerifeTenerife 1 - 4 Las PalmasLas Palmas ...
01 Oct 86 AgD CeutaAgD Ceuta 0 - 2 SevillaSevilla ...
01 Oct 86 Real SportingReal 1 - 1 RacingRacing ...
01 Oct 86 Real Madrid CReal Madrid 1 - 0 Atlético BAtlético 1
01 Oct 86 At. SanluqueñoSanluqueño 0 - 1 CádizCádiz ...
01 Oct 86 AlbaceteAlbacete 3 - 2 Real MurciaReal Murcia ...
01 Oct 86 UtreraUtrera 0 - 4 Real BetisReal Betis ...
01 Oct 86 LleidaLleida 2 - 3 Barça AtlèticBarça 1
01 Oct 86 CD RondaCD Ronda 2 - 3 CD MálagaCD Málaga ...
01 Oct 86 CD OurenseCD Ourense 1 - 0 CD LugoCD Lugo ...
01 Oct 86 Mallorca BMallorca B 3 - 3 PoblensePoblense ...
01 Oct 86 Las Palmas At.Palmas 3 - 0 CD MensajeroMensajero ...
01 Oct 86 CF ExtremaduraExtremadura 2 - 1 CD Don BenitoBenito ...
01 Oct 86 TorreviejaTorrevieja 5 - 2 Águilas CFÁguilas ...
01 Oct 86 Osasuna PromesasOsasuna 1 - 2 CD LogroñésLogroñés ...
01 Oct 86 BarakaldoBarakaldo 2 - 3 Real Sociedad BReal ...
01 Oct 86 CE ManresaCE Manresa 0 - 4 CE SabadellSabadell ...
01 Oct 86 Real Burgos CFReal Burgos 0 - 3 Real ValladolidReal ...
01 Oct 86 At. MalagueñoMalagueño 0 - 4 CD RoquetasRoquetas ...
01 Oct 86 Rayo CantabriaRayo 0 - 1 Real OviedoReal Oviedo ...
01 Oct 86 VillarrealVillarreal 0 - 0 CF GandiaCF Gandia ...
Jornada 3
23 Oct 86 Atlético BalearesAtlético 2 - 1 Barça AtlèticBarça 3
23 Oct 86 At. ValdemoroValdemoro 2 - 3 Real BetisReal Betis ...
23 Oct 86 Terrassa FCTerrassa 2 - 3 Las PalmasLas Palmas ...
22 Oct 86 UD MontijoUD Montijo 0 - 1 Real SociedadReal 2
22 Oct 86 Atlético MarbellaAtlético 0 - 0 CeltaCelta ...
22 Oct 86 Mallorca BMallorca B 1 - 1 CD MálagaCD Málaga ...
22 Oct 86 Las Palmas At.Palmas 1 - 0 Real OviedoReal Oviedo ...
22 Oct 86 Cultural LeonesaCultural 0 - 1 CD CastellónCastellón ...
22 Oct 86 LangreoLangreo 4 - 2 Real ValladolidReal ...
22 Oct 86 EibarEibar 1 - 0 SevillaSevilla ...
22 Oct 86 AlcoyanoAlcoyano 3 - 0 RC DeportivoDeportivo ...
22 Oct 86 RB LinenseRB Linense 1 - 1 EldenseEldense ...
22 Oct 86 CD OurenseCD Ourense 1 - 1 OsasunaOsasuna ...
22 Oct 86 AlbaceteAlbacete 1 - 0 CE SabadellSabadell ...
22 Oct 86 TorreviejaTorrevieja 0 - 2 MallorcaMallorca ...
22 Oct 86 VillarrealVillarreal 2 - 0 UD SalamancaSalamanca ...
22 Oct 86 CD RoquetasRoquetas 0 - 3 CádizCádiz ...
21 Oct 86 Real Madrid CReal Madrid 1 - 0 RacingRacing ...
15 Oct 86 CF ExtremaduraExtremadura 1 - 4 CD LogroñésLogroñés ...
22 Oct 86 Real Sociedad BReal 1 - 0 Bilbao Ath.Bilbao Ath. ...
Jornada 4
18 Nov 86 LangreoLangreo 2 - 0 CD CastellónCastellón ...
13 Nov 86 Atlético BalearesAtlético 2 - 4 MallorcaMallorca ...
06 Nov 86 Mallorca BMallorca B 3 - 2 Real Sociedad BReal ...
05 Nov 86 VillarrealVillarreal 0 - 1 Real SociedadReal ...
05 Nov 86 Las Palmas At.Palmas 0 - 1 CD LogroñésLogroñés ...
05 Nov 86 AlcoyanoAlcoyano 0 - 0 CádizCádiz ...
05 Nov 86 Atlético MarbellaAtlético 0 - 0 Real BetisReal Betis ...
05 Nov 86 Real Madrid CReal Madrid 3 - 1 Las PalmasLas Palmas ...
05 Nov 86 AlbaceteAlbacete 1 - 2 OsasunaOsasuna ...
Jornada 5
11 Feb 87 MallorcaMallorca 2 - 0 Real ZaragozaReal ...
11 Feb 87 Real SociedadReal 2 - 0 EibarEibar ...
11 Feb 87 CD LogroñésLogroñés 3 - 1 Real BetisReal Betis ...
11 Feb 87 AthleticAthletic 4 - 1 LangreoLangreo 1
11 Feb 87 EldenseEldense 1 - 0 Mallorca BMallorca B ...
11 Feb 87 Real MadridReal Madrid 6 - 1 CádizCádiz ...
29 Ene 87 Real ZaragozaReal 1 - 0 MallorcaMallorca ...
11 Feb 87 OsasunaOsasuna 0 - 1 BarcelonaBarcelona ...
28 Ene 87 CádizCádiz 0 - 0 Real MadridReal Madrid ...
28 Ene 87 Mallorca BMallorca B 3 - 1 EldenseEldense ...
28 Ene 87 EibarEibar 0 - 2 Real SociedadReal ...
28 Ene 87 LangreoLangreo 0 - 1 AthleticAthletic 3
28 Ene 87 AtléticoAtlético 1 - 0 Real Madrid CReal Madrid ...
28 Ene 87 Real BetisReal Betis 0 - 0 CD LogroñésLogroñés ...
28 Ene 87 BarcelonaBarcelona 0 - 1 OsasunaOsasuna ...
11 Feb 87 Real Madrid CReal Madrid 1 - 3 AtléticoAtlético ...
Jornada 6
25 Feb 87 OsasunaOsasuna 1 - 2 Real MadridReal Madrid ...
25 Feb 87 AtléticoAtlético 1 - 0 MallorcaMallorca ...
25 Feb 87 Mallorca BMallorca B 0 - 0 Real SociedadReal ...
25 Feb 87 AthleticAthletic 2 - 0 CD LogroñésLogroñés ...
11 Mar 87 Real SociedadReal 10 - 1 Mallorca BMallorca B ...
11 Mar 87 CD LogroñésLogroñés 1 - 0 AthleticAthletic ...
11 Mar 87 MallorcaMallorca 1 - 3 AtléticoAtlético ...
11 Mar 87 Real MadridReal Madrid 4 - 1 OsasunaOsasuna ...
Jornada 7
03 Jun 87 Real SociedadReal 0 - 0 AthleticAthletic ...
03 Jun 87 Real MadridReal Madrid 3 - 2 AtléticoAtlético ...
10 Jun 87 AtléticoAtlético 2 - 0 Real MadridReal Madrid ...
10 Jun 87 AthleticAthletic 0 - 1 Real SociedadReal ...
Jornada 8
27 Jun 87 Real SociedadReal 2 - 2 AtléticoAtlético 1

  USO DE MEMORIA  
5,431,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1226
Total Execution Time  0.1245
  CADENA URL  
/copa_del_rey1987/grupo0/calendario
  GET DATOS  
$_GET['/copa_del_rey1987/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0017  SELECT type FROM routes WHERE alias = 'copa_del_rey1987'
0.0037  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 = 1987 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=129 AND type_rel = 3
0.0152  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.0021  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.0026  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 = 21877 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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 calendars1987 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 21877 ORDER BY round ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 21:17:55' 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-04-30 21:17:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 21:17:55' 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-04-30 21:17:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1987
0.0039  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (21877) 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.0021  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 (21877) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (252308,252477,252190,252227,252346,252382,256877,261510,672537,252229) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1987
0.0037  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (21877) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0020  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 (21877) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (252313,256152,256932,252188,252227,252232,252246,252289,252308,252383) ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1987
0.0037  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (21877) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0021  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 (21877) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (252237,252388,252462,252473,256312,256475,256595,256711,256932,257046) ORDER BY rp.in_squad = 1 DESC