1064You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND products.status >0 order by product_order' at line 5

Select statement was select category_contents.product_id, customer_title, description, price, option_a, option_b, products.product_code, image, status from category_contents, products, price where category_contents.category_id=115 AND category_contents.product_id=products.product_id AND price.product_id = products.product_id AND currency_id= AND products.status >0 order by product_order