0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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

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

view current version

edited jan 7 16

created dec 28 15 GNU.Supporter