Questions eligible for Community User bumping

1

Please login or register to vote for this query.

(click on this box to dismiss)

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

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

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

Enter Parameters

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