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 (2360,3462,4006,7250,2360,3462,7904,7905,7906,7907,7909,7910,4006,7911,7912,7913,7914,7922,7923,7908,7250,7901,7902,7903,4005,4004,4003,4002,4001,4000,9013,4010,9015,4029,4030,9016,9017,4059,9018,9019,9020,9003,9022,9023,9008,9007,9021,4171,9000,9001,9002,9005,9009,9010,4007,4064,4169,7248,4011,4031,4101,4102,4170,4051,4060,4065,4072,4066,7249) 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|TAS'ORDER BY highlightAdvertPosition DESC