Notice: Undefined index: name in /home/shoelib/public_html/system/library/seo/product.php on line 48Notice: Undefined index: model in /home/shoelib/public_html/system/library/seo/product.php on line 49Notice: Undefined index: image in /home/shoelib/public_html/system/library/seo/product.php on line 50Notice: Undefined index: keyword in /home/shoelib/public_html/system/library/seo/product.php on line 51Notice: 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 dbocproduct p WHERE p.price>0 AND p.product_id in (select pc.product_id FROM dbocproduct_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 dbocproduct_special p WHERE p.price>0 AND p.product_id in (select pc.product_id FROM dbocproduct_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 dbocproduct p WHERE p.price>0 AND p.product_id in (select pc.product_id FROM dbocproduct_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 dbocproduct_special p WHERE p.price>0 AND p.product_id in (select pc.product_id FROM dbocproduct_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/shoelib/public_html/system/database/mysqliz.php on line 60