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 = '6508'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: surface sow and keep moist
Other: germination may be delayed for up to 90 days
Artemisia stelleriana, also known as Dusty Miller, Beach Wormwood, and Oldwoman, is an attractive perennial plant that belongs to the sunflower family. Its pale-green leaves are covered with woolly hairs, giving it a silver or whitish appearance. The plant produces yellow flowers that grow in tall clusters and bloom from July to late August. This versatile plant is native to Asia and North America, including China, Japan, Korea, Russian Far East, and the Aleutian Islands in the United States. It is drought-tolerant and thrives in a well-drained sandy soil and a sunny position. The leaves of this plant are used for flavouring rice dumplings. Established plants of Artemisia stelleriana are drought tolerant, and some named forms have been selected for their ornamental value. This plant is commonly used in gardens, and it is naturalized in scattered locations in North America and Scandinavia. Members of this genus are rarely troubled by browsing deer. Give your garden a touch of elegant beauty with Artemisia stelleriana.