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 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 = 'java'
      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 'java'
                         AND DATEDIFF(MONTH, CREATIONDATE, CURRENT_TIMESTAMP) < 6)) AS RESPONSE
ON RESPONSE.PARENTID = REQUEST.ID
where REQUEST.ID = 77716741

fork query

edited may 17 jon.doe44630

created may 25 10 sam.saffron