MySQL for finding members with profile pics but not avatars

[Soliloquy]

Thanks kh99, from that I was able to figure out the rest of the query:

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) AND
	EXISTS (SELECT * FROM vb_customprofilepic AS profile WHERE profile.userid = user.userid)
ORDER BY username asc