Unanswered questions about TAG from users with reputation >= N


Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

select top 1000 p.id as [Post Link], p.score, p.viewcount, p.answercount, p.tags,
from posts p
    INNER JOIN PostTags ON PostTags.PostId = p.id
    INNER JOIN Tags ON PostTags.TagId = Tags.id
    JOIN Users u ON u.id = p.ownerUserId
where p.owneruserid = u.id
  and p.answercount = 0
  and u.reputation >= ##rep##
  and p.deletiondate is null
  and Tags.TagName LIKE '%##tag##%'
order by p.creationdate desc
--limit 1000

Enter Parameters

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