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 = '1450'
group by i.id
Scarification: Soak in hot tap 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
Other: Spring sowing of unstratified seed will produce germination the next spring
Tilia cordata is a stunning deciduous shade and street tree with a pyramidal shape in youth, gradually becoming more rounded with age. Its dark green, lopsided-heart-shaped leaves, up to 3", have a glossy finish. Its legendary tolerance for harsh soil conditions has made it a popular choice for landscaping. Native to Europe and western Asia, it boasts yellowish, fragrant flowers in June. It is tough and vigorous, can be pruned into a hedge, and is parent to many cultivars. The tree is celebrated for producing a chocolate substitute made from a paste of the ground-up flowers and immature fruit. Tilia cordata has a rich cultural significance and is the national tree of the Czech Republic and the Slovak Republic.