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 = '286'
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 occidentalis, also known as Water Birch or Red Birch, is a species of birch native to western North America. This deciduous shrub or small tree grows up to 10 meters in height and typically occurs along streams in mountainous regions. The bark is dark reddish-brown to blackish, and its leaves are alternate, ovate to rhombic, and serrated with a short petiole up to 1.5 cm long. Water birch is known for its tendency to epicormic growth resulting in many small limbs sprouting from the trunk, resulting in full wood with small knots. Water birch is generally top-killed and sprouts from the base following fire, making it suited for use in restoration projects. Its buds and twigs are also used as a flavoring in stews.