SELECT u.userId, u.firstName, u.lastName, u.userName, COUNT(e.entryId) as entryCount FROM `User` as u LEFT JOIN Entry as e ON u.userId = e.postedByUserId GROUP BY u.userId, u.firstName, u.lastName, u.userName ORDER BY u.firstName, u.lastName SELECT userId FROM `User` WHERE userId != AND userName =