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 (4101,4101,4067,4002,9015,4001,9000,4066,9016,4000,9001,9017,9002,4064,9018,4102,9003,9019,9005,9020,9007,9021,9008,9022,9009,4004,9023,4072,9010,4003,4169,9013,4103,4059,4104,4005,4065,4006,4120,4151,4068,4171,4060,4105) 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 'QLD'ORDER BY highlightAdvertPosition DESC