Top SO users from China

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

SELECT TOP 100 USERS.ID, USERS.DISPLAYNAME, COUNT(POSTS.ID) 
FROM POSTS 
RIGHT JOIN USERS ON USERS.ID = POSTS.OWNERUSERID 
GROUP BY USERS.ID, USERS.DISPLAYNAME, POSTS.POSTTYPEID 
HAVING POSTS.POSTTYPEID = 1 AND COUNT(POSTS.ID) = 0

Enter Parameters

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