0

Please login or register to vote for this query.

(click on this box to dismiss)

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()

fork query

edited nov 7 13

created nov 6 13 Jon "not doe" Ericson