Questions favorited by a single user


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select as [Post Link], posts.FavoriteCount, posts.Score, posts.CreationDate, posts.OwnerUserId as [User Link], votes.userid as [User Link]
from votes
join posts on ( = votes.postid) 
  posts.FavoriteCount = 1 and
  votetypeid=5 and
  posts.PostTypeId = 1
  order by posts.CreationDate desc

Enter Parameters

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