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 = '887'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: sow in the spring outdoors a week before the date of the last frost, 1/4 inch deep.
Add a pop of deep purple to your garden with Malva sylvestris ssp. mauritiana (High Mallow). This biennial or perennial herb produces 2 1/2" deep purple flowers on a plant that resembles a small hollyhock. Native to Europe, north Africa, and northwest China, this herb likes full sun and can be used as a garnish or added to salads. The leaves have a mild pleasant flavor and can be eaten raw or cooked, making them a great thickener for soups or a lettuce substitute in salads. This plant can grow up to three feet tall and its stems are covered in fine soft hairs. Don't miss out on the opportunity to add this beautiful and edible plant to your garden.