0

Please login or register to vote for this query.

(click on this box to dismiss)

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 and
  posts.OwnerUserId = votes.UserId
  order by posts.CreationDate desc

fork query

edited may 16 17

created may 16 17 jon.doe7173