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 (2850,3066,2850,3065,3066,3067,8557,3068,3053,8507,3002,8002,3054,3121,3057,8386,8388,3052,3051,3050,8390,3010,3008,3006,3005,8393,3003,3001,3000,3070,8394,3078,3101,8396,8004,3141,8399,8500,8001,8003,8060,8005,8006,8007,8008,8009,8010,8045,8051,8061,8066,8069,8070,8071,8100,8101,8102,8103,8107,8108,8111,8120,8205,8383,3056,3004,3122,8538,3205,8622,8865,3055,3031,3071,3102,3142,3181,3206) 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'ORDER BY highlightAdvertPosition DESC