Find questions awaiting answers


Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

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

select as [User Link],
    u.reputation as [Reputation],
    q.lastactivitydate as [Last Active], as [Post Link]
from posts q
  join posttags pt on pt.postid =
  join tags t on = pt.tagid
  join users u on = q.OwnerUserId
where q.posttypeid = 1 -- Questions
  and q.answercount = 0 
  and q.score > 0
  and q.closeddate is null
  and q.lastactivitydate > '20181001'
  and t.tagname = 'quantum-mechanics'
order by q.lastactivitydate desc

Enter Parameters

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