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 (2024,4825,7250,7906,7905,7904,7910,7903,2024,7250,7902,4825,7901,7907,7908,7909,7911,7912,7913,7914,7922,7923,2022,2026,1355,2023,2034,2025,2031,1350,1360,7248,2021,2027,2029,1363,2032,2033,2052,1466,1465,2028,2010,2017,1441,1300,1440,2035,2016,2018,1340,1335,1445,7249,2030,2011) 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|QLD|TAS'ORDER BY highlightAdvertPosition DESC