1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional mathematicians

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

fork query

edited aug 21 13

created jun 20 13 ofstream