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 = 22 OR scsp.store_category_id = 23 OR scsp.store_category_id = 15 OR scsp.store_category_id = 16 OR scsp.store_category_id = 24 OR scsp.store_category_id = 33 OR scsp.store_category_id = 55 ) ORDER BY `name` ASC