SELECT top 100 a.id,a.DisplayName as QuestionAsker,p.id,p...

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
--p.ViewCount, a.Id, a.Reputation, a.DisplayName as QuestionAsker, p.CreationDate as DateAsked, p.Id, p.Title, p.AnswerCount, p.Score as QuestionScore, b.Id, b.Reputation, b.DisplayName as Answerer, answer.CreationDate as DateAnswered, answer.Score as AnswerScore, t.TagName,
a.id,a.DisplayName as QuestionAsker,p.id,p.Title,p.Score as QuestionScore,b.id,b.DisplayName as Answerer,
case 
  WHEN ((p.AcceptedAnswerId = answer.Id)) THEN 'selected answer'
  ELSE 'attempted answer'
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
  AND answer.parentid = p.Id
ORDER by a.id asc, answertype desc;

-- For answered questions
-- give me 
--   the question
--   the selected answer
--   the non-selected answers
--   the basic ids, scores of each, and their authors
-- for the language R
-- ordered by questions with highest score, listing the accepted answer first

Enter Parameters

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