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 = '611'
group by i.id
Other: The seed usually germinates in 2 - 4 weeks.
Digitalis Ferruginea Rusty Foxglove is a stunning biennial or short-lived perennial plant native to southern Europe and Turkey. The yellowish flowers are marked with rusty red, particularly on the inside, in spikes, and bloom in summer. This easily grown plant thrives in full or part sun and dry, well-drained soil, and prefers semi-shade but can tolerate drought. The leaves are cardiac, stimulant and tonic, often used in the treatment of certain heart complaints. It grows to a height of 1.2m (4ft) and can be grown in light (sandy), medium (loamy), and heavy (clay) soils, in acid, neutral, and basic (alkaline) soils. It is an ornamental plant suitable for woodland gardens and shady edges. Propagate through the seed sown in early spring or autumn. A must-have for discerning gardeners!