Ten Years
SELECT DISTINCT a.id,a.title, a.subtitle, a.published_date, a.upload_image, a.upload_document FROM `#__hsd_reports` AS a WHERE `a`.`showon_hsd`='1' AND `a`.`hsd_key_documents`='1' AND a.state = 1 ORDER BY a.published_date DESC