Find recent active open questions that are positive scored, have no comments and no answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/350742/no-comment-filter

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select top 1000 
       id [Post Link]
     , score
     , owneruserid [User Link]
from posts
where posttypeid = 1            -- Questions
and commentcount = 0            -- no comments
and closeddate is null          -- not closed
and answercount = 0             -- no answers
and score > 0                   -- positively scored
order by lastactivitydate desc  -- recently active

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results