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.LISTINGTYPE = 'M'AND (p.expirydate IS NULL or p.expirydate > now()) AND highlightAdvertPosition = 0 AND p.ADDRESSPOSTCODE IN (3002,3002,8002,3066,3067,8557,8507,3065,3053,3000,3003,8103,3005,3006,3008,3010,3001,3050,8107,8108,8111,8120,8205,8383,8386,8388,8390,8393,3121,8394,3141,8396,8399,8005,8865,3205,8001,8003,8004,8061,8006,8007,8008,8009,8010,8045,8051,8060,8066,8069,8070,8071,8100,8101,8102,3004,3051,3054,3068,8500,3052,3070,3101,3122,3142,3206,8622,3181,3056,3057,3031,3078,3143,3182,3207,8538,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 p.LISTINGTYPE = 'M'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