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

LIVESCORE / Partidos del Sábado, 15 Enero 2022

13:30
 Finalizado Man. City
1 - 0
Chelsea 1012
16:00
 Finalizado Wolves
3 - 1
Southampton 143
16:00
 Finalizado Newcastle
1 - 1
Watford 215
16:00
 Aplazado Burnley
-
Leicester 30
16:00
 Finalizado Norwich City
2 - 1
Everton 377
18:30
 Finalizado Aston Villa
2 - 2
Man. Utd 845
16:00
 Finalizado Mallorca
2 - 1
Espanyol 730
18:30
 Finalizado Girona
1 - 2
Rayo Vallecano 479
18:30
 Finalizado Real Sporting
0(2 - 4)0
Cádiz 853
15:00
 Finalizado Sampdoria
1 - 2
Torino 166
18:00
 Finalizado Salernitana
0 - 3
Lazio 233
20:45
 Finalizado Juventus
2 - 0
Udinese 392
17:00
 Finalizado Nigeria
3 - 1
Sudán 52
20:00
 Finalizado Guinea Bissau
0 - 1
Egipto 142
15:30
 Finalizado Köln
0 - 4
Bayern München 433
15:30
 Finalizado Union Berlin
2 - 1
Hoffenheim 90
15:30
 Finalizado Stuttgart
0 - 2
RB Leipzig 139
15:30
 Finalizado Wolfsburg
0 - 0
Hertha BSC 188
15:30
 Finalizado Mainz 05
1 - 0
VfL Bochum 84
18:30
 Finalizado Mönchengladbach
1 - 2
B. Leverkusen 558
17:00
 Finalizado Saint-Étienne
1 - 2
Lens 210
21:00
 Finalizado PSG
2 - 0
Stade Brestois 346
02:00
 Finalizado Querétaro
1 - 3
Pumas UNAM 489
04:00
 Finalizado Necaxa
0 - 4
Monterrey 543
18:45
 Finalizado NEC Nijmegen
0 - 0
Heracles 44
20:00
 Finalizado Feyenoord
0 - 1
Vitesse 88
20:00
 Finalizado Twente 1965
2 - 0
Heerenveen 23
21:00
 Finalizado Go Ahead Eagles
0 - 2
RKC Waalwijk 18
16:30
 Finalizado Boavista
1 - 1
Gil Vicente 56
19:00
 Finalizado Sporting Braga
0 - 1
Marítimo 179
19:00
 Finalizado Benfica
1 - 1
Moreirense 399
13:30
 Finalizado Luton Town
3 - 2
AFC Bournemouth 90
13:30
 Finalizado Cardiff City
0 - 1
Blackburn Rovers 67
16:00
 Finalizado Derby County
2 - 0
Sheffield United 29
16:00
 Finalizado Peterborough
1 - 4
Coventry City 2
16:00
 Aplazado Barnsley
-
Blackpool 0
16:00
 Finalizado Middlesbrough
2 - 1
Reading 19
16:00
 Finalizado Preston North End
1 - 1
Birmingham City 3
16:00
 Finalizado Huddersfield Town
1 - 1
Swansea City 7
16:00
 Finalizado Millwall
0 - 1
Nottingham Forest 10
16:00
 Finalizado Queens Park Range.
1 - 0
West Bromwich Alb. 9
16:15
 Finalizado Fulham
6 - 2
Bristol City 60
16:15
 Finalizado Asteras Tripolis
1 - 0
Volos Football 0
16:15
 Finalizado Lamia
2 - 1
Ionikos Nikea 0
18:30
 Finalizado PAOK
3 - 0
OFI 36
18:30
 Finalizado Apollon Smyrnis
0 - 0
Aris Thessaloniki 9
11:30
 Finalizado Adana Demirspor
1 - 1
Kayserispor 78
14:00
 Finalizado Sivasspor
1 - 1
Trabzonspor 26
14:00
 Finalizado Fatih Karagümrük
2 - 0
Rizespor 2
17:00
 Finalizado Antalyaspor
1 - 1
Fenerbahçe 49
02:00
 Finalizado Alianza Lima
3 - 2
La Equidad 44
09:00
 Finalizado Energetik-BGU
1 - 0
Minsk 0
09:30
 Finalizado Lokomotiv Sofia
2 - 0
Nadezhda 3
10:00
 Finalizado Pohronie
2 - 1
FC Vratimov 0
10:00
 Finalizado SFC Opava
2 - 1
Sigma Olomouc II 0
10:00
 Finalizado DAC
5 - 1
FC Petržalka 0
10:00
 Finalizado Benátky Jizerou
2 - 2
FK Caslav 0
10:00
 Finalizado Hradec Králové
3 - 0
Chrudim 0
10:15
 Finalizado Znojmo
4 - 3
Viktoria 0
10:30
 Finalizado Kromeriz
1 - 5
Slovácko 0
10:30
 Finalizado Viktoria Plzeň
1 - 0
Ústí nad Labem 0
10:30
 Finalizado Baník Sokolov
0 - 2
Banik Most - Sous 0
10:30
 Finalizado AC Horsens
5 - 0
Aarhus Fremad 0
11:00
 Finalizado Sered
1 - 1
Komárno 0
11:00
 Aplazado Schalke 04 II
-
Stuttgart II 0
11:00
 Finalizado Ponferradina
2 - 3
RC Deportivo 41
11:00
 Finalizado Dabas
1 - 0
Budaörsi 0
11:00
 Finalizado České
2 - 0
Pribram 0
11:00
 Finalizado Líšeň
2 - 0
Šamorín 2
11:00
 Finalizado Ruzomberok
3 - 1
Námestovo 0
11:00
 Finalizado Žilina
1 - 2
Podbrezová 2
11:00
 Finalizado Hutnik Krakow
4 - 3
Garbarnia Kraków 0
11:00
 Finalizado Piast Gliwice
5 - 1
Goczalkowice Zdroj 1
11:00
 Finalizado Radunia Stężyca
4 - 2
Jaguar Gdansk 0
11:00
 Finalizado TS Polonia Bytom
2 - 3
SKRA Częstochowa 0
11:00
 Finalizado UD Alzira
3 - 4
CFR Cluj 0
11:00
 Finalizado Domžale
2 - 2
Budafoki LC 0
11:00
 Finalizado Lausanne Sports
1 - 1
Stade 0
11:00
 Finalizado Slavoj Trebišov
4 - 0
Spišská Nová 0
11:00
 Aplazado Hradec Králové
-
Slovan Liberec 2
11:00
 Finalizado Vyškov
3 - 0
Hodonín-Šardice 0
11:00
 Finalizado Lierse SK
1 - 0
Patro Eisden 0
11:00
 Finalizado Stomil Olsztyn
2 - 0
Mamry Gizycko 0
11:00
 Finalizado Kazincbarcika
2 - 1
Diósgyőr VTK II 0
11:00
 Finalizado Rekord Bielsko Bi.
1 - 2
GKS Katowice 0
11:00
 Finalizado Teplice II
4 - 2
Sokol Hostouň 0
11:00
 Finalizado Istra 1961
1 - 0
Foresta Suceava 0
11:00
 Finalizado Mioveni
0 - 0
FCSB 0
11:00
 Finalizado Zbrojovka Brno
3 - 3
Zlin 0
11:00
 Finalizado Kolding IF
0 - 2
SonderjyskE 0
11:00
 Finalizado Rapid Wien
1 - 1
Stripfing 0
11:00
 Finalizado Schalke 04 II
10 - 0
ASC 09 Dortmund 6
11:00
 Aplazado Slavoj Vyšehrad
-
Chrudim 0
11:00
 Finalizado Eldense
2 - 2
UCAM Murcia 5
11:00
 Finalizado Gutersloh
2 - 5
Rödinghausen 0
11:00
 Finalizado Sopron
2 - 2
Pápai Perutz 0
11:30
 Finalizado Shakhtyor
3 - 0
Slavia Mozyr 0
11:30
 Finalizado Racing Union
1 - 3
SV 07 Elversberg 0

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,597,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Livescore / Index )  0.1495
Total Execution Time  0.1506
  CADENA URL  
/livescore/dia/15012022
  GET DATOS  
$_GET['/livescore/dia/15012022']  
  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 > '2022-01-22 00:13:16' 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:13:16' ORDER BY lm.creation_date DESC LIMIT 15
0.0135  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-15' GROUP BY cat.location ORDER BY coefficient DESC
0.0082  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-15' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 25
0.0074  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-15 00:00:00' AND c.shedule < '2022-01-15 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0061  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 (5560,5558,5561,5562,5565,5556,322267,322261,322262,48983,48982,48979,433417,433418,15712,15705,15706,15710,15711,15708,15922,15913,74427,305391,305392,2490,2489,2495,2491,35280,35282,35279,13174,13179,13173,13175,13177,13180,13181,13182,13183,13184,13176,119328,119325,119324,119327,317687,50002,50000,50006,50004,331050,333620,330086,319811,319827,329428,331054,333626,319806,329432,329434,319807,320916,319817,327379,333657,319818,327414,333659,319828,328368,319808,334277,319832,328378,319809,319834,329440,319810,319842,331066,319812,319847,331073,319813,325311,333635,319814,326074,333639,319815,326505,333641,319816,327077,333655,330047,333663) AND c.shedule >= '2022-01-15 00:00:00' AND c.shedule < '2022-01-15 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0024  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 (5560,5558,5561,5562,5565,5556,322267,322261,322262,48983,48982,48979,433417,433418,15712,15705,15706,15710,15711,15708,15922,15913,74427,305391,305392,2490,2489,2495,2491,35280,35282,35279,13174,13179,13173,13175,13177,13180,13181,13182,13183,13184,13176,119328,119325,119324,119327,317687,50002,50000,50006,50004,331050,333620,330086,319811,319827,329428,331054,333626,319806,329432,329434,319807,320916,319817,327379,333657,319818,327414,333659,319828,328368,319808,334277,319832,328378,319809,319834,329440,319810,319842,331066,319812,319847,331073,319813,325311,333635,319814,326074,333639,319815,326505,333641,319816,327077,333655,330047,333663) AND c.shedule >= '2022-01-15 00:00:00' AND c.shedule < '2022-01-15 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0032  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (113044669, 113044673, 113044683, 113653168, 113044678, 113044687, 113467114, 113467116, 113467119, 113172471, 113172473, 113172475, 113172451, 113172438, 113172440, 113172435, 113172444, 113172461, 113131868, 113131870, 113627870, 113469679, 113469685, 112219038, 112219042, 112219045, 112219047, 113087141, 113087150, 113087147, 113046871, 113046875, 113046878, 113046891, 113046873, 113046885, 113046894, 113046882, 113046888, 113046880, 113127227, 113127204, 113127209, 113129630, 113129634, 113129638, 113129658, 111928378, 111928382) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0158  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.0158  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.0158  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.0158  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.0158  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.0158  (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-15 00:00:00' AND c.shedule < '2022-01-15 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-15 00:00:00' AND c.shedule < '2022-01-15 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC