: SELECT repoID, reponame, .gedcom as gedcom, treename FROM LEFT JOIN on .gedcom = .gedcom ORDER BY reponame LIMIT