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 Drupal developers and administrators

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 P.ParentId IS NOT NULL

fork query

edited may 17 anonymous

created may 25 10 sam.saffron