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 (2063,6003,6803,2063,1560,6001,6000,6003,6800,6803,6809,6817,6820,6827,6830,6831,6832,6837,6838,6839,6840,6841,6842,6843,6844,6845,6846,6847,6848,6849,6850,6865,6905,2062,2068,2065,2089,2090,2091,1648,1646,1590,1585,6004,6005,6006,6007,6050,6872,6892,6900,6901,6902,6903,6906,6929,2060,2059,2057,2055,1699,1698,1697,1696,1695,2064,2067,2069,2088,2092,1694,1693,1692,1691,1690,1570,1517,1516,1515,1511,1507,1505,1504,1502,6016,6915,2061,2087,2093,1565,6008,6014,6051,6052,6090,6100,6151,6904,6913,6931,6932,6944,6945,6951,6979,2066,2070,2094,1611,1610,1608,1607,1606,1605,1604,1602,1597,1595,6017,6060,6103,6916,6917,6937,6938,6939,6940) 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|WA'ORDER BY highlightAdvertPosition DESC