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

LIVESCORE / Partidos del Domingo, 23 Marzo 2025

Televisión
20:45
 en 4 días Francia Francia
20:45
Croacia Croacia 4
Televisión
20:45
 en 4 días España España
20:45
Países Bajos Países Bajos 30
20:45
 en 4 días Portugal Portugal
20:45
Dinamarca Dinamarca 8
20:45
 en 4 días Alemania Alemania
20:45
Italia Italia 4
15:00
 en 4 días Georgia Georgia
15:00
Armenia Armenia 2
18:00
 en 4 días Hungría Hungría
18:00
Turquía Turquía 2
18:00
 en 4 días Escocia Escocia
18:00
Grecia Grecia 1
18:00
 en 4 días Islandia Islandia
18:00
Kosovo Kosovo 1
18:00
 en 4 días Eslovenia Eslovenia
18:00
Eslovaquia Eslovaquia 1
18:00
 en 4 días Serbia Serbia
18:00
Austria Austria 1
20:45
 en 4 días Irlanda Irlanda
20:45
Bulgaria Bulgaria 2
20:45
 en 4 días Bélgica Bélgica
20:45
Ucrania Ucrania 1
Televisión
14:00
 en 4 días Levante Levante
14:00
CD Castellón CD Castellón 11
Televisión
16:15
 en 4 días Eibar Eibar
16:15
Huesca Huesca 9
Televisión
16:15
 en 4 días Real Sporting Real Sporting
16:15
Albacete Albacete 24
Televisión
18:30
 en 4 días Tenerife Tenerife
18:30
Cádiz Cádiz 8
Televisión
18:30
 en 4 días RC Deportivo RC Deportivo
18:30
FC Cartagena FC Cartagena 7
Televisión
12:00
 en 4 días Ourense CF Ourense CF
12:00
Real Sociedad B Real Sociedad B 1
12:00
 en 4 días FC Andorra FC Andorra
12:00
Arenteiro Arenteiro 1
17:00
 en 4 días Barakaldo Barakaldo
17:00
Celta Fortuna Celta Fortuna 2
17:30
 en 4 días Ponferradina Ponferradina
17:30
CD Lugo CD Lugo 12
17:30
 en 4 días Unionistas CF Unionistas CF
17:30
Gimnástica Gimnástica 11
19:30
 en 4 días SD Amorebieta SD Amorebieta
19:30
Osasuna Promesas Osasuna Promesas 2
12:00
 en 4 días UD Ibiza UD Ibiza
12:00
CF Intercity CF Intercity 5
15:30
 en 4 días Alcorcón Alcorcón
15:30
Villarreal B Villarreal B 1
17:30
 en 4 días Marbella FC Marbella FC
17:30
Alcoyano Alcoyano 3
19:30
 en 4 días Fuenlabrada Fuenlabrada
19:30
Sevilla At. Sevilla At. 0
00:20
 en 4 días Deportivo Pereira Deportivo Pereira
00:20
Once Caldas Once Caldas 1
02:30
 en 4 días Santa Fe Santa Fe
02:30
Millonarios Millonarios 1
21:30
 en 4 días Alianza FC Alianza FC
21:30
Atlético Atlético 1
23:45
 en 5 días At. Nacional At. Nacional
23:45
Independiente Independiente 5
23 Mar 25  en 4 días Zorya Luhansk Zorya Luhansk
-
Obolon Obolon 0
01:00
 en 4 días León León
01:00
Municipal Municipal 0
13:00
 en 4 días Oskarshamns AIK Oskarshamns AIK
13:00
Halmstads Halmstads 0
13:00
 en 4 días Lyn 1896 FK Lyn 1896 FK
13:00
Moss Moss 0
13:30
 en 4 días FK Krasnodar FK Krasnodar
13:30
Amkal Moscow Amkal Moscow 0
14:00
 en 4 días Mjøndalen IF Mjøndalen IF
14:00
Haugesund Haugesund 0
14:00
 en 4 días Brann II Brann II
14:00
Vard Vard 0
14:00
 en 4 días IFK Norrköping IFK Norrköping
14:00
Degerfors IF Degerfors IF 0
14:00
 en 4 días Bryne Bryne
14:00
Egersund Egersund 0
14:30
 en 4 días Kalmar FF Kalmar FF
14:30
Osters IF Osters IF 0
15:00
 en 4 días AC Oulu AC Oulu
15:00
JIPPO Joensuu JIPPO Joensuu 0
15:30
 en 4 días Umeå Umeå
15:30
Piteå Piteå 0
16:00
 en 4 días Kristiansund BK Kristiansund BK
16:00
Aalesunds FK Aalesunds FK 0
17:00
 en 4 días IK Start IK Start
17:00
Viking Stavanger Viking Stavanger 0
Televisión
12:00
 en 4 días Deportivo Fabril Deportivo Fabril
12:00
Real Avilés Indus. Real Avilés Indus. 2
12:00
 en 4 días UM Escobedo UM Escobedo
12:00
Numancia Numancia 2
17:00
 en 4 días Real Ávila Real Ávila
17:00
Salamanca UDS Salamanca UDS 11
Televisión
17:00
 en 4 días SD Compostela SD Compostela
17:00
Bergantiños FC Bergantiños FC 0
17:00
 en 4 días UP Langreo UP Langreo
17:00
Guijuelo Guijuelo 1
17:00
 en 4 días Gimnástica Gimnástica
17:00
CD Laredo CD Laredo 0
17:00
 en 4 días Pontevedra Pontevedra
17:00
Coruxo Coruxo 0
18:00
 en 4 días Marino de Luanco Marino de Luanco
18:00
Rayo Cantabria Rayo Cantabria 1
Televisión
12:00
 en 4 días Ejea Ejea
12:00
Eibar B Eibar B 0
17:00
 en 4 días SD Gernika SD Gernika
17:00
CD Calahorra CD Calahorra 0
17:00
 en 4 días CD Alfaro CD Alfaro
17:00
Barbastro Barbastro 0
17:00
 en 4 días Izarra Izarra
17:00
Utebo Utebo 0
17:00
 en 4 días UD Logroñés UD Logroñés
17:00
SD Logroñés SD Logroñés 25
18:00
 en 4 días Tudelano Tudelano
18:00
CD Teruel CD Teruel 8
Televisión
12:00
 en 4 días CE Europa CE Europa
12:00
UE Cornellà UE Cornellà 0
12:00
 en 4 días CF Badalona Futur CF Badalona Futur
12:00
CE Andratx CE Andratx 1
12:00
 en 4 días Penya Deportiva Penya Deportiva
12:00
Lleida CF Lleida CF 0
12:00
 en 4 días Torrent Torrent
12:00
Atlético Baleares Atlético Baleares 1
12:00
 en 4 días Mallorca B Mallorca B
12:00
UE Sant Andreu UE Sant Andreu 0
12:00
 en 4 días Terrassa FC Terrassa FC
12:00
SD Ibiza SD Ibiza 2
17:00
 en 4 días UD Alzira UD Alzira
17:00
UE Olot UE Olot 0
17:00
 en 4 días Gran Peña Gran Peña
17:00
CD Lugo B CD Lugo B 0
17:00
 en 4 días Alondras CF Alondras CF
17:00
Viveiro Viveiro 0
17:00
 en 4 días Villalonga FC Villalonga FC
17:00
At. Arteixo At. Arteixo 0
17:30
 en 4 días Somozas Somozas
17:30
Betanzos CF Betanzos CF 0
18:00
 en 4 días CD Valladares CD Valladares
18:00
Arosa Arosa 0

LIGAS / COMPETICIONES

Nombre Datos
Publicidad 600x120.gif

  USO DE MEMORIA  
7,041,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.3298
Total Execution Time  0.3307
  CADENA URL  
/livescore/dia/23032025
  GET DATOS  
$_GET['/livescore/dia/23032025']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0111  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-17 23:11:13' ORDER BY lm.creation_date DESC LIMIT 8
0.0111  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 23:11:14' ORDER BY lm.creation_date DESC LIMIT 15
0.0280  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-23' GROUP BY cat.location ORDER BY coefficient DESC
0.0210  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-23' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0207  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-23 00:00:00' AND c.shedule < '2025-03-23 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0130  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 (223486,223487,223496,223500,223502,223481,223483,223498,223504,223510,223512,223514,15963,15926,15948,15957,15959,63808,63912,64537,64529,63911,63914,63916,64533,63909,64532,250650,250648,250653,250646,283446,279961,244063,244064,281573,247383,248645,248646,243559,248647,271878,248648,244065,244062,69801,69647,69804,69648,69806,69649,69650,69651,69653,68910,69798,68404,69799,68407,69800,74087,69499,68913,68403,68405,69493,69496,69497,69498,69645,69803,68399,68400,68402,74088,68406,69500,68917,241272,241297,241281,130707,130709,109709,130719,109710,109712,109713,109715,109716,111097,111098,111099,111101,111103,78977,78981,108374,108636,83920) AND c.shedule >= '2025-03-23 00:00:00' AND c.shedule < '2025-03-23 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0511  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.0511  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.0511  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.0511  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.0511  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.0511  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.0511  (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-23 00:00:00' AND c.shedule < '2025-03-23 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-23 00:00:00' AND c.shedule < '2025-03-23 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC