StackOverflow Old Unanswered Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

(Adapted from http://sqlserverpedia.com/wiki/StackOverflow_Old_Unanswered_Questions_Query) Want to answer StackOverflow questions to boost your reputation, but you can't find any old ones that are easy enough for you to answer? This query will hunt them out. You can change these things in the WHERE clause:< * p.Tags LIKE '%sql%' - change the sql keyword to one you're interested in. * p.AnswerCount <= 1 - only one (or zero) person made a suggested answer, but since p.AcceptedAnswerId IS NULL, we know the answer wasn't accepted. * p.CommentCount <= 1 - only one (or zero) comments were made, which means it didn't catch anybody's interest. We sort by p.LastActivityDate because we want to find the questions that fell off the radar. The older they are, the easier they are to swoop in and answer. Plus, keep in mind that the StackOverflow database is only exported periodically - newer questions are more likely to have already been answered by someone since the database export was made.

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

-- StackOverflow Old Unanswered Questions
-- (Adapted from http://sqlserverpedia.com/wiki/StackOverflow_Old_Unanswered_Questions_Query)
-- 
-- Want to answer StackOverflow questions to boost your reputation, but you can't find any old ones that are easy enough for you to answer? This query will hunt them out. You can change these things in the WHERE clause:<
-- 
-- * p.Tags LIKE '%sql%' - change the sql keyword to one you're interested in.
-- * p.AnswerCount <= 1 - only one (or zero) person made a suggested answer, but since p.AcceptedAnswerId IS NULL, we know the answer wasn't accepted.
-- * p.CommentCount <= 1 - only one (or zero) comments were made, which means it didn't catch anybody's interest.
-- 
-- We sort by p.LastActivityDate because we want to find the questions that fell off the radar. The older they are, the easier they are to swoop in and answer. Plus, keep in mind that the StackOverflow database is only exported periodically - newer questions are more likely to have already been answered by someone since the database export was made.

SELECT p.Title, p.Tags, 
  p.Id AS [Post Link],
  p.Body, p.LastActivityDate
FROM dbo.Posts p
  LEFT OUTER JOIN dbo.PostTags pt
    ON p.Id = pt.PostId
  LEFT OUTER JOIN dbo.Tags t
    ON t.Id = pt.TagId
WHERE t.TagName LIKE ##tag:string##
  AND p.CreationDate < DATEADD(mm, -2, GETDATE())
  AND p.CreationDate > DATEADD(mm, -24, GETDATE())
  AND p.AcceptedAnswerId IS NULL
--  AND p.AnswerCount = 1 AND p.CommentCount <= 1
  AND p.ClosedDate IS NULL
ORDER BY p.LastActivityDate

Enter Parameters

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