SELECT top 100 a.Id, a.Reputation, a.DisplayName as Quest...

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 as QuestionAsker, p.Id, p.Title, p.AnswerCount, p.Score, b.Id, b.Reputation, b.DisplayName as Answerer, answer.Score, t.TagName,
case 
  WHEN ((p.postTypeId = 2) AND (p.AcceptedAnswerId = answer.Id)) THEN 'answer'
  WHEN ((p.postTypeId = 2) AND (p.AcceptedAnswerId <> answer.Id)) THEN 'attempt'
END as answertype
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
ORDER by a.Reputation DESC;

Enter Parameters

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