Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

« Temporada Anterior

Temporada 2013

Temporada Siguiente »

2012/2013

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

Copa del Rey 2013

Primera División

Ver jornada

Jornada 1

29 Ago 12	Catarroja	Catarroja - Deportivo 2012-08-29T20:00:00 Mundial '82 0 - 2	Deportivo	40
30 Ago 12	Real Oviedo	Real Oviedo - Fuenlabrada 2012-08-30T20:30:00 Carlos Tartiere 2 - 0	Fuenlabrada	80
29 Ago 12	Caudal	Caudal - Marino 2012-08-29T19:30:00 Estadio Municipal Hermanos Antuña 2 - 0	Marino	16
29 Ago 12	Cádiz	Cádiz - Roque Lepe 2012-08-29T20:30:00 Nuevo Mirandilla 3 - 2	Roque Lepe	16
29 Ago 12	Logroñés	Logroñés - Logroñés 2012-08-29T20:00:00 Las Gaunas 2 - 1	Logroñés	16
29 Ago 12	Constància	Constància - Yeclano 2012-08-29T20:30:00 Nou Camp d'Inca 3 - 0	Yeclano	11
29 Ago 12	L´Hospital	L´Hospital - Orihuela 2012-08-29T19:00:00 Municipal Feixa Llarga 1 - 0	Orihuela	8
30 Ago 12	Sanluqueño	Sanluqueño - Cartagena 2012-08-30T21:30:00 El Palmar 1 - 0	Cartagena	32
29 Ago 12	Arroyo	Arroyo - La Roda CF 2012-08-29T20:30:00 Municipal Arroyo de la Luz 2 - 1	La Roda CF	5
29 Ago 12	Laudio	Laudio - Eibar 2012-08-29T20:00:00 Ellakuri 0 - 1	Eibar	11
29 Ago 12	Albacete	Albacete - Loja 2012-08-29T20:00:00 Carlos Belmonte 4 - 0	Loja	17
29 Ago 12	Ejea	Ejea - Peña Sport 2012-08-29T20:00:00 Estadio Municipal de Luchán 4 - 2	Peña Sport	11
29 Ago 12	CD Ourense	CD Ourense - Real Ávila 2012-08-29T20:30:00 O Couto 2 - 1	Real Ávila	38
29 Ago 12	Noja	Noja - Amorebieta 2012-08-29T18:30:00 La Caseta 3 - 2	Amorebieta	4
29 Ago 12	AE Prat	AE Prat - Gimnàstic 2012-08-29T19:30:00 Municipal Sagnier 2 - 1	Gimnàstic	7
29 Ago 12	Badalona	Badalona - Badalona 2012-08-29T20:00:00 Camp d’Esports Municipal de Llagostera 1 - 0	Badalona	4
29 Ago 12	Villarroble	Villarroble - Cacereño 2012-08-29T20:30:00 Nuestra Señora de la Caridad 1 - 3	Cacereño	37
29 Ago 12	Alcoyano	Alcoyano - Atlético 2012-08-29T20:00:00 El Collao 2 - 0	Atlético	3

Ver jornada

Jornada 2

11 Sep 12	Almería	Almería - Real Murcia 2012-09-11T21:30:00 Juegos del Mediterráneo 2 - 0	Real Murcia	384
12 Sep 12	Real	Real - Girona 2012-09-12T21:00:00 El Molinón-Enrique Castro Quini 2 - 0	Girona	20
12 Sep 12	Huesca	Huesca - Guadalajara 2012-09-12T21:00:00 El Alcoraz 2 - 1	Guadalajara	7
12 Sep 12	CD Lugo	CD Lugo - Racing 2012-09-12T21:00:00 Estadio Anxo Carro 0 - 1	Racing	29
11 Sep 12	Sabadell	Sabadell - Hércules 2012-09-11T12:00:00 Nova Creu Alta 2 - 0	Hércules	24
12 Sep 12	Villarreal	Villarreal - Ponferradin 2012-09-12T22:00:00 Estadio de la Cerámica 0 - 2	Ponferradin	71
11 Sep 12	Mirandés	Mirandés - Recreativo 2012-09-11T21:30:00 Estadio Municipal de Anduva 2 - 0	Recreativo	95
12 Sep 12	Córdoba	Córdoba - Elche 2012-09-12T20:00:00 Municipal Nuevo Arcángel 1 - 0	Elche	58
12 Sep 12	Xerez CD	Xerez CD - Las Palmas 2012-09-12T21:00:00 Estadio de la Juventud 0 - 1	Las Palmas	121
11 Sep 12	Alcorcón	Alcorcón - Numancia 2012-09-11T21:30:00 Santo Domingo 4 - 1	Numancia	22
12 Sep 12	Lucena	Lucena - Logroñés 2012-09-12T21:00:00 Ciudad de Lucena 4 - 1	Logroñés	22
12 Sep 12	Constància	Constància - CD Ourense 2012-09-12T20:30:00 Nou Camp d'Inca 1 - 1	CD Ourense	52
12 Sep 12	Lleida	Lleida - Eibar 2012-09-12T20:30:00 Camp d'Esports 0 - 2	Eibar	38
12 Sep 12	Badalona	Badalona - Ejea 2012-09-12T20:00:00 Camp d’Esports Municipal de Llagostera 1 - 0	Ejea	12
12 Sep 12	Huracán	Huracán - Albacete 2012-09-12T19:30:00 San Gregorio de Torrent 1 - 1	Albacete	41
12 Sep 12	Alcoyano	Alcoyano - Tenerife 2012-09-12T20:45:00 El Collao 1 - 0	Tenerife	98
12 Sep 12	Real Jaén	Real Jaén - Caudal 2012-09-12T21:30:00 Municipal La Victoria 2 - 0	Caudal	79
12 Sep 12	Cádiz	Cádiz - Arroyo 2012-09-12T21:00:00 Nuevo Mirandilla 1 - 2	Arroyo	35
12 Sep 12	Real Oviedo	Real Oviedo - AE Prat 2012-09-12T20:30:00 Carlos Tartiere 0 - 0	AE Prat	265
12 Sep 12	Deportivo	Deportivo - Sanluqueño 2012-09-12T20:00:00 Mendizorroza 2 - 1	Sanluqueño	55
12 Sep 12	L´Hospital	L´Hospital - Noja 2012-09-12T19:30:00 Municipal Feixa Llarga 1 - 1	Noja	44
12 Sep 12	RB Linense	RB Linense - UD Melilla 2012-09-12T21:00:00 Municipal de La Línea 2 - 2	UD Melilla	165

Ver jornada

Jornada 3

17 Oct 12	Huracán	Huracán - Deportivo 2012-10-17T20:00:00 San Gregorio de Torrent 1 - 2	Deportivo	279
17 Oct 12	Lucena	Lucena - Cacereño 2012-10-17T21:00:00 Ciudad de Lucena 1 - 3	Cacereño	223
17 Oct 12	AE Prat	AE Prat - Badalona 2012-10-17T20:45:00 Municipal Sagnier 2 - 3	Badalona	26
17 Oct 12	Eibar	Eibar - Arroyo 2012-10-17T20:00:00 Municipal de Ipurua 1 - 0	Arroyo	91
17 Oct 12	Constància	Constància - UD Melilla 2012-10-17T20:30:00 Nou Camp d'Inca 1 - 1	UD Melilla	580
17 Oct 12	Noja	Noja - Real Jaén 2012-10-17T19:30:00 La Caseta 0 - 1	Real Jaén	465
17 Oct 12	Almería	Almería - Alcorcón 2012-10-17T21:00:00 Juegos del Mediterráneo 3 - 0	Alcorcón	28
17 Oct 12	Sabadell	Sabadell - Córdoba 2012-10-17T21:00:00 Nova Creu Alta 0 - 1	Córdoba	34
17 Oct 12	Huesca	Huesca - Ponferradin 2012-10-17T21:00:00 El Alcoraz 1 - 1	Ponferradin	53
18 Oct 12	Las Palmas	Las Palmas - Racing 2012-10-18T21:00:00 Gran Canaria 4 - 2	Racing	40
17 Oct 12	Real	Real - Mirandés 2012-10-17T21:00:00 El Molinón-Enrique Castro Quini 2 - 1	Mirandés	197

Ver jornada

Jornada 4

30 Oct 12	Deportivo	Deportivo - Barcelona 2012-10-30T22:00:00 Mendizorroza 0 - 3	Barcelona	476
31 Oct 12	Cacereño	Cacereño - Málaga 2012-10-31T20:00:00 Príncipe Felipe 3 - 4	Málaga	267
01 Nov 12	Eibar	Eibar - Athletic 2012-11-01T12:00:00 Municipal de Ipurua 0 - 0	Athletic	143
31 Oct 12	Alcoyano	Alcoyano - Real Madrid 2012-10-31T22:00:00 El Collao 1 - 4	Real Madrid	145
31 Oct 12	Real Jaén	Real Jaén - Atlético 2012-10-31T20:00:00 Municipal La Victoria 0 - 3	Atlético	378
01 Nov 12	UD Melilla	UD Melilla - Levante 2012-11-01T18:00:00 Municipal Álvarez Claro 1 - 0	Levante	251
30 Oct 12	Badalona	Badalona - Valencia 2012-10-30T20:00:00 Camp d’Esports Municipal de Llagostera 0 - 2	Valencia	110
28 Nov 12	Barcelona	Barcelona - Deportivo 2012-11-28T21:30:00 Spotify Camp Nou 3 - 1	Deportivo	333
27 Nov 12	Málaga	Málaga - Cacereño 2012-11-27T21:30:00 La Rosaleda 0 - 1	Cacereño	188
12 Dic 12	Athletic	Athletic - Eibar 2012-12-12T20:00:00 San Mamés 1 - 1	Eibar	102
27 Nov 12	Real Madrid	Real Madrid - Alcoyano 2012-11-27T21:30:00 Santiago Bernabéu 3 - 0	Alcoyano	76
28 Nov 12	Atlético	Atlético - Real Jaén 2012-11-28T19:30:00 Wanda Metropolitano 1 - 0	Real Jaén	88
28 Nov 12	Levante	Levante - UD Melilla 2012-11-28T19:30:00 Ciutat de València 4 - 1	UD Melilla	210
28 Nov 12	Valencia	Valencia - Badalona 2012-11-28T19:30:00 Mestalla 3 - 1	Badalona	18
01 Nov 12	Real	Real - Osasuna 2012-11-01T19:00:00 El Molinón-Enrique Castro Quini 1 - 0	Osasuna	40
01 Nov 12	Córdoba	Córdoba - Real 2012-11-01T19:00:00 Municipal Nuevo Arcángel 2 - 0	Real	88
01 Nov 12	Ponferradin	Ponferradin - Getafe 2012-11-01T19:00:00 Municipal El Toralín 0 - 4	Getafe	52
01 Nov 12	Deportivo	Deportivo - Mallorca 2012-11-01T21:00:00 Municipal Riazor 1 - 1	Mallorca	50
31 Oct 12	Real	Real - Granada 2012-10-31T20:00:00 La Romareda 1 - 0	Granada	48
01 Nov 12	Sevilla	Sevilla - Espanyol 2012-11-01T19:00:00 Ramón Sánchez Pizjuán 3 - 1	Espanyol	18
27 Nov 12	Osasuna	Osasuna - Real 2012-11-27T19:30:00 El Sadar 2 - 0	Real	21
27 Nov 12	Real	Real - Córdoba 2012-11-27T19:30:00 Anoeta 2 - 2	Córdoba	63
28 Nov 12	Getafe	Getafe - Ponferradin 2012-11-28T19:30:00 Coliseum Alfonso Pérez 0 - 0	Ponferradin	17
29 Nov 12	Mallorca	Mallorca - Deportivo 2012-11-29T21:30:00 Visit Mallora Estadi 0 - 0	Deportivo	20
29 Nov 12	Granada	Granada - Real 2012-11-29T19:30:00 Nuevo Los Cármenes 2 - 1	Real	80
28 Nov 12	Espanyol	Espanyol - Sevilla 2012-11-28T21:30:00 RCDE Stadium 0 - 3	Sevilla	12
01 Nov 12	Real	Real - Real Betis 2012-11-01T17:00:00 Municipal José Zorrilla 1 - 0	Real Betis	20
27 Nov 12	Real Betis	Real Betis - Real 2012-11-27T19:30:00 Benito Villamarín 3 - 0	Real	29
31 Oct 12	Las Palmas	Las Palmas - Rayo 2012-10-31T21:00:00 Gran Canaria 1 - 0	Rayo	75
27 Nov 12	Rayo	Rayo - Las Palmas 2012-11-27T19:30:00 Vallecas 0 - 0	Las Palmas	63
31 Oct 12	Almería	Almería - Celta 2012-10-31T20:00:00 Juegos del Mediterráneo 2 - 0	Celta	28
29 Nov 12	Celta	Celta - Almería 2012-11-29T19:30:00 Abanca Balaídos 3 - 0	Almería	72

Ver jornada

Jornada 5

13 Dic 12	Las Palmas	Las Palmas - Real Betis 2012-12-13T22:00:00 Gran Canaria 1 - 1	Real Betis	138
10 Ene 13	Real Betis	Real Betis - Las Palmas 2013-01-10T21:30:00 Benito Villamarín 1 - 0	Las Palmas	82
11 Dic 12	Osasuna	Osasuna - Valencia 2012-12-11T20:00:00 El Sadar 0 - 2	Valencia	42
08 Ene 13	Valencia	Valencia - Osasuna 2013-01-08T21:30:00 Mestalla 2 - 1	Osasuna	17
12 Dic 12	Atlético	Atlético - Getafe 2012-12-12T22:00:00 Wanda Metropolitano 3 - 0	Getafe	26
10 Ene 13	Getafe	Getafe - Atlético 2013-01-10T19:30:00 Coliseum Alfonso Pérez 0 - 0	Atlético	17
12 Dic 12	Celta	Celta - Real Madrid 2012-12-12T22:00:00 Abanca Balaídos 2 - 1	Real Madrid	182
09 Ene 13	Real Madrid	Real Madrid - Celta 2013-01-09T21:30:00 Santiago Bernabéu 4 - 0	Celta	232
12 Dic 12	Córdoba	Córdoba - Barcelona 2012-12-12T20:00:00 Municipal Nuevo Arcángel 0 - 2	Barcelona	224
10 Ene 13	Barcelona	Barcelona - Córdoba 2013-01-10T21:30:00 Spotify Camp Nou 5 - 0	Córdoba	159
13 Dic 12	Levante	Levante - Real 2012-12-13T20:00:00 Ciutat de València 0 - 1	Real	46
09 Ene 13	Real	Real - Levante 2013-01-09T21:30:00 La Romareda 2 - 0	Levante	57
12 Dic 12	Mallorca	Mallorca - Sevilla 2012-12-12T20:00:00 Visit Mallora Estadi 0 - 5	Sevilla	35
09 Ene 13	Sevilla	Sevilla - Mallorca 2013-01-09T19:30:00 Ramón Sánchez Pizjuán 1 - 2	Mallorca	28
18 Dic 12	Eibar	Eibar - Málaga 2012-12-18T20:00:00 Municipal de Ipurua 1 - 1	Málaga	139
08 Ene 13	Málaga	Málaga - Eibar 2013-01-08T19:30:00 La Rosaleda 4 - 1	Eibar	128

Ver jornada

Jornada 6

15 Ene 13	Real Madrid	Real Madrid - Valencia 2013-01-15T21:00:00 Santiago Bernabéu 2 - 0	Valencia	242
16 Ene 13	Real	Real - Sevilla 2013-01-16T19:30:00 La Romareda 0 - 0	Sevilla	34
23 Ene 13	Valencia	Valencia - Real Madrid 2013-01-23T21:30:00 Mestalla 1 - 1	Real Madrid	242
23 Ene 13	Sevilla	Sevilla - Real 2013-01-23T19:30:00 Ramón Sánchez Pizjuán 4 - 0	Real	141
16 Ene 13	Barcelona	Barcelona - Málaga 2013-01-16T21:30:00 Spotify Camp Nou 2 - 2	Málaga	316
24 Ene 13	Málaga	Málaga - Barcelona 2013-01-24T22:00:00 La Rosaleda 2 - 4	Barcelona	393
17 Ene 13	Atlético	Atlético - Real Betis 2013-01-17T22:00:00 Wanda Metropolitano 2 - 0	Real Betis	67
24 Ene 13	Real Betis	Real Betis - Atlético 2013-01-24T20:00:00 Benito Villamarín 1 - 1	Atlético	107

Ver jornada

Jornada 7

26 Feb 13	Barcelona	Barcelona - Real Madrid 2013-02-26T21:00:00 Spotify Camp Nou 1 - 3	Real Madrid	1k
30 Ene 13	Real Madrid	Real Madrid - Barcelona 2013-01-30T21:00:00 Santiago Bernabéu 1 - 1	Barcelona	1k
27 Feb 13	Sevilla	Sevilla - Atlético 2013-02-27T22:00:00 Ramón Sánchez Pizjuán 2 - 2	Atlético	207
31 Ene 13	Atlético	Atlético - Sevilla 2013-01-31T22:00:00 Wanda Metropolitano 2 - 1	Sevilla	186

Ver jornada

Jornada 8

17 May 13

Real Madrid

1 - 2

Atlético

Equipos de esta liga

USO DE MEMORIA

5,109,480 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.3029
Total Execution Time	0.3048

CADENA URL

/copa_del_rey2013/grupo0/calendario

GET DATOS

$_GET['/copa_del_rey2013/grupo0/calendario']

POST DATOS

No hay datos POST existentes

CONSULTAS (17)

0.0106	SELECT type FROM routes WHERE alias = 'copa_del_rey2013'
0.0212	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 = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0110	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 = 1969 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0117	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 calendars2013 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 1969 ORDER BY round ASC
0.0107	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 09:42:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 09:42:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 09:42:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 09:42:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0117	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2013
0.0116	SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (1969) 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.0108	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 (1969) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (28178,28185,13324,23386,3318,23569,594,2139,7564,30482) ORDER BY rp.in_squad = 1 DESC
0.0112	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2013
0.0119	SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (1969) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0109	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 (1969) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (7393,23527,27021,28185,40197,6198,7576,21921,22230,22818) ORDER BY rp.in_squad = 1 DESC
0.0112	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 2013
0.0107	SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (1969) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0108	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 (1969) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (40197,7220,7393,14459,22230,22818,23240,23341,23482,23500) ORDER BY rp.in_squad = 1 DESC