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 = '6293'
group by i.id
Germination: requires light for germination, surface sow and keep moist
Other: stratification may be used instread of surface sowing, it is better to surface sow if possible.
Betula papyrifera, commonly known as Canoe Birch, Paper Birch or White Birch, is a medium-sized deciduous tree that can reach up to 100 ft in height, with a trunk up to 30 inches in diameter. Its standout feature is its stunning white bark that flaks off in fine horizontal strips, revealing a reddish orange underbark. This native birch offers better resistance to the borer than other birches, making it an ideal option for landscape use. It has a golden-yellow fall color and is excellent when used in groupings, in groves, or even as a single specimen. In the spring, the sap from the tree is edible raw or cooked, and can be concentrated into a syrup or fermented to make birch beer or vinegar. The leaves are ovate with a doubly serrate margin, and the flowers are wind-pollinated catkins that grow from the tips of twigs. The fruit comprises numerous tiny winged seeds that drop between September and spring. In short, the Betula papyrifera is a striking tree that adds visual appeal to any landscape while also providing edible and medicinal benefits.