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

LIVESCORE / Partidos del Domingo, 21 Abril 2024 - Ligas de España

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 21 ABR
Comunidad Valenciana Andalucía País Vasco Extremadura Castilla y León Islas Baleares Aragón Cantabria Islas Canarias Castilla-La Mancha

Partidos Domingo, 21 Abril 2024

España
Primera División Primera División »
Televisión
14:00
  Finalizado Getafe Getafe
1 - 1
 		Real Sociedad Real Sociedad 333
Televisión
16:15
  Finalizado Almería Almería
1 - 2
 		Villarreal Villarreal 296
Televisión
18:30
  Finalizado Deportivo Alavés Deportivo Alavés
2 - 0
 		Atlético Atlético 1456
Televisión
21:00
  Finalizado Real Madrid Real Madrid
3 - 2
 		Barcelona Barcelona 5231
Segunda División Segunda División »
Televisión
14:00
  Finalizado Espanyol Espanyol
1 - 1
 		FC Andorra FC Andorra 364
Televisión
16:15
  Finalizado Eldense Eldense
0 - 1
 		Albacete Albacete 183
Televisión
16:15
  Finalizado Eibar Eibar
2 - 0
 		Alcorcón Alcorcón 137
Televisión
18:30
  Finalizado Mirandés Mirandés
2 - 1
 		Burgos Burgos 287
Segunda Federación Grupo 1 Segunda Federación Grupo 1 »
12:00
  Finalizado Rayo Cantabria Rayo Cantabria
2 - 4
 		Arandina Arandina 28
12:00
  Finalizado Cayón Cayón
1 - 2
 		Gimnástica Gimnástica 11
17:00
  Finalizado Guijuelo Guijuelo
2 - 0
 		RC Villalbés RC Villalbés 3
17:00
  Finalizado Langreo Langreo
0 - 2
 		Real Valladolid P. Real Valladolid P. 40
Televisión
17:00
  Finalizado Pontevedra Pontevedra
0 - 2
 		Ourense CF Ourense CF 180
18:00
  Finalizado Real Avilés Indus. Real Avilés Indus.
3 - 1
 		CD Covadonga CD Covadonga 44
18:00
  Finalizado Marino de Luanco Marino de Luanco
2 - 0
 		Zamora Zamora 49
Segunda Federación Grupo 2 Segunda Federación Grupo 2 »
12:00
  Finalizado Arenas de Getxo Arenas de Getxo
2 - 2
 		Deportivo Aragón Deportivo Aragón 4
Televisión
12:00
  Finalizado Brea Brea
0 - 2
 		Utebo Utebo 1
17:00
  Finalizado Tudelano Tudelano
4 - 0
 		Izarra Izarra 4
17:00
  Finalizado Náxara Náxara
0 - 3
 		Barbastro Barbastro 7
17:00
  Finalizado CD Calahorra CD Calahorra
3 - 0
 		Valle Egüés Valle Egüés 3
17:00
  Finalizado SD Gernika SD Gernika
0 - 2
 		UD Logroñés UD Logroñés 14
18:00
  Finalizado Barakaldo Barakaldo
3 - 2
 		Deportivo Alavés Deportivo Alavés 7
Segunda Federación Grupo 5 Segunda Federación Grupo 5 »
12:00
  Finalizado UD Sanse UD Sanse
4 - 0
 		CD Mensajero CD Mensajero 23
12:00
  Finalizado CD Ursaria CD Ursaria
0 - 1
 		Numancia Numancia 54
12:00
  Finalizado Unión Adarve Unión Adarve
0 - 2
 		Getafe B Getafe B 19
12:30
  Finalizado UD Montijo UD Montijo
1 - 2
 		CD Badajoz CD Badajoz 135
13:00
  Finalizado UD San Fernando UD San Fernando
1 - 2
 		CDA Navalcarnero CDA Navalcarnero 53
17:00
  Finalizado CF Talavera CF Talavera
1 - 0
 		CD Illescas CD Illescas 27
17:30
  Finalizado CP Cacereño CP Cacereño
2 - 0
 		CD Atlético Paso CD Atlético Paso 55
18:00
  Finalizado Gimnástica Gimnástica
1 - 0
 		AD Llerenense AD Llerenense 142
Tercera Federación Grupo 5 Tercera Federación Grupo 5 »
11:45
  Finalizado FE Grama FE Grama
2 - 0
 		Pobla Mafumet Pobla Mafumet 0
12:00
  Finalizado CP San Cristóbal CP San Cristóbal
1 - 0
 		CF Peralada CF Peralada 0
12:00
  Finalizado CFJ Mollerussa CFJ Mollerussa
1 - 0
 		Girona FC B Girona FC B 0
12:00
  Finalizado Castelldefels Castelldefels
1 - 2
 		FC Vilafranca FC Vilafranca 1
12:00
  Finalizado AE Prat AE Prat
0 - 0
 		Reus FC Reddis Reus FC Reddis 42
12:30
  Finalizado L´Hospitalet L´Hospitalet
1 - 0
 		L'Escala L'Escala 4
Tercera Federación Grupo 7 Tercera Federación Grupo 7 »
11:30
  Finalizado AD Torrejón CF AD Torrejón CF
0 - 0
 		Alcorcón B Alcorcón B 0
11:30
  Finalizado Leganés B Leganés B
0 - 1
 		CF Pozuelo CF Pozuelo 1
11:30
  Finalizado Trival Valderas Trival Valderas
2 - 0
 		Villanueva Villanueva 0
11:30
  Finalizado CUC Villalba CUC Villalba
2 - 0
 		CDF Tres Cantos CDF Tres Cantos 0
11:30
  Finalizado AD Parla AD Parla
1 - 2
 		CD Móstoles CD Móstoles 16
12:00
  Finalizado RSD Alcalá RSD Alcalá
1 - 2
 		Real Madrid C Real Madrid C 0
12:00
  Finalizado Colonia Moscardó Colonia Moscardó
3 - 2
 		Rayo Vallecano B Rayo Vallecano B 0
12:00
  Finalizado Las Rozas Las Rozas
5 - 1
 		CD Canillas CD Canillas 0
Tercera Federación Grupo 12 Tercera Federación Grupo 12 »
12:00
  Finalizado Tenerife B Tenerife B
4 - 0
 		CD Buzanada CD Buzanada 10
12:15
  Finalizado Gran Tarajal Gran Tarajal
2 - 2
 		UD Teror UD Teror 4
13:00
  Finalizado Ibarra Ibarra
5 - 1
 		Herbania Herbania 1
13:00
  Finalizado Atletico Victoria Atletico Victoria
0 - 2
 		Tamaraceite Tamaraceite 1
13:00
  Finalizado Las Palmas At. Las Palmas At.
2 - 0
 		Arucas Arucas 4
Tercera Federación Grupo 14 Tercera Federación Grupo 14 »
11:30
  Finalizado Calamonte Calamonte
2 - 2
 		Fuente Cantos Fuente Cantos 2
12:30
  Finalizado Trujillo Trujillo
0 - 1
 		CD Diocesano CD Diocesano 2
12:30
  Finalizado Pueblonuevo Pueblonuevo
1 - 1
 		Olivenza Olivenza 0
12:30
  Finalizado Montehermoso Montehermoso
2 - 1
 		Moralo Moralo 9

LIGAS / COMPETICIONES

Nombre Datos
LIGAS
Primera División es Primera División 34/38 Mañana
COMPETICIONES
Copa de la Reina es Copa de la Reina 7/7 En 15 días
Publicidad 600x120.gif

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
11,695,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Livescore / Index )  0.4725
Total Execution Time  0.4736
  CADENA URL  
/livescore/dia/21042024/zona/futbol_espana
  GET DATOS  
$_GET['/livescore/dia/21042024/zona/futbol_espana']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0020  SELECT lm.action_name,lm.creation_date,lm.dt1,lm.dt2,c.CountryCode,lm.minute,c.coefficient,c.top,dt1.basealias as basealias1,dt2.basealias as basealias2 FROM live_matches_history lm INNER JOIN leagues l ON lm.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN datateams dt1 ON dt1.id = lm.dt1 INNER JOIN datateams dt2 ON dt2.id = lm.dt2 WHERE c.location = 'es' AND lm.creation_date > '2024-05-01 17:43:01' ORDER BY lm.creation_date DESC LIMIT 8
0.0019  SELECT lm.action_name,lm.creation_date,lm.dt1,lm.dt2,c.CountryCode,lm.minute,c.coefficient,c.top,dt1.basealias as basealias1,dt2.basealias as basealias2 FROM live_matches_history lm INNER JOIN leagues l ON lm.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN datateams dt1 ON dt1.id = lm.dt1 INNER JOIN datateams dt2 ON dt2.id = lm.dt2 WHERE c.location = 'es' AND lm.creation_date > '2024-04-25 17:43:01' ORDER BY lm.creation_date DESC LIMIT 15
0.0226  SELECT z.name,z.alias,cat.location,SUM(cat.coefficient) as coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars_all as c ON c.league_id = l.id LEFT JOIN zones z ON z.location = cat.location WHERE cat.location = 'es' AND c.date = '2024-04-21' GROUP BY cat.location ORDER BY coefficient DESC
0.0215  SELECT z.name as zname,z.alias as zalias, cat.location, l.id,cat.alias, cat.name, l.group_code, l.total_group, cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido, cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars_all as c ON c.league_id = l.id LEFT JOIN zones z ON z.location = cat.location WHERE cat.location = 'es' AND c.date = '2024-04-21' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0237  SELECT c.id AS mid, l.year,cat.coefficient,l.id FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars_all as c ON c.league_id = l.id WHERE cat.location = 'es' AND cat.ctype IN (1,3,12,34,36) AND c.shedule >= '2024-04-21 00:00:00' AND c.shedule < '2024-04-21 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0049  SELECT l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments,c.betId,c.betId_bwin,c.betId_marca,c.betId_888,c.betId_sportium, c.betId_marathon, c.penaltis1,c.penaltis2,c.prorroga,c.status,c.minute,c.finished FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE cat.location = 'es' AND cat.ctype IN (1,3,12,34,36) AND c.id IN (30556,30561,30555,29273,61183,61180,61176,61184,193422,193297,193388,193391,193404,193410,193281,193288,193291,193303,193407,193413,197767,197770,197773,197999,196845,198013,196860,197074,197125,197463,197471,197473,197736,197742,197992,206331,198009,196848,196853,197093,197095,197101,197122,197467,197752,197762,198016,196830,198021,197776,198025,196858,196863,197086,197458,197478,197758,454335,454337,454338,454340,454342,485050,481519,486344,213776,425167,456932,425168,457923,425169,481026,213777,489761,213779,449339,213781,454336,486342,213783,454341,210054,454343,420828,456674,425161,456677,425164,456684,449338,457924,481513,481515,481517,213780,210055,438197,457920,457925,457927) AND c.shedule >= '2024-04-21 00:00:00' AND c.shedule < '2024-04-21 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0022  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (153234082, 153234084, 153234086, 153234088, 153783028, 153783030, 153783032, 153783035, 153783079, 153783091, 153783081, 153783089, 153783085, 153783073, 153783093, 153783069, 153783071, 153783095, 154100377, 153791109, 154126514, 153234086, 153436078, 153234084) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0326  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='bwin' ORDER BY eventId ASC
0.0326  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='marca' ORDER BY eventId ASC
0.0326  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='b888sport' ORDER BY eventId ASC
0.0326  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='sportium' ORDER BY eventId ASC
0.0326  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='mbet' ORDER BY eventId ASC
0.0326  (SELECT c.id,rel.media_id,rel.data,c.shedule, med.lang FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2025 as c ON c.league_id = l.id INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.team2 = c.team2 AND (rel.media_id < 90000 OR rel.media_id = 99001) INNER JOIN media AS med ON rel.media_id=med.id WHERE (med.lang='es' OR med.language='spanish') AND cat.location = 'es' AND c.shedule >= '2024-04-21 00:00:00' AND c.shedule < '2024-04-21 23:59:59') UNION (SELECT c.id,rel.media_id,rel.data,c.shedule, med.lang FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.team2 = c.team2 AND (rel.media_id < 90000 OR rel.media_id = 99001) INNER JOIN media AS med ON rel.media_id=med.id WHERE (med.lang='es' OR med.language='spanish') AND cat.location = 'es' AND c.shedule >= '2024-04-21 00:00:00' AND c.shedule < '2024-04-21 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC