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 posts.Score < 0 and posts.ClosedDate IS NOT NULL and votetypeid=5 and posts.PostTypeId = 1 and posts.OwnerUserId = votes.UserId order by posts.CreationDate desc