select * from wp_property_propertypilot as b1 LEFT join wp_property_propertypilot_meta_options as b7 on b1.property_id = b7.property_id LEFT join wp_property_propertypilot_meta_options as b2 on b1.property_id = b2.property_id LEFT join wp_property_propertypilot_propertytypes as b5 on b1.property_id = b5.property_id where b1.property_status = 1 AND b2.property_name = 'status' and (b2.property_value in ('Under Offer','For Sale','For Sale/To Let')) AND b5.property_value in ('B1Offices and Light Industrial','B2 General Industrial','B8 Showroom','B8 Storage and Distribution','B8 Warehouse and Trade counter','Open Storage','Storage','Studio/Workshop','C2 Residential Institutions','Sui Generis - Cars/Spraying','Warehouse','Yard') group by b1.property_id LIMIT 0, 12