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 = '379'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: No pre-germination treatment required. Sow immediately., surface sow and keep moist, tamp the soil, mulch the seed bed
Looking for a fast-growing tree that stabilizes soil and has multiple uses? Look no further than the Catalpa bignonioides, also known as the Southern Catalpa. This medium-sized deciduous tree boasts heart-shaped leaves, trumpet-shaped white flowers with yellow spots, and long, thin bean-like pods. It prefers moist soil and full sun, and is easily grown from seeds or cuttings. Additionally, the wood is coarse and straight-grained, making it ideal for posts, fencing rails, and even cabinet work. The tree is also fairly disease and pest-resistant. Bonus: the Catalpa worms it produces are highly sought after for fishing bait, particularly for catfish! Widely grown as an ornamental tree, the Catalpa bignonioides is a beauty to behold and a valuable addition to any garden or landscape.