: SELECT count(personID) as pcount, tng_trees.gedcom, treename, description FROM tng_trees LEFT JOIN tng_people on tng_trees.gedcom = tng_people.gedcom GROUP BY tng_trees.gedcom ORDER BY treename LIMIT 50