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 = '700302'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 90 days, cold stratify for 90 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: Germination tends to be slow, Germinates faster in warmer temperatures.
Looking to add a fragrant and visually appealing plant to your garden? Look no further than Osmanthus americanus (Synonym Cartrema americana), also known as American olive, wild olive, or devilwood. This evergreen shrub or small tree is native to southeastern North America and Mexico, and grows up to 36 feet tall. Its glossy, leathery leaves form a narrow, oblong crown, while its creamy-white flowers emit a strong fragrance in early spring. The small blue-black fruit that follows is similar to cherries and resembles cultivated olives. Devilwood gets its name from its wood, which is fine-textured and difficult to work with. This plant is dioecious; that is, male pollinator plants are required to get a female fruit set. This plant is a fantastic ornamental addition to gardens and is sure to impress with its fragrant and attractive appearance.