Full Current Name Austrodrillia albobalteata (E. A. Smith, 1890) Pleurotoma albobalteata E. A. Smith, 1890 Buchema bellula (E. A. Smith, 1882) Pleurotoma bellula E. A. Smith, 1882 Buchema interstrigata (E. A. Smith, 1882) Pleurotoma caribbaea E. A. Smith, 1882 Pleurotoma interstrigata E. A. Smith, 1882 Drillia interpleura auct. non Dall & Simpson, 1901 Drillia euphanes Melvill, 1923 Neodrillia euphanes Melvill, 1923 Clavus cantharis (Reeve, 1845) [Extralimital] Pleurotoma cantharis Reeve, 1845 [Extralimital] Pleurotoma scarabaeus Reeve, 1846 Drillia marmarina (Watson, 1881) Pleurotoma marmarina Watson, 1881 Clavatula marmarina Watson, 1881 Drillia sinuosa (Montagu, 1803) Murex sinuosus Montagu, 1803 Pleurotoma amanda E. A. Smith, 1882 Eldridgea johnsoni Bartsch, 1934 Eldridgea johnsoni Bartsch, 1934 Tylotia cadenasi Clench & Aguayo, 1939 Clavus cadenasi Clench & Aguayo, 1939 Inodrillia prolongata (E. A. Smith, 1890) Pleurotoma prolongata E. A. Smith, 1890 Splendrillia coccinata (Reeve, 1845) Pleurotoma coccinata Reeve, 1845 Drillia coccinata Reeve, 1845 Cerodrillia coccinata Reeve, 1845 Pleurotoma interpunctata E. A. Smith, 1882 Drillia innocens Melvill, 1923 Douglassia nodosa Usticke, 1969 Viridrillia cervina Bartsch, 1943 Clavus ebur auct. non Reeve, 1845 Drillia ebur auct. non Reeve, 1845 Viridrillia cervina Bartsch, 1943 Cerodrillia cervina Bartsch, 1943 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 = 'Clavus' or w.currentfullname like 'Clavus %' or w.originalcombination like 'Clavus %' or w.originalcombination like '%(Clavus)%') order by w2.systematicnumber, currentname.currentfullname edit your query
