1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for peer programmer code reviews

-- 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 
    (   select count(*) 
        from Votes v 
        where v.PostId = q.Id 
        and v.VoteTypeId in (
               6   -- Close
            , 10   -- Deletion
            , 12   -- Spam
        )  
    ) > 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())
    and q.LastActivityDate >= DATEADD(mm, -6, GETDATE())
order by CreationDate desc
;

view current version

edited aug 15 19

created aug 15 19 dfhwze