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

SELECT
  Question.Id, Question.OwnerDisplayName
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
  /* Sockpuppetted questions probably won't be that great anyway */
  AND Question.Score < 10
  /* Sockpuppetted accounts won't have great rep */
  AND Users.Reputation < 1000
  /* Limit posts whilst testing */
  AND Question.Id < 5000

view current version

edited aug 18 12

created aug 18 12 halfer