Error: 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 p.price ASC LIMIT 1 ' at line 4
Error No: 1064
( SELECT 'min' AS title, p.price, p.tax_class_id FROM oc_product p WHERE p.product_id in (select pc.product_id FROM oc_product_to_category pc WHERE pc.category_id IN()) ORDER BY p.price ASC LIMIT 1 )UNION( SELECT 'min_special' AS title, p.price, 0 as tax_class_id FROM oc_product_special p WHERE p.product_id in (select pc.product_id FROM oc_product_to_category pc WHERE pc.category_id IN()) ORDER BY p.price,p.priority LIMIT 1 )UNION( SELECT 'max' AS title, p.price, p.tax_class_id FROM oc_product p WHERE p.product_id in (select pc.product_id FROM oc_product_to_category pc WHERE pc.category_id IN()) ORDER BY p.price DESC LIMIT 1 )UNION( SELECT 'max_special' AS title, p.price, 0 as tax_class_id FROM oc_product_special p WHERE p.product_id in (select pc.product_id FROM oc_product_to_category pc WHERE pc.category_id IN()) ORDER BY p.price DESC,p.priority LIMIT 1 )