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