Whose questions have you answered

2

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

SELECT
  question.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
    answer.owneruserid = ##userid##
   AND
    answer.parentid = question.id
GROUP BY
    question.owneruserid
ORDER BY
    number DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results