@SQLReview 

Sample query:

SELECT unix_timestamp(publish_date) as publish_date
FROM vpt_program
WHERE language = 'en' and publish_date <= '2013-10-02'
ORDER BY publish_date DESC
LIMIT 1