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 = '1412'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 60 -120 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: Sow seed outdoors in the fall for spring germination - stratify if sowing indoors.
Looking for a delicate and fragrant addition to your garden? Look no further than the Styrax americanus, commonly known as American Snowbell or Mock Orange. Native to the southeastern United States, this slender-branched deciduous shrub or small tree stands at 8-15 ft tall with a wide, wispy open crown. Its showy, white, bell-shaped flowers are borne in pairs from leaf axils, covering the plant in a fragrant white cloud. The foliage is bright-green and glossy, and in fall, grayish fruit appear. American Snowbell prefers moist, acid soil, making it a good garden shrub in the right conditions. Check out plants.usda.gov for more information on this stunning native species.