Which Year has a Borough of harrogate, and a Rank smaller than 6, and a Definition of civil parish?
CREATE TABLE "settlements_by_population" (
  "rank" real,
  "town" text,
  "population" real,
  "year" real,
  "borough" text,
  "definition" text
);
SELECT "year" FROM "settlements_by_population" WHERE "borough"='harrogate' AND "rank"<6 AND "definition"='civil parish';