MySQL Error!
------------------------

The Error returned was:
Unknown column 'date' in 'field list'

Error Number:
1054

SELECT DATE_FORMAT(date,'%b %Y') AS date, COUNT(*) AS cnt FROM full_post GROUP BY date ORDER BY DATE_FORMAT(date,'%Y-%m') desc