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

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
13:30
 en 5 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
13:00
 en 5 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
00:00
 en 4 días Forward Madison Forward Madison
00:00
Duluth Duluth 0
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:30
 en 4 días Carolina Core Carolina Core
00:30
Soda City Soda City 0
00:30
 en 4 días Cincinnati II Cincinnati II
00:30
Pancyprian Pancyprian 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
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
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
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
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
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
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

  USO DE MEMORIA  
6,408,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.1603
Total Execution Time  0.1613
  CADENA URL  
/livescore/dia/21032025
  GET DATOS  
$_GET['/livescore/dia/21032025']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
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 > '2025-03-15 11:32:05' 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 > '2025-03-09 11:32:05' ORDER BY lm.creation_date DESC LIMIT 15
0.0133  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.0088  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.0093  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.0061  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,757578,757579,757591,757642,757643,15952,421176,421174,421177,421175,63910,64534,64535,236657,276804,273590,262526,243120,243556,244050,248642,243121,246009,104056,85508,254501,552801,552771,552591,552621,552651,552652,552741,552833,552592,552772,552711,263404,263405,263406,263407,263408,263409,263410,256748,236317,236323,251403,51203,51204,51205,51206,51207,51209,51201,51202,223086,223087,16988,187159,756557,756558,187416,12927,12929,34814,34817,50865,25862,279908,279904,53513,53746,53045,53040,53517,176325,120253,120245,120247,120688,120689,120690,120691,120692,120246,120248,11201,11207,20176,40886,45906,11199,11200,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.0169  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,757578,757579,757591,757642,757643,15952,421176,421174,421177,421175,63910,64534,64535,236657,276804,273590,262526,243120,243556,244050,248642,243121,246009,104056,85508,254501,552801,552771,552591,552621,552651,552652,552741,552833,552592,552772,552711,263404,263405,263406,263407,263408,263409,263410,256748,236317,236323,251403,51203,51204,51205,51206,51207,51209,51201,51202,223086,223087,16988,187159,756557,756558,187416,12927,12929,34814,34817,50865,25862,279908,279904,53513,53746,53045,53040,53517,176325,120253,120245,120247,120688,120689,120690,120691,120692,120246,120248,11201,11207,20176,40886,45906,11199,11200,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.0019  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.0224  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.0224  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.0224  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.0224  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.0224  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.0224  (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