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

LIVESCORE / Partidos del Miércoles, 24 Noviembre 2021

21:00
 Finalizado Atlético
0 - 1
Milan 1812
21:00
 Finalizado Liverpool
2 - 0
Porto 610
01:00
 Finalizado Grêmio
2 - 2
Flamengo 712
01:30
 Finalizado Palmeiras
2 - 2
Atl. Mineiro 452
20:45
 Finalizado Fulham
0 - 0
Derby County 224
20:45
 Finalizado Bristol City
1 - 0
Stoke City 30
20:45
 Finalizado Queens Park Range.
1 - 0
Huddersfield Town 24
20:45
 Finalizado Barnsley
0 - 2
Swansea City 25
20:45
 Finalizado Cardiff City
0 - 1
Hull City 21
20:45
 Finalizado Blackburn Rovers
4 - 0
Peterborough 26
20:45
 Finalizado Millwall
1 - 1
AFC Bournemouth 29
14:30
 Finalizado AlbinoLeffe
0 - 1
Catanzaro 1
14:30
 Finalizado Fidelis Andria
1 - 0
Piacenza 2
15:00
 Finalizado Padova
1 - 0
Viterbese 0
17:30
 Finalizado Teramo
0 - 3
Sudtirol 2
14:00
 Finalizado Almopos Aridea
3 - 1
Pierikos 0
14:00
 Finalizado Trikala
0 - 0
Iraklis 0
14:00
 Finalizado Olympiakos Volou
3 - 2
Apollon Pontou 0
14:00
 Finalizado AE Larisa
2 - 0
Panserraikos FC 0
14:00
 Finalizado Kavala
0 - 6
Xanthi 0
14:00
 Finalizado PAOK B
1 - 2
Veria NPS 0
14:00
 Finalizado Apollon Larisas
2 - 2
Olympiacos Piraeus 0
14:00
 Finalizado Karaiskakis
0 - 1
Kalamata FC 0
14:00
 Finalizado Diagoras
1 - 0
Episkopi 2
14:00
 Finalizado OF Ierapetra
1 - 1
Irodotos 0
14:00
 Finalizado Ergotelis
0 - 0
AEK Athens B 0
14:00
 Finalizado Chania
2 - 2
Rodos 0
14:00
 Finalizado Kallithea
1 - 0
Egaleo 0
14:00
 Finalizado Asteras Vlachioti
0 - 1
Kifisia 0
14:00
 Aplazado Zakynthos
-
Levadiakos 0

LIGAS / COMPETICIONES
Nombre Datos
LIGAS
es Primera División 15/38 Mañana
gb Premier League 14/38 Hoy
it Serie A 15/38 Ayer
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  
12,543,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Livescore / Index )  0.1555
Total Execution Time  0.1573
  CADENA URL  
/livescore/dia/24112021
  GET DATOS  
$_GET['/livescore/dia/24112021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
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.coefficient >= 10 AND lm.creation_date > '2021-11-29 19:11:38' 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.coefficient >= 10 AND lm.creation_date > '2021-11-23 19:11:38' ORDER BY lm.creation_date DESC LIMIT 15
0.0043  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-24' GROUP BY cat.location ORDER BY coefficient DESC
0.0042  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-24' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 25
0.0046  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-24 00:00:00' AND c.shedule < '2021-11-24 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0076  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 (200118,200094,200101,200102,200110,200111,200119,200093,200370,414957,414958,414952,414954,414963,318727,319054,13079,13083,13084,13085,13086,13087,13088,446837,446838,4081,276017,202190,276011,202177,276025,202142,202189,202130,202129,202141,202178,7189,16351,446449,296275,296276,296277,86606,446798,446800,446799,446797,448722,448723,120206,120207,120208,120212,285425,285426,285947,285948,285950,285419,285951,285420,285952,285421,285953,285422,285954,285423,285424,222662,228712,224743,119872,119870,405286,405212,119868,26157,26163,26164,71289,445532,445561,445560,286982,294744,294749,294750,286971,294755,286972,294756,286974,294757,286975,286976,286977,286983,7648,446272) AND c.shedule >= '2021-11-24 00:00:00' AND c.shedule < '2021-11-24 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0031  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 (200118,200094,200101,200102,200110,200111,200119,200093,200370,414957,414958,414952,414954,414963,318727,319054,13079,13083,13084,13085,13086,13087,13088,446837,446838,4081,276017,202190,276011,202177,276025,202142,202189,202130,202129,202141,202178,7189,16351,446449,296275,296276,296277,86606,446798,446800,446799,446797,448722,448723,120206,120207,120208,120212,285425,285426,285947,285948,285950,285419,285951,285420,285952,285421,285953,285422,285954,285423,285424,222662,228712,224743,119872,119870,405286,405212,119868,26157,26163,26164,71289,445532,445561,445560,286982,294744,294749,294750,286971,294755,286972,294756,286974,294757,286975,286976,286977,286983,7648,446272) AND c.shedule >= '2021-11-24 00:00:00' AND c.shedule < '2021-11-24 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0031  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (110479005, 110479007, 110479027, 110479009, 110479014, 110479021, 110479012, 110479017, 110489296, 111091836, 111091822, 111091843, 111091807, 111091829, 111091814, 111091839, 111088317, 110479027, 110479005, 110479017, 110479007, 110479009, 110479012, 110479021, 110539878, 111158990, 110543473, 110838655, 110838652, 110838640, 111172884, 110838144, 110838147, 110838150, 110838152, 110838155, 111167356, 111055980, 110543473, 110543475) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0088  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.0088  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.0088  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.0088  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.0088  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.0088  (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-24 00:00:00' AND c.shedule < '2021-11-24 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-24 00:00:00' AND c.shedule < '2021-11-24 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC