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 (2303,3300,4007,5373,7140,7139,3300,3301,5373,2303,7140,2309,4007,2292,4029,2302,4010,2296,4011,2293,2300,2297,2294,2291,2310,4030,4171,2298,4006,2299,4013,4012,4005,4031,4170,4172,2305,9464,2289,4002,4001,4009,9000,9001,9002,9003,9005,9007,9008,9009,4000,9013,9015,9016,9017,9018,9019,9010,9021,9022,9023,4004,4003,4169,9020) 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 'NSW|VIC|QLD|SA|TAS'ORDER BY highlightAdvertPosition DESC