Select top 100 * FROM Users a, Posts p, PostTags pt, Tags t

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Patents Meta

Q&A about the site for people interested in improving and participating in the patent system

Select top 100 *
-- a.Id, a.Reputation, a.DisplayName
FROM Users a, Posts p, PostTags pt, Tags t
WHERE p.OwnerUserId = a.Id      -- or accountId?
AND t.TagName in ('r')
  AND Pt.PostId = p.id
  AND t.Id = pt.TagId
  order by a.Reputation DESC

Enter Parameters

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