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

LIVESCORE / Resultados de Fútbol en Directo - Mejores ligas

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

Partidos Domingo, 28 Abril 2024

España Reino Unido Francia Italia Holanda Brasil Alemania Portugal Argentina México Competiciones Europeas Colombia
Primera División Primera División »
14:00
  en 5 h Cádiz
14:00
 		Mallorca 88
16:15
  en 8 h Granada
16:15
 		Osasuna 30
18:30
  en 10 h Villarreal
18:30
 		Rayo Vallecano 22
21:00
  en 12 h Real Betis
21:00
 		Sevilla 281
Serie A Serie A »
12:30
  en 4 h Inter
12:30
 		Torino 30
15:00
  en 6 h Bologna
15:00
 		Udinese 26
18:00
  en 9 h Atalanta
18:00
 		Empoli 16
18:00
  en 9 h Napoli
18:00
 		Roma 23
20:45
  en 12 h Fiorentina
20:45
 		Sassuolo 19
Segunda División Segunda División »
14:00
  en 5 h Real Sporting
14:00
 		Villarreal B 42
16:15
  en 8 h Real Oviedo
16:15
 		Tenerife 53
16:15
  en 8 h Alcorcón
16:15
 		Eldense 49
18:30
  en 10 h Real Valladolid
18:30
 		Huesca 57
18:30
  en 10 h Levante
18:30
 		FC Cartagena 89
21:00
  en 12 h Albacete
21:00
 		Eibar 71
Ligue 1 Ligue 1 »
13:00
  en 4 h Metz
13:00
 		Lille 10
15:00
  en 6 h Clermont
15:00
 		Stade de Reims 3
15:00
  en 6 h Strasbourg
15:00
 		Nice 3
15:00
  en 6 h Lorient
15:00
 		Toulouse 4
17:05
  en 8 h Stade Rennais
17:05
 		Stade Brestois 5
19:00
  en 10 h Olympique Lyonnais
19:00
 		Monaco 19
21:00
  en 12 h Olympique
21:00
 		Lens 4
Liga Brasileña Liga Brasileña »
02:00
  Finalizado Bahía
1 - 0
 		Grêmio 259
16:00
  en 7 h Flamengo
16:00
 		Botafogo 8
21:00
  en 12 h Cruzeiro
21:00
 		Vitória 4
21:00
  en 12 h Corinthians
21:00
 		Fluminense 9
23:30
  en 15 h Fortaleza EC
23:30
 		RB Bragantino 3
23:30
  en 15 h EC Juventude
23:30
 		Athletico 3

LIGAS / COMPETICIONES

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

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
6,688,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.1732
Total Execution Time  0.1741
  CADENA URL  
/livescore/zona/top_ligas
  GET DATOS  
$_GET['/livescore/zona/top_ligas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0127  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.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.top = 1 AND lm.creation_date > '2024-04-27 08:09:00' 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.top = 1 AND lm.creation_date > '2024-04-21 08:09:00' ORDER BY lm.creation_date DESC LIMIT 15
0.0103  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-28' GROUP BY cat.location ORDER BY coefficient DESC
0.0113  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-28' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0166  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-28 00:00:00' AND c.shedule < '2024-04-28 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0060  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 (30564,30567,30571,29271,12959,12965,12964,103432,103431,103430,103437,103429,61175,61155,61172,61179,61182,61154,75398,75401,75409,70811,70801,70806,70809,70802,70808,70804,193266,193338,193351,193355,193276,193341,193343,193370,193347,193274,193360,193367,728095,58739,58740,58741,58742,107841,58743,107837,107839,197480,196893,198011,197113,197482,196897,198017,197115,197740,196901,198020,197118,197748,196905,198024,197456,197755,196908,198028,197461,197761,197098,198029,197464,197765,197100,198030,197468,196881,197769,197103,198031,197470,196884,197771,197105,206332,197474,196888,197774,197107,197477,196890,197777,197110,706695,706700,706696,706697,706699,706701) AND c.shedule >= '2024-04-28 00:00:00' AND c.shedule < '2024-04-28 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0031  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (153577921, 153577933, 153577938, 153577940, 153577858, 153577849, 153577868, 154053137, 154053114, 154053109, 154053149, 154053123, 154139311, 154139316, 154139313, 154139321, 154139319, 154139324, 153577890, 153577893, 153577898, 153577949, 153577957, 153577951, 153577954, 153577962, 153577964, 154448272, 153577968, 153577987, 153577975, 153578007, 153577993, 153578009, 153578011, 154139319, 153790915, 154149830, 154149833, 154149836, 154149840, 154149846, 154149855) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0223  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.0223  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.0223  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.0223  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.0223  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.0223  (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-28 00:00:00' AND c.shedule < '2024-04-28 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-28 00:00:00' AND c.shedule < '2024-04-28 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC