Notice: 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 3
Error No: 1064
( SELECT 'min' AS title, p.price, p.tax_class_id FROM op_product p WHERE p.price>0 AND p.product_id in (select pc.product_id FROM op_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 op_product_special p WHERE p.price>0 AND p.product_id in (select pc.product_id FROM op_product_to_category pc WHERE pc.category_id IN()) AND ((p.date_start = '0000-00-00' OR p.date_start < NOW()) AND (p.date_end = '0000-00-00' OR p.date_end > NOW())) ORDER BY p.priority ASC, p.price ASC LIMIT 1 )UNION( SELECT 'max' AS title, p.price, p.tax_class_id FROM op_product p WHERE p.price>0 AND p.product_id in (select pc.product_id FROM op_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 op_product_special p WHERE p.price>0 AND p.product_id in (select pc.product_id FROM op_product_to_category pc WHERE pc.category_id IN()) AND ((p.date_start = '0000-00-00' OR p.date_start < NOW()) AND (p.date_end = '0000-00-00' OR p.date_end > NOW())) ORDER BY p.priority ASC, p.price DESC LIMIT 1 ) in /home/sites/tommyswearandcheer.com/public_html/system/database/mysql.php on line 49