4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

LIVESCORE / Partidos del Sábado, 23 Septiembre 2023

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 23 SEP
Argentina Portugal Italia Chile Japón Uruguay Estados Unidos Irlanda Bielorusia Hungría Bolivia Camerún India Haití Senegal República Dominicana Namibia Tuvalu Azerbaiyán
Partidos Sábado, 23 Septiembre 2023
España Reino Unido Alemania Francia Escocia Rusia Turquía Holanda República Checa Italia Suecia Argentina Suiza Bélgica Portugal Rumania Japón Austria Bulgaria México Brasil Polonia Chile Croacia Noruega Finlandia Bielorusia Eslovaquia China Colombia Ucrania Dinamarca Bosnia y Herzegovina Serbia Uruguay Moldavia Grecia Ecuador Estonia Eslovenia Albania Corea del Sur Emiratos Árabes Israel Gales Granada Canadá Sudáfrica Hungría Lituania Letonia Macedonia Tailandia Montenegro Chipre Argelia Competiciones Europeas Marruecos Kazakstán Venezuela Uzbekistán Panamá Paraguay Georgia Kenya Bolivia Malta Arabia Saudita Indonesia Martinica Costa Rica India Qatar Luxemburgo Zimbabwe Túnez Zambia Islas Feroe Internacional Jordania Perú Azerbaiyán El Salvador Estados Unidos Burundi Congo, República Democrática del Burkina Faso Uganda San Marino Líbano Islandia Hong Kong Bahrein Australia Mozambique Nicaragua Malasia Nueva Zelanda Andorra Puerto Rico Ghana Santo Tomé y Príncipe Guam Botswana Filipinas Malawi Islas Salomón Brunei Omán Papua Nueva Guinea Armenia Turkmenistán Kirguistán Camboya Gibraltar Siria Aruba
Primera División Primera División »
14:00
  Finalizado Girona
5 - 3
 		Mallorca 999
16:15
  Finalizado Osasuna
0 - 0
 		Sevilla 742
18:30
  Finalizado Barcelona
3 - 2
 		Celta 3909
21:00
  Finalizado Almería
2 - 2
 		Valencia 546
Premier League Premier League »
16:00
  Finalizado Manchester City
2 - 0
 		Nottingham Forest 507
16:00
  Finalizado Crystal Palace
0 - 0
 		Fulham 441
16:00
  Finalizado Luton Town
1 - 1
 		Wolves 351
18:30
  Finalizado Brentford
1 - 3
 		Everton 268
21:00
  Finalizado Burnley
0 - 1
 		Manchester United 612
Serie A Serie A »
15:00
  Finalizado Milan
1 - 0
 		Hellas Verona 430
18:00
  Finalizado Sassuolo
4 - 2
 		Juventus 858
20:45
  Finalizado Lazio
1 - 1
 		AC Monza 696
Segunda División Segunda División »
14:00
  Finalizado FC Andorra
0 - 0
 		Real Sporting 213
16:15
  Finalizado Levante
2 - 0
 		Eldense 139
18:30
  Finalizado Burgos
4 - 0
 		Elche 295
21:00
  Finalizado Alcorcón
0 - 2
 		Huesca 107
21:00
  Finalizado Racing
2 - 1
 		Albacete 342
Bundesliga Bundesliga »
15:30
  Finalizado B. Dortmund
1 - 0
 		Wolfsburg 789
15:30
  Finalizado Union Berlin
0 - 2
 		Hoffenheim 450
15:30
  Finalizado FC Augsburg
2 - 1
 		Mainz 05 89
15:30
  Finalizado Bayern München
7 - 0
 		VfL Bochum 278
15:30
  Finalizado Mönchengladbach
0 - 1
 		RB Leipzig 546
18:30
  Finalizado Werder Bremen
2 - 1
 		Köln 183
Ligue 1 Ligue 1 »
17:00
  Finalizado Nantes
5 - 3
 		Lorient 68
21:00
  Finalizado Stade Brestois
1 - 0
 		Olympique Lyonnais 272
Liga Portuguesa Liga Portuguesa »
16:30
  Finalizado Estoril
2 - 2
 		Vizela 14
16:30
  Finalizado Moreirense
1 - 0
 		Farense 9
19:00
  Finalizado Casa Pia AC
0 - 0
 		Vitória 42
21:30
  Finalizado Porto
2 - 1
 		Gil Vicente 508
Eredivisie Eredivisie »
16:30
  Finalizado FC Volendam
2 - 2
 		Heracles 12
18:45
  Finalizado NEC Nijmegen
3 - 0
 		Utrecht 16
20:00
  Finalizado Almere City
0 - 4
 		PSV 70
21:00
  Finalizado Heerenveen
0 - 3
 		Excelsior 30
Primera Chile Primera Chile »
01:30
  Finalizado Coquimbo Unido
2 - 1
 		O'Higgins 143
17:30
  Finalizado Palestino
2 - 1
 		Unión Española 16
20:00
  Finalizado Curicó Unido
0 - 3
 		Ñublense 24
22:30
  Finalizado Colo-Colo
6 - 0
 		Cobresal 209
Championship Championship »
16:00
  Finalizado Leicester
1 - 0
 		Bristol City 81
16:00
  Finalizado Rotherham United
1 - 1
 		Preston North End 40
16:00
  Finalizado Ipswich Town
4 - 3
 		Blackburn Rovers 24
16:00
  Finalizado Middlesbrough
2 - 1
 		Southampton 7
16:00
  Finalizado Swansea City
3 - 0
 		Sheffield 3
16:00
  Finalizado Leeds United
3 - 0
 		Watford 38
16:00
  Finalizado Plymouth Argyle
6 - 2
 		Norwich City 65
16:00
  Finalizado West Bromwich Alb.
0 - 0
 		Millwall 14
Super League Griega Super League Griega »
16:30
  Finalizado OFI
1 - 1
 		Atromitos 5
19:00
  Finalizado Panserraikos FC
2 - 0
 		Lamia 10
Liga Escocia Liga Escocia »
13:30
  Finalizado Livingston
0 - 3
 		Celtic 55
16:00
  Finalizado Dundee
2 - 2
 		Kilmarnock 0
16:00
  Finalizado St. Mirren
1 - 0
 		Heart Midlothian 9
16:00
  Finalizado Hibernian FC
2 - 0
 		St. Johnstone 0
Liga Turca Liga Turca »
16:00
  Finalizado Rizespor
1 - 1
 		Sivasspor 25
16:00
  Finalizado Pendikspor
1 - 1
 		Fatih Karagümrük 5
19:00
  Finalizado İstanbul
1 - 2
 		Galatasaray SK 35
19:00
  Finalizado Antalyaspor
2 - 0
 		Samsunspor 12
Taça de Portugal Taça de Portugal »
12:00
  Finalizado Fabril Barreiro
1 - 3
 		Marítimo 1
15:00
  Finalizado São João Ver
0 - 1
 		Leixões 0
16:00
  Finalizado Tocha
2 - 4
 		Rebordosa 0
16:00
  Finalizado Portosantense
2 - 4
 		Nacional 1
16:00
  Finalizado O Elvas
1 - 0
 		Lanheses UD 0
16:00
  Finalizado Ponte
0 - 5
 		Länk Vilaverdense 0
16:00
  Finalizado Louletano
0 - 1
 		AVS Futebol 5
18:00
  Finalizado Trofense
0 - 1
 		Pevidém 0

LIGAS / COMPETICIONES
Nombre Datos
LIGAS
es Primera División 7/38 Ayer
COMPETICIONES
ue Clasificación Eurocopa 11 gr En 15 días
wo Amistosos Selecciones 14/50 En 14 días
wo Amistosos Selecciones Su. 3/8 En 15 días
wo Amistosos Selecciones Fe. 62/70 Ayer
wo Amistosos Selecciones Su. 38/12 En 17 días
Publicidad 600x120.gif

PRENSA DEL DÍA

Ver toda la prensa de hoy
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  
7,316,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.4057
Total Execution Time  0.4066
  CADENA URL  
/livescore/dia/23092023
  GET DATOS  
$_GET['/livescore/dia/23092023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0112  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 > '2023-09-26 00:55:10' ORDER BY lm.creation_date DESC LIMIT 8
0.0112  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 > '2023-09-20 00:55:10' ORDER BY lm.creation_date DESC LIMIT 15
0.0340  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 = '2023-09-23' GROUP BY cat.location ORDER BY coefficient DESC
0.0218  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 = '2023-09-23' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 25
0.0217  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 >= '2023-09-23 00:00:00' AND c.shedule < '2023-09-23 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0229  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 calendars2024 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 (30301,30304,30289,30046,12673,12675,12676,12669,12671,103139,103147,103143,60811,60833,60814,60808,60825,75162,75163,75164,75167,75172,75169,70581,70592,4501,4502,4503,332,527222,527231,659613,659611,659630,193247,193358,193359,193235,193369,193230,193372,107615,58513,107612,58514,107610,58512,58515,107614,732692,807610,807611,807612,807613,603710,573333,573332,603713,603711,603708,42239,42236,42242,27702,27705,27706,27697,27698,27699,27700,27701,185497,185501,74770,74768,74769,74772,189495,189500,189493,189498,574840,501298,574844,574845,501296,501300,574837,501289,196534,196659,206303,197302,196517,197778,197169,196562,197185,196574,196675) AND c.shedule >= '2023-09-23 00:00:00' AND c.shedule < '2023-09-23 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0119  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 calendars2023 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 (30301,30304,30289,30046,12673,12675,12676,12669,12671,103139,103147,103143,60811,60833,60814,60808,60825,75162,75163,75164,75167,75172,75169,70581,70592,4501,4502,4503,332,527222,527231,659613,659611,659630,193247,193358,193359,193235,193369,193230,193372,107615,58513,107612,58514,107610,58512,58515,107614,732692,807610,807611,807612,807613,603710,573333,573332,603713,603711,603708,42239,42236,42242,27702,27705,27706,27697,27698,27699,27700,27701,185497,185501,74770,74768,74769,74772,189495,189500,189493,189498,574840,501298,574844,574845,501296,501300,574837,501289,196534,196659,206303,197302,196517,197778,197169,196562,197185,196574,196675) AND c.shedule >= '2023-09-23 00:00:00' AND c.shedule < '2023-09-23 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0228  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (143407094, 143407110, 143407114, 143407097, 143027802, 143027792, 143027797, 143027805, 143027809, 143640603, 143640613, 143640609, 143671799, 143671801, 143671803, 143671805, 143671807, 143028232, 143028235, 143028241, 143028230, 143028238, 143028245, 143348681, 143357294, 143357298, 143671848, 143671850, 143671824, 143671828, 143671832, 143671858, 143924999, 143924996, 143327267, 143327274, 143925006, 143327278, 143327283, 143925009, 143671055, 143671063, 143671050, 143671058, 143671067, 143671052, 143671061, 143671070, 143410781, 143410785, 143326336, 143326348, 143326357, 143326352, 143674192, 143674190, 143674195, 143674197, 144070446, 144070450, 144070435, 144102738, 144070441, 143939839, 143939843, 143682972, 143682979, 143682986, 143357133, 143729913, 143729922, 143729919, 143729917, 143357634, 143350878, 143357636, 143350883, 143357638, 143357640) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0828  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.0828  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.0828  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.0828  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.0828  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.0828  (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 calendars2024 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 >= '2023-09-23 00:00:00' AND c.shedule < '2023-09-23 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 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 >= '2023-09-23 00:00:00' AND c.shedule < '2023-09-23 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC