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 = '6155'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Discover the highly aromatic and flavorful herb, Foeniculum vulgare Sweet Fennel, a flowering plant species in the carrot family. With its yellow flowers and feathery leaves, fennel is a hardy, perennial herb that is indigenous to the shores of the Mediterranean but is now naturalized in many parts of the world. Fennel is used widely in cookery and medicinal treatments for digestive complaints, including the leaves, roots, and seeds. Sweet Fennel is an easily grown plant, succeeding in most soils and is drought tolerant once established. Fennel's bulb-like stem base is also used as a vegetable and is known as Florence fennel or Finocchio. Fennel seeds are a popular addition to sweet desserts and are also used in India, Afghanistan, Iran, and the Middle East as one of the most important cooking spices. Try Foeniculum vulgare Sweet Fennel in your garden today!