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