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 = '34'
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 stat. and spring sowing
Abies fraseri, commonly known as Fraser fir, is a small to medium-sized evergreen coniferous tree native to the Appalachian Mountains of the southeastern United States. It is typically found at elevations of 4,500 to 6,900 feet, and is the only fir endemic to the region. Fraser fir is a popular Christmas tree, and is known for its long-lasting needles and fragrant scent.
The needles are fragrant and have a turpentine-like scent. The seed cones are held upright on the branches, which creates a lovely contrast against the deep green foliage. Fraser fir is a moderate grower, and can grow 6-12 inches per year. It is a good choice for a Christmas tree, as it can last for several weeks indoors.
Fraser fir is native to the southeastern United States, and is found in the Appalachian Mountains of North Carolina, Tennessee, and Virginia. The tree is endangered due to habitat loss, climate change, and pests and diseases.