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 (6000,6000,6001,6003,6848,6849,6850,6865,6847,6842,6846,6905,6838,6845,6844,6839,6840,6843,6841,6800,6803,6809,6817,6820,6827,6830,6831,6832,6837,6004,6892,6005,6006,6007,6050,6900,6901,6902,6903,6872,6906,6929,6151,6979,6051,6090,6100,6931,6944,6945,6951,6915,6052,6016,6008,6904,6932,6060,6913,6014,6937,6938,6939,6940,6103) 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 'WA|WA'ORDER BY highlightAdvertPosition DESC