Questions in need of a friendly/helpful comment


Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

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

-- query recent questions that could require some friendly comments

    , q.Tags
    , '' + CAST(q.Id AS VARCHAR) as URL
from Posts q
    (   select count(*) 
        from Posts a 
        where a.ParentId = q.Id and a.Score > 0
    ) = 0
    (   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())
    and q.LastActivityDate >= DATEADD(mm, -2, GETDATE())
order by CreationDate desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results