SELECT p.* FROM property p INNER JOIN customer c ON p.customerid = c.customerid AND c.archived IS NULL AND c.isDisabled = 0 WHERE LISTINGSTATUS = 'L'AND (p.expirydate IS NULL or p.expirydate > now()) AND highlightAdvertPosition = 0 AND p.ADDRESSPOSTCODE IN (5000,5001,5800,5810,5839,5880,5888,5000,5001,5005,5883,5902,5880,5881,5839,5882,5810,5800,5884,5885,5886,5887,5888,5900,5901,5903,5904,5920,5942,5950,5006,5031,5071,5067,5065,5069,5033,5034,5035,5061,5063,5007,5082,5081,5068,5037,5008,5070,5083) UNION SELECT p.* FROM property p INNER JOIN customer c ON p.customerid = c.customerid AND c.archived IS NULL WHERE p.listingStatus IN ('L')AND c.isDisabled = 0 AND highlightAdvertPosition > 0 AND (p.expirydate IS NULL or p.expirydate > now())AND p.addressstate RLIKE 'SA'ORDER BY highlightAdvertPosition DESC