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 = '901'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: seed may start to germinate in cold strat., sow seed 1/8" deep , tamp the soil, mulch the seed bed
Discover the unique flavor of Myrica rubra, also known as Chinese bayberry, Yang-mei or Yumberry. This small to medium-sized evergreen tree grows up to 20-60 ft high and has smooth gray bark and a uniform spherical to hemispherical crown. Its narrow 5" leaves and 1" deep reddish-purple berries are edible and have a sweet and tart flavor that is perfect for making refreshing drinks. These fruits are native to East Asia and are packed with antioxidants, anti-cancer and anti-viral properties, making them a great addition to any diet. Myricerone, an extract from the fruit, has potential for drug development due to its ability to block a receptor for the peptide, endothelin, an important mediator of blood vessel constriction. Besides fresh consumption, the fruits may be dried, canned, soaked in baijiu (Chinese liquor), or fermented into alcoholic beverages to create a unique flavor experience. Grow some Myrica rubra and discover the taste of a truly exotic fruit.