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

LIVESCORE / Partidos del Viernes, 22 Septiembre 2023

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 22 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 Viernes, 22 Septiembre 2023
Competiciones Europeas Alemania España Austria Rumania Francia Holanda Colombia Finlandia Reino Unido Italia Argentina Irlanda Brasil Polonia Israel Suecia Bulgaria Rusia Bélgica Arabia Saudita China Dinamarca Gales Turquía Uruguay Suiza República Checa Ucrania Serbia Chile Bielorusia México Portugal Georgia Croacia Indonesia Argelia Costa Rica Internacional Paraguay Honduras Albania Moldavia Lituania Estonia Uzbekistán Panamá Eslovaquia Bolivia Hungría Jordania Kazakstán Escocia Nicaragua Venezuela Bosnia y Herzegovina Chipre Eslovenia Armenia Uganda Ecuador Corea del Sur Grecia Líbano India Luxemburgo Siria Bahrein Perú Sudáfrica Malta Qatar Noruega Burkina Faso Islas Feroe Tailandia Ghana Mozambique Omán Burundi San Marino Yemen Liberia Mauritania Bhután Santo Tomé y Príncipe Islas Cook Islas Fiji Kirguistán Brunei Gibraltar
Serie A Serie A »
18:30
  Finalizado Salernitana
1 - 1
 		Frosinone 623
20:45
  Finalizado Lecce
1 - 0
 		Genoa 592
Ligue 1 Ligue 1 »
21:00
  Finalizado Monaco
0 - 1
 		Nice 1295
Liga de las Naciones de la UEFA Femenina Grupo 1 Liga de las Naciones de la UEFA Femenina Grupo 1 »
18:00
  Finalizado Dinamarca
2 - 0
 		Alemania 10
18:30
  Finalizado Suecia
2 - 3
 		España 658
19:00
  Finalizado Noruega
1 - 1
 		Austria 6
19:30
  Finalizado Suiza
0 - 1
 		Italia 14
20:00
  Finalizado Islandia
1 - 0
 		Gales 0
20:30
  Finalizado Bélgica
2 - 1
 		Países Bajos 12
20:45
  Finalizado Inglaterra
2 - 1
 		Escocia 8
21:10
  Finalizado Francia
2 - 0
 		Portugal 2
Liga de las Naciones de la UEFA Femenina Grupo 2 Liga de las Naciones de la UEFA Femenina Grupo 2 »
15:00
  Finalizado Ucrania
1 - 2
 		Serbia 18
16:00
  Finalizado Eslovenia
0 - 2
 		República Checa 4
17:00
  Finalizado Albania
1 - 1
 		Hungría 6
17:30
  Finalizado Finlandia
4 - 0
 		Eslovaquia 2
19:00
  Finalizado Grecia
1 - 3
 		Polonia 0
20:15
  Finalizado Croacia
2 - 1
 		Rumanía 1
21:00
  Finalizado Bielorrusia
1 - 2
 		Bosnia Herzegovina 3
Liga de las Naciones de la UEFA Femenina Grupo 3 Liga de las Naciones de la UEFA Femenina Grupo 3 »
15:00
  Finalizado Azerbaiyán
1 - 1
 		Chipre 6
15:00
  Finalizado Macedonia Norte
0 - 1
 		Bulgaria 5
15:30
  Finalizado Letonia
0 - 1
 		Malta 9
16:00
  Finalizado Lituania
0 - 2
 		Luxemburgo 11
16:00
  Finalizado Georgia
0 - 3
 		Turquía 34
17:00
  Finalizado Moldavia
1 - 2
 		Andorra 6
17:00
  Finalizado Estonia
0 - 0
 		Kazajistán 9
19:00
  Finalizado Islas Feroe
0 - 1
 		Montenegro 5
Liga Brasileña Liga Brasileña »
00:00
  Finalizado Vasco da Gama
5 - 1
 		Coritiba 132
00:30
  Finalizado Athletico
2 - 1
 		Internacional 369
02:30
  Finalizado Grêmio
1 - 0
 		Palmeiras 681
Serie B Serie B »
20:30
  Finalizado Palermo FC
0 - 1
 		Cosenza 137
Liga Bielorrusia Liga Bielorrusia »
16:30
  Finalizado Gomel
2 - 0
 		Minsk 4
18:30
  Finalizado BATE Borisov
2 - 1
 		Belshina Bobruisk 6

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  
6,756,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.1017
Total Execution Time  0.1027
  CADENA URL  
/livescore/dia/22092023
  GET DATOS  
$_GET['/livescore/dia/22092023']  
  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 > '2023-09-26 00:41:16' ORDER BY lm.creation_date DESC LIMIT 8
0.0018  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:41:16' ORDER BY lm.creation_date DESC LIMIT 15
0.0060  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-22' GROUP BY cat.location ORDER BY coefficient DESC
0.0059  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-22' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 25
0.0054  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-22 00:00:00' AND c.shedule < '2023-09-22 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0043  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 (30308,103146,103145,60816,75175,70574,336,425,428,422,424,338,423,333,421,427,334,248,250,247,337,426,251,249,335,245,244,339,246,527212,527210,659619,659620,659612,659616,58511,107613,732697,732689,732695,807608,807609,27695,189496,145513,444918,444925,457676,75494,75492,33806,58301,58299,111584,13235,13236,13234,746329,746328,10961,11150,574975,577086,577090,109552,109553,19189,19190,644446,36353,57916,57918,57919,57920,57924,57915,57917,889304,889319,889320,889321,704314,704316,573563,573565,452810,126110,168164,168165,168166,168167,168168,168161,168162,168163,744938,590142,590143,590144,590145) AND c.shedule >= '2023-09-22 00:00:00' AND c.shedule < '2023-09-22 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0031  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 (30308,103146,103145,60816,75175,70574,336,425,428,422,424,338,423,333,421,427,334,248,250,247,337,426,251,249,335,245,244,339,246,527212,527210,659619,659620,659612,659616,58511,107613,732697,732689,732695,807608,807609,27695,189496,145513,444918,444925,457676,75494,75492,33806,58301,58299,111584,13235,13236,13234,746329,746328,10961,11150,574975,577086,577090,109552,109553,19189,19190,644446,36353,57916,57918,57919,57920,57924,57915,57917,889304,889319,889320,889321,704314,704316,573563,573565,452810,126110,168164,168165,168166,168167,168168,168161,168162,168163,744938,590142,590143,590144,590145) AND c.shedule >= '2023-09-22 00:00:00' AND c.shedule < '2023-09-22 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0043  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (143407092, 143640594, 143640601, 143671797, 143028227, 143348679, 143327264, 143924989, 143674188, 143671892, 143028263, 143028259, 143349010, 143674629, 143674633, 143461795, 143461802, 143461807, 143350381, 143350748, 143350520, 143350522, 142971017, 143674003, 143674010, 143674007, 143674012, 143671611, 143387341, 143387337, 143357776, 143682947, 143682961, 143682968, 143357139, 143357129, 143357131, 143729910, 143729907, 143643603, 143643653, 143643649, 143643660, 143674830, 143674834, 143349035, 143349033, 143349041, 143349037) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0103  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.0103  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.0103  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.0103  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.0103  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.0103  (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-22 00:00:00' AND c.shedule < '2023-09-22 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-22 00:00:00' AND c.shedule < '2023-09-22 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC