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 = '1402'
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
Staphylea pinnata, also known as the European bladdernut, is a deciduous shrub that can grow up to 6 meters tall. Blooming from May to June, the plant produces small white, bell-shaped, fragrant flowers on panicles up to 13 cm long. These flowers are bisexual and pollinated by flies. The fruits are inflated papery capsules, 2-3 lobed, up to 4 cm tall, ripening from September to November. Not only is this plant visually stunning with its pinnate leaves, it is said to produce edible seeds that taste like pistachios. Staphylea pinnata can be grown in full sun to partial shade, and tolerates a variety of soils. It is hardy in zones 6-8 and requires regular watering. If you plan on growing this shrub, we recommend sowing stored seeds as early in the year as possible and giving them cold stratification – germination may not occur until the following spring.