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

LIVESCORE / Partidos del Viernes, 21 Marzo 2025

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

Partidos Viernes, 21 Marzo 2025

Internacional España Alemania Francia Austria Estados Unidos Competiciones Europeas Australia Gales Argelia México Israel Argentina República Checa Polonia Irlanda Finlandia Chile Uruguay Bélgica Colombia Dinamarca Escocia Emiratos Árabes Eslovaquia Jamaica Croacia Eslovenia Ghana Barbados Turquía Brasil India Ecuador Suiza Egipto Sierra Leona Burkina Faso Mongolia
Clasificación Mundial Sudamérica Clasificación Mundial Sudamérica »
00:00
  en 4 días Paraguay Paraguay
00:00
 		Chile Chile 72
01:45
  en 4 días Brasil Brasil
01:45
 		Colombia Colombia 54
02:30
  en 4 días Perú Perú
02:30
 		Bolivia Bolivia 68
22:00
  en 5 días Ecuador Ecuador
22:00
 		Venezuela Venezuela 42
Amistosos Selecciones Amistosos Selecciones »
13:30
  en 4 días Singapur Singapur
13:30
 		Nepal Nepal 1
14:00
  en 5 días Tailandia Tailandia
14:00
 		Afganistán Afganistán 0
20:45
  en 5 días Irlanda del Norte Irlanda del Norte
20:45
 		Suiza Suiza 1
Partidos Amistosos Partidos Amistosos »
13:00
  en 4 días Djurgårdens IF Djurgårdens IF
13:00
 		KuPS Kuopio KuPS Kuopio 0
15:00
  en 5 días Kalmar FF Kalmar FF
15:00
 		Halmstads Halmstads 0
15:00
  en 5 días Orebro SK Orebro SK
15:00
 		Brommapojkarna Brommapojkarna 0
16:15
  en 5 días Oskarshamns AIK Oskarshamns AIK
16:15
 		Osters IF Osters IF 0
18:00
  en 5 días Eidsvold TF Eidsvold TF
18:00
 		Ull Kisa Ull Kisa 0
19:45
  en 5 días Odra Opole Odra Opole
19:45
 		Magdeburg Magdeburg 0
US Open Cup US Open Cup »
00:00
  en 4 días Tormenta Tormenta
00:00
 		Harbor City Harbor City 0
00:00
  en 4 días Long Island Rough Long Island Rough
00:00
 		Charlotte Charlotte 0
00:00
  en 4 días Forward Madison Forward Madison
00:00
 		Duluth Duluth 0
00:30
  en 4 días Cincinnati II Cincinnati II
00:30
 		Pancyprian Pancyprian 0
00:30
  en 4 días Carolina Core Carolina Core
00:30
 		Soda City Soda City 0
02:00
  en 4 días Flatirons Rush Flatirons Rush
02:00
 		Union Omaha Union Omaha 0
03:00
  en 4 días Tacoma Defiance Tacoma Defiance
03:00
 		Washington AC Washington AC 0
National National »
19:30
  en 5 días US Boulogne US Boulogne
19:30
 		Nîmes Nîmes 0
19:30
  en 5 días Dijon FCO Dijon FCO
19:30
 		Valenciennes Valenciennes 0
19:30
  en 5 días Sochaux Sochaux
19:30
 		FC Rouen 1899 FC Rouen 1899 0
19:30
  en 5 días Bourg-Péronnas Bourg-Péronnas
19:30
 		Orléans Orléans 0
19:30
  en 5 días Le Mans Le Mans
19:30
 		Paris 13 Atletico Paris 13 Atletico 0
19:30
  en 5 días Villefranche Villefranche
19:30
 		Concarneau Concarneau 0
19:30
  en 5 días Chateauroux Chateauroux
19:30
 		Versailles Versailles 0
19:30
  en 5 días QRM QRM
19:30
 		Aubagne Aubagne 0
Copa Finlandia Copa Finlandia »
19:00
  en 5 días Dons Dons
19:00
 		EsPa EsPa 0
19:10
  en 5 días LaVe II LaVe II
19:10
 		Harma Hameenlinna Harma Hameenlinna 0
National 2 Grupo 1 National 2 Grupo 1 »
19:00
  en 5 días Le Puy Le Puy
19:00
 		Saint-Priest Saint-Priest 0
19:30
  en 5 días Andrézieux Andrézieux
19:30
 		Hyères Hyères 0
Preferente Canarias Grupo 1 Preferente Canarias Grupo 1 »
22:00
  en 5 días Raqui San Isidro Raqui San Isidro
22:00
 		I'Gara I'Gara 0
22:00
  en 5 días CD Marino B CD Marino B
22:00
 		Realejos Realejos 0
22:00
  en 5 días Tenerife C Tenerife C
22:00
 		Puerto Cruz Puerto Cruz 0
22:00
  en 5 días CD Laguna CD Laguna
22:00
 		Bahía Santiago Bahía Santiago 0
22:00
  en 5 días Lorenzo Constancia Lorenzo Constancia
22:00
 		CD Sauzal CD Sauzal 0
Oberliga Grupo 3 Oberliga Grupo 3 »
19:00
  en 5 días Wandsbeker Wandsbeker
19:00
 		ETSV Hamburg ETSV Hamburg 0
19:30
  en 5 días Süderelbe Süderelbe
19:30
 		Altona 93 Altona 93 0

LIGAS / COMPETICIONES

Nombre Datos
Publicidad 600x120.gif

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
6,407,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.2785
Total Execution Time  0.2794
  CADENA URL  
/livescore/dia/21032025
  GET DATOS  
$_GET['/livescore/dia/21032025']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0113  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-15 13:53:45' ORDER BY lm.creation_date DESC LIMIT 8
0.0112  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-09 13:53:45' ORDER BY lm.creation_date DESC LIMIT 15
0.0172  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-21' GROUP BY cat.location ORDER BY coefficient DESC
0.0133  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-21' 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-21 00:00:00' AND c.shedule < '2025-03-21 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0117  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.ctype IN (1,3,12,34,36) AND c.id IN (757590,757591,757642,757643,757578,757579,15952,421176,421174,421177,421175,64535,63910,64534,236657,276804,273590,262526,243120,243556,244050,248642,243121,246009,104056,85508,254501,552771,552801,552591,552621,552651,552652,552741,552833,552592,552772,552711,263404,263405,263406,263407,263408,263409,263410,256748,236317,236323,251403,51205,51206,51207,51209,51201,51202,51203,51204,223086,223087,16988,187159,756557,756558,187416,34814,34817,50865,25862,12927,12929,279908,279904,53045,53513,53746,53040,53517,176325,120253,120245,120247,120688,120689,120690,120691,120692,120246,120248,20176,40886,45906,11199,11200,11201,11207,40590,40280,53241,53984,20177) AND c.shedule >= '2025-03-21 00:00:00' AND c.shedule < '2025-03-21 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0135  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 (757590,757591,757642,757643,757578,757579,15952,421176,421174,421177,421175,64535,63910,64534,236657,276804,273590,262526,243120,243556,244050,248642,243121,246009,104056,85508,254501,552771,552801,552591,552621,552651,552652,552741,552833,552592,552772,552711,263404,263405,263406,263407,263408,263409,263410,256748,236317,236323,251403,51205,51206,51207,51209,51201,51202,51203,51204,223086,223087,16988,187159,756557,756558,187416,34814,34817,50865,25862,12927,12929,279908,279904,53045,53513,53746,53040,53517,176325,120253,120245,120247,120688,120689,120690,120691,120692,120246,120248,20176,40886,45906,11199,11200,11201,11207,40590,40280,53241,53984,20177) AND c.shedule >= '2025-03-21 00:00:00' AND c.shedule < '2025-03-21 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0106  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (169352763) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0149  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.0149  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.0149  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.0149  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.0149  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.0149  (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-21 00:00:00' AND c.shedule < '2025-03-21 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-21 00:00:00' AND c.shedule < '2025-03-21 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC