Programación Viernes, 10 de agosto de 2018

Publicidad
SELECT DATE_FORMAT(`date`,'%H:%i') AS `time`, `EPIS`.`number`, `EPIS`.`description`, `SHOW`.`id`, `SHOW`.`name`, `SHOW`.`description` AS `show_description`, CONCAT("/programa/", permalink) AS `link` FROM `cc_episode_schedules` AS `SCHE` INNER JOIN `cc_episodes` AS `EPIS` ON EPIS.id = SCHE.id_episode INNER JOIN `cc_shows` AS `SHOW` ON SHOW.id = EPIS.id_show WHERE (DATEDIFF(SCHE.date,DATE(FROM_UNIXTIME(1533938400)))=0) ORDER BY `SCHE`.`date` ASC LIMIT 15