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 = '414'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days, or until radicle emergence
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: fall sowing in mulched beds is prefered to artificial stratification
Looking for a unique addition to your garden? Look no further than the Cercis chinensis Chinese Redbud. This plant, native to China and Japan, can grow up to 15 meters tall as a tree, but is typically found in shrub form. The circular, pointed leaves add a beautiful texture to any landscape, and the pink or milky white flowers are a stunning sight in April. The Chinese Redbud thrives between 150-1400 meters above sea level, and produces fruit in October. This small, upright-growing, multi-trunked shrub with purplish or rose-pink flowers is a perfect accent for any garden, and even does well in the American South. Don't miss out on adding this unique plant to your collection.