1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

-- query recent questions that could require some friendly comments

select 
      q.Title  
    , q.Tags
    , 'https://codereview.stackexchange.com/questions/' + CAST(q.Id AS VARCHAR) as URL
from Posts q
where 
    (   select count(*) 
        from Posts a 
        where a.ParentId = q.Id and a.Score > 0
    ) = 0
    and 
    (   select count(*) 
        from Comments c 
        where c.PostId = q.Id
    ) = 0
    and q.Score <= 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, -1, GETDATE())
order by CreationDate desc
;

view current version

edited aug 15 19

created aug 15 19 dfhwze