Full Current Name Hemitoma emarginata (Blainville, 1825) Emarginula emarginata Blainville, 1825 Subemarginula emarginata Blainville, 1825 Subemarginula retiporosa Dall, 1903 Emarginula ostheimerae Abbott, 1958 Hemitoma octoradiata (Gmelin, 1791) Patella notata auct. non Linnaeus, 1758 Subemarginula octoradiata Gmelin, 1791 Patella octoradiata Gmelin, 1791 Emarginula tricostata Sowerby I, 1823 Emarginula depressa auct. non Blainville, 1824 Emarginula listeri Anton, 1838 Emarginula clausa d'Orbigny, 1847 Emarginula guadaloupensis Sowerby II, 1863 Patella confusa Krebs, 1864 Emarginula octocostata Mörch, 1878 Emarginula tensa Guppy, 1895 Hemitoma rubida A. H. Verrill, 1950 Your query was: select distinct w2.nameid, currentname.currentfullname, currentname.currentnameid, w2.online_list from wasp as w left join currentname on w.currentnameid = currentname.currentnameid left join wasp as w2 on currentname.currentnameid = w2.currentnameid where w2.statussort = '1' and ( w.originalgenus = 'Hemitoma' or w.currentfullname like 'Hemitoma %' or w.originalcombination like 'Hemitoma %' or w.originalcombination like '%(Hemitoma)%') order by w2.systematicnumber, currentname.currentfullname edit your query