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 = '4044'
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
Other: Should be cleaned prior to treatment or sowing.
Looking for a new addition to your garden or landscape? Consider the Juglans microcarpa, also known as the Little Walnut or Texas Walnut. This large shrub or small tree grows wild in Texas, Oklahoma, New Mexico, and Kansas along streams and ravines. It produces small nuts with a sweet and oily seed enclosed in a thick shell. The pinnately compound leaves bear 7-25 leaflets, each 1/4-1/2 inch wide, and it can be found at elevations between 700-6700 ft. In riparian woodlands where this species grows, it hosts a diverse array of animal life, including many species of birds. While it does not have specific adaptations to fire, off-site seed ensures reestablishment in areas that have burned. With its unique characteristics and adaptability, the Little Walnut will make a fantastic addition to your outdoor space.