MySQL for finding members with profile pics but not avatars

[kh99]

It looks like if a user has no avatar, the user.avatarid is 0 and there's no record in the customavatar table with that userid. So I think you want.

SELECT username, posts
FROM vb_user as user
WHERE user.avatarid = '0' AND 
    NOT EXISTS (SELECT * FROM vb_customavatar AS custom WHERE custom.userid = user.userid)
ORDER BY posts desc