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

LIVESCORE / Partidos de Lesotho de Hoy - Livescore

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 4 MAY

Partidos Jueves, 02 Mayo 2024

Camerún Egipto Sudáfrica Etiopía Congo, República Democrática del Sierra Leona Marruecos Uganda Malí Argelia Níger Ghana Somalia Seychelles

Lo sentimos...

No hay partidos programados para este día



  USO DE MEMORIA  
4,058,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Livescore / Index )  0.1509
Total Execution Time  0.1520
  CADENA URL  
/livescore/pais/lesotho/dia/hoy
  GET DATOS  
$_GET['/livescore/pais/lesotho/dia/hoy']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (5)  
0.0126  SELECT z.name,z.alias,c.CountryCode,c.location,c.continent,c.top,SUM(c.coefficient) as cuenta FROM categories c INNER JOIN zones z ON z.location = c.CountryCode WHERE z.alias = 'lesotho' AND c.troncal = 1 GROUP BY c.CountryCode ORDER BY cuenta DESC
0.0129  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories c ON c.id = l.categoryId WHERE dt.main_image = 1 AND c.troncal = 1 AND l.year=c.active_year AND c.CountryCode = 'ls' GROUP BY t.teamId ORDER BY c.coefficient*dt.relations DESC LIMIT 30
0.0162  SELECT z.name,z.alias,c.CountryCode,SUM(c.coefficient) as cuenta FROM categories c INNER JOIN leagues l ON l.categoryId = c.id INNER JOIN zones z ON z.location = c.CountryCode WHERE c.continent = 'af' AND c.troncal = 1 AND c.active_year = l.year AND l.total_num_matchs = l.total_num_matchsR GROUP BY c.CountryCode ORDER BY cuenta DESC LIMIT 30
0.0126  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.continent = 'af' AND lm.creation_date > '2024-05-01 21:22:03' ORDER BY lm.creation_date DESC LIMIT 8
0.0126  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.continent = 'af' AND lm.creation_date > '2024-04-25 21:22:03' ORDER BY lm.creation_date DESC LIMIT 15