select i.*, as2.state_abbr
from inventory_item_manage i
left outer join sheffields_2017.address_states as2 on (as2.state_name = i.CollectionLocale or as2.state_abbr = i.CollectionLocale)
where i.inventory_id = '1479'
group by i.id
* Veratrum album , commonly known as the False Helleborine (also known as White Hellebore , European White Hellebore , White Veratrum , syn. Veratrum lobelianum Bernh. ), is a medicinal plant of the Liliaceae (lily family) or Melanthiaceae which is native to Europe . more...
* Upright stems topped by 1/2-1" flowers in a branched flower head, white, green, or yellowish, grows in wet, grassy subalpine meadows and open woods, flowers in June or July, attractive pleated leaves, to 1' long, 6" wide, native from northern Europe across Asia to Alaska.