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 = '43'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Abies lasiocarpa, also known as the Subalpine Fir or Rocky Mountain Fir, is a beautiful evergreen tree found in western North America. It grows up to 25m tall and features a very narrow conic crown and smooth grey bark, becoming fissured on mature trees. The needles are flat and needle-like, with a broad stripe of stomata and blue-white bands below. This tree is typically found at high altitudes, from 300-900m in the north to 2,400-3,650m in the south, and is commonly found at and immediately below the tree line. The wood is used for structural purposes and paper manufacture, or as a popular Christmas tree. Subalpine Fir's ornamental qualities are also appreciated, with its strikingly glaucous-blue foliage making it an attractive addition to any landscape. Experience the beauty of Abies lasiocarpa in your garden or forestry project today!