2.855.770 resultados, 9.127.069 comentarios, 804.045 imágenes, 79.786 vídeos, 85.880 noticias

LIVESCORE / Partidos del Sábado, 27 Noviembre 2021

14:00
 Finalizado Alavés
1 - 2
Celta 604
16:15
 Finalizado Valencia
1 - 1
Rayo Vallecano 748
18:30
 Finalizado Mallorca
0 - 0
Getafe 322
21:00
 Finalizado Villarreal
1 - 3
Barcelona 3098
13:30
 Finalizado Arsenal
2 - 0
Newcastle 462
16:00
 Finalizado Liverpool
4 - 0
Southampton 203
16:00
 Finalizado Norwich City
0 - 0
Wolves 322
16:00
 Finalizado Crystal Palace
1 - 2
Aston Villa 309
18:30
 Finalizado Brighton Hove Alb.
0 - 0
Leeds United 100
15:00
 Finalizado Sampdoria
3 - 1
Hellas Verona 241
15:00
 Finalizado Empoli
2 - 1
Fiorentina 363
18:00
 Finalizado Juventus
0 - 1
Atalanta 570
20:45
 Finalizado Venezia
0 - 2
Inter 227
16:00
 Finalizado Burgos
3 - 0
Málaga 384
18:15
 Finalizado Almería
0 - 0
Huesca 352
18:15
 Finalizado Real Sporting
1 - 1
Fuenlabrada 428
20:30
 Finalizado Real Valladolid
2 - 0
FC Cartagena 350
15:30
 Finalizado Wolfsburg
1 - 3
B. Dortmund 433
15:30
 Finalizado VfL Bochum
2 - 1
SC Freiburg 89
15:30
 Finalizado Hertha BSC
1 - 1
FC Augsburg 147
15:30
 Finalizado Greuther Fürth
3 - 6
Hoffenheim 117
15:30
 Finalizado Köln
4 - 1
Mönchengladbach 218
18:30
 Finalizado Bayern München
1 - 0
Arminia Bielefeld 752
17:00
 Finalizado Lille
1 - 1
Nantes 259
21:00
 Finalizado Nice
0 - 1
Metz 258
17:00
 Finalizado Sanse
1 - 0
Racing Ferrol 62
17:00
 Finalizado CD Badajoz
2 - 2
SD Logroñés 162
19:00
 Finalizado Racing
1 - 1
Unionistas CF 343
19:00
 Finalizado Real Unión Irún
2 - 0
Zamora 48
16:00
 Finalizado RB Linense
1 - 2
Villarreal B 171
17:00
 Finalizado Barcelona B
0 - 2
San Fernando CD 87
17:00
 Finalizado Alcoyano
2 - 0
Cornellà 46
19:00
 Finalizado CD Castellón
2 - 1
Betis Deportivo 134
19:00
 Finalizado Sabadell
0 - 1
FC Andorra 82
13:00
 Finalizado Cannet Rocheville
1(4 - 1)1
Bastia-Borgo 0
14:00
 Finalizado J3 Amilly
0 - 5
Quevilly-Rouen 0
14:00
 Finalizado Stade Lavallois
1(7 - 6)1
Le Mans 0
14:00
 Finalizado Canet Roussillon
1(6 - 7)1
Saint-Denis 0
14:30
 Finalizado Soleil Bischheim
0 - 1
Nancy 0
14:30
 Finalizado Morteau Montlebon
0 - 2
Dijon FCO 0
15:00
 Finalizado Chambéry F 73
4 - 6
Auxerre 0
16:00
 Finalizado Aubagne
2(3 - 4)2
Nîmes 0
16:00
 Finalizado Montchat Lyon
0 - 3
Sochaux 0
16:00
 Finalizado Amiens AC
1(1 - 3)1
Feignies 0
16:00
 Finalizado Calonne Ricouart
1 - 4
Valenciennes 0
16:15
 Finalizado Guingamp
1 - 0
Stade Briochin 0
17:00
 Finalizado FC Mulhouse
1 - 3
Lyon-Duchère 0
17:00
 Finalizado Biesheim
0 - 1
Thaon 0
17:00
 Finalizado Andrézieux
3 - 0
Grenoble 0
17:00
 Finalizado Cannes
2 - 1
Rodez 0
17:00
 Aplazado Club Franciscain
-
Cholet 0
18:00
 Finalizado Sarrebourg
1 - 3
Creteil 0
18:00
 Finalizado Vénissieux
1(4 - 3)1
Yzeure 0
18:00
 Finalizado Cambrai
1 - 4
Amiens SC 0
18:00
 Finalizado Ergué-Gaberic
1 - 2
Vannes 0
18:00
 Finalizado Paris FC
14 - 0
CSC Cayenne 0
18:00
 Finalizado Chambly
0(4 - 5)0
Beauvais Oise 0
18:00
 Finalizado Bergerac
4 - 0
Stade Bordelais 0
18:00
 Finalizado Gazélec Ajaccio
1 - 2
Red Star 0
18:00
 Finalizado Dinan-Léhon
2(5 - 4)2
Saint-Malo 0
18:00
 Finalizado Toulouse
0 - 0
Montauban TG 0
18:00
 Finalizado Linas-Montlhery
1(5 - 4)1
Evreux 27 0
19:00
 Finalizado Stade Poitevin
1(4 - 3)1
Orléans 0
16:30
 Finalizado Famalicão
0 - 3
Portimonense 11
19:00
 Finalizado Arouca
2 - 1
Boavista 9
21:30
 Finalizado Belenenses SAD
0 - 7
Benfica 171
18:45
 Finalizado Fortuna Sittard
1 - 4
Groningen 12
20:00
 Finalizado PEC Zwolle
0 - 0
RKC Waalwijk 18
21:00
 Finalizado Willem II
0 - 1
Go Ahead Eagles 20
13:30
 Finalizado Preston North End
1 - 1
Fulham 99
16:00
 Finalizado Birmingham City
1 - 0
Blackpool 3
16:00
 Finalizado Luton Town
1 - 2
Cardiff City 4
16:00
 Finalizado Stoke City
0 - 1
Blackburn Rovers 18
16:00
 Finalizado Huddersfield Town
1 - 2
Middlesbrough 1
16:00
 Finalizado Peterborough
0 - 0
Barnsley 5
16:00
 Finalizado Swansea City
2 - 3
Reading 17
16:00
 Finalizado AFC Bournemouth
2 - 2
Coventry City 38
16:00
 Finalizado Hull City
2 - 1
Millwall 5
22:00
 Finalizado O'Higgins
0 - 0
Antofagasta 18
22:00
 Finalizado CD Melipilla
1 - 0
Everton Viña 28
22:00
 Finalizado Cobresal
0 - 0
Univ de Chile 44
12:00
 Finalizado Ural Yekaterinburg
1 - 1
Sochi 23
14:30
 Finalizado Akhmat Grozny
2 - 0
FK Rostov 2
17:00
 Finalizado FK Khimki
3 - 3
FK Krasnodar 11
16:00
 Finalizado Heart Midlothian
2 - 0
St. Mirren 1
16:00
 Finalizado Ross County FC
1 - 1
Dundee United 0
16:00
 Finalizado Dundee
3 - 0
Motherwell 0
16:00
 Finalizado St. Johnstone
1 - 2
Hibernian FC 1
11:30
 Finalizado Antalyaspor
3 - 0
Alanyaspor 0
14:00
 Finalizado Rizespor
1 - 0
Kayserispor 3
17:00
 Finalizado Beşiktaş
0 - 4
Giresunspor 69

LIGAS / COMPETICIONES
Nombre Datos
LIGAS
es Primera División 15/38 Mañana
gb Premier League 14/38 Hoy
it Serie A 15/38 Hoy
es Segunda División 18/42 En 3 días
de Bundesliga 13/34 En 3 días
fr Ligue 1 16/38 Mañana
ar Liga Profesional Argenti. 23/25 Hoy
es Primera RFEF 2 gr En 3 días
br Liga Brasileña 35/38 Hoy
pt Liga Portuguesa 12/34 Hoy
nl Eredivisie 4/34 Mañana
es Segunda RFEF 5 gr En 3 días
es Primera Femenina 12/30 En 3 días
COMPETICIONES
wo Clasificación Mundial Su. 14/18 En 57 días
ue Clasificación Europeo Su. 9 gr En 113 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  
13,305,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Livescore / Index )  0.2311
Total Execution Time  0.2324
  CADENA URL  
/livescore/dia/27112021
  GET DATOS  
$_GET['/livescore/dia/27112021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0024  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.coefficient >= 10 AND lm.creation_date > '2021-11-29 18:24:20' ORDER BY lm.creation_date DESC LIMIT 8
0.0024  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.coefficient >= 10 AND lm.creation_date > '2021-11-23 18:24:20' ORDER BY lm.creation_date DESC LIMIT 15
0.0407  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 c.date = '2021-11-27' GROUP BY cat.location ORDER BY coefficient DESC
0.0181  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 c.date = '2021-11-27' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 25
0.0121  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.ctype IN (1,3,12,34,36) AND c.shedule >= '2021-11-27 00:00:00' AND c.shedule < '2021-11-27 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0060  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 calendars2022 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.ctype IN (1,3,12,34,36) AND c.id IN (20900,20908,20903,20910,5516,5521,5523,5525,5518,48897,48901,48898,48905,21483,21474,21498,21506,15657,15658,15659,15653,15656,15651,16146,16156,414972,414969,441912,74124,74104,74111,74332,74340,74101,74109,74318,74323,293311,293320,293333,293337,293298,293303,293307,293312,293317,293318,293301,293330,293310,293335,293297,293304,293306,293308,293313,293314,293316,293321,293322,293328,293332,293336,296078,293300,293326,319070,35205,35213,35208,2445,2444,2446,13096,13098,13099,13089,13090,13092,13093,13094,13095,428669,428670,428672,6601,6596,6602,295644,4096,4097,4099,4100,119275,119273,119274,49931,49936,49929,75101) AND c.shedule >= '2021-11-27 00:00:00' AND c.shedule < '2021-11-27 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0028  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 calendars2021 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.ctype IN (1,3,12,34,36) AND c.id IN (20900,20908,20903,20910,5516,5521,5523,5525,5518,48897,48901,48898,48905,21483,21474,21498,21506,15657,15658,15659,15653,15656,15651,16146,16156,414972,414969,441912,74124,74104,74111,74332,74340,74101,74109,74318,74323,293311,293320,293333,293337,293298,293303,293307,293312,293317,293318,293301,293330,293310,293335,293297,293304,293306,293308,293313,293314,293316,293321,293322,293328,293332,293336,296078,293300,293326,319070,35205,35213,35208,2445,2444,2446,13096,13098,13099,13089,13090,13092,13093,13094,13095,428669,428670,428672,6601,6596,6602,295644,4096,4097,4099,4100,119275,119273,119274,49931,49936,49929,75101) AND c.shedule >= '2021-11-27 00:00:00' AND c.shedule < '2021-11-27 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0126  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (110198188, 110198222, 110198204, 110198225, 110196412, 110196419, 110196421, 110196417, 110536458, 110198546, 110198541, 110198548, 110198550, 110536794, 110536799, 110536797, 110536801, 110197803, 110197810, 110197805, 110197812, 110197807, 110197818, 110198725, 110198727, 110882450, 110882431, 110882387, 110882389, 110882460, 110882455, 110882391, 110882453, 110882393, 111276245, 111276247, 111276263, 111322647, 111296042, 111276236, 111276233, 111322649, 111322651, 111276243, 111331192, 111276229, 111276238, 111376988, 111331194, 111276254, 111379968, 111296056, 111276241, 111276249, 111296051, 110200853, 110200855, 110200857, 110200579, 110200581, 110200585, 110536414, 110536429, 110536441, 110536446, 110536435, 110536443, 110536448, 110536416, 110536439, 110201008, 110201010, 110201249, 110201253, 110201247, 110201264, 110201966, 110201969, 110201977, 110887780, 110201184, 110201186, 110838171, 110838175, 110595170, 111170806, 110836418, 110836423, 110836412) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0371  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.0371  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.0371  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.0371  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.0371  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.0371  (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 calendars2022 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 c.shedule >= '2021-11-27 00:00:00' AND c.shedule < '2021-11-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 calendars2021 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 c.shedule >= '2021-11-27 00:00:00' AND c.shedule < '2021-11-27 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC