View all unanswered questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

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

DECLARE @TagLike NVARCHAR(25) = ##taglike:string##

SELECT TOP 500 * FROM (SELECT Id AS [Post Link], AnswerCount AS [Ans],
CommentCount AS [Com], CreationDate, Score AS [Scr],
ViewCount AS [Views], OwnerUserId FROM Posts
WHERE AnswerCount = 0 AND Tags LIKE '%' + @TagLike + '%' AND
ClosedDate IS NULL) AS p
INNER JOIN (SELECT Id, LastAccessDate, Reputation AS [Rep] FROM Users
WHERE LastAccessDate >= '2015-12-01') AS u
ON p.OwnerUserId = u.Id
ORDER BY p.Com

Enter Parameters

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