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