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 = '2044'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 180 days, cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: acid treatment can be used in substitution for warm stratification
Looking for a beautiful and unique addition to your garden or landscape? Consider Staphylea bumalda Bumalda Bladdernut! This deciduous suckering shrub features delicate white flowers in May or June, followed by eye-catching inflated yellowish fruits to 1". Its opposite compound leaves have three 2" leaflets, and the plant is native to Japan, Korea, and China, where it grows in woods and along streams. Staphlea bumalda is easy to grow in sun or part shade, and is capable of tolerating a wide range of soils so long as they are not too dry. The shrub typically grows to 4-6' tall and as wide, and its fragrant flowers give way to somewhat compressed two-lobed fruits (seed capsules to 1" long). Notably resistant to honey fungus, this shrub prefers a rich loamy soil in full sun or semi-shade. While the Japanese form of this species may be rather tender in Britain, Bumald bladdernut is generally hardy to about -25°c and will flower best in hot summers. Add a touch of beauty and uniqueness to your garden or landscape with Staphylea bumalda Bumalda Bladdernut!