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 'for-notebook-20-usb,logitech-s-120-speakers-20-black-oem)' at line 1

---

SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p WHERE p.productID IN (logitech-s150-digital-speaker-usb-black-20,logitech-v-20-speakers-for-notebook-20-usb,logitech-s-120-speakers-20-black-oem)