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

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

Copa del Rey 2015

Ver jornada
Jornada 1
03 Sep 14 Racing FerrolRacing 5 - 1 Atl. AstorgaAtl. 41
03 Sep 14 SomozasSomozas 3 - 0 CD VareaCD Varea 36
03 Sep 14 Gimnástica TorrelavegaGimnástica 1 - 2 Lealtad VillaviciosaLealtad 26
03 Sep 14 Real Avilés IndustrialReal 0 - 0 Marino de LuancoMarino 114
03 Sep 14 BarakaldoBarakaldo 3 - 0 Trival ValderasTrival 29
03 Sep 14 UE CornellàCornellà 0 - 0 Real JaénReal Jaén 175
03 Sep 14 LeioaLeioa 1 - 0 Sestao RiverSestao 53
03 Sep 14 IzarraIzarra 1 - 0 At. GranadillaGranadilla 23
03 Sep 14 PuertollanoPuertollano 0 - 3 CD TeruelCD Teruel 50
03 Sep 14 HuescaHuesca 2 - 1 CD ToledoCD Toledo 78
03 Sep 14 Gimnàstic TarragonaGimnàstic 0 - 0 Atlético BalearesAtlético 129
03 Sep 14 AlcoyanoAlcoyano 1 - 1 Peña DeportivaPeña 34
03 Sep 14 HérculesHércules 2 - 2 EldenseEldense 316
03 Sep 14 San Roque de LepeRoque Lepe 0 - 3 CádizCádiz 137
03 Sep 14 FC CartagenaCartagena 0 - 1 UCAM MurciaUCAM Murcia 248
03 Sep 14 Lorca FCLorca FC 2 - 2 VillanovenseVillanovens 182
03 Sep 14 Real OviedoReal Oviedo 4 - 0 SD AmorebietaAmorebieta 241
03 Sep 14 Marbella FCMarbella 0 - 1 RB LinenseRB Linense 119
Ver jornada
Jornada 2
10 Sep 14 GuijueloGuijuelo 0 - 1 L´HospitaletL´Hospital 64
09 Sep 14 Deportivo AlavésDeportivo 2 - 0 OsasunaOsasuna 267
10 Sep 14 Real SportingReal 1 - 3 Real ValladolidReal 411
10 Sep 14 Real BetisReal Betis 2 - 0 CF Badalona FuturBadalona 255
10 Sep 14 RecreativoRecreativo 2 - 1 PonferradinaPonferradin 130
09 Sep 14 GironaGirona 0 - 0 TenerifeTenerife 249
10 Sep 14 MallorcaMallorca 0 - 2 Las PalmasLas Palmas 258
10 Sep 14 Real MurciaReal Murcia 1 - 2 CE SabadellSabadell 127
11 Sep 14 CD LugoCD Lugo 1 - 0 AlcorcónAlcorcón 161
10 Sep 14 AlbaceteAlbacete 1 - 0 Real ZaragozaReal 476
10 Sep 14 LeganésLeganés 1 - 1 NumanciaNumancia 128
10 Sep 14 Lleida EsportiuLleida 3 - 0 CD GuadalajaraGuadalajara 132
10 Sep 14 UE CornellàCornellà 3 - 2 ZamoraZamora 87
10 Sep 14 RB LinenseRB Linense 4 - 1 FuenlabradaFuenlabrada 147
10 Sep 14 AlcoyanoAlcoyano 1 - 0 Gimnàstic TarragonaGimnàstic 75
10 Sep 14 VillanovenseVillanovens 2 - 2 HuescaHuesca 154
10 Sep 14 LeioaLeioa 2 - 0 CD TeruelCD Teruel 51
10 Sep 14 CádizCádiz 2 - 1 Lealtad VillaviciosaLealtad 218
10 Sep 14 IzarraIzarra 3 - 1 SomozasSomozas 40
10 Sep 14 Real Avilés IndustrialReal 0 - 1 BarakaldoBarakaldo 120
10 Sep 14 UCAM MurciaUCAM Murcia 1 - 1 EldenseEldense 203
10 Sep 14 MirandésMirandés 4 - 1 Racing FerrolRacing 114
Ver jornada
Jornada 3
14 Oct 14 MirandésMirandés 0 - 1 Deportivo AlavésDeportivo 242
15 Oct 14 Real BetisReal Betis 0 - 0 CD LugoCD Lugo 462
14 Oct 14 AlbaceteAlbacete 2 - 1 RecreativoRecreativo 579
16 Oct 14 Las PalmasLas Palmas 2 - 0 NumanciaNumancia 353
15 Oct 14 Real ValladolidReal 2 - 0 GironaGirona 160
15 Oct 14 HuescaHuesca 2 - 1 BarakaldoBarakaldo 430
15 Oct 14 Real OviedoReal Oviedo 1 - 0 UCAM MurciaUCAM Murcia 2k
15 Oct 14 AlcoyanoAlcoyano 1 - 0 Lleida EsportiuLleida 169
15 Oct 14 RB LinenseRB Linense 1 - 2 CádizCádiz 523
15 Oct 14 UE CornellàCornellà 2 - 1 LeioaLeioa 94
15 Oct 14 L´HospitaletL´Hospital 3 - 2 IzarraIzarra 318
Ver jornada
Jornada 4
03 Dic 14 HuescaHuesca 0 - 4 BarcelonaBarcelona 2k
29 Oct 14 UE CornellàCornellà 1 - 4 Real MadridReal Madrid 2k
03 Dic 14 L´HospitaletL´Hospital 0 - 3 AtléticoAtlético 894
16 Dic 14 BarcelonaBarcelona 8 - 1 HuescaHuesca 2k
02 Dic 14 AlcoyanoAlcoyano 1 - 1 AthleticAthletic 1k
04 Dic 14 CádizCádiz 1 - 2 VillarrealVillarreal 926
04 Dic 14 Real OviedoReal Oviedo 0 - 0 Real SociedadReal 1k
29 Oct 14 CE SabadellSabadell 1 - 6 SevillaSevilla 806
02 Dic 14 Deportivo AlavésDeportivo 0 - 2 EspanyolEspanyol 424
05 Dic 14 AlbaceteAlbacete 1 - 1 LevanteLevante 605
02 Dic 14 Las PalmasLas Palmas 2 - 1 CeltaCelta 601
05 Dic 14 Real BetisReal Betis 3 - 4 AlmeríaAlmería 724
02 Dic 14 Real ValladolidReal 0 - 0 ElcheElche 244
05 Dic 14 GetafeGetafe 3 - 0 EibarEibar 210
03 Dic 14 GranadaGranada 1 - 0 Córdoba CFCórdoba 508
04 Dic 14 Rayo VallecanoRayo 1 - 2 ValenciaValencia 1k
03 Dic 14 RC DeportivoDeportivo 1 - 1 MálagaMálaga 593
02 Dic 14 Real MadridReal Madrid 5 - 0 UE CornellàCornellà 1k
18 Dic 14 AtléticoAtlético 2 - 2 L´HospitaletL´Hospital 1k
18 Dic 14 AthleticAthletic 1 - 0 AlcoyanoAlcoyano 723
17 Dic 14 VillarrealVillarreal 3 - 0 CádizCádiz 710
17 Dic 14 Real SociedadReal 2 - 0 Real OviedoReal Oviedo 1k
03 Dic 14 SevillaSevilla 5 - 1 CE SabadellSabadell 421
16 Dic 14 AlmeríaAlmería 2 - 1 Real BetisReal Betis 653
17 Dic 14 EspanyolEspanyol 1 - 0 Deportivo AlavésDeportivo 283
16 Dic 14 CeltaCelta 3 - 1 Las PalmasLas Palmas 735
18 Dic 14 ElcheElche 1 - 0 Real ValladolidReal 279
17 Dic 14 LevanteLevante 0 - 0 AlbaceteAlbacete 593
17 Dic 14 EibarEibar 1 - 2 GetafeGetafe 257
16 Dic 14 ValenciaValencia 4 - 4 Rayo VallecanoRayo 2k
18 Dic 14 MálagaMálaga 4 - 1 RC DeportivoDeportivo 478
17 Dic 14 Córdoba CFCórdoba 1 - 1 GranadaGranada 483
Ver jornada
Jornada 5
07 Ene 15 AlmeríaAlmería 1 - 1 GetafeGetafe 576
14 Ene 15 GetafeGetafe 1 - 0 AlmeríaAlmería 297
07 Ene 15 ValenciaValencia 2 - 1 EspanyolEspanyol 1k
13 Ene 15 EspanyolEspanyol 2 - 0 ValenciaValencia 3k
07 Ene 15 VillarrealVillarreal 1 - 0 Real SociedadReal 499
14 Ene 15 Real SociedadReal 2 - 2 VillarrealVillarreal 377
08 Ene 15 GranadaGranada 1 - 2 SevillaSevilla 852
14 Ene 15 SevillaSevilla 4 - 0 GranadaGranada 525
07 Ene 15 AtléticoAtlético 2 - 0 Real MadridReal Madrid 8k
15 Ene 15 Real MadridReal Madrid 2 - 2 AtléticoAtlético 7k
08 Ene 15 BarcelonaBarcelona 5 - 0 ElcheElche 3k
15 Ene 15 ElcheElche 0 - 4 BarcelonaBarcelona 1k
06 Ene 15 CeltaCelta 2 - 4 AthleticAthletic 1k
14 Ene 15 AthleticAthletic 0 - 2 CeltaCelta 1k
06 Ene 15 MálagaMálaga 2 - 0 LevanteLevante 422
13 Ene 15 LevanteLevante 3 - 2 MálagaMálaga 707
Ver jornada
Jornada 6
21 Ene 15 MálagaMálaga 0 - 0 AthleticAthletic 959
29 Ene 15 AthleticAthletic 1 - 0 MálagaMálaga 1k
21 Ene 15 VillarrealVillarreal 1 - 0 GetafeGetafe 1k
29 Ene 15 GetafeGetafe 0 - 1 VillarrealVillarreal 828
22 Ene 15 EspanyolEspanyol 3 - 1 SevillaSevilla 2k
29 Ene 15 SevillaSevilla 1 - 0 EspanyolEspanyol 2k
21 Ene 15 BarcelonaBarcelona 1 - 0 AtléticoAtlético 5k
28 Ene 15 AtléticoAtlético 2 - 3 BarcelonaBarcelona 7k
Ver jornada
Jornada 7
11 Feb 15 BarcelonaBarcelona 3 - 1 VillarrealVillarreal 4k
04 Mar 15 VillarrealVillarreal 1 - 3 BarcelonaBarcelona 5k
11 Feb 15 AthleticAthletic 1 - 1 EspanyolEspanyol 1k
04 Mar 15 EspanyolEspanyol 0 - 2 AthleticAthletic 3k
Ver jornada
Jornada 8
30 May 15 AthleticAthletic 1 - 3 BarcelonaBarcelona 14k

  USO DE MEMORIA  
5,109,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1045
Total Execution Time  0.1065
  CADENA URL  
/copa_del_rey2015/grupo0/calendario
  GET DATOS  
$_GET['/copa_del_rey2015/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0019  SELECT type FROM routes WHERE alias = 'copa_del_rey2015'
0.0041  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 = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0027  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 = 3992 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 calendars2015 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 3992 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 21:24:44' 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=2 AND last_update > '2024-05-08 21:24:44' 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=4 AND last_update > '2024-05-08 21:24:44' 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-08 21:24:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0037  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2015
0.0027  SELECT e.action, count(e.action) as total, e.player_id FROM events2015 e WHERE e.league_id IN (3992) 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 (3992) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (7408,64511,3354,23569,27116,29477,107189,510,21144,22806) ORDER BY rp.in_squad = 1 DESC
0.0027  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2015
0.0028  SELECT e.action, count(e.action) as total, e.player_id FROM events2015 e WHERE e.league_id IN (3992) AND (e.action = 4 or e.action = 5) 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 (3992) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (7393,34338,82646,3085,16939,23527,26974,29279,29973,31126) ORDER BY rp.in_squad = 1 DESC
0.0026  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2015
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2015 e WHERE e.league_id IN (3992) 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 (3992) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (7393,16939,23393,23507,23679,23865,30861,31601,32851,35191) ORDER BY rp.in_squad = 1 DESC