Full Current Name Hespererato maugeriae (Gray, 1832) Pachybathron cypraeoides (C. B. Adams, 1845) Eratoidea hematita (Kiener, 1834) 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 = 'Erato' or w.currentfullname like 'Erato %' or w.originalcombination like 'Erato %' or w.originalcombination like '%(Erato)%') order by w2.systematicnumber, currentname.currentfullname edit your query