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.

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

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 like '%##Tag##%'
order by CreationDate asc

Enter Parameters

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