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 = '1478'
group by i.id
Germination: sow seed 1/16" deep , tamp the soil, keep moist
Valeriana officinalis, also known as Common Valerian or Garden Valerian, is a hardy perennial flowering plant native to Europe and Asia. It bears sweetly scented pink or white flowers in the summer months, attracting many fly species. Valerian has been used as a medicinal herb since ancient times, with documented use by Hippocrates and Galen for insomnia and as an antiseptic, anticonvulsant, migraine treatment and pain reliever. Today, it is commonly sold in dietary supplement capsules to promote sleep due to its sedative and anxiolytic effects. Valerian extracts are available in both standardized and unstandardized forms, with standardized products being preferred for their consistent levels of valerenic acid or valeric acid. Due to its potential to produce central nervous system depression, valerian should not be used with other depressants such as ethanol, benzodiazepines, barbiturates or opiates. Valerian root has a similar effect on cats as catnip. Valeriana officinalis is also sometimes considered a weed and can be invasive. Overall, Valeriana officinalis is a versatile and popular choice for those seeking an herbal sleep aid.