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 (2756,4030,5501,3181,2756,3181,4030,5501,3182,3183,4010,4029,3004,3141,3142,3143,4006,4007,4011,4031,3121,3144,3161,3184,3185,3205,3206,8865,4012,4059,3002,3006,3122,8002,8622,4000,4001,4002,4003,4004,4005,4032,4051,4171,9000,9001,9002,9003,9005,9007,9008,9009,9010,9013,9015,9016,9017,9018,9019,9020,9021,9022,9023,3000,3001,3005,3008,3010,3050,3065,3066,3067,3123,3145,3146,3162,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,8557,4013,4053,4060,4064,9464) 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 'NSW|VIC|QLD|SA'ORDER BY highlightAdvertPosition DESC