Malacolog 4.1.1: Western Atlantic Mollusk Species Database at The Academy of Natural Sciences

Malacolog Version 4.1.1

10 records found

Full Current Name
Busycon candelabrum (Lamarck, 1816)
Busycon carica (Gmelin, 1791)
Busycon coarctatum (Sowerby I, 1825)
Busycon laeostomum Kent, 1982
Busycon lyonsi Petuch, 1987
Busycon perversum (Linnaeus, 1758)
Busycon pulleyi Hollister, 1958
Busycon sinistrum Hollister, 1958
Busycotypus canaliculatus (Linnaeus, 1758)
Busycotypus plagosus (Conrad, 1862)
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 = 'busycon' or w.currentfullname like 'busycon %' or w.originalcombination like 'busycon %' or w.originalcombination like '%(busycon)%') order by w2.systematicnumber, currentname.currentfullname edit your query