Top 500 answerers on the site

0

Please login or register to vote for this query.

(click on this box to dismiss)

A list of the top 500 users with the highest average answer score excluding community wiki / closed posts or users with less than 10 answers

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

SELECT REQUEST.ID,
       REQUEST.TITLE,
       REQUEST.BODY as REQUEST,
       RESPONSE.BODY as ANSWERS
FROM (SELECT P.ID, P.TITLE, P.BODY, P.CREATIONDATE, T.TAGNAME
      FROM TAGS T
      JOIN POSTTAGS PT ON T.ID = PT.TAGID
      JOIN POSTS P ON P.ID = PT.POSTID
      WHERE TAGNAME = 'python'
      AND PARENTID IS NULL
      AND DATEDIFF(MONTH, CREATIONDATE, CURRENT_TIMESTAMP) < 6) AS REQUEST
JOIN (SELECT *
      FROM POSTS
      WHERE PARENTID IN (SELECT P.ID
                         FROM TAGS T
                         JOIN POSTTAGS PT ON T.ID = PT.TAGID
                         JOIN POSTS P ON P.ID = PT.POSTID
                         WHERE TAGNAME LIKE 'python'
                         AND DATEDIFF(MONTH, CREATIONDATE, CURRENT_TIMESTAMP) < 6)) AS RESPONSE
ON RESPONSE.PARENTID = REQUEST.ID

Enter Parameters

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