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(1532210400)))=0)
ORDER BY
`SCHE`.`fecha` ASC
LIMIT 15
