Show users who marked my posts as "favorites", and which posts they marked...
Q&A for professional and enthusiast programmers
SELECT COUNT(*), votes.UserId AS Downvotes FROM votes JOIN posts on posts.id = votes.postid WHERE votetypeid=3 and posts.owneruserid in (select top 10 id from users) GROUP BY votes.UserId