0

Please login or register to vote for this query.

(click on this box to dismiss)

Excluding closed and wiki answers with a filter for min body length

Q&A for anime and manga fans

-- Interesting answers per tag in the last N days
-- Excluding closed and wiki answers with a filter for min body length

set nocount on 
-- Interesting Questions for a Tag in the last N days

declare @latest datetime
select @latest = CreationDate from Posts where Id = (select max(Id) from Posts)
set nocount off

select top 500 a.CreationDate, a.Id as [Post Link], a.Score, u.Id as [User Link]
, DATEDIFF(d,u.CreationDate,@latest) as [Account Age (Days)], u.Reputation
from Posts a
join Posts q on a.ParentId = q.Id
join PostTags pt on pt.PostId = q.Id 
join Tags t on t.Id = pt.TagId
join Users u on u.Id = a.OwnerUserId
where a.CreationDate > DateAdd(d, -##Age##, @latest) -- and a.ClosedDate is null
  and a.CommunityOwnedDate is null 
  and q.CommunityOwnedDate is null
  --and q.ClosedDate is null
  and t.TagName = ##TagName:string##
  and Len(a.Body) > ##MinBodyLength:int##
order by a.CreationDate desc

fork query

created jul 11 11 knb