Q&A for administrators, end users, developers and designers for Craft CMS
u.id as [User Link],
u.reputation as [Reputation],
q.lastactivitydate as [Last Active],
q.id as [Post Link]
from posts q
join posttags pt on pt.postid = q.id
join tags t on t.id = pt.tagid
join users u on u.id = 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