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 = '5342'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: 60 days cold strat may be enough
Looking for a unique and native addition to your garden? Consider the Calycanthus Occidentalis, also known as the Californian Allspice or Western Sweetshrub. This deciduous shrub is native to California and can grow up to 3 meters in height. It prefers a well-drained soil that is deep and moist, but it can also succeed in fertile soils. The plant produces aromatic bark that has been traditionally used as a substitute for cinnamon and all spice. It has also been used in treating sore throats, severe colds, and stomach disorders as it is an expectorant and stomachic. The Calycanthus Occidentalis also contains a light brown dye that can be obtained from its flowers. An added bonus: the plant is notably resistant to honey fungus. Add the Calycanthus Occidentalis to your garden and enjoy the unique fragrance and attractive appearance of this native plant.