StackOverflow Old Unanswered Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

(Copied 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.

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
-- (Copied 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.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