Which Year has a Borough of harrogate, and a Rank smaller than 6, and a Definition of civil parish?
CREATE TABLE table_name_59 (year VARCHAR, definition VARCHAR, borough VARCHAR, rank VARCHAR)
SELECT year FROM table_name_59 WHERE borough = "harrogate" AND rank < 6 AND definition = "civil parish"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_59 (year VARCHAR, definition VARCHAR, borough VARCHAR, rank VARCHAR) Question: Which Year has a Borough of harrogate, and a Rank smaller than 6, and a Definition of civil parish? [/INST] SELECT year FROM table_name_59 WHERE borough = "harrogate" AND rank < 6 AND definition = "civil parish" </s>