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

LIVESCORE / Partidos de Mañana - Livescore

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 14 MAR

Partidos Jueves, 13 Marzo 2025

Competiciones Europeas Italia Brasil España Argentina Reino Unido Túnez Congo, República Democrática del Arabia Saudita Internacional Malta Iraq Bielorusia Uganda Nicaragua Irán Honduras Guatemala Estados Unidos Finlandia Eslovenia Libia Azerbaiyán Bosnia y Herzegovina Alemania Andorra Egipto Indonesia Jamaica Estonia Austria Serbia Armenia Zambia Macao
Europa League Europa League »
18:45
  en 1 día Olympiacos Olympiacos
18:45
 		FK Bodo Glimt FK Bodo Glimt 3
18:45
  en 1 día Lazio Lazio
18:45
 		Viktoria Plzeň Viktoria Plzeň 5
Televisión
18:45
  en 1 día Athletic Athletic
18:45
 		Roma Roma 69
Televisión
18:45
  en 1 día Eintracht Eintracht
18:45
 		Ajax Ajax 4
Televisión
21:00
  en 1 día Manchester United Manchester United
21:00
 		Real Sociedad Real Sociedad 12
21:00
  en 1 día Olympique Lyonnais Olympique Lyonnais
21:00
 		FCSB FCSB 4
21:00
  en 1 día Rangers Rangers
21:00
 		Fenerbahçe Fenerbahçe 4
Televisión
21:00
  en 1 día Tottenham Hotspur Tottenham Hotspur
21:00
 		AZ Alkmaar AZ Alkmaar 4
Conference League Conference League »
18:45
  en 1 día Cercle Brugge Cercle Brugge
18:45
 		Jagiellonia Jagiellonia 3
18:45
  en 1 día Djurgårdens IF Djurgårdens IF
18:45
 		Pafos Pafos 2
18:45
  en 1 día FC Lugano FC Lugano
18:45
 		Celje Celje 1
18:45
  en 1 día Rapid Wien Rapid Wien
18:45
 		Borac Banja Luka Borac Banja Luka 2
21:00
  en 1 día Vitória Vitória
21:00
 		Real Betis Real Betis 23
21:00
  en 1 día Legia Warszawa Legia Warszawa
21:00
 		Molde FK Molde FK 3
21:00
  en 1 día Fiorentina Fiorentina
21:00
 		Panathinaikos Panathinaikos 2
21:00
  en 1 día Chelsea Chelsea
21:00
 		Kobenhavn Kobenhavn 5
Copa Brasil Copa Brasil »
00:00
  en 21 h Maracanã Maracanã
00:00
 		Ceilândia Ceilândia 3
00:00
  en 21 h Capital Brasilia Capital Brasilia
00:00
 		Porto Velho Porto Velho 1
01:30
  en 22 h Ceará Ceará
01:30
 		Confiança Confiança 2
01:30
  en 22 h Atlético GO Atlético GO
01:30
 		Retro FC Retro FC 3
23:30
  en 1 día Athletico Athletico
23:30
 		Guarany de Bagé Guarany de Bagé 0
Serie C Grupo 1 Serie C Grupo 1 »
18:30
  en 1 día Giana Erminio Giana Erminio
18:30
 		Caldiero Terme Caldiero Terme 0
18:30
  en 1 día Virtus Verona Virtus Verona
18:30
 		Trento Trento 0
18:30
  en 1 día Pergolettese Pergolettese
18:30
 		Lumezzane Lumezzane 0
18:30
  en 1 día Renate Renate
18:30
 		Padova Padova 0
18:30
  en 1 día Feralpisalò Feralpisalò
18:30
 		Clodiense Clodiense 0
18:30
  en 1 día Pro Patria Pro Patria
18:30
 		Arzignano Arzignano 0
20:45
  en 1 día AlbinoLeffe AlbinoLeffe
20:45
 		Triestina Triestina 0
20:45
  en 1 día Pro Vercelli Pro Vercelli
20:45
 		Atalanta Sub 23 Atalanta Sub 23 0
20:45
  en 1 día Alcione Alcione
20:45
 		Lecco Lecco 0
20:45
  en 1 día Vicenza Vicenza
20:45
 		Novara Novara 0
League Two League Two »
21:00
  en 1 día Bromley Bromley
21:00
 		Walsall Walsall 0
Liga Saudí Liga Saudí »
20:00
  en 1 día Al-Ittihad Al-Ittihad
20:00
 		Al-Riyadh SC Al-Riyadh SC 0
20:00
  en 1 día Al-Shabab Al-Shabab
20:00
 		Al-Orubah FC Al-Orubah FC 0
20:00
  en 1 día Al-Fateh SC Al-Fateh SC
20:00
 		Al-Raed Al-Raed 0
Liga Tunecina Liga Tunecina »
14:00
  en 1 día Olympique Béja Olympique Béja
14:00
 		US Tataouine US Tataouine 0
14:00
  en 1 día Club Africain Club Africain
14:00
 		Stade Tunisien Stade Tunisien 0
14:00
  en 1 día Zarzis Zarzis
14:00
 		Monastir Monastir 0
14:00
  en 1 día EGS Gafsa EGS Gafsa
14:00
 		Etoile Metlaoui Etoile Metlaoui 0
Liga Kosovo Liga Kosovo »
14:00
  en 1 día Prishtina Prishtina
14:00
 		Dukagjini Dukagjini 0
14:00
  en 1 día FC Suhareka FC Suhareka
14:00
 		Feronikeli Feronikeli 0
Rondoniense Rondoniense »
00:30
  Aplazado Guaporé Guaporé
-
 		Porto Velho Porto Velho 0
21:00
  en 1 día Vilhena Vilhena
21:00
 		Gênus Gênus 0
Copa Nicaragua Copa Nicaragua »
13 Mar 25  Aplazado Sport Sébaco Sport Sébaco
-
 		Real Madriz Real Madriz 0
12:00
  Aplazado Real Estelí Real Estelí
-
 		FC Esteli FC Esteli 0
12:00
  Aplazado Walter Ferretti Walter Ferretti
-
 		CD Ocotal CD Ocotal 0
Liga Irán Liga Irán »
16:30
  en 1 día Nassaji Nassaji
16:30
 		Sepahan Esfahan Sepahan Esfahan 0
16:30
  en 1 día Havadar SC Havadar SC
16:30
 		Shams Azar Qazvin Shams Azar Qazvin 0
16:45
  en 1 día Kheybar Kheybar
16:45
 		Chadormalu Chadormalu 0
Liga Malta Grupo 4 Liga Malta Grupo 4 »
18:00
  en 1 día Naxxar Lions FC Naxxar Lions FC
18:00
 		Marsaxlokk FC Marsaxlokk FC 0
18:30
  en 1 día Hamrun Spartans Hamrun Spartans
18:30
 		Sliema Wanderers Sliema Wanderers 1
18:30
  en 1 día Mosta Mosta
18:30
 		Melita Melita 0
20:45
  en 1 día Hibernians Hibernians
20:45
 		Balzan FC Balzan FC 0
20:45
  en 1 día Zabbar Patrick Zabbar Patrick
20:45
 		Gzira United Gzira United 0

LIGAS / COMPETICIONES

Nombre Datos
Publicidad 600x120.gif

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
7,396,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.2687
Total Execution Time  0.2697
  CADENA URL  
/livescore/dia/13032025
  GET DATOS  
$_GET['/livescore/dia/13032025']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0107  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 > '2025-03-11 02:49:43' 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 > '2025-03-05 02:49:44' ORDER BY lm.creation_date DESC LIMIT 15
0.0124  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 = '2025-03-13' GROUP BY cat.location ORDER BY coefficient DESC
0.0123  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 = '2025-03-13' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0123  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 >= '2025-03-13 00:00:00' AND c.shedule < '2025-03-13 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0138  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 calendars2025 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 (270906,270910,270919,270920,270908,270912,270915,270916,273883,270960,270964,270954,270958,270956,270962,270966,270968,273581,241274,269763,274537,273895,273891,273889,270861,274646,266098,274647,39229,39231,39233,39226,39227,39228,39224,39225,39230,39232,14990,221472,221471,269048,268815,246179,269715,271059,17888,50131,50135,50130,264255,53977,150431,132539,132542,132544,132545,267802,267804,236355,279331,273870,78607,246457,246458,264319,236166,236168,185347,275359,275360,280202,136921,44304,136915,238541,238555,262414,262411,262412,262413,262415,265439,29728,276786,276782,276784,271685,271684,271686,3657,240755,240753,240756,240754,240757,241257,243342,243401,243424) AND c.shedule >= '2025-03-13 00:00:00' AND c.shedule < '2025-03-13 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0211  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.0211  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.0211  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.0211  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.0211  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.0211  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.0211  (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 calendars2026 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 >= '2025-03-13 00:00:00' AND c.shedule < '2025-03-13 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 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 >= '2025-03-13 00:00:00' AND c.shedule < '2025-03-13 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC