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 = '175'
group by i.id
Germination: sow indoors 2 months before the date of the last frost
Alcea rosea, also known as Common Hollyhock, is a beautiful ornamental plant in the Malvaceae family. It is a hardy plant that can easily reach a height of about 8 feet and can be grown in a wide range of soils. The flowers come in a range of colors from white to dark red, including pink, yellow, and orange. But this plant is not just a pretty face - it has many other uses! The flower petals can be used to make a refreshing tea, while a nutritious starch is obtained from the root. The flowers also have medicinal properties and are useful in the treatment of chest complaints. The stems can be used to make fiber for papermaking, and the red anthocyanin constituent of the flowers is used as a litmus. Alcea rosea is easily grown from seed and readily self-seeds. Don't miss the chance to add this versatile plant to your collection!