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 = '588'
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/16" deep, tamp the soil, mulch the seed bed
Other: seed can be treated with Captan (4 tablespoons/gallon of water) during stratification to prevent fungal problems
Looking for an elegant and long-lived evergreen tree to add character to your garden? Look no further than Hesperocyparis sempervirens Italian Cypress. This stunning coniferous tree boasts a conical crown with level branches, and variably loosely hanging branchlets, making it perfect for creating a signature Mediterranean look to your landscape. Native to the eastern Mediterranean region, this medium-sized evergreen tree is very long-lived, with some trees estimated to be over a thousand years old. It has dark green, dense foliage that grows in sprays of scale-like, 2-5mm long leaves on rounded shoots. The tree also produces ovoid or oblong seed cones that mature from green to brown within 20-24 months after pollination. Its beautiful, durable wood is ideal for a wide range of applications, from building uses to cabinet making and wardrobes, and an essential oil distilled from its shoots is used in perfumery and soap-making. Moderate susceptibility to cypress canker isn't enough to detract from the beauty of its fragrant and impervious wood. So, add some Mediterranean charm to your garden with this stunning tree today!