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