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 = '9'
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 3/8" deep, tamp the soil, mulch the seed bed
Other: fall sowing in mulched beds is often prefered to artificial strat and spring sowing
Looking for a fragrant and symmetrically pyramidal tree for your garden or as a Christmas tree? Our Abies balsamea Balsam Fir is the perfect choice! Our Nova Scotia source seed is from the Balsam Fir Christmas Tree Capital of the World, ensuring high quality trees. The lustrous dark green needles are very aromatic, making this tree a popular choice for Christmas trees. But the benefits don't stop there - the resin obtained from the balsam fir has been proven to be a highly effective antiseptic and healing agent. It's used in propriety mixtures to treat coughs, diarrhoea, sore nipples, sore throats and much more. The leaves and young shoots are also used in folk remedies for treating coughs, colds, fevers and cancer. This plant was widely used medicinally by various North American Indian tribes. Looking for a tree with endless benefits? Look no further than Abies balsamea Balsam Fir.