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 = '6533'
group by i.id
Germination: Best sown as soon as it is ripe in the autumn in a cold frame. Sow stored seed in a greenhouse as soon as it is obtained.
Other: Germination is slow and could take 1 - 6 months at 15°c.
Introducing the stunning Eremurus spectabilis Foxtail Lily, a perennial plant that grows up to 1 meter tall and 0.6 meters wide. This plant is hardy to zone 6 and is not affected by frost, making it a great addition to any garden. The stunning yellow flowers bloom from May to June and attract pollinators such as bees with their sweet nectar. Not only is this plant beautiful, but it has versatile uses too. Its young shoots can be cooked and enjoyed as a delicacy in Siberia, with a flavour that is said to be a mix of purslane and spinach. The root is also valuable, containing about 30% gum (an arabinic acid derivative) that makes a high-quality glue. Additionally, the bulb is dried and powdered to be used in sizing cloth, bookbinding, and more. This plant prefers light and medium (loamy) soils that are well-drained and can tolerate drought. It cannot grow in shade and prefers acidic, neutral, and basic (alkaline) soils. Don't miss out on the chance to add the show-stopping Eremurus spectabilis Foxtail Lily to your garden today!