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 = '697167'
group by i.id
Scarification: Soak in sulfuric or nitric acid for 1-2 hours and wash under cold water for 10-15 minutes.
Stratification: cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: Should be cleaned prior to treatment or sowing., acid treatment should be tested on a small sample, before subjecting the entire seed lot
Introducing Cotoneaster simonsii, also known as Himalayan Cotoneaster or Simon's Cotoneaster. Not only does this shrub produce attractive, rose-tan fruit, it also serves as an ideal hedge for your garden. Its medium to tall height allows for informal hedging, creating a cozy and charming feel to any outdoor space. This plant is also versatile in that when closely trimmed, it becomes an excellent dense hedge that will provide privacy and shade. Additionally, the fruit of Cotoneaster simonsii can be used to create a beautiful rose-tan dye. Don't miss out on this wonderful addition to your garden. Visit http://plants.usda.gov for more information.