Select * from site_item where date(createddate)>='2014-11-01' AND parti=6 and publish=1 and `type`='Revue de presse' and title_fr !='' and (( publish_at <= NOW() or publish_at = '0000-00-00 00:00:00' ) and (unpublish_at >= NOW() or unpublish_at='0000-00-00 00:00:00' ) ) order by createddate desc limit 0,3