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

Resultados de Fútbol

« Temporada Anterior

Temporada 1968

Temporada Siguiente »

1967/1968

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

Copa del Rey 1968

Primera División

Ver jornada

Jornada 1

Ver jornada

Jornada 2

Ver jornada

Jornada 3

Ver jornada

Jornada 4

09 Jun 68	Atlético	Atlético - Valencia 1968-06-09T00:00:00 Wanda Metropolitano 1 - 0	Valencia	...
16 Jun 68	Valencia	Valencia - Atlético 1968-06-16T00:00:00 Mestalla 2 - 3	Atlético	...
09 Jun 68	Barcelona	Barcelona - Athletic 1968-06-09T00:00:00 Spotify Camp Nou 3 - 1	Athletic	...
16 Jun 68	Athletic	Athletic - Barcelona 1968-06-16T00:00:00 San Mamés 0 - 0	Barcelona	...
09 Jun 68	Elche	Elche - Celta 1968-06-09T00:00:00 Martínez Valero 3 - 0	Celta	...
16 Jun 68	Celta	Celta - Elche 1968-06-16T00:00:00 Abanca Balaídos 3 - 0	Elche	...
09 Jun 68	Real	Real - Real Madrid 1968-06-09T00:00:00 La Romareda 3 - 2	Real Madrid	...
16 Jun 68	Real Madrid	Real Madrid - Real 1968-06-16T00:00:00 Santiago Bernabéu 2 - 0	Real	4
22 Jun 68	Celta	Celta - Elche 1968-06-22T00:00:00 Abanca Balaídos 2 - 1	Elche	...

Ver jornada

Jornada 5

23 Jun 68	Atlético	Atlético - Barcelona 1968-06-23T00:00:00 Wanda Metropolitano 1 - 0	Barcelona	...
30 Jun 68	Barcelona	Barcelona - Atlético 1968-06-30T00:00:00 Spotify Camp Nou 3 - 1	Atlético	...
23 Jun 68	Celta	Celta - Real Madrid 1968-06-23T00:00:00 Abanca Balaídos 3 - 2	Real Madrid	...
30 Jun 68	Real Madrid	Real Madrid - Celta 1968-06-30T00:00:00 Santiago Bernabéu 3 - 0	Celta	...

Ver jornada

Jornada 6

11 Jul 68

Barcelona

1 - 0

Real Madrid

Equipos de esta liga

USO DE MEMORIA

5,036,824 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1080
Total Execution Time	0.1100

CADENA URL

/copa_del_rey1968/grupo0/calendario

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (19)

0.0018	SELECT type FROM routes WHERE alias = 'copa_del_rey1968'
0.0042	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 = 1968 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=129 AND type_rel = 3
0.0172	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 129 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021	SELECT /53 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (801142,1286949,1244521,905062,976970) ORDER BY n.cover_points DESC, update_date DESC
0.0024	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 = 22134 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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 calendars1968 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 22134 ORDER BY round ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:45:07' 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=2 AND last_update > '2024-04-27 19:45:07' 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-04-27 19:45:07' 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-04-27 19:45:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1968
0.0022	SELECT e.action, count(e.action) as total, e.player_id FROM events1968 e WHERE e.league_id IN (22134) 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 (22134) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (255206,255436,255637,254697,254925,254995,254996,255213,255262,255290) ORDER BY rp.in_squad = 1 DESC
0.0020	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1968
0.0030	SELECT e.action, count(e.action) as total, e.player_id FROM events1968 e WHERE e.league_id IN (22134) 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 l.id FROM leagues_webci l WHERE l.categoryId = 129 AND l.year = 1968
0.0024	SELECT e.action, count(e.action) as total, e.player_id FROM events1968 e WHERE e.league_id IN (22134) 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 (22134) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (254642,255243,255600,255610,263281,263718) ORDER BY rp.in_squad = 1 DESC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

01 Oct 67	Alcoyano	Alcoyano - Burgos 1967-10-01T00:00:00 El Collao 2 - 0	Burgos	...
22 Oct 67	Burgos	Burgos - Alcoyano 1967-10-22T00:00:00 Municipal de El Plantío 0 - 0	Alcoyano	...
01 Oct 67	Club	Club - Racing 1967-10-01T00:00:00 No disponible 1 - 2	Racing	...
22 Oct 67	Racing	Racing - Club 1967-10-22T00:00:00 Campos de Sport de El Sardinero 2 - 1	Club	...
01 Oct 67	CD Badajoz	CD Badajoz - Real Murcia 1967-10-01T00:00:00 Nuevo Vivero 4 - 2	Real Murcia	...
22 Oct 67	Real Murcia	Real Murcia - CD Badajoz 1967-10-22T00:00:00 Enrique Roca de Murcia 1 - 0	CD Badajoz	...
01 Oct 67	Cádiz	Cádiz - Real 1967-10-01T00:00:00 Nuevo Mirandilla 2 - 1	Real	...
22 Oct 67	Real	Real - Cádiz 1967-10-22T00:00:00 El Molinón-Enrique Castro Quini 4 - 0	Cádiz	...
01 Oct 67	Puertollano	Puertollano - Racing 1967-10-01T00:00:00 Ciudad de Puertollano 1 - 0	Racing	...
22 Oct 67	Racing	Racing - Puertollano 1967-10-22T00:00:00 A Malata 0 - 2	Puertollano	...
01 Oct 67	Castellón	Castellón - Osasuna 1967-10-01T00:00:00 Municipal de Castalia 3 - 1	Osasuna	...
22 Oct 67	Osasuna	Osasuna - Castellón 1967-10-22T00:00:00 El Sadar 1 - 0	Castellón	...
01 Oct 67	Celta	Celta - Mallorca 1967-10-01T00:00:00 Abanca Balaídos 3 - 0	Mallorca	...
22 Oct 67	Mallorca	Mallorca - Celta 1967-10-22T00:00:00 Visit Mallora Estadi 0 - 1	Celta	...
01 Oct 67	Constància	Constància - Real 1967-10-01T00:00:00 Nou Camp d'Inca 2 - 2	Real	...
22 Oct 67	Real	Real - Constància 1967-10-22T00:00:00 Municipal José Zorrilla 8 - 0	Constància	...
01 Oct 67	Deportivo	Deportivo - Hércules 1967-10-01T00:00:00 Municipal Riazor 1 - 3	Hércules	...
22 Oct 67	Hércules	Hércules - Deportivo 1967-10-22T00:00:00 José Rico Pérez 1 - 1	Deportivo	...
01 Oct 67	CE Europa	CE Europa - Real Jaén 1967-10-01T00:00:00 Municipal Nou Sardenya 4 - 0	Real Jaén	1
22 Oct 67	Real Jaén	Real Jaén - CE Europa 1967-10-22T00:00:00 Municipal La Victoria 4 - 0	CE Europa	...
01 Oct 67	Gimnástica	Gimnástica - Valencia 1967-10-01T00:00:00 El Malecón 0 - 1	Valencia	...
22 Oct 67	Valencia	Valencia - Gimnástica 1967-10-22T00:00:00 Antonio Puchades 1 - 2	Gimnástica	...
01 Oct 67	Granada	Granada - Langreo 1967-10-01T00:00:00 Nuevo Los Cármenes 2 - 2	Langreo	...
22 Oct 67	Langreo	Langreo - Granada 1967-10-22T00:00:00 Nuevo Ganzábal 2 - 2	Granada	...
01 Oct 67	Xerez CD	Xerez CD - Lleida 1967-10-01T00:00:00 Estadio de la Juventud 3 - 0	Lleida	...
22 Oct 67	Lleida	Lleida - Xerez CD 1967-10-22T00:00:00 No disponible 3 - 0	Xerez CD	...
01 Oct 67	Levante	Levante - Badalona 1967-10-01T00:00:00 Ciutat de València 2 - 1	Badalona	...
22 Oct 67	Badalona	Badalona - Levante 1967-10-22T00:00:00 Estadi Municipal de Badalona 4 - 0	Levante	...
01 Oct 67	Real Oviedo	Real Oviedo - Recreativo 1967-10-01T00:00:00 Carlos Tartiere 3 - 2	Recreativo	...
22 Oct 67	Recreativo	Recreativo - Real Oviedo 1967-10-22T00:00:00 Nuevo Colombino 2 - 1	Real Oviedo	...
01 Oct 67	Rayo	Rayo - Tenerife 1967-10-01T00:00:00 Vallecas 3 - 1	Tenerife	...
22 Oct 67	Tenerife	Tenerife - Rayo 1967-10-22T00:00:00 Heliodoro Rodríguez López 1 - 0	Rayo	...
08 Dic 67	CE Europa	CE Europa - Real Jaén 1967-12-08T00:00:00 Municipal Nou Sardenya 4 - 0	Real Jaén	...
21 Dic 67	Gimnástica	Gimnástica - Valencia 1967-12-21T00:00:00 El Malecón 3 - 2	Valencia	...
14 Nov 67	Langreo	Langreo - Granada 1967-11-14T00:00:00 Nuevo Ganzábal 1 - 0	Granada	...
12 Dic 67	Xerez CD	Xerez CD - Lleida 1967-12-12T00:00:00 Estadio de la Juventud 2 - 1	Lleida	...
19 Mar 68	Recreativo	Recreativo - Real Oviedo 1968-03-19T00:00:00 Nuevo Colombino 1 - 1	Real Oviedo	...

12 May 68	Badalona	Badalona - Real Betis 1968-05-12T00:00:00 Estadi Municipal de Badalona 2 - 3	Real Betis	...
19 May 68	Real Betis	Real Betis - Badalona 1968-05-19T00:00:00 Benito Villamarín 0 - 1	Badalona	...
12 May 68	Real	Real - Atlético 1968-05-12T00:00:00 Municipal José Zorrilla 0 - 3	Atlético	...
19 May 68	Atlético	Atlético - Real 1968-05-19T00:00:00 Wanda Metropolitano 3 - 3	Real	...
12 May 68	Hércules	Hércules - Espanyol 1968-05-12T00:00:00 José Rico Pérez 0 - 0	Espanyol	...
19 May 68	Espanyol	Espanyol - Hércules 1968-05-19T00:00:00 RCDE Stadium 4 - 2	Hércules	...
12 May 68	Valencia	Valencia - Gimnástica 1968-05-12T00:00:00 Mestalla 5 - 0	Gimnástica	...
19 May 68	Gimnástica	Gimnástica - Valencia 1968-05-19T00:00:00 El Malecón 0 - 1	Valencia	...
12 May 68	Racing	Racing - Real 1968-05-12T00:00:00 Campos de Sport de El Sardinero 0 - 1	Real	...
19 May 68	Real	Real - Racing 1968-05-19T00:00:00 Anoeta 3 - 1	Racing	...
12 May 68	Barcelona	Barcelona - Real 1968-05-12T00:00:00 Spotify Camp Nou 5 - 0	Real	...
19 May 68	Real	Real - Barcelona 1968-05-19T00:00:00 El Molinón-Enrique Castro Quini 2 - 0	Barcelona	...
12 May 68	Athletic	Athletic - Alcoyano 1968-05-12T00:00:00 San Mamés 1 - 0	Alcoyano	...
19 May 68	Alcoyano	Alcoyano - Athletic 1968-05-19T00:00:00 El Collao 1 - 4	Athletic	...
12 May 68	Langreo	Langreo - Las Palmas 1968-05-12T00:00:00 Nuevo Ganzábal 1 - 4	Las Palmas	...
19 May 68	Las Palmas	Las Palmas - Langreo 1968-05-19T00:00:00 Gran Canaria 6 - 1	Langreo	...
12 May 68	CD Badajoz	CD Badajoz - Elche 1968-05-12T00:00:00 Nuevo Vivero 0 - 1	Elche	...
19 May 68	Elche	Elche - CD Badajoz 1968-05-19T00:00:00 Martínez Valero 4 - 2	CD Badajoz	...
12 May 68	CD Málaga	CD Málaga - Castellón 1968-05-12T00:00:00 No disponible 1 - 0	Castellón	...
19 May 68	Castellón	Castellón - CD Málaga 1968-05-19T00:00:00 Municipal de Castalia 0 - 1	CD Málaga	...
12 May 68	Recreativo	Recreativo - Pontevedra 1968-05-12T00:00:00 Nuevo Colombino 2 - 0	Pontevedra	...
19 May 68	Pontevedra	Pontevedra - Recreativo 1968-05-19T00:00:00 Estadio Municipal de Pasarón 3 - 0	Recreativo	...
12 May 68	Celta	Celta - Córdoba 1968-05-12T00:00:00 Abanca Balaídos 1 - 1	Córdoba	...
19 May 68	Córdoba	Córdoba - Celta 1968-05-19T00:00:00 Municipal Nuevo Arcángel 0 - 2	Celta	...
12 May 68	Xerez CD	Xerez CD - Sabadell 1968-05-12T00:00:00 Estadio de la Juventud 2 - 0	Sabadell	...
19 May 68	Sabadell	Sabadell - Xerez CD 1968-05-19T00:00:00 Nova Creu Alta 3 - 0	Xerez CD	...
12 May 68	Real	Real - CE Europa 1968-05-12T00:00:00 La Romareda 3 - 0	CE Europa	...
19 May 68	CE Europa	CE Europa - Real 1968-05-19T00:00:00 Municipal Nou Sardenya 0 - 1	Real	...
12 May 68	Real Madrid	Real Madrid - Puertollano 1968-05-12T00:00:00 Santiago Bernabéu 2 - 0	Puertollano	...
19 May 68	Puertollano	Puertollano - Real Madrid 1968-05-19T00:00:00 Ciudad de Puertollano 0 - 1	Real Madrid	...
12 May 68	Sevilla	Sevilla - Rayo 1968-05-12T00:00:00 Ramón Sánchez Pizjuán 7 - 3	Rayo	...
19 May 68	Rayo	Rayo - Sevilla 1968-05-19T00:00:00 Vallecas 1 - 0	Sevilla	...
24 May 68	Real Betis	Real Betis - Badalona 1968-05-24T00:00:00 Benito Villamarín 3 - 1	Badalona	...

26 May 68	Real Betis	Real Betis - Atlético 1968-05-26T00:00:00 Benito Villamarín 0 - 0	Atlético	...
02 Jun 68	Atlético	Atlético - Real Betis 1968-06-02T00:00:00 Wanda Metropolitano 2 - 1	Real Betis	...
26 May 68	Espanyol	Espanyol - Valencia 1968-05-26T00:00:00 RCDE Stadium 1 - 0	Valencia	...
02 Jun 68	Valencia	Valencia - Espanyol 1968-06-02T00:00:00 Mestalla 2 - 0	Espanyol	...
26 May 68	Real	Real - Barcelona 1968-05-26T00:00:00 Anoeta 0 - 2	Barcelona	...
02 Jun 68	Barcelona	Barcelona - Real 1968-06-02T00:00:00 Spotify Camp Nou 6 - 1	Real	...
26 May 68	Athletic	Athletic - Las Palmas 1968-05-26T00:00:00 San Mamés 6 - 0	Las Palmas	...
02 Jun 68	Las Palmas	Las Palmas - Athletic 1968-06-02T00:00:00 Gran Canaria 2 - 0	Athletic	...
26 May 68	Elche	Elche - CD Málaga 1968-05-26T00:00:00 Martínez Valero 1 - 0	CD Málaga	...
02 Jun 68	CD Málaga	CD Málaga - Elche 1968-06-02T00:00:00 No disponible 0 - 1	Elche	...
26 May 68	Pontevedra	Pontevedra - Celta 1968-05-26T00:00:00 Estadio Municipal de Pasarón 0 - 0	Celta	...
02 Jun 68	Celta	Celta - Pontevedra 1968-06-02T00:00:00 Abanca Balaídos 2 - 1	Pontevedra	...
26 May 68	Sabadell	Sabadell - Real 1968-05-26T00:00:00 Nova Creu Alta 0 - 0	Real	...
02 Jun 68	Real	Real - Sabadell 1968-06-02T00:00:00 La Romareda 5 - 1	Sabadell	...
26 May 68	Real Madrid	Real Madrid - Sevilla 1968-05-26T00:00:00 Santiago Bernabéu 1 - 0	Sevilla	...
02 Jun 68	Sevilla	Sevilla - Real Madrid 1968-06-02T00:00:00 Ramón Sánchez Pizjuán 3 - 4	Real Madrid	...