Find unanswered questions in a tag by asker reputation
Q&A for scientists, academics, teachers, and students in the field of chemistry
-- Find unanswered questions in a tag by asker reputation SELECT TOP 20 Posts.Title, Posts.Id FROM Posts INNER JOIN PostTags ON Posts.Id = PostTags.PostId INNER JOIN Tags ON PostTags.TagId = Tags.id WHERE Tags.TagName = '##TagName##' AND Posts.AnswerCount = 0 AND Posts.PostTypeId = 1 -- PostTypeId = 1 -> Question AND Posts.CommunityOwnedDate is null AND Posts.ClosedDate is null ORDER by Posts.Score