0

Please login or register to vote for this query.

(click on this box to dismiss)

Show all questions with the specified tag where the question's asker has at least the specified reputation

Q&A for pro webmasters

-- Questions by Tag and Minimum Asker Reputation
-- Show all questions with the specified tag where the question's asker has at least the specified reputation

SELECT Posts.Id AS [Post Link], Users.ID AS [User Link], Users.Reputation
FROM Posts, Users, PostTags, Tags
WHERE Posts.Id = PostTags.PostId
AND PostTags.TagId = Tags.Id
AND Tags.TagName = '##TagName##'
AND Posts.OwnerUserId = Users.Id
AND Users.Reputation >= ##MinReputation##
ORDER BY Posts.Id ASC;

fork query

created jul 28 10 Michael Mrozek