SELECT TOP 200 Posts.Id as [Post Link], Posts.ViewCount, ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 200 
Posts.Id as [Post Link],
Posts.ViewCount, Posts.Score, Posts.CreationDate, Posts.Body, p.Tags
FROM Posts 
join Posts p on p.AcceptedAnswerId=Posts.Id
WHERE 
Posts.PostTypeId = 2
AND
Posts.Score <6
AND
Posts.LastActivityDate < (GETDATE() - 200) 
AND 
p.Tags like '%##tag##%'
AND
p.AcceptedAnswerId IS NOT NULL 
ORDER BY Posts.CreationDate DESC , Posts.ViewCount DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results