FROM #__hikashop_product AS b LEFT JOIN #__hikashop_product_category AS a ON b.product_id = a.product_id WHERE (b.product_published = 1) AND (b.product_type = 'main') AND (b.product_manufacturer_id IN (61)) AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%')) ORDER BY a.ordering ASC