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 'OR p.products_id =' at line 5
SELECT
p.products_id,
p.products_image, p.products_tax_class_id, p.products_price, s.status as specstat, s.specials_new_products_price
FROM products p left join specials s on p.products_id = s.products_id
WHERE p.products_id = 10360 OR p.products_id = 10411 OR p.products_id = 10352 OR p.products_id = 7204 OR p.products_id = 10376 OR p.products_id = 2977 OR p.products_id = OR p.products_id =