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

LIVESCORE / Partidos del Jueves, 21 Septiembre 2023

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 21 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 Jueves, 21 Septiembre 2023
Competiciones Europeas Estados Unidos Argentina Italia Colombia Brasil Uruguay México España Arabia Saudita Israel Rusia Costa Rica Perú Finlandia Georgia Guatemala Bolivia El Salvador Egipto Eslovenia Rumania Canadá Kazakstán Paraguay Chile Internacional Jordania Honduras Reino Unido Noruega Marruecos Azerbaiyán Panamá Irán India Túnez Serbia Tanzania Nicaragua Holanda Qatar Armenia Bahrein Malawi Ecuador Austria Uganda Bhután Yemen
Europa League Grupo 5 Europa League Grupo 5 »
18:45
  Finalizado LASK
1 - 3
 		Liverpool 898
18:45
  Finalizado Union
1 - 1
 		Toulouse 432
Europa League Grupo 7 Europa League Grupo 7 »
18:45
  Finalizado Servette
0 - 2
 		Slavia Praha 89
18:45
  Finalizado Sheriff
1 - 2
 		Roma 433
Liga Brasileña Liga Brasileña »
00:00
  Finalizado Goiás EC
0 - 0
 		Flamengo 690
02:30
  Finalizado Fluminense
1 - 0
 		Cruzeiro 352
02:30
  Finalizado São Paulo
1 - 2
 		Fortaleza EC 428
MLS - Liga USA MLS - Liga USA »
01:30
  Finalizado Charlotte FC
2 - 2
 		Philadelphia Union 62
01:30
  Finalizado Inter Miami
4 - 0
 		Toronto FC 657
01:30
  Finalizado New York City
2 - 0
 		Orlando City 112
01:30
  Finalizado DC United
1 - 1
 		Atlanta United 111
01:30
  Finalizado New York RB
1 - 1
 		Austin FC 69
01:30
  Finalizado Columbus Crew
3 - 0
 		Chicago Fire 19
01:30
  Finalizado CF Montréal
1 - 1
 		Cincinnati 174
02:30
  Finalizado Sporting Kansas C.
0 - 3
 		Nashville SC 26
02:30
  Finalizado Houston Dynamo
4 - 1
 		Vancouver 50
02:30
  Finalizado St. Louis City
0 - 0
 		Los Angeles FC 93
03:30
  Finalizado Colorado Rapids
1 - 2
 		Seattle Sounders 46
03:30
  Finalizado Real Salt Lake
1 - 3
 		FC Dallas 45
04:30
  Finalizado Portland Timbers
2 - 1
 		Jose Earthquakes 58
04:30
  Finalizado LA Galaxy
4 - 3
 		Minnesota United 171
Liga Rumana Liga Rumana »
19:00
  Finalizado Hermannstadt
2 - 2
 		FCSB 15

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,930,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.2826
Total Execution Time  0.2835
  CADENA URL  
/livescore/dia/21092023
  GET DATOS  
$_GET['/livescore/dia/21092023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0107  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:28:49' ORDER BY lm.creation_date DESC LIMIT 8
0.0106  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:28:49' ORDER BY lm.creation_date DESC LIMIT 15
0.0134  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-21' GROUP BY cat.location ORDER BY coefficient DESC
0.0123  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-21' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 25
0.0125  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-21 00:00:00' AND c.shedule < '2023-09-21 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0126  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 (555801,555803,555805,555807,555808,555795,555797,555799,555787,555788,555789,555790,555791,555792,555793,555786,555969,555970,555972,555961,555962,555963,555965,555966,555956,555957,555959,555950,555952,555953,555955,4445,545815,527219,527217,527218,659617,659618,659614,732694,732693,732696,586205,586206,586207,586208,586202,586203,586204,586209,586210,586211,586212,586213,586214,586215,127306,58262,111583,111582,704032,853211,574973,574974,577087,547686,577083,628719,628517,628720,628722,628721,482724,482725,482726,482732,552878,482727,482728,482729,482730,482731,704286,13454,13456,650262,650239,19561,19557,19559,748919,748756,765343,177545,177550,177552,177546,177549,872166,577332) AND c.shedule >= '2023-09-21 00:00:00' AND c.shedule < '2023-09-21 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
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 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 (555801,555803,555805,555807,555808,555795,555797,555799,555787,555788,555789,555790,555791,555792,555793,555786,555969,555970,555972,555961,555962,555963,555965,555966,555956,555957,555959,555950,555952,555953,555955,4445,545815,527219,527217,527218,659617,659618,659614,732694,732693,732696,586205,586206,586207,586208,586202,586203,586204,586209,586210,586211,586212,586213,586214,586215,127306,58262,111583,111582,704032,853211,574973,574974,577087,547686,577083,628719,628517,628720,628722,628721,482724,482725,482726,482732,552878,482727,482728,482729,482730,482731,704286,13454,13456,650262,650239,19561,19557,19559,748919,748756,765343,177545,177550,177552,177546,177549,872166,577332) AND c.shedule >= '2023-09-21 00:00:00' AND c.shedule < '2023-09-21 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0223  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (143278886, 143278896, 143278914, 143278892, 143278900, 143278880, 143278889, 143278908, 143278919, 143278927, 143278935, 143278922, 143278931, 143278937, 143278925, 143278933, 143467765, 143467775, 143467773, 143467779, 143467760, 143467767, 143467719, 143467788, 143467794, 143467781, 143467790, 143467796, 143467783, 143467792, 139609939, 143674626, 143357891, 143357900, 143683072, 143730160, 143730157, 143730162, 143730167, 143730170, 143973171, 143387344, 143387371, 143387362, 143387365, 143357765, 143357772, 143357122, 143357125, 143357127, 143327767, 143328061, 143328071, 143328059, 143328067, 143328056, 143328064, 143328079, 143328076, 143328084, 143328088, 143328304, 143328317, 143328309, 142752722) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0167  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.0167  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.0167  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.0167  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.0167  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.0167  (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-21 00:00:00' AND c.shedule < '2023-09-21 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-21 00:00:00' AND c.shedule < '2023-09-21 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC