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

LIVESCORE / Partidos de Turquía de Hoy - Livescore

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

Partidos Jueves, 25 Abril 2024

Reino Unido Suecia Rusia Holanda Rumania Islandia Italia Noruega Grecia Finlandia Georgia Polonia Bélgica Portugal Kazakstán Azerbaiyán Alemania Islas Feroe Eslovenia Dinamarca Austria Suiza Armenia Andorra

Lo sentimos...

No hay partidos programados para este día



  USO DE MEMORIA  
4,209,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.0466
Total Execution Time  0.0476
  CADENA URL  
/livescore/pais/turquia/dia/hoy
  GET DATOS  
$_GET['/livescore/pais/turquia/dia/hoy']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
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 = 'turquia' AND c.troncal = 1 GROUP BY c.CountryCode ORDER BY cuenta DESC
0.0021  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-24 18:17:17' 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.location != 'es' AND c.continent = 'eu' AND lm.creation_date > '2024-04-18 18:17:17' ORDER BY lm.creation_date DESC LIMIT 15
0.0044  SELECT l.id FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE c.active_year = l.year AND c.CountryCode = 'tr' ORDER BY c.coefficient
0.0034  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-05' AND l.end_date >'2024-04-30' AND c.active_year = l.year AND c.CountryCode = 'tr' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC
0.0021  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-24' AND categoryId = 359
0.0018  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-24' AND categoryId = 2944
0.0038  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-30' AND c.active_year = l.year AND c.CountryCode = 'tr' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC
0.0037  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-30' AND c.active_year = l.year AND c.CountryCode = 'tr' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC