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 = '318'
group by i.id
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Introducing the Calendula officinalis 'Orange King', also known as the Orange King Pot Marigold. This annual plant produces stunning orange flowers up to 4 inches in diameter, making it a great cut flower for arrangements. But this plant is not just beautiful, it is also edible! The leaves and fresh petals are rich in vitamins and minerals, making them similar to dandelions in nutritional value. The dried petals can be used as a seasoning in soups and cakes, while the petals can be added to salads for a unique touch. The plant also produces an edible yellow dye that can be used in coloring and flavoring rice and soups, and can even be used as a hair rinse to add golden tints to brown or auburn hair. But it's not just its edible qualities that make the Orange King Pot Marigold special - it also has antibacterial, anti-fungal, and anti-inflammatory properties known to help with digestion and gynecological problems. The beautiful flowers are also known to lift spirits and promote healing when used as an oil extract topically for skin abrasions. This easy-to-grow plant is native to southern Europe and can be re-seeded for years of beauty and nectar in your garden. Order your Orange King Pot Marigold today and enjoy its unique, edible and healing qualities.