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 (3182,4671,5110,3182,4671,5110,3183,3181,3206,3004,3184,3161,3143,8865,3141,3185,3205,3142,3121,5108,5107,3006,3005,8102,8393,8045,8103,8001,8394,3144,8051,3002,8107,8002,8396,8060,3001,8108,8003,8399,8061,3000,8111,8004,8066,8120,8005,8069,8205,8006,3050,8070,8383,8007,3010,8071,8386,8008,3008,8100,3186,8388,8009,8101,8390,3162,8010) 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|QLD|SA'ORDER BY highlightAdvertPosition DESC