1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

-- 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
;

fork query

edited aug 29 19

created aug 4 19 dfhwze