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 = '749'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 30 days, cold stratify for 60 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed|sow seed 1/4 deep, tamp the soil, mulch the seed bed
Other: mechanical rupture of the pericarp is recommended before stratification
Experience the beauty of the Iris ensata, also known as the Japanese Iris or Japanese Water Iris. This stunning species features reddish-purple flowers that bloom in June and July. It thrives in wet places, including marshes, ditches, and even shallow water. Iris ensata requires acid soil for cultivation and prefers a light, well-drained soil in a sunny position. These elaborate and unusual cultivars come in various colors such as whites, pinks, purples, and bluish mauves. Native to Korea, China, Central Asia, and Japan, this species is widely cultivated as an ornamental plant. It is highly prized in Japan and has been cultivated and hybridized there for centuries. In the West, it has been intensively hybridized to produce many beautiful new cultivars. Discover the beauty of Iris ensata and its many exquisite cultivars that showcase large blooms and a wide range of colors. Choose from a variety of award-winning cultivars, such as 'Aldridge Visitor', 'Alpine Majesty', 'Flying Tiger', and 'Hue and Cry'. Whether you grow them in gardens, parks, or containers in pond margins, these Japanese Irises will surely enhance any landscape with their distinctive beauty.