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

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

Copa del Rey 2014

Ver jornada
Jornada 1
04 Sep 13 OlotOlot 3 - 2 Huracán ValenciaHuracán 11
04 Sep 13 Écija BalompiéÉcija 2 - 2 Lorca FCLorca FC 11
04 Sep 13 Algeciras CFAlgeciras 2 - 1 Novelda CFNovelda CF 36
04 Sep 13 San Fernando CDFernando 1 - 0 RB LinenseRB Linense 14
04 Sep 13 Haro DeportivoHaro 0 - 0 Real OviedoReal Oviedo 119
04 Sep 13 TropezónTropezón 0 - 1 CD TuillaCD Tuilla 16
04 Sep 13 Caudal DeportivoCaudal 1 - 0 Racing FerrolRacing 8
04 Sep 13 LeganésLeganés 3 - 0 At. GranadillaGranadilla 62
04 Sep 13 BarakaldoBarakaldo 1 - 0 SD AmorebietaAmorebieta 8
04 Sep 13 LaudioLaudio 3 - 1 Real Unión ClubReal Unión 50
04 Sep 13 CD ToledoCD Toledo 0 - 1 HuescaHuesca 8
04 Sep 13 Gimnàstic TarragonaGimnàstic 1 - 1 AlcoyanoAlcoyano 49
04 Sep 13 UE Sant AndreuSant Andreu 2 - 1 Peña DeportivaPeña 21
04 Sep 13 ExtremaduraExtremadura 1 - 2 AlbaceteAlbacete 60
04 Sep 13 El Palo FCEl Palo FC 1 - 1 Xerez CDXerez CD 92
04 Sep 13 FC CartagenaCartagena 2 - 1 CD GuadalajaraGuadalajara 37
04 Sep 13 BurgosBurgos 3 - 1 San JuanSan Juan 21
04 Sep 13 SariñenaSariñena 1 - 0 Puerta BonitaPuerta 12
Ver jornada
Jornada 2
10 Sep 13 Deportivo AlavésDeportivo 1 - 0 Real ZaragozaReal 99
11 Sep 13 EibarEibar 1 - 0 TenerifeTenerife 83
11 Sep 13 GironaGirona 2 - 1 PonferradinaPonferradin 123
11 Sep 13 HérculesHércules 2 - 0 Real MurciaReal Murcia 184
11 Sep 13 CE SabadellSabadell 1 - 3 Las PalmasLas Palmas 97
11 Sep 13 RecreativoRecreativo 3 - 2 Real SportingReal 67
11 Sep 13 CD LugoCD Lugo 1 - 1 MirandésMirandés 64
10 Sep 13 MallorcaMallorca 1 - 4 AlcorcónAlcorcón 41
11 Sep 13 Real JaénReal Jaén 1 - 0 NumanciaNumancia 53
11 Sep 13 Córdoba CFCórdoba 2 - 2 RC DeportivoDeportivo 134
11 Sep 13 Gimnàstic TarragonaGimnàstic 1 - 1 AlbaceteAlbacete 210
11 Sep 13 L´HospitaletL´Hospital 3 - 4 RacingRacing 87
11 Sep 13 CD TuillaCD Tuilla 0 - 3 BurgosBurgos 29
11 Sep 13 Haro DeportivoHaro 1 - 0 SariñenaSariñena 9
11 Sep 13 LeganésLeganés 5 - 1 LucenaLucena 46
11 Sep 13 Olimpic XátivaOlimpic 1 - 0 BarakaldoBarakaldo 21
11 Sep 13 HuescaHuesca 0 - 1 FC CartagenaCartagena 20
11 Sep 13 Lleida EsportiuLleida 2 - 0 Caudal DeportivoCaudal 38
11 Sep 13 Écija BalompiéÉcija 0 - 2 LaudioLaudio 19
11 Sep 13 San Fernando CDFernando 0 - 1 TudelanoTudelano 13
11 Sep 13 UE Sant AndreuSant Andreu 2 - 0 OlotOlot 6
11 Sep 13 Xerez CDXerez CD 1 - 1 FuenlabradaFuenlabrada 50
Ver jornada
Jornada 3
16 Oct 13 GironaGirona 0 - 0 Deportivo AlavésDeportivo 125
17 Oct 13 EibarEibar 1 - 2 AlcorcónAlcorcón 95
17 Oct 13 Las PalmasLas Palmas 3 - 0 HérculesHércules 70
16 Oct 13 RecreativoRecreativo 1 - 0 CD LugoCD Lugo 58
16 Oct 13 Real JaénReal Jaén 2 - 0 RC DeportivoDeportivo 148
16 Oct 13 LaudioLaudio 2 - 2 Olimpic XátivaOlimpic 74
16 Oct 13 TudelanoTudelano 1 - 4 FC CartagenaCartagena 143
16 Oct 13 Haro DeportivoHaro 1 - 1 Algeciras CFAlgeciras 58
16 Oct 13 LeganésLeganés 1 - 1 RacingRacing 350
16 Oct 13 Xerez CDXerez CD 1 - 3 Lleida EsportiuLleida 158
16 Oct 13 BurgosBurgos 0 - 1 Gimnàstic TarragonaGimnàstic 78
Ver jornada
Jornada 4
07 Dic 13 Olimpic XátivaOlimpic 0 - 0 Real MadridReal Madrid 570
06 Dic 13 Algeciras CFAlgeciras 1 - 1 Real SociedadReal 105
06 Dic 13 FC CartagenaCartagena 1 - 4 BarcelonaBarcelona 870
07 Dic 13 UE Sant AndreuSant Andreu 0 - 4 AtléticoAtlético 97
06 Dic 13 RacingRacing 0 - 1 SevillaSevilla 189
08 Dic 13 Gimnàstic TarragonaGimnàstic 0 - 0 ValenciaValencia 87
06 Dic 13 Lleida EsportiuLleida 1 - 2 Real BetisReal Betis 580
07 Dic 13 RecreativoRecreativo 1 - 0 LevanteLevante 64
07 Dic 13 GironaGirona 1 - 1 GetafeGetafe 62
08 Dic 13 AlcorcónAlcorcón 0 - 2 GranadaGranada 67
08 Dic 13 Las PalmasLas Palmas 1 - 3 AlmeríaAlmería 218
08 Dic 13 Real JaénReal Jaén 2 - 2 EspanyolEspanyol 161
06 Dic 13 VillarrealVillarreal 2 - 2 ElcheElche 93
08 Dic 13 MálagaMálaga 3 - 3 OsasunaOsasuna 212
07 Dic 13 CeltaCelta 1 - 0 AthleticAthletic 142
06 Dic 13 Real ValladolidReal 0 - 0 Rayo VallecanoRayo 192
18 Dic 13 Real MadridReal Madrid 2 - 0 Olimpic XátivaOlimpic 578
18 Dic 13 Real SociedadReal 5 - 0 Algeciras CFAlgeciras 105
17 Dic 13 BarcelonaBarcelona 3 - 0 FC CartagenaCartagena 465
18 Dic 13 AtléticoAtlético 2 - 1 UE Sant AndreuSant Andreu 142
18 Dic 13 SevillaSevilla 0 - 2 RacingRacing 215
19 Dic 13 ValenciaValencia 1 - 0 Gimnàstic TarragonaGimnàstic 161
18 Dic 13 Real BetisReal Betis 2 - 2 Lleida EsportiuLleida 338
17 Dic 13 LevanteLevante 4 - 0 RecreativoRecreativo 58
17 Dic 13 GetafeGetafe 4 - 1 GironaGirona 35
17 Dic 13 GranadaGranada 0 - 2 AlcorcónAlcorcón 301
18 Dic 13 AlmeríaAlmería 0 - 0 Las PalmasLas Palmas 85
19 Dic 13 EspanyolEspanyol 2 - 0 Real JaénReal Jaén 142
17 Dic 13 ElcheElche 0 - 1 VillarrealVillarreal 66
17 Dic 13 OsasunaOsasuna 1 - 1 MálagaMálaga 177
19 Dic 13 AthleticAthletic 4 - 0 CeltaCelta 214
19 Dic 13 Rayo VallecanoRayo 3 - 1 Real ValladolidReal 80
Ver jornada
Jornada 5
08 Ene 14 BarcelonaBarcelona 4 - 0 GetafeGetafe 579
09 Ene 14 Real SociedadReal 0 - 0 VillarrealVillarreal 101
09 Ene 14 Real MadridReal Madrid 2 - 0 OsasunaOsasuna 711
09 Ene 14 Rayo VallecanoRayo 0 - 0 LevanteLevante 75
08 Ene 14 AlcorcónAlcorcón 1 - 0 EspanyolEspanyol 132
07 Ene 14 ValenciaValencia 1 - 1 AtléticoAtlético 764
08 Ene 14 Real BetisReal Betis 1 - 0 AthleticAthletic 238
08 Ene 14 RacingRacing 1 - 1 AlmeríaAlmería 229
16 Ene 14 GetafeGetafe 0 - 2 BarcelonaBarcelona 599
16 Ene 14 VillarrealVillarreal 0 - 1 Real SociedadReal 226
15 Ene 14 OsasunaOsasuna 0 - 2 Real MadridReal Madrid 644
15 Ene 14 LevanteLevante 1 - 0 Rayo VallecanoRayo 141
15 Ene 14 EspanyolEspanyol 4 - 2 AlcorcónAlcorcón 229
14 Ene 14 AtléticoAtlético 2 - 0 ValenciaValencia 418
15 Ene 14 AthleticAthletic 2 - 0 Real BetisReal Betis 326
14 Ene 14 AlmeríaAlmería 0 - 2 RacingRacing 449
Ver jornada
Jornada 6
21 Ene 14 EspanyolEspanyol 0 - 1 Real MadridReal Madrid 552
23 Ene 14 AtléticoAtlético 1 - 0 AthleticAthletic 566
22 Ene 14 Real SociedadReal 3 - 1 RacingRacing 364
22 Ene 14 LevanteLevante 1 - 4 BarcelonaBarcelona 829
28 Ene 14 Real MadridReal Madrid 1 - 0 EspanyolEspanyol 801
29 Ene 14 AthleticAthletic 1 - 2 AtléticoAtlético 827
30 Ene 14 RacingRacing 0 - 3 Real SociedadReal 622
29 Ene 14 BarcelonaBarcelona 5 - 1 LevanteLevante 555
Ver jornada
Jornada 7
05 Feb 14 Real MadridReal Madrid 3 - 0 AtléticoAtlético 2k
05 Feb 14 BarcelonaBarcelona 2 - 0 Real SociedadReal 1k
11 Feb 14 AtléticoAtlético 0 - 2 Real MadridReal Madrid 2k
12 Feb 14 Real SociedadReal 1 - 1 BarcelonaBarcelona 1k
Ver jornada
Jornada 8
16 Abr 14 BarcelonaBarcelona 1 - 2 Real MadridReal Madrid 4k

  USO DE MEMORIA  
5,115,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3420
Total Execution Time  0.3439
  CADENA URL  
/copa_del_rey2014/grupo0/calendario
  GET DATOS  
$_GET['/copa_del_rey2014/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0124  SELECT type FROM routes WHERE alias = 'copa_del_rey2014'
0.0252  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 = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0134  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 calendars2014 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 2735 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 13:58:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 13:58:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 13:58:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 13:58:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2014
0.0131  SELECT e.action, count(e.action) as total, e.player_id FROM events2014 e WHERE e.league_id IN (2735) 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.0128  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 (2735) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (23569,23527,27146,63294,13332,28185,29477,32465,58696,67338) ORDER BY rp.in_squad = 1 DESC
0.0136  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2014
0.0136  SELECT e.action, count(e.action) as total, e.player_id FROM events2014 e WHERE e.league_id IN (2735) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  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 (2735) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (29364,30356,30471,27010,27382,28178,34104,35055,37121,67959) ORDER BY rp.in_squad = 1 DESC
0.0132  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2014
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events2014 e WHERE e.league_id IN (2735) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0130  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 (2735) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (17910,22230,23765,27398,27457,27932,28260,29364,30356,31705) ORDER BY rp.in_squad = 1 DESC