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