SELECT U.*, COUNT(M.ID) AS NoOfMaps FROM `doma_users` U LEFT JOIN `doma_maps` M ON U.ID=M.UserID WHERE U.Visible=1 GROUP BY U.ID, U.LastName, U.FirstName, U.Username, U.Password, U.Email, U.Visible, U.DefaultCategoryID ORDER BY U.LastName, U.FirstName, U.ID