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

LIVESCORE / Partidos del Domingo, 16 Enero 2022

15:00
 Finalizado West Ham
2 - 3
Leeds United 497
15:00
 Finalizado Liverpool
3 - 0
Brentford 237
17:30
 Aplazado Tottenham Hotspur
-
Arsenal 29
12:30
 Finalizado Sassuolo
2 - 4
Hellas Verona 357
15:00
 Finalizado Venezia
1 - 1
Empoli 158
18:00
 Finalizado Roma
1 - 0
Cagliari 459
20:45
 Finalizado Atalanta
0 - 0
Inter 649
14:00
 Finalizado Gambia
1 - 1
Mali 84
17:00
 Finalizado Túnez
4 - 0
Mauritania 32
13:00
 Finalizado Stade Rennais
6 - 0
Girondins Bordeaux 27
15:00
 Finalizado Monaco
4 - 0
Clermont 55
15:00
 Finalizado Strasbourg
3 - 1
Montpellier 39
15:00
 Finalizado Lorient
0 - 0
Angers SCO 43
15:00
 Finalizado Stade de Reims
0 - 1
Metz 20
17:05
 Finalizado Troyes
0 - 1
Olympique Lyonnais 160
20:45
 Finalizado Olympique
1 - 1
Lille 300
00:00
 Finalizado Atlas Guadalajara
1 - 0
Atl. San Luis 480
02:00
 Finalizado Tigres UANL
0 - 2
Puebla 592
04:00
 Finalizado Cruz Azul
1 - 0
FC Juárez 159
04:06
 Finalizado Tijuana
1 - 1
León 234
19:00
 Finalizado Toluca
3 - 1
Santos Laguna 86
12:15
 Finalizado Utrecht
0 - 3
Ajax 57
14:30
 Finalizado Cambuur
1 - 1
Sparta Rotterdam 10
14:30
 Finalizado Groningen
0 - 1
PSV 58
16:45
 Finalizado Fortuna Sittard
1 - 2
AZ Alkmaar 40
16:30
 Finalizado CD Santa Clara
2 - 2
Tondela 51
19:00
 Finalizado Vizela
0 - 2
Sporting CP 140
19:30
 Finalizado Famalicão
0 - 0
Paços Ferreira 73
21:30
 Finalizado Belenenses SAD
1 - 4
Porto 374
22:00
 Finalizado Perú
1 - 1
Panamá 495
23:30
 Finalizado Colombia
2 - 1
Honduras 369
11:30
 Finalizado Altay
0 - 2
Alanyaspor 21
14:00
 Finalizado Giresunspor
0 - 2
Kasimpasa 5
17:00
 Finalizado Hatayspor
4 - 2
Galatasaray SK 37
10:00
 Finalizado Mladá Boleslav
2 - 0
SK Kladno 0
10:30
 Finalizado Slavia Praha II
3 - 3
Sokol Živanice 1
10:45
 Aplazado Paloma Hamburg
-
TSV Sasel 0
11:00
 Finalizado Lokomotiva
2 - 3
NK Opatija 9
13:00
 Finalizado Renova
1 - 1
KF Besa 0
13:30
 Finalizado Rostocker FC
1 - 0
Dynamo Schwerin 0
14:00
 Aplazado Debreceni VSC
-
Újpest FC 0
14:00
 Finalizado Mönchengladbach
2 - 1
FC Remscheid 0
14:00
 Finalizado Paide
2 - 0
Vaprus Pärnu 0
14:00
 Finalizado Geestemünde
0 - 3
Drochtersen Assel 1
14:00
 Finalizado NK Varazdin
1 - 2
Celje 0
14:00
 Aplazado Ferencvárosi
-
Spartak Subotica 0
14:30
 Finalizado Hajduk Split
2 - 1
Siroki Brijeg 0
14:30
 Finalizado NK Dugopolje
5 - 1
Iskra Danilovgrad 0
14:30
 Finalizado Dinamo Zagreb
4 - 2
FC Koper 1
15:00
 Finalizado TuS Bovinghausen
3 - 4
FSV Duisburg 1
15:00
 Finalizado Zaglebie Lubin
1 - 0
Voluntari 0
15:00
 Finalizado Leher Bremerhaven
2 - 4
SFL Bremerhaven 1
15:00
 Finalizado Maribor
4 - 0
Triglav Kranj 0
15:00
 Aplazado Siegburger SV 04
-
KFC Uerdingen 05 0
15:30
 Finalizado Galway United
1 - 0
Finn Harps 0
19:00
 Finalizado Aliança AL
0 - 0
CSE 1
23:15
 Finalizado Belgrano
2 - 0
Unión Española 9

LIGAS / COMPETICIONES
Nombre Datos
LIGAS
es Primera División 22/38 Ayer
gb Premier League 23/38 Ayer
it Serie A 23/38 Ayer
es Segunda División 24/42 Ayer
de Bundesliga 20/34 Ayer
fr Ligue 1 22/38 Ayer
es Primera RFEF 2 gr Ayer
nl Eredivisie 20/34 Ayer
pt Liga Portuguesa 19/34 Ayer
es Segunda RFEF 5 gr Ayer
es Primera Femenina 18/30 En 6 días
COMPETICIONES
es Copa del Rey 6/8 En 10 días
wo Clasificación Mundial Su. 14/18 En 4 días
ue Clasificación Europeo Su. 9 gr En 60 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,518,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Livescore / Index )  0.1762
Total Execution Time  0.1785
  CADENA URL  
/livescore/dia/16012022
  GET DATOS  
$_GET['/livescore/dia/16012022']  
  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 > '2022-01-22 00:29:13' ORDER BY lm.creation_date DESC LIMIT 8
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 > '2022-01-16 00:29:13' ORDER BY lm.creation_date DESC LIMIT 15
0.0388  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 = '2022-01-16' GROUP BY cat.location ORDER BY coefficient DESC
0.0170  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 = '2022-01-16' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 25
0.0122  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 >= '2022-01-16 00:00:00' AND c.shedule < '2022-01-16 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 (20998,5559,5564,5563,322260,322265,48984,48985,48981,48976,433429,433423,433430,433424,332718,15707,15713,15919,15909,15916,15925,15900,15928,15903,305393,305394,305395,305396,305397,2493,2492,2494,2496,35281,35275,35277,35276,13178,119322,119323,119326,302258,304025,75034,74836,75139,76036,75023,50001,49998,49999,333750,333751,319848,329516,323309,333755,331158,331159,331160,331156,333757,331157,326567,329518,331161,333766,333768,319849,332142,333765,333770,334368,333771,147301,118669,125427,145118,145119,170332,147295,147297,147300,114300,145124,114297,114298,174113,174119,143828,118662,143830,147620,118663,170335,125422,118667,147298,125429,118668) AND c.shedule >= '2022-01-16 00:00:00' AND c.shedule < '2022-01-16 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0025  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 (20998,5559,5564,5563,322260,322265,48984,48985,48981,48976,433429,433423,433430,433424,332718,15707,15713,15919,15909,15916,15925,15900,15928,15903,305393,305394,305395,305396,305397,2493,2492,2494,2496,35281,35275,35277,35276,13178,119322,119323,119326,302258,304025,75034,74836,75139,76036,75023,50001,49998,49999,333750,333751,319848,329516,323309,333755,331158,331159,331160,331156,333757,331157,326567,329518,331161,333766,333768,319849,332142,333765,333770,334368,333771,147301,118669,125427,145118,145119,170332,147295,147297,147300,114300,145124,114297,114298,174113,174119,143828,118662,143830,147620,118663,170335,125422,118667,147298,125429,118668) AND c.shedule >= '2022-01-16 00:00:00' AND c.shedule < '2022-01-16 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0033  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (113444390, 113044690, 113044692, 113708196, 113467124, 113467121, 113172477, 113172481, 113446746, 113446742, 113625491, 113172464, 113172469, 113131889, 113131899, 113131884, 113131895, 113131901, 113131908, 113469681, 113469695, 113469688, 113469704, 113469708, 112219050, 112219056, 112219053, 112219058, 113087158, 113087160, 113087132, 113102499, 113046910, 113127239, 113127245, 113127251, 113648695, 113648698, 113129662, 113129668, 113129672, 111928391, 111928407, 111928400) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0225  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.0225  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.0225  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.0225  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.0225  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.0225  (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 c.shedule >= '2022-01-16 00:00:00' AND c.shedule < '2022-01-16 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 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 >= '2022-01-16 00:00:00' AND c.shedule < '2022-01-16 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC