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 = '380'
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,
Catalpa ovata, also known as Chinese Catalpa, Japanese Catalpa, or Yellow Catalpa, is a beautiful pod-bearing tree native to China. Its creamy white flowers, which bloom in July and August, are considered to be one of the best bee plants in Japan and are extremely fragrant. The tree typically reaches heights between 20 and 30 feet and has three-lobed dark green leaves, which are very similar in shape to those of Paulownia tomentosa. The bark of mature trees is fissured, prominently ridged and pale gray-brown. While native to China, Catalpa ovata is commonly found in North America and Europe. Its fruits are narrow, foot-long pods, and it is commonly used to make the undersides of qin. The stems of this tree also have medicinal benefits and are known for its diuretic effects. If you are looking for a unique and fragrant addition to your garden, the yellow catalpa may be the perfect fit for your space.