select i.*, substring_index(group_concat(distinct pa.country order by rsi.date_added desc),',',-1) as source_country
from inventory_item_manage i
left outer join sheffields_2017.receiving_shipments_item_has_inventory_item hrsi on i.id = hrsi.inventory_item_id
left outer join sheffields_2017.receiving_shipments_item rsi on rsi.id = hrsi.receiving_shipments_item_id
left outer join sheffields_2017.po on rsi.po_id = po.id
left outer join sheffields_2017.po_address pa on pa.po_id = po.id
where i.inventory_id = '700195'
group by i.id
Stratification: warm stratify for 30 days, cold stratify for 30 days
Germination: sow seed 1/16" deep , tamp the soil, keep moist
Artemisia tridentata ssp. wyomingensis, also known as Wyoming Big Sagebrush, is a highly aromatic shrub that grows in drier regions of the sagebrush steppe. It typically has low shrub density and little herbaceous cover surrounding the plant. However, it provides food and habitat for various species such as sage grouse, pronghorn antelope, grey vireo, pygmy rabbit, and mule deer. Sagebrush is not a desert plant but is found in the steppe regions that receive 18-40cm of annual precipitation. The infusion of its leaves is used by the Zuni people for treating body aches, as cold medicine, and for treating athlete's foot and fissures between toes. Sagebrush also has several medicinal properties due to the presence of camphor, terpenoids, and tannins. However, its oils are toxic to the liver and digestive system of humans, and care must be taken during any form of internal use. Sagebrush is an important part of the Great Basin habitat, and its conservation is threatened by human settlements, conversion to agricultural land, invasive species, livestock grazing, wildfires, and climate change.