What's the highest year than hawthorn won with a season result of preliminary finalist and a crowd smaller than 27,407?
CREATE TABLE table_name_18 (year INTEGER, crowd VARCHAR, winners VARCHAR, season_result VARCHAR)
SELECT MAX(year) FROM table_name_18 WHERE winners = "hawthorn" AND season_result = "preliminary finalist" AND crowd < 27 OFFSET 407 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_18 (year INTEGER, crowd VARCHAR, winners VARCHAR, season_result VARCHAR) Question: What's the highest year than hawthorn won with a season result of preliminary finalist and a crowd smaller than 27,407? [/INST] SELECT MAX(year) FROM table_name_18 WHERE winners = "hawthorn" AND season_result = "preliminary finalist" AND crowd < 27 OFFSET 407 ROWS </s>