You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where status='1' order by date desc' at line 1
QUERY:
select DISTINCT(date) from where status='1' order by date desc