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 = '964'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: seed is sensitive to excess moisture in the medium
Looking for an eye-catching and versatile evergreen tree to add to your garden? Consider the Picea orientalis, commonly known as the Oriental Spruce or Caucasian Spruce. Native to the Caucasus and adjacent northeast Turkey, this large evergreen can grow up to 45 meters tall and has a trunk diameter of up to 1.5 meters. Its dark green needles are the shortest of any spruce, at only 6-8 mm, and it forms a dense, narrow cone shape. It prefers shelter from dry winter winds but can grow on a wide range of soils. The Oriental Spruce is a popular ornamental tree in gardens across northern Europe and the USA, thanks to its attractive foliage. It's also grown for timber, paper production, and Christmas trees, though its slower growth compared to other spruces reduces its importance. The Picea orientalis was even awarded the Royal Horticultural Society's Award of Garden Merit, and the 'Aureospicata' cultivar has gold-colored foliage in spring. Consider the Oriental Spruce a fantastic and versatile addition to your garden.