1064 - 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.products_status = '1'
AND...' at line 6
SELECT COUNT(p.products_id) AS total FROM
products_description pd,
products p
LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id
LEFT JOIN specials s ON p.products_id = s.products_id
WHERE p.products_id IN ()
AND p.products_status = '1'
AND p.products_id = pd.products_id
AND pd.language_id = '2'