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 = '6520'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 120 days
Germination: sow seed 1/16" deep, tamp the soil and keep moist.
Other: Germination may be irregular and some seed may lie over 2 years before germination.
In a Nutshell:
* Iris magnifica is a bulbous flowering plant in the genus Iris, native to the mountains of Central Asia. It is cultivated as an ornamental plant in temperate regions – growing to 60 centimetres (24 in) (less in poor soils), and producing pale lilac and white flowers in spring.
* This plant has gained the Royal Horticultural Society's Award of Garden Merit. more...