C# Unanswered questions for archeologists

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

-- query unanswered C# questions subject to the archeologist badge

select 
    q.Id as [Post Link]  
    , q.Tags
from Posts q
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.Tags like '%[C#]%'
    and q.LastActivityDate <= DATEADD(mm, -6, GETDATE())
order by CreationDate desc
;

Enter Parameters

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