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 ('A1 Shop and Resi','A1 Use Lock up shop','A3 Restaurants Cafes Snack Bars','A5 Hot Food Takeaways','A1 Retail Unit','Boutique Retail Unit') group by b1.property_id LIMIT 0, 12