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

LIVESCORE / Partidos del Domingo, 07 Mayo 2023 - Ligas de España

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

Partidos Domingo, 07 Mayo 2023

España
Segunda División Segunda División »
14:00
  Finalizado Villarreal B Villarreal B
2 - 0
 		Real Sporting Real Sporting 359
Televisión
16:15
  Finalizado UD Ibiza UD Ibiza
0 - 5
 		Albacete Albacete 357
16:15
  Finalizado Ponferradina Ponferradina
2 - 0
 		Málaga Málaga 690
Televisión
18:30
  Finalizado CD Lugo CD Lugo
2 - 2
 		FC Andorra FC Andorra 120
18:30
  Finalizado Real Oviedo Real Oviedo
2 - 1
 		Real Zaragoza Real Zaragoza 210
21:00
  Finalizado FC Cartagena FC Cartagena
0 - 0
 		Burgos Burgos 557
Segunda Federación Grupo 2 Segunda Federación Grupo 2 »
12:00
  Finalizado CD Alfaro CD Alfaro
0 - 1
 		Brea Brea 6
12:00
  Finalizado Deportivo Alavés Deportivo Alavés
1 - 0
 		Beasain KE Beasain KE 2
12:00
  Finalizado Izarra Izarra
2 - 1
 		Real Sociedad C Real Sociedad C 0
12:00
  Finalizado UD Logroñés B UD Logroñés B
1 - 1
 		Cirbonero Cirbonero 0
12:00
  Finalizado SD Tarazona SD Tarazona
3 - 1
 		Racing Rioja Racing Rioja 6
12:00
  Finalizado Arenas de Getxo Arenas de Getxo
0 - 0
 		Mutilvera Mutilvera 1
12:00
  Finalizado Utebo Utebo
1 - 0
 		Arnedo Arnedo 1
12:00
  Finalizado SD Gernika SD Gernika
0 - 1
 		AD San Juan AD San Juan 4
12:00
  Finalizado Tudelano Tudelano
0 - 0
 		Sestao River Sestao River 1
Segunda Federación Grupo 3 Segunda Federación Grupo 3 »
12:00
  Finalizado Deportivo Aragón Deportivo Aragón
2 - 1
 		Mallorca B Mallorca B 4
12:00
  Finalizado Terrassa FC Terrassa FC
2 - 1
 		Espanyol B Espanyol B 43
12:00
  Finalizado UD Alzira UD Alzira
3 - 0
 		Ibiza I. Pitiusas Ibiza I. Pitiusas 11
12:00
  Finalizado Peña Deportiva Peña Deportiva
1 - 0
 		Valencia Mestalla Valencia Mestalla 11
12:00
  Finalizado Lleida Esportiu Lleida Esportiu
1 - 0
 		AE Prat AE Prat 22
12:00
  Finalizado Hércules Hércules
2 - 1
 		At. Saguntino At. Saguntino 119
12:00
  Finalizado SD Formentera SD Formentera
3 - 1
 		CD Ebro CD Ebro 2
12:00
  Finalizado Olot Olot
0 - 1
 		CF Badalona Futur CF Badalona Futur 12
12:00
  Finalizado CE Manresa CE Manresa
3 - 0
 		CD Teruel CD Teruel 106
Segunda Federación Grupo 5 Segunda Federación Grupo 5 »
12:00
  Finalizado Yugo Socuéllamos Yugo Socuéllamos
3 - 2
 		CD Don Benito CD Don Benito 36
12:00
  Finalizado Villanovense Villanovense
2 - 2
 		Cerdanyola FC Cerdanyola FC 41
12:00
  Finalizado CD Guadalajara CD Guadalajara
3 - 1
 		Gimnástica Gimnástica 39
12:00
  Finalizado CP Cacereño CP Cacereño
2 - 0
 		UD Montijo UD Montijo 18
12:00
  Finalizado Unión Adarve Unión Adarve
2 - 1
 		CD Estepona CD Estepona 7
12:00
  Finalizado Atlético B Atlético B
2 - 0
 		Leganés B Leganés B 6
Televisión
12:00
  Finalizado UD Melilla UD Melilla
0 - 0
 		CDA Navalcarnero CDA Navalcarnero 18
12:00
  Finalizado CD Diocesano CD Diocesano
0 - 1
 		CD Coria CD Coria 12
Televisión
12:00
  Finalizado CD Atlético Paso CD Atlético Paso
1 - 1
 		Alcorcón B Alcorcón B 5
Tercera Federación - Play Offs Ascenso Tercera Federación - Play Offs Ascenso »
11:30
  Finalizado Getafe B Getafe B
1 - 1
 		Paracuellos Paracuellos 9
12:00
  Finalizado CD Gerena CD Gerena
0 - 1
 		Salerm Puente Gen. Salerm Puente Gen. 9
12:00
  Finalizado CD Varea CD Varea
4 - 2
 		Anguiano Anguiano 1
12:00
  Finalizado L´Entregu CF L´Entregu CF
4 - 0
 		UD Llanera UD Llanera 8
12:00
  Finalizado Córdoba CF B Córdoba CF B
2 - 3
 		Ciudad de Lucena Ciudad de Lucena 28
12:00
  Finalizado Penya Independent Penya Independent
1 - 1
 		Poblense Poblense 2
12:00
  Finalizado CP San Cristóbal CP San Cristóbal
3 - 2
 		L´Hospitalet L´Hospitalet 24
12:00
  Finalizado El Palo FC El Palo FC
1 - 1
 		UD Torre Del Mar UD Torre Del Mar 42
12:15
  Finalizado CD Azuaga CD Azuaga
3 - 0
 		Jerez Jerez 22
13:00
  Finalizado Lanzarote Lanzarote
1 - 1
 		Villa Santa Brígi. Villa Santa Brígi. 29
13:00
  Finalizado UD San Fernando UD San Fernando
2 - 1
 		Las Palmas At. Las Palmas At. 24
15:30
  Finalizado CD Vitoria CD Vitoria
1 - 2
 		Deusto Deusto 20
18:00
  Finalizado Tropezón Tropezón
1 - 0
 		UM Escobedo UM Escobedo 0
18:00
  Finalizado Salamanca UDS Salamanca UDS
2 - 0
 		Real Ávila Real Ávila 99
18:00
  Finalizado Ejea Ejea
0 - 1
 		CDJ Tamarite CDJ Tamarite 2
18:00
  Finalizado Real Madrid C Real Madrid C
4 - 0
 		CD Móstoles CD Móstoles 32
18:00
  Finalizado Sporting Atlético Sporting Atlético
0 - 1
 		CD Praviano CD Praviano 26
18:00
  Finalizado Manacor Manacor
1 - 1
 		Santanyi Santanyi 2
18:00
  Finalizado Huesca B Huesca B
1 - 3
 		Almudévar Almudévar 5
18:00
  Finalizado La Calzada La Calzada
5 - 2
 		Oyonesa Oyonesa 12
18:05
  Finalizado UE Sant Andreu UE Sant Andreu
1 - 0
 		CF Peralada CF Peralada 14
19:00
  Finalizado Lorca Deportiva Lorca Deportiva
2 - 1
 		At. Pulpileño At. Pulpileño 134
19:00
  Finalizado Quintanar Quintanar
1 - 0
 		CS Puertollano CS Puertollano 33
19:00
  Finalizado Real Jaén Real Jaén
1 - 2
 		At. Malagueño At. Malagueño 204
19:30
  Finalizado Moralo Moralo
1 - 1
 		Olivenza Olivenza 27
20:45
  Finalizado Arosa Arosa
3 - 0
 		Ourense UD Ourense UD 13
División Honor Senior Grupo 1 División Honor Senior Grupo 1 »
11:58
  Finalizado Lebrijana Lebrijana
0 - 2
 		Montilla Montilla 0
12:00
  Finalizado Cabecense Cabecense
6 - 0
 		Arcos CF Arcos CF 8
12:00
  Finalizado Villafranco Villafranco
5 - 1
 		Palma Atletico Palma Atletico 0
12:00
  Finalizado Club Atl. Central Club Atl. Central
1 - 1
 		Viso UP Viso UP 1

LIGAS / COMPETICIONES

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

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
11,696,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Livescore / Index )  0.6904
Total Execution Time  0.6914
  CADENA URL  
/livescore/dia/07052023/zona/futbol_espana
  GET DATOS  
$_GET['/livescore/dia/07052023/zona/futbol_espana']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.1857  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories c ON c.id = l.categoryId WHERE dt.main_image = 1 AND c.troncal = 1 AND l.year=c.active_year AND c.location = 'es' GROUP BY t.teamId ORDER BY c.coefficient*dt.relations DESC LIMIT 30
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-04 09:24:12' 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-28 09:24:12' ORDER BY lm.creation_date DESC LIMIT 15
0.0310  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 = '2023-05-07' GROUP BY cat.location ORDER BY coefficient DESC
0.0161  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 = '2023-05-07' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0159  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 >= '2023-05-07 00:00:00' AND c.shedule < '2023-05-07 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0044  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 calendars2023 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 (50108,50105,50112,50091,50094,50096,161566,161570,161581,161591,161615,161620,161642,161638,161563,161587,161608,161573,161646,268455,269317,268685,269031,268456,269996,268688,269032,268459,269999,268691,269302,268462,270001,268693,269303,330618,268465,270006,269013,269305,268468,270007,269015,269307,268666,270009,269017,269309,268669,270011,269021,269311,268672,270014,269024,268445,269313,268676,269026,268446,269315,268680,269030,819059,820334,820832,812897,819069,819080,819084,820333,812899,819086,819088,819044,820398,820834,819042,819057,819067,819082,819092,820396,819065,819055,819313,819321,819317,819076,310121,310128,310126,313739,313737,420401,313502,313738,313503,313740,313504) AND c.shedule >= '2023-05-07 00:00:00' AND c.shedule < '2023-05-07 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 (136308054, 136308060, 136308056, 136308069, 136308064, 136308079, 136681699, 136681738, 136681696, 136681735, 136681705, 136681740, 136681744, 136681716, 136681746, 136681723, 136681727, 136681748, 136681738, 136681744, 136681738) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0019  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.0019  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (1005961748, 1005961745) AND typeId=40 AND site='marca' ORDER BY eventId ASC
0.0585  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (1005961763, 1005962474) AND typeId=40 AND site='b888sport' ORDER BY eventId ASC
0.0585  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.0585  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.0585  (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 >= '2023-05-07 00:00:00' AND c.shedule < '2023-05-07 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 calendars2023 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 >= '2023-05-07 00:00:00' AND c.shedule < '2023-05-07 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC