SELECT * FROM (SELECT albumid,(SELECT COUNT(userName) FROM albumPhoto WHERE albumID=album.albumID) as albumCOUNT FROM album ) A WHERE albumcount =0