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` ASC' at line 4
SELECT A.`id_bar`, A.`name`, A.`btype`, A.`title_slug`, A.`long_desc` FROM ac_bar AS A, ac_bar_cocktail AS B WHERE A.`id_bar` = B.`bar_id` AND A.`status` = 'on' AND B.`status` = 'on' AND B.`cocktail_id` = ORDER BY A.`name` ASC