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

LIVESCORE / Partidos del Martes, 09 Mayo 2023

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 9 MAY
Argentina Portugal Italia Chile Japón Uruguay Estados Unidos Irlanda Bielorusia Hungría Francia Bolivia India Haití Tuvalu Azerbaiyán

Partidos Martes, 09 Mayo 2023

Argentina Brasil China Chile Colombia Competiciones Europeas Alemania Suecia Finlandia Macedonia Georgia Austria Corea del Sur Arabia Saudita Uzbekistán España Lituania Uruguay Letonia Egipto Argelia República Checa Serbia Reino Unido Kazakstán Internacional Paraguay Armenia Bolivia Islas Feroe Holanda Azerbaiyán Ecuador Noruega Chipre Etiopía Escocia Qatar Uganda Perú Kuwait Malí Rusia Bangladesh Bielorusia Bahrein Congo, República Democrática del Mauritania Nepal Seychelles Aruba Santo Tomé y Príncipe Maldivas Siria Bhután
Liga Finlandia Grupo 1 Liga Finlandia Grupo 1 »
17:00
  Finalizado FC Honka
0 - 2
 		FC Haka 53
17:00
  Finalizado FC KTP
3 - 3
 		HJK Helsinki 27
17:00
  Finalizado AC Oulu
0 - 2
 		KuPS Kuopio 30
K League 1 Grupo 1 K League 1 Grupo 1 »
12:00
  Finalizado Ulsan HD FC
1 - 0
 		Gangwon FC 34
12:30
  Finalizado FC Seoul
3 - 1
 		Gwangju FC 7
12:30
  Finalizado Daegu FC
1 - 1
 		Pohang Steelers 13
Liga Saudí Liga Saudí »
18:00
  Finalizado Al-Fayha
3 - 0
 		Al-Fateh SC 35
18:00
  Finalizado Al-Taawoun
2 - 1
 		Al-Raed 68
Liga Letonia Liga Letonia »
16:00
  Finalizado FK Tukums 2000
1 - 7
 		FK RFS 12
17:00
  Finalizado FS Jelgava
2 - 3
 		FK Metta 33
Copa Uzbekistán Grupo 2 Copa Uzbekistán Grupo 2 »
14:00
  Finalizado FK Yangiyer
0 - 1
 		Buxoro 0
16:00
  Finalizado FK Turon
5 - 2
 		Shurtan 0
Liga Egipto Liga Egipto »
18:00
  Finalizado Pyramids
3 - 1
 		Ismaily 34
Copa de Lituania Copa de Lituania »
17:00
  Finalizado FK Šilutė
0 - 5
 		Dziugas Telsiai 0
17:00
  Finalizado Atmosfera
0 - 4
 		FC Hegelmann 1
17:45
  Finalizado FKS Ukmergė
0 - 3
 		Sūduva 0
Segunda Macedonia del Norte Segunda Macedonia del Norte »
17:00
  Finalizado Gostivar
4 - 0
 		FK Borec 0
17:00
  Finalizado Teteks
4 - 2
 		Kozuv Gevgelija 0
17:00
  Finalizado Voska Sport
5 - 3
 		Detonit 0
17:00
  Finalizado Vardar Skopje
1 - 1
 		Pelister 0
17:00
  Finalizado Sasa
2 - 1
 		Lokomotiva Skopje 0
17:00
  Finalizado Sloga Vinica
3 - 0
 		FK Ohrid 0
17:00
  Finalizado KF Besa
1 - 0
 		Karaorman Struga 0
17:00
  Finalizado Belasica
0 - 1
 		Aresimi 0
Segunda Uzbekistán Segunda Uzbekistán »
13:30
  Finalizado Mash' al
3 - 0
 		Andijon 0
15:00
  Finalizado Gijduvon
1 - 0
 		Aral Nukus 0
Cuarta Austria Grupo 4 Cuarta Austria Grupo 4 »
19:00
  Finalizado Liezen
0 - 0
 		Frauental 0
19:00
  Finalizado Wildon
2 - 0
 		Köflach 0
19:00
  Finalizado SC Bruck
2 - 1
 		Judenburg 1
19:00
  Finalizado Voitsberg
2 - 1
 		Mettersdorf 0
19:00
  Finalizado Union Gamlitz
2 - 1
 		TUS Heiligenkreuz 1
19:00
  Finalizado Ilzer SV
1 - 0
 		SV Union Gnas 0
19:00
  Finalizado Lafnitz II
3 - 0
 		Fehring 0
19:00
  Finalizado SC Fürstenfeld
3 - 4
 		Lebring 0

LIGAS / COMPETICIONES

Nombre Datos
LIGAS
es Primera División 33/38 Mañana
COMPETICIONES
wo Amistosos Selecciones 73/84 En 36 días
es Copa de la Reina 7/7 En 22 días
Publicidad 600x120.gif

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
6,344,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.0972
Total Execution Time  0.0981
  CADENA URL  
/livescore/dia/09052023
  GET DATOS  
$_GET['/livescore/dia/09052023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
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 > '2024-04-24 14:34:18' 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 > '2024-04-18 14:34:18' ORDER BY lm.creation_date DESC LIMIT 15
0.0053  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-05-09' GROUP BY cat.location ORDER BY coefficient DESC
0.0034  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-05-09' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0052  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-05-09 00:00:00' AND c.shedule < '2023-05-09 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0112  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 (817130,638772,638767,526709,544848,732281,807328,807329,807330,603623,573199,573202,715509,656937,671034,671035,671033,736961,644324,632109,657352,573431,677715,644692,644690,644691,578145,578148,757980,740976,740977,150739,782081,782082,594055,762926,762929,820583,742061,742062,742065,742063,743882,743886,810626,517162,855573,855589,865124,859551,854482,854483,854484,524589,524598,812795,812796,826844,823620,823627,823624,581849,503625,790905,790916,730904,730905,828020,827063,828019,328732,328733,328734,328735,328736,328737,328738,328739,903030,605812,812512,812515,625955,625957,782130,782129,691566,568885,167518,167519,167520,167521,167522,167523,167524,167517,169514,821038,812971,545495) AND c.shedule >= '2023-05-09 00:00:00' AND c.shedule < '2023-05-09 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0029  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 (817130,638772,638767,526709,544848,732281,807328,807329,807330,603623,573199,573202,715509,656937,671034,671035,671033,736961,644324,632109,657352,573431,677715,644692,644690,644691,578145,578148,757980,740976,740977,150739,782081,782082,594055,762926,762929,820583,742061,742062,742065,742063,743882,743886,810626,517162,855573,855589,865124,859551,854482,854483,854484,524589,524598,812795,812796,826844,823620,823627,823624,581849,503625,790905,790916,730904,730905,828020,827063,828019,328732,328733,328734,328735,328736,328737,328738,328739,903030,605812,812512,812515,625955,625957,782130,782129,691566,568885,167518,167519,167520,167521,167522,167523,167524,167517,169514,821038,812971,545495) AND c.shedule >= '2023-05-09 00:00:00' AND c.shedule < '2023-05-09 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0024  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (136407576, 136693272, 136693274, 136315295, 136315300, 136692495, 136694535, 136694540, 136694537, 137066018, 136312594, 136312596, 137066557, 137065173, 136312776, 136312773, 136312778, 136315464, 136312642, 136321764, 136321771, 136321768, 136694928, 136694931, 136693314, 137066480) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0019  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.0019  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (1005961313, 1005961984, 1005961987, 1005962031, 1005962292) AND typeId=40 AND site='marca' ORDER BY eventId ASC
0.0075  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (1005961312, 1005962076, 1005961995, 1005961996, 1005962017, 1005962016, 1005962304) AND typeId=40 AND site='b888sport' ORDER BY eventId ASC
0.0075  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.0075  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.0075  (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-05-09 00:00:00' AND c.shedule < '2023-05-09 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-05-09 00:00:00' AND c.shedule < '2023-05-09 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC