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 (4006,4006,4005,4004,4003,4002,4001,4000,9010,4010,9013,4029,4030,9015,9016,4059,9017,9019,9002,9020,9021,9022,9023,9018,4171,9000,9001,9003,9005,9007,9008,9009,4007,4064,4169,4011,4031,4101,4102,4170,4051,4060,4066,4072,4065) 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 'QLD'ORDER BY highlightAdvertPosition DESC