Full Current Name Brocchinia clenchi Petit, 1986 Cancellaria mitraeformis auct. non Brocchi, 1814 Cancellaria pusilla H. Adams, 1869 Brocchinia clenchi Petit, 1986 Brocchinia harasewychi Barros & Lima, 2006 Brocchinia harasewychi Barros & Lima, 2006 Brocchinia nodosa (Verrill & Smith, 1885) Admete nodosa Verrill & Smith, 1885 Brocchinia pustulosa Verhecken, 1991 Brocchinia pustulosa Verhecken, 1991 Brocchinia verheckeni Barros & Lima, 2006 Brocchinia verheckeni Barros & Lima, 2006 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 = 'Brocchinia' or w.currentfullname like 'Brocchinia %' or w.originalcombination like 'Brocchinia %' or w.originalcombination like '%(Brocchinia)%') order by w2.systematicnumber, currentname.currentfullname edit your query