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 = '10'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: seed may start to germinate in cold strat., sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: fall sowing in mulched beds is often prefered to artificial strat and spring sowing
The Abies balsamea, also known as the Balsam Fir, is a popular tree commonly used as a Christmas tree in the northeastern USA. However, its uses extend beyond just its decorative value. The resin obtained from the Balsam Fir is an effective natural antiseptic and healing agent that has been used throughout the world for centuries. It is particularly renowned for its healing and analgesic properties, making it an excellent protective covering for burns, bruises, wounds, and sores, and a powerful curative for sore throat. The Balsam Fir buds, resin, and sap have been used in folk remedies to treat corns, warts and even cancers. This plant was widely used by various North American Indian tribes and is still used today due to its antiscorbutic, diuretic, diaphoretic, stimulant, and tonic properties. The tea made from the leaves is helpful in treating coughs, colds, and fevers. This tree is a slow grower but can reach a height of 75 feet at maturity, making it ideal for lumber, fuelwood, veneer, and naval store products. It is tolerant of shade, making it a great choice for landscaping projects in shaded areas. With its exceptional medicinal properties and its many uses, the Balsam Fir is truly a invaluable tree to have around.