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, b.CreationDate as DateAnswered, answer.Score as AnswerScore, t.TagName,
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 p.ViewCount 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 view count