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 = '5642'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 90 days, cold stratify for 90 days
Germination: sow seed 3/8 deep, tamp the soil, mulch the seed bed
Looking for a unique addition to your garden? Look no further than Paeonia obovata, also known as Japanese Pink Woodland Peony or Woodland Peony. This perennial herbaceous species boasts purple-red flowers and grows to a height of 18-20 inches. Its lower leaves have no more than nine leaflets or segments, and it dies down in the autumn before re-emerging in the spring. The seed pods are even larger and more dramatic than those of P. obovata japonica. Paeonia obovata grows naturally in warm-temperate to cold China, including Manchuria, Korea, Japan, Far Eastern Russia, and Sakhalin. This plant has been used in traditional Chinese medicine for pain relief, anti-inflammation, and cardiovascular health. First introduced in Europe in 1900, Paeonia obovata has been cultivated in botanical gardens and is now available for gardeners. Add this unique and beautiful plant to your garden today!