: SELECT tng_xnotes.ID as ID, tng_xnotes.note as note, tng_notelinks.persfamID as personID, tng_xnotes.gedcom as gedcom FROM (tng_xnotes, tng_notelinks) WHERE tng_xnotes.ID = tng_notelinks.xnoteID AND tng_xnotes.gedcom = "tree1" ORDER BY note LIMIT 50