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 = '37'
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
Grand fir is a large evergreen conifer that can grow up to 70 meters (230 feet) tall.
It is native to the Pacific Northwest and Northern California of North America, where it is found at altitudes of sea level to 1,700 meters (5,600 ft).
Grand fir is a fast-growing tree that can reach maturity in as little as 60 years.
It has a conical crown with drooping branches.
The bark is thin and reddish-brown, and the needles are flattened, dark green, and 2-3 centimeters (0.8-1.2 inches) long.
The seed cones are cylindrical and 4-6 centimeters (1.6-2.4 inches) long.
Grand fir is a shade-tolerant tree that can grow in a variety of soils, but it prefers moist, well-drained soils.
It is a popular tree for timber and Christmas trees.
The wood of grand fir is strong and lightweight, and it is used for a variety of purposes, including construction, furniture, and flooring.
Grand fir is a popular Christmas tree because it has long-lasting needles and a pleasant scent.
The tree is also a source of nectar for bees and other pollinators.
Grand fir is susceptible to a number of pests and diseases, including the balsam woolly adelgid, which can kill young trees.
However, grand fir is a relatively resilient tree and can often recover from damage.