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

Malacolog Version 4.1.1

6 records found

Full Current Name
Astralium brevispina (Lamarck, 1822)
Lithopoma americanum (Gmelin, 1791)
Lithopoma aspinosum (Usticke, 1971) [Dubious name]
Lithopoma caelatum (Gmelin, 1791)
Lithopoma tectum (Lightfoot, 1786)
Lithopoma tuber (Linnaeus, 1758)
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 = 'Lithopoma' or w.currentfullname like 'Lithopoma %' or w.originalcombination like 'Lithopoma %' or w.originalcombination like '%(Lithopoma)%') order by w2.systematicnumber, currentname.currentfullname edit your query