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

LIVESCORE / Partidos de San Marino del Domingo, 16 Enero 2022

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 16 ENE
Portugal Italia Suiza Irlanda Bielorusia Hungría Azerbaiyán

Partidos Domingo, 16 Enero 2022

Lo sentimos...

No hay partidos programados para este día



  USO DE MEMORIA  
4,056,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.0360
Total Execution Time  0.0369
  CADENA URL  
/livescore/dia/16012022/pais/san-marino
  GET DATOS  
$_GET['/livescore/dia/16012022/pais/san-marino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0020  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 = 'san-marino' AND c.troncal = 1 GROUP BY c.CountryCode ORDER BY cuenta DESC
0.0022  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 = 'sm' GROUP BY t.teamId ORDER BY c.coefficient*dt.relations DESC LIMIT 30
0.0022  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.location != 'es' AND c.continent = 'eu' AND lm.creation_date > '2024-04-18 11:17:35' ORDER BY lm.creation_date DESC LIMIT 8
0.0020  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.location != 'es' AND c.continent = 'eu' AND lm.creation_date > '2024-04-12 11:17:35' ORDER BY lm.creation_date DESC LIMIT 15
0.0021  SELECT l.id FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE c.active_year = l.year AND c.CountryCode = 'sm' ORDER BY c.coefficient
0.0021  SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.start_date<'2024-04-29' AND l.end_date >'2024-04-24' AND c.active_year = l.year AND c.CountryCode = 'sm' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC
0.0022  SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.end_date <'2024-04-24' AND c.active_year = l.year AND c.CountryCode = 'sm' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC
0.0021  SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.start_date >'2024-04-24' AND c.active_year = l.year AND c.CountryCode = 'sm' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC