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 = '697230'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 60 days. Stratify by surface sowing seeds on moist, tamped, soil in trays and place trays in cold for 60 days. Keep moist.
Germination: Take trays out of refrigeration, put plastic wrap around them and place in a warm, sunny location. Remove the plastic wrap once seeds germinate.
Discover the wild relative of chives, native to Europe and Asia - Allium ursinum. Known by many names such as Ramsons, Buckrams, Wild Garlic, Broad-leaved Garlic, Wood Garlic, Bear Leek or Bear's Garlic, this perennial herbaceous monocot is a favorite of the brown bear and wild boar. The Latin name ursinum is derived from the bear's taste for its bulbs and their digging habit to get to them. However, its similarity in appearance to poisonous plants, like the lily of the valley, has led to poisoning cases especially in Europe. All parts of the plant are edible, its leaves can be used in salads, herbs, soups, or even as a pesto substitute. Even the flowers and bulbs can be consumed, and it's used in making herbed cheese in Turkey. But beware, mistaken identifications can have serious consequences. Learn more about this intriguing plant, its habitats, the edibility, and its similarity to poisonous plants. Discover Allium ursinum, the wild garlic of the British Isles.