Lemmy: Can someone come up with a SQL query to fix the count of comments on a post - possibly something to run during migration?

Example posting: https://beehaw.org/post/823476

If you hand-count the comments, there are 6. But the posting says 10.

This could involve a lot of data, do it in batches? Please share what SQL you can come up with. Thank you.