Greenstand / treetracker-admin-api

Legacy API microservice for the admin panel
GNU Affero General Public License v3.0
31 stars 81 forks source link

Revert "fix: add DISTINCT clause to ensure no duplicates" #612

Closed nmcharlton closed 2 years ago

nmcharlton commented 2 years ago

Reverts Greenstand/treetracker-admin-api#611

Unfortunately, this fix doesn't resolve issue – the inner join on tree_tag means that each record is a distinct combination of capture record and tree tag record, so captures with multiple tags are repeated. Further, the count clause is not working properly and any tag selection returns the same count.