Error accured: 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 product_pos asc' at line 4
SELECT `product_id` FROM `album_products` LEFT JOIN `album_product_groups` ON `product_group` = `group_id` WHERE `product_cat` AND `product_promo` = 1 and `product_cat` = ORDER BY product_pos asc