select * from media where state=1 and language_id in (3, 1) and date_published<='2012-05-20' order by date_published desc