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 (3065,5082,8557,3053,8507,3065,5082,8557,3066,8002,3002,5083,3067,3005,8045,5081,8103,5008,8001,8394,8051,8107,5007,3054,8396,3003,8060,8108,5006,8003,8399,8061,8111,3052,8004,8500,3001,8066,8120,3051,8005,3000,8069,8205,3050,8006,8070,8383,8007,8071,8386,3010,8008,8100,8388,5084,3008,8009,3068,8101,8390,3006,8010,8102,8393,3121,3141,3205,8865,5010,3057,3070,5009,5885,5950,3004,5886,3078,5094,5070,5887,3101,5800,5069,5888,5005,5810,5900,5001,5839,5031,5901,5000,8538,5880,5902,3031,5881,5012,5903,5882,5904,5883,5920,5085,5884,5942,3056,3071,3055,5087,5071,5067,3122,5025,3142,3181,8622,5011,3206,8873,3207,5086) 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|SA'ORDER BY highlightAdvertPosition DESC