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 = '6515'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
In a Nutshell:
* Eremurus robustus is a plant native to the Tien Shan and Pamir Mountains in central Asia that is often used as an ornamental plant. It often goes by the common name Foxtail lily.
E. robustus has a stem six to ten feet high, with leaves as long as 48 inches, and 4 inches in width, the widest in its genus. The leaves can vary from a bright green to a bluish-green in color. Inflorescence goes to four feet in length which is covered with many deep to pale pink flowers, four cm across.
* The plant was introduced from Central Asia in 1874 and is popular in gardens. However some may find the plant to be too tall for normal gardens. It prefers sandy, well-drained soil and full sun. more...
Â Eremurus robustus is a PERENNIAL growing to 3 m (9ft) by 1 m (3ft 3in). It is hardy to zone 6 and is not frost tender. It is in flower in June. The flowers are hermaphrodite (have both male and female organs) and are pollinated by Bees.It is noted for attracting wildlife. The plant prefers light (sandy) and medium (loamy) soils and requires well-drained soil.The plant prefers acid, neutral and basic (alkaline) soils..It cannot grow in the shade.It requires dry or moist soil and can tolerate drought.