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