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 = '1397'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Sorbus torminalis, also known as the Chequer Tree, is a medium-sized deciduous tree native to Europe, North Africa, and Southwest Asia. With its smooth, greyish bark and maple-like leaves, this tree produces white, fragrant flowers in May, followed by edible brown fruits which were once used in medicine. It prefers deep, fertile soils but can adapt to a range of conditions. This valuable hardwood was traditionally used to make billiard cue sticks and winepress screws, and is now prized for decorative veneers. The fruits are enjoyed by birds and mammals and can be harvested for their date-like flavour. This tree is rarely found in the wild and is an indication of primary woodland when it is. Its Latin name, Torminalis, means "good for colic", a reference to its medicinal properties. Order your Sorbus torminalis today and enjoy its ornamental appeal and ecological value.