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 ('B1 Offices','Live/Work') group by b1.property_id LIMIT 0, 12