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 = '1297'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 3/8" deep, tamp the soil, keep moist, mulch the seed bed, can be sown outdoors in the fall for spring germination
Other: if boiling water treatment does not allow seed to imbibe, sulfuric acid treatment is required
Looking for an attractive, hardy plant to liven up your garden? Look no further than the Staghorn Sumac. This deciduous shrub to small tree is native to eastern North America and can be found in Southeastern Canada, the Northeastern and Midwestern United States, Southern Ontario, and the Appalachian Mountains. The Staghorn Sumac is an attractive plant, with compound leaves that turn scarlet, orange, and yellow in the fall. It grows in any dryish soil and produces greenish flowers in early summer, followed by fuzzy crimson fruit clusters that last through winter. The seed heads can be used to make a tea with a vaguely raspberry flavor, and the middle of a broad dome-shaped colony would be a fine place to have a picnic. The Staghorn Sumac also has many other uses beyond its ornamental value. The leaves are rich in tannin, up to 48% has been obtained in a controlled plantation, and can be used as a brown dye or as a mordant. The bark, especially the root bark, and the fruits are also very rich in tannin. A yellow dye can be obtained from the roots, and an orange dye from the inner bark and central pith of the stem, mixed with bloodroot. The leaves and fruit can also be boiled to make black ink. The Staghorn Sumac is a hardy plant that can be grown under a wide array of conditions, but is most often found in dry and poor soil. It can be cultivated for ornamental uses or planted for wildlife cover in various ecosystems. Add the Staghorn Sumac to your garden for its beauty and versatility.