select b1.*,b2.* from wp_property_propertypilot as b1 LEFT join wp_property_propertypilot_meta_options as b2 on b1.property_id = b2.property_id LEFT join wp_property_propertypilot_meta_options as b3 on b1.property_id = b3.property_id where b1.property_status = '0' AND b2.property_name = 'status' and b2.property_value = 'Active' and b3.property_name = 'propertyoption' and (b3.property_value NOT IN('For Sale','Under Offer','To Let')) GROUP By b1.property_id order by b1.id LIMIT 0, 8