SELECT TOP(50) question.Id as [Post Link], question.Tags ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT TOP(50)
  question.Id as [Post Link], 
  question.Tags as [Tags],
  COUNT(answers.Id) as [Answers],
  MAX(answers.Score) as [Answer score]
FROM Posts question
INNER JOIN Posts answers
  ON question.Id = answers.ParentId
WHERE question.PostTypeId = 1
  AND question.Tags LIKE '%java%'
  AND question.Tags NOT LIKE '%javascript%'
  AND question.Tags NOT LIKE '%android%'
  AND question.AcceptedAnswerId IS NOT NULL
--  AND question.Body LIKE '%Exception in thread%'
GROUP BY
  question.Id,
  question.Tags
--HAVING accepted_answer.Score < MAX(answers.Score)
--   AND accepted_answer.Score > 0
HAVING
  COUNT(answers.Id) = 1
ORDER BY MAX(answers.Score) DESC

Enter Parameters

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