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 (2500,3004,3088,3182,3183,4671,5110,5461,6302,1922,1921,2500,2520,2521,2522,2746,3004,3088,4671,5110,5461,6302,3141,3205,3206,8865,3006,3181,3182,3087,3086,3094,3002,3001,3000,3005,3008,3010,3050,3121,3183,8001,8002,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,3085,1928,1927,2519,2525,2526,3003,3053,3065,3066,3142,3143,3184,3207,8507,8557,8873,3083,3089,3090,3093,3145,5108,5107,2502,2505,2506,3051,3067,3122,3144,3161,3185,8500,8622,3082,3095,3162,3186,3163,3146,3123,3187) 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|WA'ORDER BY highlightAdvertPosition DESC