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 = '244'
group by i.id
Stratification: warm stratify for 30 days, cold stratify for 30 days
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Artemisia dracunculus, commonly known as tarragon, is a perennial herb in the Asteraceae family. It is native to temperate Europe and Asia, but is now cultivated worldwide for its culinary and medicinal properties. Tarragon has a strong, anise-like flavor and aroma, and is used in a variety of dishes, including sauces, salads, and fish dishes.
It is also used in traditional medicine to treat a variety of ailments, including digestive problems, flatulence, and menstrual cramps. Tarragon is a hardy plant that is easy to grow in most climates. It prefers full sun and well-drained soil. The leaves can be harvested fresh or dried, and should be stored in a cool, dark place. The name "tarragon" comes from the Greek word "drakontion," which means "dragon." This is thought to be a reference to the long, narrow leaves of the plant, which resemble dragon tongues.