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


Please login or register to vote for this query.

(click on this box to dismiss)

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

Switch sites:
loading Hold tight while we fetch your results