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 = '3175'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 12 hours. If the seed fails to imbibe, boiling water may be required.
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: Hardness of seedcoat will determine how much scarification is required
Looking to add some native flair to your outdoor space? Look no further than the Sophora microphylla, also known as Kowhai. This evergreen shrub or small tree, native to New Zealand, grows up to 8 metres tall and wide, with shiny oval leaflets and many racemes of brightly coloured, pea-like yellow flowers in early spring. What sets the Sophora microphylla apart from other Kowhai species is its smaller leaves and flowers – perfect for those looking for a more delicate look. After the vibrant flowers come the distinctly segmented pods, each containing six or more hard, yellow seeds that quickly identify the presence of a nearby Kowhai tree. While most Kowhai trees lose their leaves quickly after blooming, the Sophora microphylla holds onto its foliage. And if you're worried about attracting honeybees, take note – the nectar is toxic to this species. Add some New Zealand charm to your garden or outdoor space with the distinct and delicate Sophora microphylla.