[openstreetmap/openstreetmap-website] Add changeset comment search api with filtering by author and time (PR #4359)

[Milan Cvetkovic]

It shouldn't be too bad. It is the number of comments on their subscribed changesets that is the limiting factor. Inner join should get rid of the changesets without comments, and we can limit the size of the output. I am not sure what the heavy duty contributors' numbers would be though - I am the only one commenting on my changesets so far :-(

Here is the query rewritten to use JOIN explicitly:

```
SELECT * FROM changesets_subscribers S
INNER JOIN changeset_comments M
ON S.changeset_id=M.changeset_id
WHERE S.subscriber_id=<userid> AND M.visible == TRUE
ORDER by M.created_at DESC
LIMIT 100
```

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/4359#issuecomment-1930407460
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/4359/c1930407460 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20240206/0fce0ce3/attachment.htm>