Archaeology by Tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

The Great Outdoors

Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

declare @TagName nvarchar(255) = '##TagName##';

select 
    q.Id as [Post Link]  
    , q.Tags
from Posts q
cross apply (
    select TagName from PostTags p
    inner join Tags t on t.Id = p.TagId
    where PostId = q.Id
    and lower(TagName) = lower(@TagName)
) t
where (
    select count(*) 
    from Posts a 
    where a.ParentId = q.Id 
        and a.Score > 0
    ) = 0
    and q.CommunityOwnedDate is null 
    and q.ClosedDate is null 
    and q.ParentId is null 
    and q.AcceptedAnswerId is null
    and q.LastActivityDate <= DATEADD(mm, -6, GETDATE())
order by CreationDate desc
;

Enter Parameters

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