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 - Mejores ligas

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 27 MAY

Partidos Sábado, 27 Mayo 2023

España Francia Alemania Portugal Italia Brasil Argentina Internacional Competiciones Europeas
Serie A Serie A »
15:00
  Finalizado Spezia
0 - 4
 		Torino 136
15:00
  Finalizado Salernitana
3 - 2
 		Udinese 105
18:00
  Finalizado Fiorentina
2 - 1
 		Roma 283
20:45
  Finalizado Inter
3 - 2
 		Atalanta 199
Segunda División Segunda División »
16:15
  Finalizado FC Andorra
4 - 3
 		Villarreal B 68
16:15
  Finalizado Burgos
0 - 1
 		CD Lugo 173
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
Bundesliga Bundesliga »
15:30
  Finalizado Wolfsburg
1 - 2
 		Hertha BSC 45
15:30
  Finalizado Union Berlin
1 - 0
 		Werder Bremen 175
15:30
  Finalizado Eintracht
2 - 1
 		SC Freiburg 77
15:30
  Finalizado RB Leipzig
4 - 2
 		Schalke 04 120
15:30
  Finalizado Stuttgart
1 - 1
 		Hoffenheim 82
15:30
  Finalizado Mönchengladbach
2 - 0
 		FC Augsburg 59
15:30
  Finalizado B. Dortmund
2 - 2
 		Mainz 05 1614
15:30
  Finalizado VfL Bochum
3 - 0
 		B. Leverkusen 99
15:30
  Finalizado Köln
1 - 2
 		Bayern München 373
Ligue 1 Ligue 1 »
21:00
  Finalizado Clermont
2 - 0
 		Lorient 80
21:00
  Finalizado Stade Rennais
2 - 0
 		Monaco 125
21:00
  Finalizado Olympique Lyonnais
3 - 0
 		Stade de Reims 37
21:00
  Finalizado Angers SCO
2 - 1
 		Troyes 63
21:00
  Finalizado Strasbourg
1 - 1
 		PSG 408
21:00
  Finalizado Montpellier
2 - 3
 		Nice 38
21:00
  Finalizado Lens
3 - 0
 		Ajaccio 42
21:00
  Finalizado Lille
2 - 1
 		Nantes 148
21:00
  Finalizado Toulouse
1 - 1
 		Auxerre 127
21:00
  Finalizado Olympique
1 - 2
 		Stade Brestois 191
Primera Federación Grupo 1 Primera Federación Grupo 1 »
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
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
Liga Portuguesa Liga Portuguesa »
13:45
  Finalizado Gil Vicente
1 - 0
 		Casa Pia AC 29
16:30
  Finalizado Estoril
3 - 1
 		Marítimo 10
16:30
  Finalizado Chaves
1 - 4
 		Boavista 8
19:00
  Finalizado Benfica
3 - 0
 		CD Santa Clara 57
19:00
  Finalizado Portimonense
0 - 2
 		Arouca 21
19:00
  Finalizado Porto
3 - 0
 		Vitória 31
21:30
  Finalizado Sporting Braga
3 - 0
 		Paços Ferreira 8
Liga Brasileña Liga Brasileña »
21:00
  Finalizado Athletico
1 - 2
 		Grêmio 77
21:00
  Finalizado Fortaleza EC
2 - 0
 		Vasco da Gama 98
23:30
  Finalizado Flamengo
1 - 1
 		Cruzeiro 156
23:30
  Finalizado Cuiabá
1 - 1
 		Coritiba 51
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

LIGAS / COMPETICIONES

Nombre Datos
LIGAS
es Primera División 33/38 Mañana
COMPETICIONES
wo Amistosos Selecciones 73/84 En 36 días
es Copa de la Reina 7/7 En 22 días
Publicidad 600x120.gif

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
6,147,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.4074
Total Execution Time  0.4084
  CADENA URL  
/livescore/dia/27052023/zona/top_ligas
  GET DATOS  
$_GET['/livescore/dia/27052023/zona/top_ligas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0267  SELECT z.name,z.alias,c.CountryCode,SUM(c.coefficient) as cuenta FROM categories c INNER JOIN leagues l ON l.categoryId = c.id INNER JOIN zones z ON z.location = c.CountryCode WHERE c.top = 1 AND c.troncal = 1 AND c.active_year = l.year AND l.total_num_matchs = l.total_num_matchsR GROUP BY c.CountryCode ORDER BY cuenta DESC LIMIT 30
0.0146  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.top = 1 AND lm.creation_date > '2024-04-24 12:01:31' ORDER BY lm.creation_date DESC LIMIT 8
0.0145  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.top = 1 AND lm.creation_date > '2024-04-18 12:01:31' ORDER BY lm.creation_date DESC LIMIT 15
0.0200  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.top = '1' AND c.date = '2023-05-27' GROUP BY cat.location ORDER BY coefficient DESC
0.0191  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.top = '1' AND c.date = '2023-05-27' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0215  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.top = '1' 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.0307  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.top = '1' AND cat.ctype IN (1,3,12,34,36) AND c.id IN (49356,53785,53787,53779,53781,50119,50121,50126,50137,50123,50125,50129,50134,24345,24320,24322,24324,24327,24330,24333,24336,24342,26323,26325,26328,26330,26331,26332,26305,26314,26318,26321,160979,160976,160980,160981,160963,160982,160965,160983,160968,160984,160969,160985,160970,160971,160974,160972,160977,160973,160978,160975,96294,96293,96306,96291,96300,96302,96304,526746,544902,526743,732326,732325,732318,732327,833662,833663,833659,833660,833644,833643,841132,841084,841138,841090,842460,827253,827252,827250,827251,827249,827254,879663,879664) 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.0152  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (137794951, 137974626, 137974613, 137974581, 137432398, 137794953, 137794955, 137794968, 137794996, 137794961, 137794992, 137794958, 137794972, 137374835, 137374821, 137374831, 137374819, 137374851, 137374828, 137374817, 137374846, 137374823, 137423370, 137423389, 137423367, 137423387, 137423377, 137423385, 137423374, 137423391, 137423382, 137795039, 137795078, 137795030, 137795061, 137795021, 137795035, 137795075, 137795028, 137795057, 137795083, 137795018, 137795044, 137795073, 137795026, 137795048, 137795081, 137795014, 137795033, 137795068, 138155964, 138155966, 138155969, 138155973, 138155981, 138155977, 137795006, 137432202, 137432204, 137432206, 137432378, 137432380, 137432382, 137432384, 137795030) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0145  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.0145  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (1005962336) AND typeId=40 AND site='marca' ORDER BY eventId ASC
0.0310  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (1005956937, 1005962425, 1005955616) AND typeId=40 AND site='b888sport' ORDER BY eventId ASC
0.0310  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.0310  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.0310  (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.top = '1' 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.top = '1' 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