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 = '976'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Looking for a stunning ornamental tree for your garden? Look no further than the Picea smithiana Himalayan Spruce, also known as the Morinda Spruce. This large evergreen tree grows up to 60 meters tall and has a conical crown with pendulous branchlets, making it an eye-catching addition to any landscape. Native to the western Himalayas, it thrives in moist soil and is often found growing alongside deodar cedar, blue pine, and pindrow fir. While it may not be the fastest grower, it produces high-quality timber and paper and is an important species within its native range. Hardy down to -5 to -10°C, this spruce is perfect for gardens in zones 7 and 8. So if you're looking for a unique and beautiful tree to create a focal point in your garden, consider the Picea smithiana Himalayan Spruce, the Morinda Spruce.