bug - movie entries no longer unique

[pbogre]

Description

i suspect that this is because the SQL query now groups by watched_at, which means that there are different entries even when sorting by title, release date, etc.

to fix this, make the sql query sort by the first watched_at date.

im not familiar enough with sql to do this right away, but maybe it is possible to remove entries with duplicate title and only leave the one with the earliest watch date?

todo:

• remove duplicate entries in query, only leave out earliest watch date
• change sortBy name from Watch date to Earliest watch date

Version

latest repo

Steps to Reproduce

1. build & run latest repo
2. add movie with two different watch dates
3. go to all movies, see 2 entries

Screenshots

No response

Logs

No response

Server OS

No response

Client Platform

None

Client Device

No response

Client OS

No response

Client Browser

No response

Additional Context

No response