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

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

Copa del Rey 2024

Ver jornada
Jornada 1
12 Oct 23 TuréganoTurégano 3 - 1 SanturtziSanturtzi 96
12 Oct 23 CD MonteCD Monte 0 - 1 BoiroBoiro 20
11 Oct 23 PradejónPradejón 1 - 2 Atlético de LugonesAtlético 160
12 Oct 23 AD TardientaTardienta 2 - 1 CD ZiraukiCD Zirauki 15
12 Oct 23 RubíRubí 0 - 0 Rotlet MolinarRotlet 78
11 Oct 23 CP Mijas Las LagunasMijas 0 - 1 Chiclana CFChiclana 128
12 Oct 23 Melilla CDMelilla CD 1 - 3 Deportivo MurciaDeportivo 39
11 Oct 23 Ceuta 6 de JunioCeuta Junio 0 - 3 BuñolBuñol 43
12 Oct 23 Hernán CortésHernán 3 - 1 CD SauzalCD Sauzal 80
12 Oct 23 CD Quintanar de la OrdenQuintanar 1 - 0 Unión Zona NorteUnión Zona 45
Ver jornada
Jornada 2
01 Nov 23 Hernán CortésHernán 1 - 12 Real BetisReal Betis 531
02 Nov 23 Chiclana CFChiclana 0 - 5 VillarrealVillarreal 236
01 Nov 23 AD TardientaTardienta 0 - 12 GetafeGetafe 298
01 Nov 23 Atlético de LugonesAtlético 0 - 6 Rayo VallecanoRayo 81
01 Nov 23 CD Quintanar de la OrdenQuintanar 0 - 3 SevillaSevilla 211
02 Nov 23 Deportivo MurciaDeportivo 0 - 10 Deportivo AlavésDeportivo 344
01 Nov 23 TuréganoTurégano 0 - 4 CeltaCelta 81
01 Nov 23 BuñolBuñol 0 - 1 Real SociedadReal 148
01 Nov 23 RubíRubí 1 - 2 AthleticAthletic 242
01 Nov 23 BoiroBoiro 0 - 4 MallorcaMallorca 59
01 Nov 23 San Roque de LepeRoque Lepe 1 - 2 GironaGirona 596
31 Oct 23 CF TalaveraTalavera 0 - 2 AlmeríaAlmería 171
01 Nov 23 CF Badalona FuturBadalona 0 - 0 CádizCádiz 399
02 Nov 23 UD LogroñésLogroñés 0 - 2 ValenciaValencia 367
02 Nov 23 ArosaArosa 3 - 0 GranadaGranada 407
31 Oct 23 ManacorManacor 0 - 3 Las PalmasLas Palmas 195
01 Nov 23 Atl. AstorgaAtl. 1 - 0 FC AndorraFC Andorra 257
31 Oct 23 CD VareaCD Varea 0 - 3 LevanteLevante 221
01 Nov 23 Real JaénReal Jaén 2 - 3 EldenseEldense 206
01 Nov 23 CD AzuagaCD Azuaga 0 - 0 FC CartagenaCartagena 216
14 Nov 23 AtzenetaAtzeneta 2 - 1 Real ZaragozaReal 550
01 Nov 23 Peña DeportivaPeña 1 - 5 Real ValladolidReal 41
31 Oct 23 CD MensajeroMensajero 0 - 2 EspanyolEspanyol 157
01 Nov 23 CDA NavalcarneroNavalcarner 0 - 1 AlcorcónAlcorcón 21
01 Nov 23 Terrassa FCTerrassa 1 - 0 AlbaceteAlbacete 205
01 Nov 23 GuijueloGuijuelo 0 - 3 Real SportingReal 116
01 Nov 23 UteboUtebo 1 - 2 MirandésMirandés 70
01 Nov 23 CE ManresaCE Manresa 1 - 2 Real OviedoReal Oviedo 161
31 Oct 23 Lorca DeportivaLorca 0 - 4 EibarEibar 211
01 Nov 23 CE EuropaCE Europa 0 - 2 ElcheElche 153
01 Nov 23 Marbella FCMarbella 1 - 3 Racing FerrolRacing 149
01 Nov 23 ZamoraZamora 2 - 2 RacingRacing 468
01 Nov 23 AD LlerenenseLlerenense 0 - 2 LeganésLeganés 45
02 Nov 23 HérculesHércules 1 - 2 BurgosBurgos 323
01 Nov 23 SD CompostelaCompostela 0 - 1 TenerifeTenerife 65
01 Nov 23 Águilas FCÁguilas 0 - 1 HuescaHuesca 71
01 Nov 23 CD Valle de EgüésValle 1 - 0 CD TeruelCD Teruel 95
01 Nov 23 BarakaldoBarakaldo 0 - 0 MálagaMálaga 199
01 Nov 23 AndratxAndratx 3 - 2 SD TarazonaTarazona 22
01 Nov 23 CD Manchego Ciudad RealManchego 1 - 3 Antequera CFAntequera 89
01 Nov 23 TudelanoTudelano 1 - 0 RecreativoRecreativo 196
01 Nov 23 Real Avilés IndustrialReal 0 - 1 ArenteiroArenteiro 82
08 Nov 23 Gimnástica SegovianaGimnástica 3 - 4 Sestao RiverSestao 220
01 Nov 23 CD CovadongaCovadonga 1 - 3 RC DeportivoDeportivo 241
01 Nov 23 NáxaraNáxara 1 - 2 UD MelillaUD Melilla 55
01 Nov 23 SD GernikaSD Gernika 0 - 2 Unionistas CFUnionistas 42
02 Nov 23 VillanovenseVillanovens 2 - 1 UD IbizaUD Ibiza 307
01 Nov 23 Atlético AntonianoAtlético 0 - 1 CD LugoCD Lugo 79
01 Nov 23 BarbastroBarbastro 1 - 0 PonferradinaPonferradin 119
01 Nov 23 Yeclano DeportivoYeclano 2 - 0 At. SanluqueñoSanluqueño 53
01 Nov 23 UCAM MurciaUCAM Murcia 0 - 0 Linares DeportivoLinares 79
01 Nov 23 ArandinaArandina 1 - 0 Real MurciaReal Murcia 108
31 Oct 23 CP CacereñoCacereño 2 - 3 CD CastellónCastellón 351
01 Nov 23 Orihuela CFOrihuela 0 - 0 Gimnàstic TarragonaGimnàstic 99
01 Nov 23 CD UrsariaCD Ursaria 1 - 2 CayónCayón 23
Ver jornada
Jornada 3
06 Dic 23 Atl. AstorgaAtl. 0 - 2 SevillaSevilla 186
05 Dic 23 AtzenetaAtzeneta 1 - 2 GetafeGetafe 550
05 Dic 23 ArosaArosa 0 - 1 ValenciaValencia 205
06 Dic 23 VillanovenseVillanovens 1 - 2 Real BetisReal Betis 637
06 Dic 23 BarbastroBarbastro 1 - 0 AlmeríaAlmería 255
07 Dic 23 ArandinaArandina 2 - 1 CádizCádiz 778
06 Dic 23 Terrassa FCTerrassa 0 - 1 Deportivo AlavésDeportivo 177
07 Dic 23 Orihuela CFOrihuela 2 - 5 GironaGirona 377
06 Dic 23 Yeclano DeportivoYeclano 0 - 2 Rayo VallecanoRayo 238
06 Dic 23 CD Valle de EgüésValle 0 - 3 MallorcaMallorca 53
22 Nov 23 ZamoraZamora 1 - 2 VillarrealVillarreal 840
06 Dic 23 TudelanoTudelano 1 - 2 Las PalmasLas Palmas 192
06 Dic 23 AndratxAndratx 0 - 1 Real SociedadReal 281
07 Dic 23 CayónCayón 0 - 3 AthleticAthletic 204
07 Dic 23 Sestao RiverSestao 1 - 2 CeltaCelta 184
06 Dic 23 CD LugoCD Lugo 2 - 0 MirandésMirandés 98
06 Dic 23 Antequera CFAntequera 0 - 2 HuescaHuesca 80
06 Dic 23 MálagaMálaga 1 - 0 EldenseEldense 228
06 Dic 23 RC DeportivoDeportivo 2 - 3 TenerifeTenerife 339
06 Dic 23 ArenteiroArenteiro 1 - 3 BurgosBurgos 84
05 Dic 23 CD CastellónCastellón 2 - 1 Real OviedoReal Oviedo 552
07 Dic 23 UD MelillaUD Melilla 1 - 1 EibarEibar 361
06 Dic 23 Unionistas CFUnionistas 2 - 0 Real SportingReal 352
07 Dic 23 Linares DeportivoLinares 1 - 3 ElcheElche 217
06 Dic 23 LevanteLevante 0 - 1 SD AmorebietaAmorebieta 185
05 Dic 23 EspanyolEspanyol 3 - 1 Real ValladolidReal 158
06 Dic 23 AlcorcónAlcorcón 0 - 0 FC CartagenaCartagena 238
07 Dic 23 Racing FerrolRacing 1 - 0 LeganésLeganés 206
Ver jornada
Jornada 4
07 Ene 24 BarbastroBarbastro 2 - 3 BarcelonaBarcelona 1k
06 Ene 24 ArandinaArandina 1 - 3 Real MadridReal Madrid 1k
07 Ene 24 CD CastellónCastellón 0 - 1 OsasunaOsasuna 846
06 Ene 24 CD LugoCD Lugo 1 - 3 AtléticoAtlético 495
07 Ene 24 MálagaMálaga 0 - 1 Real SociedadReal 443
08 Ene 24 Unionistas CFUnionistas 1 - 1 VillarrealVillarreal 2k
06 Ene 24 ElcheElche 0 - 2 GironaGirona 590
07 Ene 24 BurgosBurgos 0 - 3 MallorcaMallorca 357
07 Ene 24 TenerifeTenerife 2 - 0 Las PalmasLas Palmas 827
06 Ene 24 EspanyolEspanyol 0 - 1 GetafeGetafe 545
07 Ene 24 Racing FerrolRacing 1 - 2 SevillaSevilla 726
06 Ene 24 HuescaHuesca 0 - 2 Rayo VallecanoRayo 879
07 Ene 24 SD AmorebietaAmorebieta 2 - 4 CeltaCelta 408
07 Ene 24 FC CartagenaCartagena 1 - 2 ValenciaValencia 1k
07 Ene 24 EibarEibar 0 - 3 AthleticAthletic 297
06 Ene 24 Deportivo AlavésDeportivo 1 - 0 Real BetisReal Betis 707
Ver jornada
Jornada 5
18 Ene 24 Unionistas CFUnionistas 1 - 3 BarcelonaBarcelona 2k
16 Ene 24 TenerifeTenerife 0 - 1 MallorcaMallorca 443
16 Ene 24 GetafeGetafe 1 - 3 SevillaSevilla 876
17 Ene 24 OsasunaOsasuna 0 - 2 Real SociedadReal 756
17 Ene 24 ValenciaValencia 1 - 3 CeltaCelta 1k
16 Ene 24 AthleticAthletic 2 - 0 Deportivo AlavésDeportivo 707
18 Ene 24 AtléticoAtlético 4 - 2 Real MadridReal Madrid 3k
17 Ene 24 GironaGirona 3 - 1 Rayo VallecanoRayo 447
Ver jornada
Jornada 6
24 Ene 24 AthleticAthletic 4 - 2 BarcelonaBarcelona 3k
23 Ene 24 CeltaCelta 1 - 2 Real SociedadReal 755
24 Ene 24 MallorcaMallorca 3 - 2 GironaGirona 3k
25 Ene 24 AtléticoAtlético 1 - 0 SevillaSevilla 2k
Ver jornada
Jornada 7
06 Feb 24 MallorcaMallorca 0 - 0 Real SociedadReal 1k
07 Feb 24 AtléticoAtlético 0 - 1 AthleticAthletic 2k
27 Feb 24 Real SociedadReal 1 - 1 MallorcaMallorca 1k
29 Feb 24 AthleticAthletic 3 - 0 AtléticoAtlético 3k
Ver jornada
Jornada 8
06 Abr 24 AthleticAthletic 1 - 1 MallorcaMallorca 3k

  USO DE MEMORIA  
5,191,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.3941
Total Execution Time  0.3967
  CADENA URL  
/copa_del_rey2024/grupo0/calendario
  GET DATOS  
$_GET['/copa_del_rey2024/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0145  SELECT type FROM routes WHERE alias = 'copa_del_rey2024'
0.0292  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 = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0155  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 71759 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-27 13:44:52' 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-27 13:44:52' 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=4 AND last_update > '2024-04-27 13:44:52' 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-27 13:44:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2024
0.0150  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (71759) 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.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 (71759) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (80389,186129,396751,21144,48594,240048,16928,35477,131302,170510) ORDER BY rp.in_squad = 1 DESC
0.0151  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2024
0.0156  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (71759) AND (e.action = 4 or e.action = 5) 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 (71759) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (36293,71934,140938,147265,238315,21144,29499,33661,82130,107809) ORDER BY rp.in_squad = 1 DESC
0.0150  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2024
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (71759) AND (e.action = 3 or e.action = 4) 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 (71759) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (71934,82130,82285,139844,147309,177072,192566,198718,205919,213000) ORDER BY rp.in_squad = 1 DESC