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

LIVESCORE / Partidos del Sábado, 27 Mayo 2023 - Ligas de España

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

Partidos Sábado, 27 Mayo 2023

España
Segunda División Segunda División »
16:15
  Finalizado Burgos
0 - 1
 		CD Lugo 173
16:15
  Finalizado FC Andorra
4 - 3
 		Villarreal B 68
18:30
  Finalizado Albacete
2 - 1
 		Mirandés 240
18:30
  Finalizado Málaga
1 - 1
 		UD Ibiza 188
21:00
  Finalizado Levante
2 - 1
 		Real Oviedo 200
21:00
  Finalizado Huesca
0 - 1
 		Eibar 108
21:00
  Finalizado Granada
2 - 0
 		Leganés 351
21:00
  Finalizado Las Palmas
0 - 0
 		Deportivo Alavés 869
Primera Federación Grupo 1 Primera Federación Grupo 1 »
19:30
  Finalizado Rayo Majadahonda
1 - 1
 		AD Mérida 76
19:30
  Finalizado Cultural Leonesa
3 - 1
 		CF Talavera 139
19:30
  Finalizado AD Ceuta FC
0 - 0
 		RB Linense 231
19:30
  Finalizado Fuenlabrada
2 - 1
 		Unionistas CF 133
19:30
  Finalizado Linares Deportivo
1 - 1
 		San Fernando CD 240
19:30
  Finalizado Alcorcón
2 - 0
 		UD Sanse 70
19:30
  Finalizado Racing Ferrol
2 - 0
 		Celta Fortuna 425
19:30
  Finalizado Algeciras CF
0 - 1
 		RM Castilla 75
19:30
  Finalizado Córdoba CF
3 - 1
 		CD Badajoz 537
19:30
  Finalizado Pontevedra
1 - 1
 		RC Deportivo 118
Queens League Grupo 1 Queens League Grupo 1 »
16:00
  Finalizado Jijantas FC
3 - 1
 		El Barrio 8
17:00
  Finalizado Aniquiladoras
0 - 2
 		Ultimate Móstoles 1
18:00
  Finalizado 1K
6 - 3
 		Las Troncas 1
19:00
  Finalizado Xbuyer Team
2(3 - 4)2
 		Kunitas 0
20:00
  Finalizado Saiyans FC
2 - 3
 		Porcinas FC 12
21:00
  Finalizado Rayo de Barcelona
2(2 - 4)2
 		Pio FC 3
Preferente Baleares Grupo 6 Preferente Baleares Grupo 6 »
18:00
  Finalizado Murense
7 - 0
 		Alqueria 0
18:00
  Finalizado Esporles
0 - 0
 		S´Horta 0
18:00
  Finalizado CD Génova
3 - 2
 		Son Sardina 0
19:15
  Finalizado Arta
2 - 3
 		Indep. Camp Redó 0
División Honor País Vasco Grupo 1 División Honor País Vasco Grupo 1 »
16:00
  Finalizado Zaramaga
1 - 2
 		Laudio 0
16:00
  Finalizado San Ignacio B
3 - 1
 		Zuia de Fútbol 0
16:00
  Finalizado San Prudencio
2 - 2
 		Alegría 0
16:00
  Finalizado CD Lakua Arriaga
2 - 0
 		Urgatzi KK 0
16:00
  Finalizado Deportivo Alavés
1 - 0
 		San Viator 5
16:00
  Finalizado Nanclares
1 - 2
 		CD Alipendi 0
17:00
  Finalizado Salvatierra
2 - 3
 		Abetxuko 0
División Honor País Vasco Grupo 2 División Honor País Vasco Grupo 2 »
16:15
  Finalizado Dínamo San Juan
2 - 3
 		SD San Pedro 0
17:00
  Finalizado CD Getxo
1 - 0
 		Santutxu 0
17:00
  Finalizado SD Indautxu
0 - 2
 		Balmaseda FC 0
17:30
  Finalizado JD Somorrostro
4 - 1
 		Galdakao 0
17:30
  Finalizado Zalla
0 - 2
 		Santurtzi 1
18:00
  Finalizado Abanto Club
0 - 3
 		Club Bermeo 0
18:00
  Finalizado SD Erandio
2 - 1
 		CD Elorrio 0
18:00
  Finalizado Iurretako KT
1 - 2
 		SD Zamudio 0
18:30
  Finalizado Sodupe
0 - 2
 		CD Derio 0
División Honor País Vasco Grupo 3 División Honor País Vasco Grupo 3 »
12:30
  Finalizado Eibar B
5 - 1
 		Amaikak Bat 0
16:15
  Finalizado Beti Gazte KKE
1 - 1
 		Tolosa CF 1
16:30
  Finalizado SD Urola
1 - 2
 		UPV Vasconia 0
16:30
  Finalizado Mondragón
1 - 1
 		Aloña Mendi 0
17:30
  Finalizado Zarautz
3 - 0
 		Lagun Onak B 0
17:30
  Finalizado CD Hernani
2 - 3
 		CD Elgoibar 0
17:30
  Finalizado Zumaiako
5 - 2
 		Oiartzun KE 0
17:30
  Finalizado Aretxabaleta
0 - 1
 		Mutriku FT 1
Primera RFFPA Primera RFFPA »
16:45
  Finalizado Berrón
0 - 1
 		Urraca CF 0
18:00
  Finalizado TSK Roces
1 - 0
 		Lealtad 0
18:30
  Finalizado Navarro
1 - 0
 		Astur 0
Preferente La Rioja Grupo 3 Preferente La Rioja Grupo 3 »
17:00
  Finalizado Aldeano
7 - 1
 		Berceo B 0
18:00
  Finalizado Cenicero
1 - 1
 		Rapid de Murillo 0
18:00
  Finalizado San Marcial
2 - 2
 		Varea B 0

LIGAS / COMPETICIONES

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

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
11,436,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.7874
Total Execution Time  0.7883
  CADENA URL  
/livescore/dia/27052023/zona/futbol_espana
  GET DATOS  
$_GET['/livescore/dia/27052023/zona/futbol_espana']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.2028  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.0106  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-18 06:07:58' ORDER BY lm.creation_date DESC LIMIT 8
0.0106  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-12 06:07:58' ORDER BY lm.creation_date DESC LIMIT 15
0.0174  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-27' GROUP BY cat.location ORDER BY coefficient DESC
0.0213  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-27' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0169  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-27 00:00:00' AND c.shedule < '2023-05-27 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0129  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 (49356,50121,50119,50126,50137,50123,50125,50129,50134,160965,160983,160968,160984,160969,160985,160970,160971,160974,160972,160977,160973,160978,160975,160979,160976,160980,160981,160963,160982,833662,833663,833659,833660,833644,833643,841132,841084,841138,841090,827253,827252,827250,827251,827249,827254,842460,844100,844146,810195,796040,796088,796039,810192,796037,349540,349842,349533,349538,842337,842334,335217,351864,351178,351179,351180,351183,351184,351186,351542,351870,351867,351871,351185,351541,351544,351872,351537,351538,351866,351868,351869,351539,351543,351545,351540,335583,335580,335588,778318,778377,778378,778314,778315) AND c.shedule >= '2023-05-27 00:00:00' AND c.shedule < '2023-05-27 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0109  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (137794951, 137794955, 137794953, 137794968, 137794996, 137794961, 137794992, 137794958, 137794972, 137795061, 137795021, 137795035, 137795075, 137795028, 137795057, 137795083, 137795018, 137795044, 137795073, 137795026, 137795048, 137795081, 137795014, 137795033, 137795068, 137795039, 137795078, 137795030, 137795030) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0240  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.0240  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.0240  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.0240  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.0240  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.0240  (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-27 00:00:00' AND c.shedule < '2023-05-27 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-27 00:00:00' AND c.shedule < '2023-05-27 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC