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 = '1332'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 60 days, cold stratify for 60 days
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed|sow seed 3/8 deep, tamp the soil, keep moist, mulch the seed bed, remove mulch upon germination, can be sown outdoors in the fall for spring germination
Rosa xanthina, also known as Manchu Rose or Yellow Rose, is a fascinating species of rose that boasts an abundance of musky-smelling yellow flowers and interesting red hips in autumn. Unlike many hybrid roses on the market today, wild roses like this one are known for their excellent resistance to diseases and insects. This shrub grows 6-9 feet tall, with reddish stems armed with reddish-brown thorns. Semi-double yellow flowers (up to 2 inches in diameter) bloom for several weeks from late April into May, emitting a delightful fragrance. The flowers are followed by attractive spherical to ellipsoid red hips that mature in late summer and persist on the shrub throughout winter. While foliage typically produces insignificant fall color, occasionally an interesting blend of yellow, orange, and red will occur. This rose is well worth growing in a large yard or garden and adds a touch of unique beauty to any landscape. More information on this fascinating specimen can be found on the USDA website.