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

LIVESCORE / Partidos de Hungría de Hoy - Livescore

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

Partidos Jueves, 02 Mayo 2024

Competiciones Europeas Reino Unido Bulgaria Georgia Rusia Turquía Serbia Alemania Lituania Bielorusia Finlandia Letonia Kazakstán Polonia Rumania Azerbaiyán Austria Malta Armenia Dinamarca Suecia Noruega

Lo sentimos...

No hay partidos programados para este día


LIGAS / COMPETICIONES

Nombre Datos
Publicidad 600x120.gif

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
4,239,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Livescore / Index )  0.2267
Total Execution Time  0.2281
  CADENA URL  
/livescore/pais/hungria/dia/hoy
  GET DATOS  
$_GET['/livescore/pais/hungria/dia/hoy']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0146  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 = 'hungria' AND c.troncal = 1 GROUP BY c.CountryCode ORDER BY cuenta DESC
0.0146  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-05-01 10:33:01' ORDER BY lm.creation_date DESC LIMIT 8
0.0146  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-25 10:33:01' ORDER BY lm.creation_date DESC LIMIT 15
0.0152  SELECT l.id FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE c.active_year = l.year AND c.CountryCode = 'hu' ORDER BY c.coefficient
0.0158  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-05-12' AND l.end_date >'2024-05-07' AND c.active_year = l.year AND c.CountryCode = 'hu' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC
0.0145  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-05-01' AND categoryId = 583
0.0154  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-05-07' AND c.active_year = l.year AND c.CountryCode = 'hu' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC
0.0152  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-05-07' AND c.active_year = l.year AND c.CountryCode = 'hu' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC