SELECT DISTINCT `e`.`attribute_set_id`
 FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_index_price` AS `price_index`
   ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = '1'
 INNER JOIN `catalog_category_product_index` AS `cat_index`
  ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(3, 4) AND cat_index.category_id='2'