Closed questions with negative score favorited only by the OP


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, votes.userid as [User Link]
from votes
join posts on ( = votes.postid) 
  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

Enter Parameters

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