0

Please login or register to vote for this query.

(click on this box to dismiss)

Posts satisfying the conditions in http://meta.stackexchange.com/a/184511

Q&A for Joomla! administrators, users, developers and designers

SELECT
  questions.Id AS [Post Link],
  questions.Score AS 'Q score',
  MAX(answers.Score) AS 'max A score',
  COUNT(*) AS 'answer count'
FROM Posts questions
LEFT JOIN Posts answers ON answers.ParentId = questions.Id
WHERE questions.PostTypeId = 1 -- questions
  AND answers.PostTypeId = 2 -- answers
  AND questions.Score>=0
  AND questions.AcceptedAnswerId IS NULL
  AND questions.ClosedDate IS NULL
GROUP BY questions.Id, questions.CreationDate, questions.Score
HAVING MAX(answers.Score) = 0
ORDER BY questions.CreationDate DESC

view current version

edited sep 14 16

created sep 14 16 E.P.