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

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT REQUEST.ID        AS REQUESTID,
       REQUEST.TITLE     AS REQUESTTITLE,
       REQUEST.BODY      AS REQUESTBODY,
       RESPONSE.PARENTID AS RESPONSEPARENTID,
       RESPONSE.BODY     AS RESPONSEBODY
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 P.ID = 77716741
        AND DATEDIFF(MONTH, CREATIONDATE, CURRENT_TIMESTAMP) < 6) AS REQUEST
         JOIN (SELECT ParentId, Body
                 FROM Posts )AS RESPONSE
          ON RESPONSE.ParentId = REQUEST.Id

Enter Parameters

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