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

LIVESCORE / Partidos del Jueves, 28 Marzo 2024

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 28 MAR
Argentina Portugal Italia Chile Japón Uruguay Estados Unidos Irlanda Bielorusia Hungría Bolivia India Haití Tuvalu Azerbaiyán

Partidos Jueves, 28 Marzo 2024

España Italia Alemania Internacional Suiza Dinamarca Brasil Camerún Colombia Argentina Guatemala Reino Unido Finlandia México Suecia Israel Austria Chile Competiciones Europeas Georgia Polonia Emiratos Árabes Costa Rica Arabia Saudita Croacia Nueva Zelanda Eslovaquia Senegal Uzbekistán Marruecos Bolivia Indonesia Holanda Zimbabwe El Salvador San Cristóbal y Nieves Australia Estados Unidos Rumania Azerbaiyán Paraguay Martinica Etiopía India Bélgica Haití Jordania Uganda Perú Bahrein Albania Ecuador Trinidad y Tobago Guadalupe Iraq Luxemburgo Rwanda Estonia Polinesia francés Mauritania Irán Liberia Swazilandia Francés Guayana Kirguistán
Partidos Amistosos Partidos Amistosos »
00:00
  Finalizado Corinthians
3 - 0
 		Londrina 99
11:30
  Finalizado HJK Helsinki
5 - 1
 		TPS 7
12:00
  Finalizado Ørn Horten
4 - 0
 		Askollen FK 6
13:00
  Finalizado Eidsvold TF
3 - 0
 		Notodden 1
14:00
  Finalizado Beşiktaş
1 - 1
 		Fatih Karagümrük 36
14:00
  Finalizado Sivasspor
3 - 0
 		Sivas Belediyespor 0
14:00
  Finalizado FK Arendal
5 - 1
 		Mandalskameratene 2
14:00
  Finalizado Skeid
1 - 4
 		Kjelsås 3
15:15
  Finalizado FC Mikkeli
2 - 0
 		KuPS II 1
Tercera Federación Grupo 1 Tercera Federación Grupo 1 »
12:00
  Finalizado Rápido de Bouzas
1 - 2
 		Viveiro 4
12:00
  Finalizado CD Estradense
2 - 1
 		Pontevedra B 1
12:00
  Finalizado CD Lugo B
4 - 2
 		Ourense UD 3
12:00
  Finalizado Celta Gran Peña
3 - 3
 		At. Arteixo 3
12:15
  Finalizado Silva SD
0 - 2
 		Bergantiños FC 2
17:00
  Finalizado Barbadás
2 - 1
 		Alondras CF 3
17:00
  Finalizado UD Paiosaco
0 - 1
 		SD Sarriana 2
17:00
  Finalizado CSD Arzua
1 - 2
 		Somozas 3
17:00
  Finalizado Betanzos CF
1 - 2
 		Arosa 2
Tercera Federación Grupo 2 Tercera Federación Grupo 2 »
12:00
  Finalizado Lealtad
2 - 1
 		Urraca CF 0
12:00
  Finalizado Gijón Industrial
0 - 1
 		Condal 2
12:00
  Finalizado Luarca CF
0 - 3
 		CD Colunga 0
12:30
  Finalizado UC Ceares
0 - 1
 		L´Entregu CF 8
17:15
  Finalizado CD Praviano
1 - 0
 		CD Tuilla 3
17:15
  Finalizado Llanes
2 - 1
 		Real Titánico 4
Tercera Federación Grupo 3 Tercera Federación Grupo 3 »
11:45
  Finalizado Siete Villas
1 - 1
 		SD Solares 1
17:00
  Finalizado CD Bezana
1 - 2
 		Sámano 6
17:00
  Finalizado Castro
2 - 1
 		Atlético 5
Tercera Federación Grupo 4 Tercera Federación Grupo 4 »
11:30
  Finalizado Portugalete
3 - 1
 		CD Padura 19
11:30
  Finalizado Beasain KE
1 - 1
 		CD Touring 2
11:30
  Finalizado CD Basconia
1 - 1
 		SCD Durango 2
13:00
  Finalizado Deportivo Alavés
0 - 1
 		Deusto 2
16:30
  Finalizado Aurrera KE
0 - 1
 		CD Lagun Onak 2
Tercera Federación Grupo 11 Tercera Federación Grupo 11 »
11:30
  Finalizado Ibiza I. Pitiusas
3 - 3
 		Constància 0
11:30
  Finalizado UD Collerense
0 - 2
 		Poblense 1
12:00
  Finalizado Binissalem
1 - 2
 		SD Portmany 1
16:00
  Finalizado Mercadal
3 - 1
 		Manacor 1
16:00
  Finalizado Llosetense
0 - 2
 		UE Alcudia 5
Tercera Federación Grupo 12 Tercera Federación Grupo 12 »
12:00
  Finalizado Arucas
1 - 1
 		Tenerife B 13
13:00
  Finalizado Panadería Pulido
2 - 1
 		Lanzarote 7
13:00
  Finalizado Unión Puerto
0 - 1
 		Union Sur Yaiza 3
13:00
  Finalizado CD Santa Úrsula
1 - 0
 		Ibarra 4
13:00
  Finalizado Tamaraceite
1 - 1
 		UD Teror 1
21:00
  Finalizado Marino
2 - 0
 		Atletico Victoria 8
Tercera Federación Grupo 14 Tercera Federación Grupo 14 »
12:00
  Finalizado Castuera
3 - 1
 		Calamonte 7
12:30
  Finalizado Arroyo
1 - 1
 		Trujillo 16
17:00
  Finalizado Villafranca
0 - 1
 		Pueblonuevo 7
17:00
  Finalizado CD Diocesano
1 - 0
 		CD Don Álvaro 0
Tercera Federación Grupo 15 Tercera Federación Grupo 15 »
11:00
  Finalizado Beti Onak
1 - 0
 		Txantrea 2
11:30
  Finalizado CD Alesves
2 - 2
 		CF Ardoi 5
12:00
  Finalizado Beti Kozkor
1 - 0
 		FC Bidezarra 1
20:00
  Finalizado Cirbonero
0 - 0
 		CD Cortes 3
Tercera Federación Grupo 16 Tercera Federación Grupo 16 »
11:30
  Finalizado Comillas CF
0 - 2
 		Arnedo 1
12:00
  Finalizado CD Calahorra B
0 - 1
 		CD Varea 3
12:00
  Finalizado La Calzada
0 - 1
 		UD Logroñés B 3
12:00
  Finalizado CD Berceo
0 - 2
 		Anguiano 1
12:00
  Finalizado CD Tedeón
0 - 0
 		Racing Rioja 0
12:00
  Finalizado Oyonesa
7 - 0
 		Alberite 0
12:00
  Finalizado River Ebro
0 - 1
 		Haro Deportivo 0
Tercera Federación Grupo 17 Tercera Federación Grupo 17 »
11:00
  Finalizado Calamocha
0 - 0
 		CD Binéfar 5
11:00
  Finalizado Huesca B
0 - 0
 		SD Borja 11
11:30
  Finalizado CF Epila
1 - 1
 		CD Cuarte 2
12:00
  Finalizado CD Belchite 97
1 - 2
 		Ejea 1
16:30
  Finalizado CDJ Tamarite
2 - 2
 		Fuentes 1
16:30
  Finalizado Caspe
4 - 0
 		CD Cariñena 1
16:30
  Finalizado CD Ebro
3 - 1
 		CD Utrillas 1
17:00
  Finalizado Fraga
4 - 0
 		Illueca 4

LIGAS / COMPETICIONES

Nombre Datos
LIGAS
es Primera División 33/38 Hoy
COMPETICIONES
wo Amistosos Selecciones 73/84 En 34 días
es Copa de la Reina 7/7 En 20 días
Publicidad 600x120.gif

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
6,323,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.0986
Total Execution Time  0.0996
  CADENA URL  
/livescore/dia/28032024
  GET DATOS  
$_GET['/livescore/dia/28032024']  
  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 > '2024-04-26 07:36:29' 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 > '2024-04-20 07:36:29' ORDER BY lm.creation_date DESC LIMIT 15
0.0065  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 = '2024-03-28' GROUP BY cat.location ORDER BY coefficient DESC
0.0070  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 = '2024-03-28' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0067  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 >= '2024-03-28 00:00:00' AND c.shedule < '2024-03-28 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0052  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 (658406,651090,651163,721304,720025,677005,685141,721074,721337,721417,719957,677006,454313,209695,445136,209694,438163,438164,438168,445137,454316,480981,489731,210027,210028,209696,420800,489734,449292,481490,489735,449293,480982,489736,449296,480983,449297,480984,210030,445139,480985,209698,454310,480986,425104,454315,480987,425137,456893,489729,425141,456894,489730,441755,456914,489732,442064,457897,449291,456664,481488,425134,442070,438170,457892,457893,457894,457898,210035,456898,210032,209697,209700,209701,438167,442067,442069,454314,449294,449295,481491,481494,480979,209699,420804,420806,442028,449289,449290,425136,425140,480980,213749,445141,441758,213755,457899,673149,651367,651368) AND c.shedule >= '2024-03-28 00:00:00' AND c.shedule < '2024-03-28 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 (152639672, 152357309, 152357311, 152952487, 152639717) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0131  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.0131  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.0131  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.0131  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.0131  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.0131  (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 >= '2024-03-28 00:00:00' AND c.shedule < '2024-03-28 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 calendars2024 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 >= '2024-03-28 00:00:00' AND c.shedule < '2024-03-28 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC