An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY promotions.homeposition desc LIMIT 2' at line 8

SELECT as id, promotions.identifier as identifier, promotions.image as image, promotions_lg.price as price, promotions_lg.title as title, promotions_lg.resume as resume FROM promotions JOIN promotions_lg ON = promotions_lg.id_promotions WHERE promotions.publish = 'Yes' AND promotions.homepublish = 'Yes' AND promotions_lg.code = 'ro' AND!= ORDER BY promotions.homeposition desc LIMIT 2