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 = 1 AND ( scsp.store_category_id = 44 OR scsp.store_category_id = 64 OR scsp.store_category_id = 67 OR scsp.store_category_id = 68 OR scsp.store_category_id = 69 OR scsp.store_category_id = 73 OR scsp.store_category_id = 74 ) ORDER BY `name` ASC