0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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

fork query

edited nov 27 anonymous

created jul 3 18 YCF_L