: SELECT repoID, reponame, tng_repositories.gedcom as gedcom, treename FROM tng_repositories INNER JOIN tng_trees on tng_repositories.gedcom = tng_trees.gedcom WHERE tng_repositories.gedcom = "tree1" ORDER BY reponame LIMIT 50