Old questions with a specific tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Brings up those open question with no accepted answer of a certain time old with a tag.

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

select
  q.Id as [Post Link],
  q.Score as 'Votes',
  q.CreationDate as 'Posted',
  q.LastActivityDate as 'Last Active',
  q.ViewCount as 'Views',
  q.CommentCount as 'Comments'
from
  Posts q 
where
  q.PostTypeId = 1 and
  q.AcceptedAnswerId is null and
  q.ClosedDate is null and
  q.CreationDate < DATEADD(Month, -##Month##, getdate()) and
  q.Tags = '##Tag##'
order by CreationDate asc

Enter Parameters

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