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 = '16'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
The Abies cephalonica Greek Fir is a stunning and unique tree that is native to the mountains of Greece. Growing to a height of 25-35 meters, this medium-sized evergreen coniferous tree is perfect for adding a touch of sophistication to any park or large garden. Its needle-like leaves are glossy dark green above, with two blue-white bands of stomata below, and the cones are approximately 10-20 cm long with about 150-200 scales. Though the Greek Fir was important for wood construction in the past, it’s too rare to be of significant value nowadays. However, it is an ideal tree for adding beauty and variety to any landscape. While it’s prone to frost damage in areas that often get late frosts, this unique tree is sure to impress visitors and elevate any space it grows in.