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 = '627'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 6 hours
Stratification: cold stratify for 90 days
Germination: can be sown outdoors in the fall for spring germination, sow seed 3/4" deep, tamp the soil, keep moist, mulch the seed bed
Looking for an evergreen shrub that can tolerate tough conditions? Look no further than the Elaeagnus pungens, also known as the Thorny Elaeagnus or Thorny Olive. This hardy plant can reach heights of up to 4 meters and is not frost tender, making it ideal for gardens in zones 7 and above. The Thorny Elaeagnus blooms from November to February, with hermaphrodite flowers that attract bees for pollination. It can even fix Nitrogen in the soil! This shrub can grow in a variety of soil types, including light, medium, and heavy soils, and can tolerate both dry and moist conditions. Ideal for areas with poor nutrition, the Thorny Elaeagnus can grow in neutral, acidic, or alkaline soils and in full shade, semi-shade, or even with no shade at all. It's a tough plant that can even handle maritime exposure. Get your Thorny Elaeagnus today and enjoy a beautiful evergreen shrub that can stand up to any challenge!