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

Islam Meta

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

SELECT REQUEST.ID,
       REQUEST.TITLE,
       REQUEST.BODY,
       RESPONSE.BODY
FROM (SELECT TOP 10 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 = 'java' AND ParentId IS NULL
        AND DATEDIFF(MONTH, CREATIONDATE, CURRENT_TIMESTAMP) < 6) AS REQUEST
         JOIN (
             SELECT P.ParentId, P.BODY
              FROM TAGS T
                       JOIN POSTTAGS PT ON T.ID = PT.TAGID
                       JOIN POSTS P ON P.ID = PT.POSTID
              WHERE T.TAGNAME = 'java' 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