SELECT sp.*, scsp.store_category_id as categ_id FROM store_products sp INNER JOIN store_categories_store_products scsp ON scsp.store_product_id = sp.id INNER JOIN store_store_products ssp ON ssp.store_product_id = sp.id WHERE ssp.store_id = 2 AND ( scsp.store_category_id = 118 OR scsp.store_category_id = 119 OR scsp.store_category_id = 120 OR scsp.store_category_id = 121 OR scsp.store_category_id = 123 OR scsp.store_category_id = 143 ) ORDER BY `name` ASC