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

LIVESCORE / Partidos de Hoy - Livescore - Mejores ligas

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 29 ABR

Partidos Sábado, 27 Abril 2024

España Reino Unido Alemania Italia Portugal Brasil Francia Colombia Competiciones Europeas México
Primera División Primera División »
14:00
  en 5 h Las Palmas
14:00
 		Girona 53
16:15
  en 7 h Almería
16:15
 		Getafe 42
18:30
  en 9 h Deportivo Alavés
18:30
 		Celta 56
21:00
  en 12 h Atlético
21:00
 		Athletic 175
Premier League Premier League »
13:30
  en 4 h West Ham
13:30
 		Liverpool 88
16:00
  en 7 h Wolves
16:00
 		Luton Town 24
16:00
  en 7 h Newcastle
16:00
 		Sheffield United 29
16:00
  en 7 h Fulham
16:00
 		Crystal Palace 35
16:00
  en 7 h Manchester United
16:00
 		Burnley 47
18:30
  en 9 h Everton
18:30
 		Brentford 24
21:00
  en 12 h Aston Villa
21:00
 		Chelsea 42
Serie A Serie A »
15:00
  en 6 h Lecce
15:00
 		AC Monza 17
18:00
  en 9 h Juventus
18:00
 		Milan 33
20:45
  en 12 h Lazio
20:45
 		Hellas Verona 13
Ligue 1 Ligue 1 »
21:00
  en 12 h PSG
21:00
 		Le Havre 35
Liga Portuguesa Liga Portuguesa »
16:30
  en 7 h Casa Pia AC
16:30
 		Chaves 1
16:30
  en 7 h Vizela
16:30
 		Rio Ave 1
19:00
  en 10 h Benfica
19:00
 		Sporting Braga 4
21:30
  en 12 h Vitória
21:30
 		Boavista 1

LIGAS / COMPETICIONES

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

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
6,492,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Livescore / Index )  0.4409
Total Execution Time  0.4420
  CADENA URL  
/livescore/zona/top_ligas/dia/hoy
  GET DATOS  
$_GET['/livescore/zona/top_ligas/dia/hoy']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0190  SELECT z.name,z.alias,c.CountryCode,SUM(c.coefficient) as cuenta FROM categories c INNER JOIN leagues l ON l.categoryId = c.id INNER JOIN zones z ON z.location = c.CountryCode WHERE c.top = 1 AND c.troncal = 1 AND c.active_year = l.year AND l.total_num_matchs = l.total_num_matchsR GROUP BY c.CountryCode ORDER BY cuenta DESC LIMIT 30
0.0126  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.top = 1 AND lm.creation_date > '2024-04-26 08:30:55' ORDER BY lm.creation_date DESC LIMIT 8
0.0126  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.top = 1 AND lm.creation_date > '2024-04-20 08:30:55' ORDER BY lm.creation_date DESC LIMIT 15
0.0414  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 cat.top = '1' AND c.date = '2024-04-27' GROUP BY cat.location ORDER BY coefficient DESC
0.0197  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 cat.top = '1' AND c.date = '2024-04-27' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0241  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.top = '1' AND cat.ctype IN (1,3,12,34,36) AND c.shedule >= '2024-04-27 00:00:00' AND c.shedule < '2024-04-27 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0271  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.top = '1' AND cat.ctype IN (1,3,12,34,36) AND c.id IN (30570,30569,30565,30563,12966,12961,12962,12963,12967,12960,12958,103438,103435,103436,61177,61169,61162,75399,75400,75404,75397,75406,70799,193272,193264,193267,193259,193256,193261,193363,193255,107836,107843,107835,107842,706704,706698,721423,426461,426470,426455,426473,728312,728313,433832,434313,434807,434924,434925,434926,434927,434928,434929,434930,434923,433830,434449,435170,434805,433833,434308,434808,433834,434309,434810,434187,434310,435157,434188,434311,435162,434189,434312,435166,434190,434444,435168,434191,434446,433827,435173,434192,434447,433828,470299,434193,458275,433829,434194,434804,433831,434307,434314,454041,497342,488817,488819,488822,488824,567067) AND c.shedule >= '2024-04-27 00:00:00' AND c.shedule < '2024-04-27 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0137  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (153577942, 153577905, 153577910, 153577913, 153577824, 153577838, 153577835, 153577827, 153577831, 153577840, 153577842, 154053146, 154053139, 154053143, 154139295, 154139303, 154139308, 153577878, 153577884, 153577875, 153577881, 153577887, 153577947, 153577998, 153578000, 153578002, 153578005, 154149820, 154149828) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0646  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.0646  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.0646  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.0646  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.0646  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.0646  (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 cat.top = '1' AND c.shedule >= '2024-04-27 00:00:00' AND c.shedule < '2024-04-27 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 cat.top = '1' AND c.shedule >= '2024-04-27 00:00:00' AND c.shedule < '2024-04-27 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC