People who have favorited your posts.

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

declare @UID int = ##UserID##

select UserId as [User Link], PostId as [Post Link]
from (select PostId, UserId
      from Votes
      where VoteTypeId = 5) as lclVotes
inner join (select Score, Id
            from Posts
            where PostTypeId = 1 
            and OwnerUserId = @UID) as lclPosts
on lclVotes.PostId = lclPosts.Id
order by lclPosts.Score desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results