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 = '699'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours| Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 90 days, cold stratify for 90 days
Germination: sow 1-2" deep, tamp the soil, mulch the seed bed| sow seed 3/4" deep, tamp the soil, mulch the seed bed
Looking for an understory tree that offers stunning spring blossoms? Look no further than Halesia carolina Carolina Silverbell. This small tree or large shrub boasts elegant, white, bell-shaped blooms that dangle in rows along its branches like raindrops. The limbs of this native Southeastern and South-Central U.S. tree arch up and out to form a rounded, horizontal canopy, making it a beautiful addition to any landscape. It prefers rich, acidic soil and is relatively pest-free. Carolina Silverbell is also easy to grow and makes a great focal point in your garden. So why wait? Add the beauty of Carolina Silverbell to your landscape today!