Questions favorited by a single user

0

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 posts.id as [Post Link], posts.FavoriteCount, posts.Score, posts.CreationDate, votes.userid as [User Link]
from votes
join posts on (posts.id = votes.postid) 
where
  posts.FavoriteCount = 1 and
  votetypeid=5 and
  posts.PostTypeId = 1
  order by posts.CreationDate desc

Enter Parameters

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