Select top 100 a.Id, a.Reputation, a.DisplayName FROM Use...

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
-- COUNT(*) over (t.TagName in ('r')) as rtagcount
FROM Users a, Posts p, Users b, Posts answer, PostTags pt, Tags t
WHERE p.OwnerUserId = a.Id      -- or accountId?
  AND t.TagName in ('r')
  AND answer.OwnerUserId = b.Id -- or accountId
  AND p.PostTypeId = 1          -- question
  AND answer.PostTypeId = 2     -- answer
  AND Pt.PostId = p.id
  AND t.Id = pt.TagId
  AND answer.parentid = p.Id
order by a.Reputation

Enter Parameters

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