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

LIVESCORE / Partidos del Sábado, 15 Marzo 2025

Televisión
14:00
 en 3 días Real Valladolid Real Valladolid
14:00
Celta Celta 20
Televisión
16:15
 en 3 días Mallorca Mallorca
16:15
Espanyol Espanyol 10
Televisión
18:30
 en 3 días Villarreal Villarreal
18:30
Real Madrid Real Madrid 17
Televisión
21:00
 en 3 días Girona Girona
21:00
Valencia Valencia 10
Televisión
16:00
 en 3 días Everton Everton
16:00
West Ham West Ham 1
Televisión
16:00
 en 3 días Southampton Southampton
16:00
Wolves Wolves 1
Televisión
16:00
 en 3 días Ipswich Town Ipswich Town
16:00
Nottingham Forest Nottingham Forest 1
Televisión
16:00
 en 3 días Manchester City Manchester City
16:00
Brighton Hove Alb. Brighton Hove Alb. 3
Televisión
18:30
 en 3 días AFC Bournemouth AFC Bournemouth
18:30
Brentford Brentford 1
Televisión
15:00
 en 3 días AC Monza AC Monza
15:00
Parma Parma 1
Televisión
15:00
 en 3 días Udinese Udinese
15:00
Hellas Verona Hellas Verona 1
Televisión
18:00
 en 3 días Milan Milan
18:00
Como Como 2
Televisión
20:45
 en 3 días Torino Torino
20:45
Empoli Empoli 1
Televisión
14:00
 en 3 días Racing Ferrol Racing Ferrol
14:00
Eibar Eibar 11
Televisión
16:15
 en 3 días Albacete Albacete
16:15
Málaga Málaga 33
Televisión
16:15
 en 3 días FC Cartagena FC Cartagena
16:15
Burgos Burgos 17
Televisión
18:30
 en 3 días Almería Almería
18:30
Real Zaragoza Real Zaragoza 56
Televisión
21:00
 en 3 días Córdoba CF Córdoba CF
21:00
Real Sporting Real Sporting 18
Televisión
15:30
 en 3 días Union Berlin Union Berlin
15:30
Bayern München Bayern München 1
Televisión
15:30
 en 3 días FC Augsburg FC Augsburg
15:30
Wolfsburg Wolfsburg 1
Televisión
15:30
 en 3 días Werder Bremen Werder Bremen
15:30
Mönchengladbach Mönchengladbach 1
Televisión
15:30
 en 3 días Mainz 05 Mainz 05
15:30
SC Freiburg SC Freiburg 1
Televisión
18:30
 en 3 días RB Leipzig RB Leipzig
18:30
B. Dortmund B. Dortmund 3
17:00
 en 3 días Nantes Nantes
17:00
Lille Lille 1
19:00
 en 3 días Angers SCO Angers SCO
19:00
Monaco Monaco 1
21:05
 en 3 días Lens Lens
21:05
Stade Rennais Stade Rennais 1
16:00
 en 3 días Osasuna Promesas Osasuna Promesas
16:00
Bilbao Ath. Bilbao Ath. 2
Televisión
17:00
 en 3 días Arenteiro Arenteiro
17:00
Ponferradina Ponferradina 1
Televisión
17:00
 en 3 días Gimnàstic Gimnàstic
17:00
Barakaldo Barakaldo 13
18:00
 en 3 días Barça Atlètic Barça Atlètic
18:00
SD Tarazona SD Tarazona 1
18:00
 en 3 días Real Sociedad B Real Sociedad B
18:00
Zamora CF Zamora CF 6
20:30
 en 3 días CD Lugo CD Lugo
20:30
Unionistas CF Unionistas CF 7
02:00
 en 2 días Querétaro Querétaro
02:00
Mazatlán Mazatlán 0
Televisión
02:00
 en 2 días Necaxa Necaxa
02:00
León León 6
04:05
 en 3 días Puebla Puebla
04:05
Toluca Toluca 1
16:30
 en 3 días Utrecht Utrecht
16:30
NEC Nijmegen NEC Nijmegen 0
18:45
 en 3 días Sparta Rotterdam Sparta Rotterdam
18:45
PEC Zwolle PEC Zwolle 0
20:00
 en 3 días RKC Waalwijk RKC Waalwijk
20:00
PSV PSV 0
21:00
 en 3 días Heerenveen Heerenveen
21:00
Heracles Heracles 0
16:30
 en 3 días Farense Farense
16:30
Sporting Braga Sporting Braga 0
16:30
 en 3 días Gil Vicente Gil Vicente
16:30
CD Santa Clara CD Santa Clara 0
19:00
 en 3 días Porto Porto
19:00
AVS Futebol AVS Futebol 0
21:30
 en 3 días Sporting CP Sporting CP
21:30
Famalicão Famalicão 1
13:30
 en 3 días Queens Park Range. Queens Park Range.
13:30
Leeds United Leeds United 0
13:30
 en 3 días Millwall Millwall
13:30
Stoke City Stoke City 0
16:00
 en 3 días Oxford United Oxford United
16:00
Watford Watford 0
16:00
 en 3 días Luton Town Luton Town
16:00
Middlesbrough Middlesbrough 0
16:00
 en 3 días Plymouth Argyle Plymouth Argyle
16:00
Derby County Derby County 0
16:00
 en 3 días Swansea City Swansea City
16:00
Burnley Burnley 1
16:00
 en 3 días Blackburn Rovers Blackburn Rovers
16:00
Cardiff City Cardiff City 0
16:00
 en 3 días Preston North End Preston North End
16:00
Portsmouth Portsmouth 0
16:00
 en 3 días West Bromwich Alb. West Bromwich Alb.
16:00
Hull City Hull City 0
16:00
 en 3 días Coventry City Coventry City
16:00
Sunderland Sunderland 0
00:30
 en 2 días Atlético Atlético
00:30
Deportivo Pereira Deportivo Pereira 2
02:30
 en 2 días Deportivo Pasto Deportivo Pasto
02:30
La Equidad La Equidad 5
20:00
 en 3 días Envigado Envigado
20:00
At. Nacional At. Nacional 0
22:10
 en 3 días Fortaleza Fortaleza
22:10
Deportes Tolima Deportes Tolima 1
16:00
 en 3 días Kilmarnock Kilmarnock
16:00
Hibernian FC Hibernian FC 0
16:00
 en 3 días Motherwell Motherwell
16:00
St. Mirren St. Mirren 0
16:00
 en 3 días Heart Midlothian Heart Midlothian
16:00
Ross County FC Ross County FC 0
16:00
 en 3 días St. Johnstone St. Johnstone
16:00
Aberdeen Aberdeen 0
11:30
 en 3 días Gaziantep Gaziantep
11:30
Kayserispor Kayserispor 0
14:00
 en 3 días Kasımpaşa Kasımpaşa
14:00
Alanyaspor Alanyaspor 0
18:30
 en 3 días İstanbul İstanbul
18:30
Trabzonspor Trabzonspor 0
18:30
 en 3 días Konyaspor Konyaspor
18:30
Beşiktaş Beşiktaş 0
11:00
 en 3 días Dnepr Mogilev Dnepr Mogilev
11:00
Lokomotiv Gomel Lokomotiv Gomel 0
11:45
 en 3 días FC Lahti FC Lahti
11:45
PKKU PKKU 0
12:00
 en 3 días Trollhattan FC Trollhattan FC
12:00
Skovde AIK Skovde AIK 0
12:00
 en 3 días GAIS GAIS
12:00
Varbergs BoIS Varbergs BoIS 0
13:00
 en 3 días SJK Akatemia SJK Akatemia
13:00
VPS Vaasa VPS Vaasa 0
13:00
 en 3 días Landskrona BoIS Landskrona BoIS
13:00
IFK Varnamo IFK Varnamo 0
13:00
 en 3 días Trelleborgs FF Trelleborgs FF
13:00
Halmstads Halmstads 0
13:00
 en 3 días Sandefjord Sandefjord
13:00
KFUM Oslo KFUM Oslo 0
13:00
 en 3 días Sotra SK Sotra SK
13:00
Brann II Brann II 0
13:00
 en 3 días Hødd Hødd
13:00
Åsane Åsane 0
13:00
 en 3 días Stjørdals-Blink Stjørdals-Blink
13:00
Orkla Orkla 0
13:00
 en 3 días Orebro SK Orebro SK
13:00
IF Karlstad IF Karlstad 0
13:00
 en 3 días Hønefoss Hønefoss
13:00
Grorud IL Grorud IL 0
14:00
 en 3 días Fredrikstad Fredrikstad
14:00
Stromsgodset IF Stromsgodset IF 0
14:00
 en 3 días Sogndal Sogndal
14:00
Raufoss IL Raufoss IL 0
14:00
 en 3 días Bryne Bryne
14:00
Jerv Jerv 0
14:00
 en 3 días Ilves II Ilves II
14:00
JJK Jyväskylä JJK Jyväskylä 0
14:00
 en 3 días Pors Grenland Pors Grenland
14:00
Flekkeroy Flekkeroy 0
14:00
 en 3 días Lillestrom SK Lillestrom SK
14:00
Odd Odd 0
14:00
 en 3 días Træff Træff
14:00
Brattvåg Brattvåg 0
14:00
 en 3 días Osters IF Osters IF
14:00
AIK Solna AIK Solna 0
14:00
 en 3 días Lysekloster Lysekloster
14:00
Vard Vard 0
14:00
 en 3 días Kjelsås Kjelsås
14:00
Ull Kisa Ull Kisa 0

LIGAS / COMPETICIONES

Nombre Datos
Publicidad 600x120.gif

  USO DE MEMORIA  
7,844,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Livescore / Index )  0.3541
Total Execution Time  0.3556
  CADENA URL  
/livescore/dia/15032025
  GET DATOS  
$_GET['/livescore/dia/15032025']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
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-11 03:19: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.coefficient >= 10 AND lm.creation_date > '2025-03-05 03:19:00' ORDER BY lm.creation_date DESC LIMIT 15
0.0137  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-15' GROUP BY cat.location ORDER BY coefficient DESC
0.0158  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-15' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0167  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-15 00:00:00' AND c.shedule < '2025-03-15 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0067  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 (6581,10610,6586,6575,6172,6166,6168,6170,6163,25498,25495,25494,25497,15983,15921,15975,15929,16000,24795,24799,24800,24801,24796,9782,9777,9779,63906,64527,63900,63904,63901,63908,64519,64525,64520,63905,231309,231311,231310,236710,236711,236706,236709,7262,29191,29192,7265,29190,7264,7266,29195,13701,13705,13702,13703,13704,13707,13708,13697,13699,13700,250643,250641,250635,250636,8735,8733,8732,8734,16819,16820,16817,16818,37181,37184,37178,37185,270077,271875,244034,253751,256108,256998,243108,257102,243554,244036,244038,244039,244040,243110,280205,243111,244453,273093,243112,244955,243114,269737,243115) AND c.shedule >= '2025-03-15 00:00:00' AND c.shedule < '2025-03-15 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0478  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.0478  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.0478  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.0478  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.0478  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.0478  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.0478  (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-15 00:00:00' AND c.shedule < '2025-03-15 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-15 00:00:00' AND c.shedule < '2025-03-15 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC