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 = '681'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 60 days, cold stratify for 60 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Looking for a medium-sized tree to add to your garden or landscaping project? Look no further than Fraxinus profunda, also known as Pumpkin Ash. Native to eastern North America, this deciduous tree reaches 40-100 ft and has a trunk up to 3 ft in diameter. With gray, thick, fissured bark, and dark brown to blackish winter buds with a velvety texture, it adds visual interest all year round. In spring, inconspicuous purplish-green flowers are produced in panicles, followed by the largest of any North American ash species' fruit - a samara comprising a single seed with an elongated apical wing 9mm broad. Plant in coarse or medium-textured soil with a planting density of 300-800 per acre and enjoy pumpkin ash's rapid growth rate and high fire tolerance.