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 = '5014'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 24 hours, repeat process on seed that did not imbibe
Stratification: none required
Germination: sow 1/4 deep, tamp the soil, mulch the seed bed| sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: Seed needs warm temperatures after sowing to germinate (75 degrees F +)
Looking for a unique and striking addition to your garden or landscape? Look no further than the Dracaena draco, commonly known as the Canary Islands dragon tree or dragontree. This subtropical tree-like plant is native to the Canary Islands, Cape Verde, Madeira, and western Morocco, and has been introduced to the Azores. When young, it has a single stem, but it soon grows a crown of terminal buds that develops into an umbrella-like habit. Mature plants have a striking appearance and slow growth, taking around 10 years to reach a height of 1.2 metres (4 ft). The oldest living plant of this species is "El Drago Milenario," growing in Tenerife, estimated to be around 250 years old and the largest D. draco tree alive. This plant produces a reddish resin known as dragon's blood when its bark or leaves are cut, and it has a number of traditional medical uses. Its striking appearance, impressive size, and hardiness make it a popular choice as an ornamental tree for parks, gardens and drought-tolerant, water-conserving sustainable landscape projects. The Dracaena draco has also gained the Royal Horticultural Society's Award of Garden Merit.