Random singleton comments with zero score


Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

with singleton as (select min(c.Id) Id
                   from comments c
                        join posts p on (PostId = p.Id)
                   group by PostId
                   having count(*) = 1

select top 100 s.Id as [Comment Link]
--len(text)/15, count(*)
from singleton s
join comments c on (s.Id = c.Id)
where score is null
--group by len(text)/15
order by newid()

Enter Parameters

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