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
)