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

LIVESCORE / Partidos del Miércoles, 15 Mayo 2024

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 15 MAY

Partidos Miércoles, 15 Mayo 2024

España Reino Unido Argentina Grecia Japón Polonia Rusia Escocia Alemania Suecia Francia Bosnia y Herzegovina Bulgaria Ghana Georgia Dinamarca Kenya Suiza Italia Corea del Sur Estados Unidos Emiratos Árabes Egipto China Brasil Jordania Letonia Rumania Hong Kong Arabia Saudita Croacia Hungría Ucrania Armenia Ecuador Vietnam Finlandia Kuwait República Checa Congo, República Democrática del Iraq Noruega Turkmenistán Somalia Tayikistán Kirguistán Islandia Omán
Primera División Primera División »
19:30
  en 15 días Rayo Vallecano Rayo Vallecano
19:30
 		Granada Granada 2
19:30
  en 15 días Sevilla Sevilla
19:30
 		Cádiz Cádiz 3
22:00
  en 15 días Celta Celta
22:00
 		Athletic Athletic 4
22:00
  en 15 días Getafe Getafe
22:00
 		Atlético Atlético 3
Ligue 1 Ligue 1 »
21:00
  en 15 días Nice Nice
21:00
 		PSG PSG 1
21:00
  en 15 días Stade de Reims Stade de Reims
21:00
 		Olympique Olympique 1
Coppa Italia Coppa Italia »
21:00
  en 15 días Atalanta Atalanta
21:00
 		Juventus Juventus 9
Liga Sueca Liga Sueca »
19:00
  en 15 días Halmstads Halmstads
19:00
 		Häcken Häcken 1
19:00
  en 15 días Mjällby AIF Mjällby AIF
19:00
 		Hammarby IF Hammarby IF 1
19:00
  en 15 días IF Elfsborg IF Elfsborg
19:00
 		AIK Solna AIK Solna 1
19:00
  en 15 días Västerås SK Västerås SK
19:00
 		IFK Varnamo IFK Varnamo 1
Liga Escocia Grupo 3 Liga Escocia Grupo 3 »
20:45
  en 15 días St. Johnstone St. Johnstone
20:45
 		Ross County FC Ross County FC 0
20:45
  en 15 días Aberdeen Aberdeen
20:45
 		Livingston Livingston 0
20:45
  en 15 días Hibernian FC Hibernian FC
20:45
 		Motherwell Motherwell 0
Liga Japonesa J1 Liga Japonesa J1 »
12:00
  en 15 días Vissel Kobe Vissel Kobe
12:00
 		Avispa Fukuoka Avispa Fukuoka 1
12:00
  en 15 días Consadole Sapporo Consadole Sapporo
12:00
 		Júbilo Iwata Júbilo Iwata 1
12:00
  en 15 días Nagoya Grampus Nagoya Grampus
12:00
 		FC Tokyo FC Tokyo 1
12:00
  en 15 días Tokyo Verdy Tokyo Verdy
12:00
 		Gamba Osaka Gamba Osaka 2
12:00
  en 15 días Kashiwa Reysol Kashiwa Reysol
12:00
 		Shonan Bellmare Shonan Bellmare 1
12:00
  en 15 días Sagan Tosu Sagan Tosu
12:00
 		Kawasaki Frontale Kawasaki Frontale 1
12:00
  en 15 días Albirex Niigata Albirex Niigata
12:00
 		Yokohama Marinos Yokohama Marinos 1
12:00
  en 15 días Machida Zelvia Machida Zelvia
12:00
 		Cerezo Osaka Cerezo Osaka 1
12:00
  en 15 días Sanfrecce Sanfrecce
12:00
 		Kashima Antlers Kashima Antlers 1
12:30
  en 15 días Urawa Reds Urawa Reds
12:30
 		Kyoto Sanga Kyoto Sanga 1
Superliga Danesa Grupo 3 Superliga Danesa Grupo 3 »
18:00
  en 15 días Vejle BK Vejle BK
18:00
 		Lyngby BK Lyngby BK 0
18:00
  en 15 días Randers Randers
18:00
 		Viborg FF Viborg FF 0
Segunda Grecia Grupo 3 Segunda Grecia Grupo 3 »
15:00
  en 15 días Kalamata FC Kalamata FC
15:00
 		Ionikos Nikea Ionikos Nikea 0
15:00
  en 15 días AEK Athens B AEK Athens B
15:00
 		Niki Volos Niki Volos 0
15:00
  en 15 días Chania Chania
15:00
 		Ilioupoli Ilioupoli 0
15:00
  en 15 días AE Larisa AE Larisa
15:00
 		Makedonikos Makedonikos 0
Segunda Grecia Grupo 4 Segunda Grecia Grupo 4 »
15:00
  en 15 días Kampaniakos Kampaniakos
15:00
 		Kozani FC Kozani FC 0
15:00
  en 15 días Diagoras Diagoras
15:00
 		Egaleo Egaleo 0
15:00
  en 15 días Anagennisi Anagennisi
15:00
 		Aiolikos Aiolikos 0
15:00
  en 15 días Olympiacos Piraeus Olympiacos Piraeus
15:00
 		Giouchtas Giouchtas 0
15:00
  en 15 días PAOK B PAOK B
15:00
 		Iraklis Iraklis 0
15:00
  en 15 días Panathinaikos B Panathinaikos B
15:00
 		Panachaiki Panachaiki 0
Liga Emiratos Liga Emiratos »
16:10
  en 15 días Baniyas Baniyas
16:10
 		Al Bataeh Al Bataeh 0
16:10
  en 15 días Sharjah FC Sharjah FC
16:10
 		Hatta Club Hatta Club 0
19:00
  en 15 días Ajman Ajman
19:00
 		Al-Jazira Al-Jazira 0
Segunda A Rusia Grupo 3 Segunda A Rusia Grupo 3 »
17:00
  en 15 días FC Chelyabinsk FC Chelyabinsk
17:00
 		FK Novosibirsk FK Novosibirsk 1
17:00
  en 15 días Rotor Volgograd Rotor Volgograd
17:00
 		FC Krasnodar II FC Krasnodar II 1
17:00
  en 15 días Chayka Chayka
17:00
 		Metallurg Lipetsk Metallurg Lipetsk 1
17:00
  en 15 días Ufa Ufa
17:00
 		Murom Murom 1

LIGAS / COMPETICIONES

Nombre Datos
LIGAS
es Primera División 33/38 Ayer
COMPETICIONES
wo Amistosos Selecciones 73/84 En 31 días
es Copa de la Reina 7/7 En 18 días
Publicidad 600x120.gif

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
6,254,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.2450
Total Execution Time  0.2459
  CADENA URL  
/livescore/dia/15052024
  GET DATOS  
$_GET['/livescore/dia/15052024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
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 > '2024-04-28 23:41:29' 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 > '2024-04-22 23:41:29' ORDER BY lm.creation_date DESC LIMIT 15
0.0125  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 = '2024-05-15' GROUP BY cat.location ORDER BY coefficient DESC
0.0128  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 = '2024-05-15' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0122  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 >= '2024-05-15 00:00:00' AND c.shedule < '2024-05-15 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0135  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 (30595,30599,30593,30596,12949,12954,70821,70824,728833,717682,717718,717659,717731,717695,717803,717743,717791,717802,717779,709870,709871,709872,646224,690969,727590,644601,644604,644606,644600,727360,727361,727374,727375,727376,727855,727872,679351,679352,679354,679345,679346,679347,679348,679349,679350,679353,728071,718053,718054,718023,723971,724512,728955,722255,722256,718146,718147,718148,718149,722251,722252,722253,722254,37090,37092,37086,645378,26218,716125,700801,708487,708315,708488,708316,708489,708317,708558,708318,708559,708404,708560,708405,708561,708406,720002,708407,708408,708486,675241,675242,727715,672053,700604,700605,700606,700607,700518,700519,700520,700521) AND c.shedule >= '2024-05-15 00:00:00' AND c.shedule < '2024-05-15 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0142  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0142  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.0142  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.0142  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.0142  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.0142  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.0142  (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 calendars2025 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 >= '2024-05-15 00:00:00' AND c.shedule < '2024-05-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 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 >= '2024-05-15 00:00:00' AND c.shedule < '2024-05-15 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC