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

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

fork query

edited may 17 anonymous

created may 25 10 sam.saffron