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 = '698116'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
;"Dipsacus sativus Cultivated Teasel, Fuller's Teasel, Indian Teasel" is a biennial/perennial plant that grows up to 1.8m tall and is primarily cultivated for its seed head, which is used for carding cloth. Formerly widely used in textile processing for cleaning, aligning, and raising the nap on fabrics, particularly wool, it has now been largely replaced by metal cards. However, some people who weave wool still prefer to use teasels for raising the nap, claiming that the result is better. The dried flower heads are also much prized by flower arrangers because they keep their color almost indefinitely when dried. The roots are also used for medicinal purposes, with an infusion said to strengthen the stomach, create an appetite, remove obstructions of the liver and treat jaundice. The plant has a folk history of use in the treatment of cancer, warts, wens, and whitlows. A homeopathic remedy is made from the flowering plant and is used in the treatment of skin diseases. The plant can grow in most soils but prefers clay and requires a sunny position. It is occasionally cultivated in central and southern Europe, Russian Asia, the Caucasus, Iran, and Pakistan. The plant is hardy to zone (UK) 5 and is not frost tender.