Old unanswered questions whose asker is still around

0

Please login or register to vote for this query.

(click on this box to dismiss)

Unanswered questions where the asked has been active in the last 30 days, order with the oldest question first

Mathematics

Q&A for people studying math at any level and professionals in related fields

-- Enter Query Title
-- Enter Query Description

Select
Question.Id, Question.Id AS [Post Link],
Users.LastAccessDate, Question.AnswerCount
FROM Posts AS Question
JOIN Users ON Question.OwnerUserId = Users.Id
WHERE Question.AcceptedAnswerId IS NULL
AND NOT EXISTS (SELECT * FROM Posts AS Answer WHERE Answer.ParentId = Question.Id AND Answer.Score > 0)
AND Question.PostTypeId = 1
AND Question.ClosedDate IS NULL
AND DateDiff( Day, Users.LastAccessDate, GETDATE() ) < 30
ORDER BY Question.Id ASC

Enter Parameters

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