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 = '3436'
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 needs warm temperatures after sowing to germinate (75 degrees F +)
Looking for a fast-growing tree for your garden? Consider Celtis africana, commonly known as White Stinkwood. This deciduous tree is a member of the Cannabaceae family and is widespread throughout South Africa and Ethiopia. It's known for its pale trunk and branches and hemispherical canopy. Celtis africana is also a popular choice for bonsai enthusiasts. Browsing cattle and goats enjoy its leaves while birds feed on its plentiful fruit, making it an ideal tree for planning bird-friendly gardens. While it grows quite large, heavy branches can be managed with proper pruning. Bring a bit of Africa to your garden with the hardy and easily propagated Celtis africana.