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.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,23' at line 1
Error No: 1064
SELECT SQL_CALC_FOUND_ROWS DISTINCT p.product_id FROM man_product p LEFT JOIN man_product_description pd ON (pd.product_id=p.product_id) INNER JOIN (SELECT DISTINCT product_id FROM man_product_to_category WHERE category_id = '61') p2c ON(p.product_id=p2c.product_id) LEFT JOIN man_product_attribute pop ON pop.product_id=p.product_id AND pop.attribute_id=285 WHERE p.status = '1' AND p.date_available <= '2021-06-15 03:53:00' AND p.quantity > 0 AND pd.language_id = '1' AND p.price >=0 AND EXISTS (select 1 FROM man_product_option_value pov0 WHERE pov0.product_id=p.product_id AND pov0.option_value_id IN(63)) AND EXISTS (select 1 FROM man_product_option_value pov1 WHERE pov1.product_id=p.product_id AND pov1.option_value_id IN()) ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,23 in /home/manline/manline.com.ua/www/system/database/mysql.php on line 50