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 = '254'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours, rinse 3 times
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Shadscale, also known as Spiny Saltbush, is a valuable evergreen shrub native to the western United States and northern Mexico. Its leaves make delicious greens when cooked and the water used can be added to corn pudding. The seeds can be made into a meal and used as a thickener in bread or mixed with flour. In winter, shadscale fruits and leaves provide important browse for both domestic livestock and native herbivores. Shadscale prefer sandy, well-drained soils and can tolerate moderately saline conditions. Its height varies from 1-3ft and its fruit does not have four wings like the fourwing saltbush. Its blooms can be seen from March to June. Shadscale saltbush is essential for providing cover for several species of small mammals and is great browse for deer and pronghorn. It is generally killed by fire and is a valuable component of the ecosystems it inhabits.