I’m an admin of my own instance and I have direct access to the database.
On the database I run these two queries:
For comments:
select p.actor_id, c.content
from person p
innerjoin comment_like cl on cl.person_id = p.id
innerjoincomment c on cl.comment_id = c.id
where cl.comment_id = ?
and cl.score = -1;
For posts:
select p.actor_id
from person p
innerjoin post_like pl on p.id = pl.person_id
where pl.post_id = ?
and pl.score = -1;
You can replace the question mark with post/comment id.
I’d say that yes, at the time of checking you were downvoted by these (you may noticed many of the users being the same on unrelated comments):
Post:
Comment:
https://lemmings.world/comment/857087
https://lemmings.world/comment/857045
https://lemmings.world/comment/856796
Hope it helps.
Thanks, how did you get this information? it’s something i’d like to keep track of
I’m an admin of my own instance and I have direct access to the database.
On the database I run these two queries:
For comments:
select p.actor_id, c.content from person p inner join comment_like cl on cl.person_id = p.id inner join comment c on cl.comment_id = c.id where cl.comment_id = ? and cl.score = -1;
For posts:
select p.actor_id from person p inner join post_like pl on p.id = pl.person_id where pl.post_id = ? and pl.score = -1;
You can replace the question mark with post/comment id.
Thanks, perhaps i’ll roll my own instance then