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 = '1476'
group by i.id
Scarification: soak in warm water, let stand in water for 24 hours
Stratification: none required
Germination: surface sow and keep moist, cover seedbed with some shade
Other: remove seed from fruit prior to treatments
Discover the wonders of Vaccinium myrtillus, commonly known as bilberry, wimberry, or whortleberry. This shrub boasts blue edible fruit that is tasty both raw and cooked, and can be used to make excellent preserves and tea. The regional names of this species include blaeberry, ground hurts, myrtle blueberry, and winberry. Vaccinium myrtillus can be found in Northern Europe, Northern Asia, and Western Canada and the Western United States, growing in the wild on heathlands and acidic soils. This plant has been used for nearly 1,000 years in traditional European medicine, with the leaves being used for diarrhea, scurvy, infections, burns, and diabetes. With its antiseptic, astringent, and tonic properties, it is also a remedy for the urinary tract, and can help with diabetes and ulceration. The fruit is an excellent source of anthocyanosides, which have shown potential in treating varicose veins, hemorrhoids, and capillary fragility. Bilberry is a hardy and self-fertile plant that prefers moist, well-drained, and acidic soils, growing in woodland gardens, sunny edges, and dappled shade. With its propensity for resisting honey fungus, it makes a valuable addition to any garden.