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 = '765'
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, tamp the soil, mulch the seed bed
Introducing Juglans regia 'Carpathian', a strain of English walnut with greater cold hardiness for colder climates. This large deciduous tree grows up to 65 ft tall with a broad crown and requires full sun to thrive. Not only does it produce thin-shelled, edible nuts, but it also yields a valuable timber that is heavy, hard, and close-grained. The green husks of this tree contain methyl palmitate, which has insecticidal properties, making it an eco-friendly insecticide. Additionally, the green nuts and leaves make a yellow dye while the mature husks and leaves produce a brown dye without a mordant, making it perfect for use as a natural hair coloring and tonic. The catkins also produce a golden-brown dye for use in various applications. The seeds provide a drying oil that is useful in soap making and paint preparation while the nut kernels can be used as a wood polish. With its many versatile uses, this tree is a must-have for any nature lover and a great addition to any garden or outdoor space.