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 = '3623'
group by i.id
Scarification: Soak in water, let stand in water for 48 hours
Stratification: cold stratify for 60 days
Germination: seed may start to germinate in cold strat., sow seed 1/4" deep, tamp the soil, mulch the seed bed
Introducing the Abies nordmanniana or Nordmann Fir - a species of fir native to the mountains in Turkey, Georgia, Russian Caucasus, and Armenia. It grows up to 60 meters tall and has a trunk diameter of up to 2 meters. With dark green needles, it is an evergreen coniferous tree perfect for Christmas tree production. Its unique foliage, with needles that are not sharp and do not drop readily when the tree dries out, make it a popular ornamental tree in parks and large gardens. In addition, the soft and white wood of the Nordmann Fir is used for general construction, paper, and more. At altitudes of 900-2,200 meters, this fir is a stunning sight to behold and is a great addition to any garden or landscape.