SELECT product_id FROM products where 1=1 and status=1 and is_sold=0 and FIND_IN_SET(:category_id, category_id) and FIND_IN_SET(:domain_ids, domain_ids)-1

Horizontal Machining Center (HMC)