A Database Error Occurred

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 `a`.`name` desc' at line 12

SELECT `a` .* FROM (`tbl_involvement` a) INNER JOIN `tbl_inv_category` b ON `b`.`InvolvementID` = `a`.`id` WHERE a.`involvementtypeID` = ( SELECT id FROM tbl_involvementtype WHERE description = 'Minisitry' ) AND b.CategoryID = ( SELECT id FROM tbl_category WHERE title = 'Youth' Limit 1 ) and a.diocese_id =7 and a.org_id = ORDER BY `a`.`name` desc