4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2017
Temporada Siguiente »
Copa del Rey 2017
2016/2017

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

Copa del Rey 2017

Ver jornada
Jornada 1
31 Ago 16 Racing FerrolRacing 3 - 2 ZamoraZamora 189
31 Ago 16 BoiroBoiro 1 - 3 GuijueloGuijuelo 52
31 Ago 16 Caudal DeportivoCaudal 2 - 1 BurgosBurgos 130
31 Ago 16 CirboneroCirbonero 0 - 0 PonferradinaPonferradin 273
31 Ago 16 CD LaredoCD Laredo 2 - 3 Cultural LeonesaCultural 136
31 Ago 16 BarakaldoBarakaldo 4 - 0 SD ZamudioSD Zamudio 28
31 Ago 16 CD CalahorraCalahorra 0 - 0 UD LogroñésLogroñés 93
31 Ago 16 CD ToledoCD Toledo 2 - 0 UB ConquenseConquense 204
31 Ago 16 Sestao RiverSestao 4 - 2 Villa Santa BrígidaVilla Santa 69
31 Ago 16 SD AmorebietaAmorebieta 2 - 1 UD Yugo SocuéllamosYugo 144
31 Ago 16 AlbaceteAlbacete 2 - 1 Real Unión ClubReal Unión 154
31 Ago 16 Lleida EsportiuLleida 1 - 0 AE PratAE Prat 84
31 Ago 16 AndorraAndorra 0 - 5 HérculesHércules 378
31 Ago 16 ExtremaduraExtremadura 5 - 0 Mancha RealMancha Real 103
31 Ago 16 Lorca DeportivaLorca 1 - 2 Lorca FCLorca FC 361
31 Ago 16 At. SanluqueñoSanluqueño 1 - 0 Real MurciaReal Murcia 300
31 Ago 16 UE CornellàCornellà 2 - 1 UD SanseUD Sanse 47
31 Ago 16 At. SaguntinoSaguntino 1 - 1 SD FormenteraFormentera 55
Ver jornada
Jornada 2
07 Sep 16 Real ZaragozaReal 1 - 2 Real ValladolidReal 276
06 Sep 16 MirandésMirandés 2 - 2 ElcheElche 435
08 Sep 16 HuescaHuesca 1 - 0 GironaGirona 235
06 Sep 16 CD LugoCD Lugo 1 - 2 TenerifeTenerife 230
07 Sep 16 CádizCádiz 1 - 1 LevanteLevante 645
06 Sep 16 AlmeríaAlmería 0 - 2 Rayo VallecanoRayo 147
08 Sep 16 AlcorcónAlcorcón 1 - 0 GetafeGetafe 245
07 Sep 16 MallorcaMallorca 1 - 0 Reus DeportiuReus 159
07 Sep 16 Gimnàstic TarragonaGimnàstic 1 - 0 NumanciaNumancia 294
07 Sep 16 RacingRacing 2 - 1 CF Badalona FuturBadalona 258
08 Sep 16 UCAM MurciaUCAM Murcia 4 - 3 Real OviedoReal Oviedo 1k
07 Sep 16 AlbaceteAlbacete 2 - 0 Arenas de GetxoArenas 331
07 Sep 16 Caudal DeportivoCaudal 1 - 0 Lleida EsportiuLleida 232
07 Sep 16 FC CartagenaCartagena 1 - 1 HérculesHércules 1k
07 Sep 16 BarakaldoBarakaldo 3 - 3 SD AmorebietaAmorebieta 103
07 Sep 16 TudelanoTudelano 1 - 0 At. SanluqueñoSanluqueño 163
07 Sep 16 Racing FerrolRacing 0 - 0 CirboneroCirbonero 250
07 Sep 16 GuijueloGuijuelo 1 - 0 Sestao RiverSestao 75
07 Sep 16 CD ToledoCD Toledo 4 - 0 AlcoyanoAlcoyano 269
07 Sep 16 UE CornellàCornellà 3 - 1 ExtremaduraExtremadura 235
07 Sep 16 Cultural LeonesaCultural 3 - 1 CD CalahorraCalahorra 130
07 Sep 16 SD FormenteraFormentera 2 - 2 Lorca FCLorca FC 476
Ver jornada
Jornada 3
12 Oct 16 RacingRacing 2 - 0 SD AmorebietaAmorebieta 519
12 Oct 16 CirboneroCirbonero 1 - 2 GuijueloGuijuelo 437
12 Oct 16 TudelanoTudelano 0 - 0 SD FormenteraFormentera 469
12 Oct 16 CD ToledoCD Toledo 4 - 1 Caudal DeportivoCaudal 617
12 Oct 16 Cultural LeonesaCultural 2 - 1 AlbaceteAlbacete 599
12 Oct 16 HérculesHércules 2 - 1 UE CornellàCornellà 437
12 Oct 16 Rayo VallecanoRayo 1 - 1 Gimnàstic TarragonaGimnàstic 564
12 Oct 16 CádizCádiz 1 - 2 Córdoba CFCórdoba 536
11 Oct 16 ElcheElche 0 - 1 AlcorcónAlcorcón 188
12 Oct 16 MallorcaMallorca 1 - 2 UCAM MurciaUCAM Murcia 434
12 Oct 16 Real ValladolidReal 3 - 1 TenerifeTenerife 694
Ver jornada
Jornada 4
30 Nov 16 CD ToledoCD Toledo 0 - 3 VillarrealVillarreal 637
20 Dic 16 VillarrealVillarreal 1 - 1 CD ToledoCD Toledo 751
30 Nov 16 SD FormenteraFormentera 1 - 5 SevillaSevilla 338
21 Dic 16 SevillaSevilla 9 - 1 SD FormenteraFormentera 483
26 Oct 16 Cultural LeonesaCultural 1 - 7 Real MadridReal Madrid 3k
30 Nov 16 Real MadridReal Madrid 6 - 1 Cultural LeonesaCultural 1k
21 Dic 16 BarcelonaBarcelona 7 - 0 HérculesHércules 2k
30 Nov 16 HérculesHércules 1 - 1 BarcelonaBarcelona 2k
20 Dic 16 AtléticoAtlético 4 - 1 GuijueloGuijuelo 363
30 Nov 16 GuijueloGuijuelo 0 - 6 AtléticoAtlético 517
22 Dic 16 AthleticAthletic 3 - 0 RacingRacing 715
01 Dic 16 RacingRacing 1 - 2 AthleticAthletic 1k
22 Dic 16 CeltaCelta 1 - 0 UCAM MurciaUCAM Murcia 422
30 Nov 16 UCAM MurciaUCAM Murcia 0 - 1 CeltaCelta 433
30 Nov 16 Córdoba CFCórdoba 2 - 0 MálagaMálaga 599
20 Dic 16 MálagaMálaga 3 - 4 Córdoba CFCórdoba 770
01 Dic 16 Real ValladolidReal 1 - 3 Real SociedadReal 1k
20 Dic 16 Real SociedadReal 1 - 1 Real ValladolidReal 293
01 Dic 16 HuescaHuesca 2 - 2 Las PalmasLas Palmas 649
20 Dic 16 Las PalmasLas Palmas 2 - 1 HuescaHuesca 334
01 Dic 16 Gimnàstic TarragonaGimnàstic 0 - 3 Deportivo AlavésDeportivo 533
22 Dic 16 Deportivo AlavésDeportivo 3 - 0 Gimnàstic TarragonaGimnàstic 354
29 Nov 16 AlcorcónAlcorcón 1 - 1 EspanyolEspanyol 414
22 Dic 16 EspanyolEspanyol 1 - 1 AlcorcónAlcorcón 1k
29 Nov 16 Real SportingReal 1 - 2 EibarEibar 658
21 Dic 16 EibarEibar 3 - 1 Real SportingReal 484
21 Dic 16 OsasunaOsasuna 2 - 0 GranadaGranada 333
30 Nov 16 GranadaGranada 1 - 0 OsasunaOsasuna 265
29 Nov 16 LeganésLeganés 1 - 3 ValenciaValencia 759
21 Dic 16 ValenciaValencia 2 - 1 LeganésLeganés 515
29 Nov 16 Real BetisReal Betis 1 - 0 RC DeportivoDeportivo 643
21 Dic 16 RC DeportivoDeportivo 3 - 1 Real BetisReal Betis 760
Ver jornada
Jornada 5
03 Ene 17 Las PalmasLas Palmas 0 - 2 AtléticoAtlético 458
10 Ene 17 AtléticoAtlético 2 - 3 Las PalmasLas Palmas 1k
04 Ene 17 AlcorcónAlcorcón 0 - 0 Córdoba CFCórdoba 539
11 Ene 17 Córdoba CFCórdoba 1 - 2 AlcorcónAlcorcón 673
05 Ene 17 AthleticAthletic 2 - 1 BarcelonaBarcelona 6k
11 Ene 17 BarcelonaBarcelona 3 - 1 AthleticAthletic 6k
04 Ene 17 Real MadridReal Madrid 3 - 0 SevillaSevilla 4k
12 Ene 17 SevillaSevilla 3 - 3 Real MadridReal Madrid 6k
04 Ene 17 Real SociedadReal 3 - 1 VillarrealVillarreal 629
11 Ene 17 VillarrealVillarreal 1 - 1 Real SociedadReal 733
03 Ene 17 RC DeportivoDeportivo 2 - 2 Deportivo AlavésDeportivo 628
11 Ene 17 Deportivo AlavésDeportivo 1 - 1 RC DeportivoDeportivo 902
03 Ene 17 ValenciaValencia 1 - 4 CeltaCelta 2k
12 Ene 17 CeltaCelta 2 - 1 ValenciaValencia 1k
03 Ene 17 OsasunaOsasuna 0 - 3 EibarEibar 349
12 Ene 17 EibarEibar 0 - 0 OsasunaOsasuna 444
Ver jornada
Jornada 6
19 Ene 17 Real SociedadReal 0 - 1 BarcelonaBarcelona 4k
26 Ene 17 BarcelonaBarcelona 5 - 2 Real SociedadReal 4k
18 Ene 17 AlcorcónAlcorcón 0 - 2 Deportivo AlavésDeportivo 1k
24 Ene 17 Deportivo AlavésDeportivo 0 - 0 AlcorcónAlcorcón 840
19 Ene 17 AtléticoAtlético 3 - 0 EibarEibar 798
25 Ene 17 EibarEibar 2 - 2 AtléticoAtlético 756
25 Ene 17 CeltaCelta 2 - 2 Real MadridReal Madrid 7k
18 Ene 17 Real MadridReal Madrid 1 - 2 CeltaCelta 4k
Ver jornada
Jornada 7
02 Feb 17 CeltaCelta 0 - 0 Deportivo AlavésDeportivo 2k
08 Feb 17 Deportivo AlavésDeportivo 1 - 0 CeltaCelta 4k
01 Feb 17 AtléticoAtlético 1 - 2 BarcelonaBarcelona 4k
07 Feb 17 BarcelonaBarcelona 1 - 1 AtléticoAtlético 5k
Ver jornada
Jornada 8
27 May 17 BarcelonaBarcelona 3 - 1 Deportivo AlavésDeportivo 6k

  USO DE MEMORIA  
5,127,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4047
Total Execution Time  0.4067
  CADENA URL  
/copa_del_rey2017/grupo0/calendario
  GET DATOS  
$_GET['/copa_del_rey2017/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0144  SELECT type FROM routes WHERE alias = 'copa_del_rey2017'
0.0293  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 = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0149  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 = 33904 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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 calendars2017 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 33904 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-04-28 03:40:00' 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-04-28 03:40:00' 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-04-28 03:40:00' 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 03:40:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0156  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2017
0.0150  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (33904) 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.0149  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 (33904) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (23569,72169,11935,14381,29685,32465,43629,82134,88796,120440) ORDER BY rp.in_squad = 1 DESC
0.0157  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2017
0.0154  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (33904) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0150  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 (33904) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (7393,23569,23991,29526,29685,33541,64511,75798,82134,98590) ORDER BY rp.in_squad = 1 DESC
0.0181  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2017
0.0154  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (33904) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0169  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 (33904) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (23527,29443,29526,29685,29879,29975,33541,61365,75438,75601) ORDER BY rp.in_squad = 1 DESC