Whose questions have you answered

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

SELECT
  answer.owneruserid as [User Link],
  count(*) as number
FROM 
    posts as question
 INNER JOIN
    posts as answer
  ON
    question.posttypeid = 1
   AND
    answer.posttypeid = 2
   AND
    question.owneruserid = ##userid##
   AND
    answer.parentid = question.id
GROUP BY
    answer.owneruserid
ORDER BY
    number DESC

Enter Parameters

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