SELECT DISTINCT b.* FROM #__hikashop_product AS b WHERE (b.product_published = 1) AND (b.product_type = 'main') AND (b.product_manufacturer_id IN (143)) AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%')) ORDER BY IF(b.product_quantity = 0, 0, 1) DESC, b.product_name ASC 040
