Find questions awaiting answers and with a given tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

select
    u.id as [User Link],
    u.reputation as [Reputation],
    q.creationdate as [Created],
    q.viewcount as [Views],
    q.id as [Post ID],
    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.creationdate > '20180601'
  and t.tagname = 'newtonian-mechanics'
order by q.creationdate desc

Enter Parameters

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