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 about the site for serious players and enthusiasts of chess

-- 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 300 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 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 Len(a.Body) > ##MinBodyLength:int##
order by a.Score desc

fork query

created aug 4 10 sam.saffron