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 = '6158'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Discover the wonders of Tagetes patula, also known as French Marigold! This vibrant annual flowering plant, part of the daisy family, is not only a beautiful addition to any garden or borders, but it also has some amazing benefits. Its secretion from the roots acts as a natural insecticide, effective against nematodes and slugs. The whole plant can be harvested for its essential oil, which is widely used in perfumery and produces the exotic 'attar genda' perfume. Additionally, French Marigold also contains substances that repel tomato-munching whiteflies and cockroaches. This low-growing plant with red and yellow hues is perfect for edging borders and has herbal and medicinal uses. Its yellow dye is also used to color food and textiles. Don't miss out on this fantastic plant that attracts pollinating wildlife and adds a pop of color to your garden! Learn more about Tagetes patula on our website.