0

Please login or register to vote for this query.

(click on this box to dismiss)

Question I answered with no accepted answer

Q&A for speakers of other languages learning English

-- Question I answered with no accepted answer
-- Question I answered with no accepted answer

SELECT p2.Id as QuestionId, P2.Title as QuestionTitle, Count(p3.Id) as NumberOfAnswer
FROM Posts p1, Posts p2, Posts p3
WHERE p1.PostTypeId=2 
  AND p1.OwnerUserId=##UserId## 
  AND p1.ParentId=p2.Id 
  AND P2.AcceptedAnswerId is null
  AND p3.ParentId=p2.id
GROUP BY p2.Id, P2.Title
ORDER BY NumberOfAnswer DESC

fork query

created jun 20 10 radius