4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1944
Temporada Siguiente »
Publicidad 600x120.gif
Copa del Rey 1944
1943/1944

Copa del Rey 1944

Resultados
« Jornada Anterior
F. Previas
Jornada Siguiente »
 
05 Mar 44
Finalizado 		Fábrica Nacional Fábrica Nacional 4-0 Racing De Sama Racing De Sama más información Jugadas destacadas ...
20' Argüelles 1-0
22' Argüelles 2-0
44' Rosell 3-0
69' Argüelles 4-0
 
12 Mar 44
Finalizado 		CD Teruel CD Teruel 6-1 Oberena Oberena más información Jugadas destacadas ...
49' Lafuente 1-0
51' Lafuente 2-0
59' Lafuente 3-0
68' Balbino 4-0
72' Peláez 5-0
5-1 79' Iciz
89' Pérez 6-1
 
05 Mar 44
Finalizado 		SG Lucense SG Lucense 2-3 Club Berbés Club Berbés más información Jugadas destacadas ...
0-1 10' Eloy
40' Nilo 1-1
1-2 55' Soage
1-3 75' César
89' Michines 2-3
 
05 Mar 44
Finalizado 		Gimnàstic Tarragona Gimnàstic Tarragona 2-0 EC Granollers EC Granollers más información Jugadas destacadas ...
5' Mauri 1-0
33' Huguet 2-0
 
05 Mar 44
Finalizado 		SD Indautxu SD Indautxu 0-1 Deportivo Alavés Deportivo Alavés más información Jugadas destacadas ...
0-1 10' Divino
 
12 Mar 44
Finalizado 		RCD Córdoba RCD Córdoba 4-2 UD Melilla UD Melilla más información Jugadas destacadas ...
0-1 2' Tiburcio
5' Vega 1-1
1-2 10' Tiburcio
40' Sillero 2-2
60' Acedo 3-2
87' Acedo 4-2
 
05 Mar 44
Finalizado 		Tánagra Tánagra 2-1 Sestao Sport Club Sestao Sport Club más información Jugadas destacadas 1
17' Botas 1-0
1-1 84' Lorin
100' Guzón 2-1
 
12 Mar 44
Finalizado 		Lérida Balompié Lérida Balompié 4-0 Huesca Huesca más información Jugadas destacadas ...
40' Vidal 1-0
60' Vidal 2-0
70' Sellart 3-0
80' Sellart 4-0
 
05 Mar 44
Finalizado 		Júpiter Júpiter 3-0 UE Figueres UE Figueres más información Jugadas destacadas ...
47' González 1-0
55' González 2-0
78' Castro 3-0
 
05 Mar 44
Finalizado 		RSD Alcalá RSD Alcalá 1-2 Imperio Madrid Imperio Madrid más información Jugadas destacadas ...
0-1 20' Cheme
45' Navarrete 1-1
1-2 80' Anselmo
 
05 Mar 44
Finalizado 		CD Acero CD Acero 6-2 Alicante Alicante más información Jugadas destacadas ...
2' Zúnica 1-0
40' Urrutia 2-0
55' Pérez 3-0
57' Manolín 4-0
60' Urrutia 5-0
75' Zúnica 6-0
6-1 88' Sirvent
6-2 89' Sirvent
 
05 Mar 44
Finalizado 		Albacete Albacete 1-0 Eldense Eldense más información Jugadas destacadas ...
15' Amat
 
05 Mar 44
Finalizado 		CD Badajoz CD Badajoz 3-0 CD Manchego CD Manchego más información Jugadas destacadas ...
32' Casariego 1-0
60' Casariego 2-0
85' Elizondo 3-0
 
05 Mar 44
Finalizado 		Recreativo Recreativo 3-1 Cádiz Cádiz más información Jugadas destacadas ...
30' Mazarío 1-0
1-1 56' Bazán
63' Cambra 2-1
70' Cambra 3-1
 
05 Mar 44
Finalizado 		Algeciras CF Algeciras CF 1-2 Real Jaén Real Jaén más información Jugadas destacadas ...
0-1 47' Carrillo
63' Díaz II 1-1
1-2 66' Gabella
 
05 Mar 44
Finalizado 		Real Murcia Imperial Real Murcia Imperial 2-1 Cartagena CF Cartagena CF más información Jugadas destacadas ...
11' Zamora 1-0
36' Zamora 2-0
2-1 72' Alcántara
JUGADORES DESTACADOS
RK Nombre Goles Posición Equipo
1 Vilanova es Vilanova 11 DEL Albacete Albacete
2 Zarra es Zarra 10 DEL Athletic Athletic
3 Igoa es Igoa 9 MED Valencia Valencia
4 Acedo es Acedo 9 DEL RCD Córdoba RCD Córdoba
5 Taltavull es Taltavull 8 DEL Atlético Atlético
6 Portilla es Portilla 7 MED Real Murcia Real Murcia
7 Gorostiza es Gorostiza 6 DEL Valencia Valencia
8 Mundo es Mundo 6 DEL Valencia Valencia
9 Campos es Campos 6 DEL Atlético Atlético
10 Escudero es Escudero 6 DEL Athletic Athletic
11 Nilo es Nilo 6 DEL SG Lucense SG Lucense
12 Argüelles es Argüelles 6 DEL Fábrica Nacional Fábrica Nacional
13 Herrerita es Herrerita 5 DEL Real Oviedo Real Oviedo
14 Panizo es Panizo 5 MED Athletic Athletic
15 Vázquez es Vázquez 5 DEL Atlético Atlético
16 Vega es Vega 5 MED RCD Córdoba RCD Córdoba
17 Galvany es Galvany 5 DEL Gimnàstic Tarragona Gimnàstic Tarragona
18 Mauri es Mauri 5 Gimnàstic Tarragona Gimnàstic Tarragona
19 Peláez es Peláez 5 DEL CD Teruel CD Teruel
20 Goicoechea es Goicoechea 5 DEL Maestranza Aerea Log. Maestranza Aerea Logroño

INFORMACIÓN

El Campeonato de España Copa de Su Majestad el Rey de Fútbol, comúnmente conocida como Copa del Rey o simplemente la Copa, es un torneo futbolístico por eliminación directa que se disputa anualmente entre los mejores clubes de España. La organiza la Real Federación Española de Fútbol y el actual campeón es el Sevilla C.F


  USO DE MEMORIA  
5,353,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3441
Total Execution Time  0.3460
  CADENA URL  
/copa_del_rey1944/grupo0/jornada3
  GET DATOS  
$_GET['/copa_del_rey1944/grupo0/jornada3']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0151  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 = 22158 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=1 ORDER BY l.group_code ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 09:28:13' 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-05-04 09:28:13' 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-05-04 09:28:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 09:28:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=22158 AND rel.round=3
0.0150  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-04-04" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 22158 ORDER BY creation_date DESC LIMIT 0, 10
0.0173  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-04-04" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 22158
0.0200  SELECT c.isVideo, c.id,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,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1944` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 22158 AND c.`round` = 3 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0149  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events1944 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1944 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 22158 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (2417,2425,2421,2416,2418,2426,2419,2424,2410,2412,2415,2414,2409,2408,2411,2413) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0150  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1944` e INNER JOIN calendars1944 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 3 AND e.real_date IS NOT NULL AND e.league_id = 22158 ORDER BY total DESC LIMIT 40
0.0147  SELECT distinct(shedule), round FROM `calendars1944` as c WHERE c.`league_id` = 22158 AND shedule >= '1944/03/01' AND shedule < '1944/04/01' ORDER BY shedule ASC
0.0157  SELECT data1, data2 FROM services_tags WHERE categoryId=129
0.0157  SELECT group_code, extraName from `leagues` WHERE categoryId=129 AND year=1944