When viewing query results, users see duplicate results for certain records.
Query is a way to group records; it is not a reporting module. The query output shows you whether the record belongs in the query. If a field with a one-to-many relationship (such as constituency codes) is in the filters or output, the record appears multiple times, once for each time the record meets the criteria. This allows you to check your query to ensure you get the expected results.