0

Please login or register to vote for this query.

(click on this box to dismiss)

Posts with No Answer, No Comment, No Duplicate

Q&A for people looking to bypass life's everyday problems with simple tricks

select p.Id as [Post Link], p.CreationDate from Posts p
where answercount=0 -- no answers
  and commentcount=0 -- no comments
  and p.body not like '%uplicate%' -- not a duplicate
  and p.ClosedDate is null -- not closed
order by p.CreationDate DESC

fork query

edited nov 18 12 anonymous

created apr 16 12 draks