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 = '3500'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 180 days
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Other: remove seed from fruit prior to treatments|can be fall sown without stratification.|Sporadic germination may occur over a 2-3 year period
Looking for a unique shrub to add to your garden? Consider Sorbus californica, also known as California Mountain Ash. This shrub features 1/4" white flowers followed by eye-catching scarlet fruit that is 1/4" round in shape. With its compound leaves and toothed leaflets, Sorbus californica is native to California but can be cultivated elsewhere. This species of Rowans is often compared to S. occidentalis but stands out with its gorgeous orange-red fruit and sharply-toothed leaflets. For more information on Sorbus californica, visit http://plants.usda.gov today!