Questions with answercount 0 and an acceptedanswer or merged


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 distinct as[Post Link]
, p.AcceptedAnswerId as [Accepted Answer Id]
, as [Post Link]
, ph.CreationDate as [Merged on]
FROM Posts p
left outer join posts ap on = p.AcceptedAnswerId
left outer join posthistory ph 
  on ph.postid = 
  and ph.PostHistoryTypeId = 37
WHERE p.PostTypeId = 1
AND p.AnswerCount = 0
AND p.AcceptedAnswerId IS NOT NULL

Enter Parameters

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