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

LIVESCORE / Partidos del Lunes, 29 Noviembre 2021

21:00
 en 2 días Eibar
21:00
Girona 7
19:00
 en 2 días Mjällby
19:00
Orebro SK 0
19:00
 en 2 días Elfsborg
19:00
AIK Solna 1
19:00
 en 2 días IK Sirius
19:00
Häcken 0
15:00
 en 2 días Ufa
15:00
Spartak Moskva 1
17:00
 en 2 días Arsenal Tula
17:00
Lokomotiv Moskva 0
20:30
 en 2 días Ternana Calcio
20:30
Crotone 0
13:00
 Aplazado MVV Maastricht
-
Roda JC 21
20:00
 en 2 días Emmen
20:00
Almere City 0
19:00
 en 2 días Türkgücü
19:00
Zwickau 0

LIGAS / COMPETICIONES
Nombre Datos
LIGAS
es Primera División 15/38 Hoy
gb Premier League 13/38 Hoy
it Serie A 14/38 Hoy
es Segunda División 18/42 Hoy
de Bundesliga 13/34 Hoy
fr Ligue 1 15/38 Hoy
ar Liga Profesional Argenti. 22/25 Hoy
es Primera RFEF 2 gr Hoy
br Liga Brasileña 36/38 Hoy
nl Eredivisie 14/34 Hoy
pt Liga Portuguesa 12/34 Hoy
es Segunda RFEF 5 gr Hoy
es Primera Femenina 11/30 En 7 días
COMPETICIONES
wo Clasificación Mundial Su. 14/18 En 60 días
ue Clasificación Europeo Su. 9 gr En 117 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,286,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Livescore / Index )  0.1144
Total Execution Time  0.1161
  CADENA URL  
/livescore/dia/29112021
  GET DATOS  
$_GET['/livescore/dia/29112021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0023  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-26 08:54:25' ORDER BY lm.creation_date DESC LIMIT 8
0.0022  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-20 08:54:25' ORDER BY lm.creation_date DESC LIMIT 15
0.0080  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-29' GROUP BY cat.location ORDER BY coefficient DESC
0.0027  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-29' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 25
0.0027  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-29 00:00:00' AND c.shedule < '2021-11-29 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0066  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 (20906,21485,414975,414964,414967,296099,296098,319062,35211,448805,448804,13091,240263,240265,240267,6600,6598,49935,96277,443714,278049,63269,63266,293364,189559,1285,86710,2759,2797,172386,173112,35462,448788,24180,448733,448734,3609,265788,265790,50302,100137,71345,445565,375239,375240,448362,448363,448366,448367,416218,33564,70647,70644,107659,227026,12754,12748,54071,54074,31038,110747,404884,211910,276904,294258,448900,206929,206930,206931,11450,11452,11453,422313,422319,422323,422325,273324,18903,295138,295139,295140,295141,295142,201589,201595,200977,200978,200979,200980,200981,200982,446777,446778,213059,201132,201134,281640,201135,201136,201137) AND c.shedule >= '2021-11-29 00:00:00' AND c.shedule < '2021-11-29 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0034  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 (20906,21485,414975,414964,414967,296099,296098,319062,35211,448805,448804,13091,240263,240265,240267,6600,6598,49935,96277,443714,278049,63269,63266,293364,189559,1285,86710,2759,2797,172386,173112,35462,448788,24180,448733,448734,3609,265788,265790,50302,100137,71345,445565,375239,375240,448362,448363,448366,448367,416218,33564,70647,70644,107659,227026,12754,12748,54071,54074,31038,110747,404884,211910,276904,294258,448900,206929,206930,206931,11450,11452,11453,422313,422319,422323,422325,273324,18903,295138,295139,295140,295141,295142,201589,201595,200977,200978,200979,200980,200981,200982,446777,446778,213059,201132,201134,281640,201135,201136,201137) AND c.shedule >= '2021-11-29 00:00:00' AND c.shedule < '2021-11-29 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 (110198218, 110536811, 111200239, 111200232, 110200865, 110201020, 110201022, 110201205, 111183239, 111223242, 111223244, 110588927, 110204299, 109234528, 110200714, 110200913, 110536784, 110887786, 111372096, 110838204, 110838207, 110838211, 111170827, 111288465, 111288467, 110204546, 110204542, 110204544, 111171047, 110836433, 111340660, 110833336, 110838207) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0060  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.0060  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.0060  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.0060  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.0060  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.0060  (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-29 00:00:00' AND c.shedule < '2021-11-29 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-29 00:00:00' AND c.shedule < '2021-11-29 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC