WordPress database error: [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 'DESC' at line 1]
SELECT YEAR(p.post_date) FROM pfq_posts AS p RIGHT JOIN pfq_term_relationships AS r ON r.object_id = p.ID WHERE p.post_status = 'publish' GROUP BY YEAR(p.post_date) DESC