0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

/*
Answering questions is encouraged on StackOverflow, but users of low
rep do sometimes create low-quality question-and-answers to attract the
odd bit of rep. This query helps weed that out.
*/
SELECT TOP 10
  Question.Id,
  Question.CreationDate,
  Question.Title
FROM
  Posts Question
INNER JOIN Posts Answer ON (Answer.ParentId = Question.Id)
INNER JOIN Users ON (Users.Id = Question.OwnerUserId)
WHERE
  Question.PostTypeId = 1
  AND Answer.PostTypeId = 2
  /* The asker has answered their own question */
  AND Question.OwnerUserId = Answer.OwnerUserId
  /* Such questions probably won't be that great anyway */
  AND Question.Score < 10
  /* Involved account won't have great rep */
  AND Users.Reputation < 500
  /* Limit posts whilst testing */
/* Most recent items probably won't be detected yet */
ORDER BY Question.CreationDate DESC

fork query

edited aug 18 12

created aug 18 12 halfer