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,3065,3066,8507,8557,5082,3002,3067,8002,5083,3054,3052,3051,3050,3010,3008,3006,3005,3003,3001,3000,3068,8001,8003,8004,8005,8006,8007,8008,8009,8010,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,8500,5081,5008,5007,5006,5084,3057,3070,3121,3141,3205,8865,5010,5009,3056,3031,3004,3078,3101,8538,5070,5069,5031,5012,5005,5001,5000,5085,5094,5800,5810,5839,5880,5881,5882,5883,5884,5885,5886,5887,5888,5900,5901,5902,5903,5904,5920,5942,5950,3055,3071,3122,3142,3181,3206,3207,8622,8873,5071,5067,5025,5011,5086,5087) 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