Closed questions with negative score favorited only by the OP

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results