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 Europa

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
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 1637
15:30
 Finalizado VfL Bochum
3 - 0
B. Leverkusen 99
15:30
 Finalizado Köln
1 - 2
Bayern München 373
15:30
 Finalizado Wolfsburg
1 - 2
Hertha BSC 45
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
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
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 Portimonense
0 - 2
Arouca 21
19:00
 Finalizado Porto
3 - 0
Vitória 31
19:00
 Finalizado Benfica
3 - 0
CD Santa Clara 57
21:30
 Finalizado Sporting Braga
3 - 0
Paços Ferreira 8
13:00
 Finalizado FK Khimki
0 - 3
Ural Yekaterinburg 5
15:30
 Finalizado Torpedo Moscow
1 - 3
FC Orenburg 3
18:00
 Finalizado FK Krasnodar
0 - 0
CSKA Moskva 10
18:00
 Finalizado Sochi
1 - 1
Zenit 27
13:30
 Finalizado Celtic
5 - 0
Aberdeen 24
13:30
 Finalizado St. Mirren
0 - 3
Rangers FC 24
13:30
 Finalizado Heart Midlothian
1 - 1
Hibernian FC 17
15:00
 Finalizado Mjällby AIF
0 - 2
Halmstads 5
17:30
 Finalizado Brommapojkarna
1 - 2
IK Sirius 4
20:30
 Finalizado Calcio Foggia
1 - 0
Crotone 0
20:30
 Finalizado Lecco
0 - 1
Pordenone 1
20:30
 Finalizado Pescara
2 - 1
Virtus Entella 2
20:30
 Finalizado Vicenza
0 - 0
Cesena 5
12:00
 Finalizado Penafiel
2 - 4
Estrela Amadora 4
13:45
 Finalizado Porto II
3 - 1
Benfica II 13
17:30
 Finalizado Raków
1 - 1
Zaglebie Lubin 5
17:30
 Finalizado Lech Poznań
2 - 0
Jagiellonia 1
17:30
 Finalizado Pogon Szczecin
4 - 0
Radomiak Radom 0
17:30
 Finalizado Piast Gliwice
3 - 0
Lechia Gdansk 12
17:30
 Finalizado Widzew Łódź
0 - 3
Korona Kielce 0
17:30
 Finalizado Miedz Legnica
0 - 0
Górnik Zabrze 6
17:30
 Finalizado KS Cracovia
3 - 0
Wisła Płock 2
17:30
 Finalizado Stal Mielec
1 - 0
Warta Poznan 0
17:30
 Finalizado Legia Warszawa
3 - 1
Śląsk Wrocław 5
13:30
 Finalizado Zwickau
2 - 2
1860 München 3
13:30
 Finalizado Ingolstadt 04
1 - 2
SV Elversberg 3
13:30
 Finalizado Bayreuth SpVgg
3 - 3
Erzgebirge Aue 1
13:30
 Finalizado Dynamo Dresden
2 - 1
VfB Oldenburg 8
13:30
 Finalizado VfL Osnabrück
2 - 1
B. Dortmund II 40
13:30
 Finalizado Freiburg II
2 - 0
SV Meppen 9
13:30
 Finalizado Rot-Weiss Essen
2 - 2
Verl 0
13:30
 Finalizado Wehen Wiesbaden
1 - 0
Hallescher FC 14
13:30
 Finalizado Saarbrücken
2 - 1
Viktoria Köln 1
13:30
 Finalizado Waldhof Mannheim
3 - 1
MSV Duisburg 6
16:00
 Finalizado Shinnik Yaroslavl
1 - 0
SKA-Khabarovsk 0
16:00
 Finalizado Volga Ulyanovsk
0 - 1
Rodina Moskva 5
16:00
 Finalizado Volgar Astrakhan
0 - 3
FC Krasnodar II 0
16:00
 Finalizado Kuban Krasnodar
0 - 2
Yenisey 0
16:30
 Finalizado Neftekhimik
2 - 0
Ufa 0
17:00
 Finalizado Arsenal Tula
0 - 1
KamAZ 1
17:00
 Finalizado Rubin Kazán
2 - 0
Dynamo Makhachkala 0
18:00
 Finalizado Veles
1 - 2
Akron Tolyatti 0
15:00
 Finalizado Naftan Novopolotsk
0 - 1
Isloch 0
17:00
 Finalizado Energetik-BGU
1 - 0
Dinamo Brest 0
19:00
 Finalizado Minsk
1 - 1
Dinamo Minsk 2

LIGAS / COMPETICIONES
Nombre Datos
LIGAS
no Cuarta Noruega 6 gr En 8 días
Publicidad 600x120.gif
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
10,079,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.3970
Total Execution Time  0.3979
  CADENA URL  
/livescore/dia/27052023/zona/futbol_europa
  GET DATOS  
$_GET['/livescore/dia/27052023/zona/futbol_europa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0107  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 c.continent = 'eu' AND lm.creation_date > '2024-03-28 00:58:44' 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 c.continent = 'eu' AND lm.creation_date > '2024-03-22 00:58:44' ORDER BY lm.creation_date DESC LIMIT 15
0.0229  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.continent = 'eu' AND cat.location!='es' AND c.date = '2023-05-27' GROUP BY cat.location ORDER BY coefficient DESC
0.0171  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.continent = 'eu' AND cat.location!='es' AND c.date = '2023-05-27' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 25
0.0185  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.continent = 'eu' AND 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.0234  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.continent = 'eu' AND cat.location!='es' AND cat.ctype IN (1,3,12,34,36) AND c.id IN (53785,53787,53779,53781,24336,24342,24345,24320,24322,24324,24327,24330,24333,26330,26331,26332,26305,26314,26318,26321,26323,26325,26328,96294,96293,96306,96291,96300,96302,96304,39329,39327,39324,39326,820596,820597,820598,840806,840808,836981,573226,573219,823328,823329,823327,839791,819859,819860,775808,829267,829250,10072,10069,842339,842341,842343,842345,96585,96582,88475,88478,88479,4992,4993,4994,4995,4996,4997,4998,4999,5000,788029,788030,788031,56756,56757,56758,56759,56760,56761,56762,56763,56764,56765,39627,39628,39632,39633,39626,39629,39634,39631,746248,746245,746247,671053,506646,507221,573452,573457) 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.0114  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (137974626, 137974613, 137974581, 137432398, 137374821, 137374831, 137374819, 137374851, 137374828, 137374817, 137374846, 137374823, 137374835, 137423367, 137423387, 137423377, 137423385, 137423374, 137423391, 137423382, 137423370, 137423389, 138155964, 138155966, 138155969, 138155981, 138155977, 138155973, 137795006, 137423643, 137423653, 137423646, 138181623, 138181625, 137891198, 137795864, 137795870, 137423818, 137423824, 137423821, 138021747, 137375187, 137375189, 138247948, 138103860, 138103911, 137423783, 137423766, 138209562, 138209569, 138159814, 138083585, 136758289, 136758284, 136758274, 136758269, 136758294, 136758291, 136758264, 136758277, 136758286, 137423676, 137423681, 137423679, 137423143, 137423134, 137423149, 137423140, 137423132, 137423147, 137423138, 137423129, 137423145, 137423136, 137796075, 137795889, 137795897) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0105  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.0107  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.0299  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.0299  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.0299  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.0299  (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.continent = 'eu' 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.continent = 'eu' 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