Programación Lunes, 15 de octubre de 2018

Publicidad
SELECT DATE_FORMAT(`fecha`,'%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.fecha,DATE(FROM_UNIXTIME(1539640800)))=0) ORDER BY `SCHE`.`fecha` ASC LIMIT 15