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

LIVESCORE / Partidos del Martes, 18 Enero 2022

20:00
 Finalizado Real Betis
4 - 0
Alavés 1066
21:30
 Finalizado Cádiz
2 - 2
Espanyol 989
17:00
 Finalizado Malawi
0 - 0
Senegal 371
17:00
 Finalizado Zimbabue
2 - 1
Guinea 187
20:00
 Finalizado Gabón
2 - 2
Marruecos 240
20:00
 Finalizado Ghana
2 - 3
Comoras 202
17:30
 Finalizado Lazio
1 - 0
Udinese 900
21:00
 Finalizado Juventus
4 - 1
Sampdoria 160
18:30
 Finalizado 1860 München
0 - 1
Karlsruher SC 54
18:30
 Finalizado Köln
1(3 - 4)1
Hamburger SV 130
20:45
 Finalizado FC St. Pauli
2 - 1
B. Dortmund 735
20:45
 Finalizado VfL Bochum
3 - 1
Mainz 05 33
20:45
 Finalizado Dundee United
1 - 2
St. Mirren 8
20:45
 Finalizado Ross County FC
3 - 1
Motherwell 21
20:45
 Finalizado Heart Midlothian
2 - 0
St. Johnstone 39
20:45
 Finalizado Aberdeen
1 - 1
Rangers FC 66
20:45
 Finalizado Livingston
2 - 0
Dundee 3
01:30
 Finalizado Nacional
2(4 - 2)2
Ñublense 53
11:00
 Finalizado Žarkovo
0 - 0
Foresta Suceava 1
13:00
 Finalizado Zlín II
0 - 1
Baník Ostrava II 1
13:00
 Finalizado Rabotnički
2 - 1
Makedonija GjP 1
13:00
 Finalizado Belasica
0 - 4
Akademija Pandev 0
13:00
 Finalizado FK Vozdovac
2 - 0
Metalac GM 0
13:00
 Finalizado Ruzomberok
4 - 2
Bardejov 4
14:00
 Finalizado Slavia Sofia
0 - 3
Stal Mielec 0
14:00
 Finalizado Baník Ostrava
1 - 0
Kisvárda 0
14:30
 Finalizado Istra 1961
2 - 1
HNK Sibenik 0
15:00
 Finalizado Lechia Gdansk
0 - 2
Chornomorets 0
15:00
 Finalizado Paksi SE
2 - 0
Ufa 1
15:00
 Finalizado Krylya Sovetov
2 - 0
Szeged 2011 0
15:00
 Finalizado Salzburg
3 - 1
Ried 0
15:00
 Finalizado Lech Poznań
4 - 1
Shkupi 0
15:00
 Finalizado Levski Sofia
1 - 1
KS Górnik Zabrze 0
15:00
 Finalizado Kuban Krasnodar
0 - 1
Bregalnica Štip 0
15:30
 Finalizado Radomiak Radom
2 - 1
Bačka Topola 0
15:30
 Finalizado Wisla Kraków
1 - 1
Ludogorets 0
16:00
 Finalizado Young Boys
6 - 0
Sion 6
16:00
 Aplazado Young Boys
-
Salzburg 1
16:00
 Aplazado Unterhaching
-
Sonnenhof 0
17:00
 Aplazado Marchfeld
-
SKN St. Polten 0
18:00
 Aplazado FCM Traiskirchen
-
Kapfenberger SV 0
18:30
 Finalizado Liefering
4 - 0
Salzburger AK 2
18:30
 Finalizado Rsv Eintracht
3 - 3
Tennis Borussia 0
19:00
 Finalizado Inter Turkspor Ki.
0 - 0
Weiche Flensburg 0
19:00
 Finalizado Empor
0 - 0
Altglienicke 0
20:00
 Finalizado Una Strassen
6 - 2
Jeunesse Canach 2
20:30
 Finalizado Cobh Ramblers
0 - 3
Dundalk 1
18:45
 Finalizado RKC Waalwijk
4 - 2
ADO Den Haag 13
20:00
 Finalizado Vitesse
2 - 0
DVS'33 3
21:00
 Finalizado Heerenveen
0 - 1
Go Ahead Eagles 20
20:00
 Finalizado RFC Seraing
0 - 4
Union 40
19:00
 Finalizado Mafra
2 - 2
CF Estrela 17
21:15
 Finalizado SC Covilha
2 - 2
Feirense 17

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,311,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Livescore / Index )  0.1253
Total Execution Time  0.1282
  CADENA URL  
/livescore/dia/18012022
  GET DATOS  
$_GET['/livescore/dia/18012022']  
  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 > '2022-01-22 00:51:52' ORDER BY lm.creation_date DESC LIMIT 8
0.0021  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:51:52' ORDER BY lm.creation_date DESC LIMIT 15
0.0051  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-18' GROUP BY cat.location ORDER BY coefficient DESC
0.0055  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-18' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 25
0.0050  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-18 00:00:00' AND c.shedule < '2022-01-18 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0128  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 (20990,20995,5577,433407,433408,433413,433414,306063,307140,74092,74465,281349,281346,281345,281351,13140,13147,317690,4136,4131,4133,4134,4135,74989,75236,50009,50013,339234,329524,334384,339240,319854,323315,326572,319851,326579,326580,323316,325366,326575,326576,331180,334392,323314,339254,339259,319850,331181,339256,339258,331183,319852,331185,331187,331186,335249,333800,309416,309419,309418,3207,13702,13709,13612,13677,172790,35515,35509,448884,14238,14239,14250,14267,14220,298156,223501,222766,44796,44812,327084,45246,45293,45322,45701,45746,45771,316315,316317,316314,316361,144555,199188,152579,152574,316255,107284,107290,107732,108043,108080) AND c.shedule >= '2022-01-18 00:00:00' AND c.shedule < '2022-01-18 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0045  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 (20990,20995,5577,433407,433408,433413,433414,306063,307140,74092,74465,281349,281346,281345,281351,13140,13147,317690,4136,4131,4133,4134,4135,74989,75236,50009,50013,339234,329524,334384,339240,319854,323315,326572,319851,326579,326580,323316,325366,326575,326576,331180,334392,323314,339254,339259,319850,331181,339256,339258,331183,319852,331185,331187,331186,335249,333800,309416,309419,309418,3207,13702,13709,13612,13677,172790,35515,35509,448884,14238,14239,14250,14267,14220,298156,223501,222766,44796,44812,327084,45246,45293,45322,45701,45746,45771,316315,316317,316314,316361,144555,199188,152579,152574,316255,107284,107290,107732,108043,108080) AND c.shedule >= '2022-01-18 00:00:00' AND c.shedule < '2022-01-18 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0063  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (113444392, 113444394, 113444951, 113193248, 113193250, 113491926, 113780720, 110597238, 110597240, 110597242, 110597245, 112214803, 112662186, 113812834, 112219331, 112219344, 112219335, 112219326, 112219337, 113492413, 113492416, 113467755, 113467761, 113467763, 113127974, 113487863, 109871559, 113487866, 111880613, 113088332, 113088335, 112667933, 113487957, 113487949, 113487954, 113487944, 113193248, 110536581, 113749372, 113768040, 111928420, 111928417, 111928424, 111928426) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0123  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.0123  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.0123  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.0123  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.0123  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.0123  (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-18 00:00:00' AND c.shedule < '2022-01-18 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-18 00:00:00' AND c.shedule < '2022-01-18 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC