Парфюмерия D.Simachev

---

SELECT p.productID, `name_ru` as `name` FROM SC_products p LEFT JOIN SC_category_product cp ON cp.productID=p.productID AND cp.`categoryID`=1140 WHERE (p.`categoryID`=1140 OR cp.`productID`) AND `enabled`=1 ORDER BY `name`