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 (2218,3053,7173,8507,8557,8507,3065,7173,3053,2218,2217,8500,3066,3003,3002,3051,1487,1485,8002,3054,8107,8108,8111,2207,8120,8205,1495,1493,8383,1481,8386,2219,2220,2221,2222,8071,8390,8393,3052,3050,8394,8396,8399,3010,3008,3006,3005,8388,3001,3000,3067,3068,8006,8001,8003,8004,8005,8007,8008,8009,8010,8045,8051,8060,8061,8066,8069,8070,8100,8101,8102,8103,3031,3205,3057,3056,8538,8865,2216,2209,2208,2205,1484,1480,2223,3004,3121,3141,3055,3070,2206,2224,2225,3039,3011,3071,3078,3206,3207,3101,8873) 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|TAS'ORDER BY highlightAdvertPosition DESC