Questions with answercount 0 and an acceptedanswer or merged

0

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

Enter Parameters

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