Comments on questions with accepted answers

0

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

select Top 10 c.Id as [Comment Link]
from Comments c join Posts p on (p.Id = PostId)
where AcceptedAnswerId is not null
--      and ClosedDate is null
      and c.Score is null
      and p.Score > 2
      and (cast(GetUTCDate() - c.CreationDate as int) > 7)
order by newid();

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results