Questions eligible for Community User bumping


Please login or register to vote for this query.

(click on this box to dismiss)

Posts satisfying the conditions in

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

  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

Switch to main site
loading Hold tight while we fetch your results