An Error Was Encountered

Error Number: 1064

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 'ORDER BY desc LIMIT 2' at line 8

SELECT as id, projectsitems.identifier as identifier, projectsitems.image as image, projectsitems_lg.headertitle as headertitle, projectsitems_lg.resume as resume FROM projectsitems JOIN projectsitems_lg ON = projectsitems_lg.id_projectsitems WHERE projectsitems.publish = 'Yes' AND projectsitems.finished = 'Yes' AND projectsitems_lg.code = 'fr' AND!= ORDER BY desc LIMIT 2