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 = '2836'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Origanum vulgare var. Virens Oregano is a versatile species that originates from Europe to China and enjoys full sun and dry soil. It produces attractive purple, pink, or white flowers in July and August, has aromatic leaves, and spreads via suckers. This herb is widely used in cooking and herbal remedies, with many forms in cultivation. Oregano is an essential ingredient in Mediterranean cuisine, particularly in Greece, Spain, and Italy, where it is used in tomato sauces, grilled meat, and strongly flavored dishes. Oregano combines well with pickled olives, capers, and lovage leaves. The leaves are antiseptic, antispasmodic, carminative, cholagogue, diaphoretic, emmenagogue, expectorant, stimulant, stomachic, and mildly tonic, and are commonly taken for colds, influenza, fungal infections, indigestion, stomach upsets, and enteric parasites. This herb has a high content of phenolic acids and flavonoids, making it a potent antioxidant with demonstrated antimicrobial activity against pathogens such as Listeria monocytogenes. Oregano is a must-have for anyone seeking to add a flavorful twist to their cuisine while harnessing the many health benefits of this herb.