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 (2046,3067,4670,2046,3066,3067,4670,4676,3065,3002,8002,8557,2045,2040,2047,2132,2137,1470,3053,3068,3101,3121,8507,2039,1805,1801,1800,2110,2111,2130,2131,2134,1675,3054,3070,3078,3122,3141,8622,2041,2038,2048,2049,2133,2138,2139,2203,3057,3052,3051,3050,3010,3008,3006,3005,3003,3001,3000,3102,3142,3205,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,8500,8865,2042,2037,2009,2006,1819,2050,2066,2112,2127,2135,2136,2140,2193,1680,1611,1610,1608,1607,1606,1605,1604,1602,1597,1595,1450,3056,3004,3071,3079,3123,3181,8538,8576) 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'ORDER BY highlightAdvertPosition DESC