Questions eligible for Community User bumping

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

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  questions.Id AS [Post Link],
  questions.Score AS 'Q score',
  MAX(answers.Score) AS 'max A score',
  COUNT(*) AS 'answer count',
  (SELECT STRING_AGG ( ISNULL(DisplayName,'N/A'), ',') AS csv 
    FROM Posts 
    JOIN Users ON Users.Id = Posts.OwnerUserId
    WHERE Posts.ParentId = questions.Id)
FROM Posts questions
JOIN Posts answers ON answers.ParentId = questions.Id
WHERE questions.PostTypeId = 1 -- questions
  AND answers.PostTypeId = 2 -- answers
  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

Enter Parameters

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