text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  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?
  ### Answer:
  SELECT year FROM table_name_59 WHERE borough = "harrogate" AND rank < 6 AND definition = "civil parish"