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

LIVESCORE / Partidos del Viernes, 05 Mayo 2023

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

Partidos Viernes, 05 Mayo 2023

España Alemania Austria Finlandia Rusia Rumania Holanda Argentina China Irlanda Escocia Colombia Polonia Suecia Portugal Georgia Dinamarca República Checa Suiza Egipto Bélgica Croacia Bulgaria Corea del Sur Reino Unido Australia Eslovaquia Bielorusia Italia Brasil Israel Islandia Islas Feroe Irán Marruecos Chile Iraq México Bangladesh Bosnia y Herzegovina Hungría Argelia Serbia Letonia Estonia Perú Grecia Kenya Kazakstán Arabia Saudita Uzbekistán Honduras Venezuela Gales Libia Noruega Paraguay Lituania Eslovenia Costa de Marfil Luxemburgo Azerbaiyán Bahrein Singapur Ucrania Nueva Zelanda Internacional Burkina Faso Barbados Ecuador Panamá Congo, República Democrática del Uganda Mozambique Sudán Guinea Zimbabwe Santo Tomé y Príncipe Tayikistán Djibouti Macao Togo Turkmenistán Swazilandia Nepal Surinam Seychelles Bhután
Bundesliga Bundesliga »
20:30
  Finalizado Mainz 05
2 - 3
 		Schalke 04 363
20:30
  Finalizado B. Leverkusen
1 - 2
 		Köln 472
Serie B Serie B »
20:30
  Finalizado Perugia
0 - 5
 		Cagliari 93
Eerste Divisie Eerste Divisie »
20:00
  Finalizado Helmond Sport
1 - 1
 		VVV Venlo 25
20:00
  Finalizado De Graafschap
2 - 1
 		MVV Maastricht 47
20:00
  Finalizado SC Telstar
0 - 0
 		Willem II 113
20:00
  Finalizado Dordrecht
1 - 3
 		Heracles 42
20:00
  Finalizado Roda JC
1 - 2
 		FC Eindhoven 38

LIGAS / COMPETICIONES

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

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
6,099,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.1106
Total Execution Time  0.1115
  CADENA URL  
/livescore/dia/05052023
  GET DATOS  
$_GET['/livescore/dia/05052023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0020  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-15 09:25:42' ORDER BY lm.creation_date DESC LIMIT 8
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 > '2024-04-09 09:25:42' ORDER BY lm.creation_date DESC LIMIT 15
0.0104  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-05' GROUP BY cat.location ORDER BY coefficient DESC
0.0103  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-05' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 25
0.0113  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-05 00:00:00' AND c.shedule < '2023-05-05 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0107  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 (50085,24295,24303,794268,794424,794388,794376,15280,96305,638734,638732,526702,544861,794483,794399,794459,794471,794495,794484,145802,807320,807321,807322,807323,24637,24638,823130,775711,775709,10054,42383,42384,42385,42386,42387,96554,88458,788020,656321,4965,4970,56727,23467,23468,23469,23470,23471,746227,746229,671030,671031,671032,671027,671029,671028,507031,310124,762431,573427,741569,741607,190507,62243,62237,62241,190508,115156,115160,115162,115465,115794,190503,190504,115787,115793,190505,53728,53725,589889,589890,589887,589888,677712,677714,347462,377592,347804,347807,347810,796022,34999,34998,35001,34997,348944,826837,826838,644684,644685,644686) AND c.shedule >= '2023-05-05 00:00:00' AND c.shedule < '2023-05-05 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0063  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (136738756, 136307645, 136307678, 136738735, 136738744, 136738749, 136738756, 135739978, 136682293, 136693234, 135580526, 136315261, 136315263, 136738790, 136738798, 136738807, 136738793, 136738810, 136738814, 136308293, 136694516, 136694513, 136694521, 136694519, 136307685, 136307683, 136685861, 136685863, 136311749, 136308428, 136308426, 136308435, 136308424, 136308431, 136682348, 136689192, 136311682, 137065184, 135655836, 135655839, 136681429, 136308734, 136308754, 136308731, 136308750, 136308742, 136312753, 136312750, 136312764, 136312758, 136312745, 136312767, 136312602, 136682521, 136682535, 136307675, 136311816, 136311820, 136308557, 136308552, 136308549, 136308569, 137095372, 137095368, 136321732, 136321729, 136321740) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0020  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.0021  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (1005961640, 1005961638, 1005961474, 1005961705, 1005961917, 1005961600, 1005961578, 1005961793, 1005961794, 1005961551, 1005961550, 1005961801) AND typeId=40 AND site='marca' ORDER BY eventId ASC
0.0123  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (1005961648, 1005961618, 1005961700, 1005962015, 1005960849, 1005961810, 1005961921, 1005961608, 1005961516, 1005961802, 1005961758, 1005960964) AND typeId=40 AND site='b888sport' ORDER BY eventId ASC
0.0123  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.0123  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.0123  (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-05 00:00:00' AND c.shedule < '2023-05-05 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-05 00:00:00' AND c.shedule < '2023-05-05 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC