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 = '759'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 120 days
Germination: sow 1-2" deep, keep moist, mulch the seed bed, can be sown outdoors in the fall for spring germination
Juglans cinerea, also known as Butternut or White Walnut, is a deciduous tree native to eastern North America. It grows to a height of 90 feet with light gray bark and has compound leaves, 2" edible fruit, and a rather open habit with few internal branches. Butternut grows quickly but lacks longevity, living rarely longer than 75 years. Its seed is used raw or ground into powder and mixed with cereal flours in making cakes, biscuits, muffins, and bread, with a rich, oily and sweet taste. Butternut prefers moist soil but also adapts well to drier sites. It is found growing up to an elevation of 5,000 ft in the Virginias and is best suited to stream banks and well-drained soils. Butternut trees are found in several hardwood types in the mixed mesophytic forest; common associated trees include basswood, black cherry, beech, black walnut, elm, hemlock, hickory, oak, red maple, sugar maple, yellow poplar, white ash, and yellow birch. Butternuts are light in weight, highly rot-resistant, and used for carving furniture. Butternut bark and nut rinds were also used to dye cloth between light yellow and dark brown. Butternut canker is the most serious disease of J. cinerea but hybrid resistance and other pest control measures are being developed. Butternut is not listed as threatened federally in the US but is listed as "Special Concern" in Kentucky, "Exploitably Vulnerable" in New York State, and "Threatened" in Tennessee.