Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND p.product_id IN (24102, 24100, 27474, 24107, 24106, 24108, 24096, 2410...' at line 11<br />Error No: 1064<br />
SELECT COUNT(DISTINCT p.product_id) total
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id) LEFT JOIN `oc_category_path` cp ON (cp.category_id = p2c.category_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
AND pd.language_id = '1'
AND cp.path_id = '191' AND EXISTS (SELECT * FROM `oc_product_filter` pfi WHERE p.product_id = pfi.product_id AND pfi.filter_id IN ()) AND p.product_id IN (24102, 24100, 27474, 24107, 24106, 24108, 24096, 24101, 24098, 24103, 24097, 24109, 24110, 23922 in /home/admin/web/souq.dental/opencart/modification/system/library/db/mysqli.php on line 51