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

/*
Please enter how many months in the month field.
Please enter a tag / keyword to check.
*/

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 
join Posts a on a.ParentId = q.Id
where
  q.PostTypeId = 1 and
  q.AcceptedAnswerId is null and
  q.ClosedDate is null and
  q.CreationDate < DATEADD(Month, -##Month:int?24##, getdate()) and
  q.Tags like '%##Tag?freya##%'
group by 
  q.Id,q.Score,q.CreationDate,q.LastActivityDate,q.ViewCount,q.CommentCount
having 
  max(a.Score) = 0
order by q.CreationDate asc

Enter Parameters

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