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 = '1449'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: Sporadic germination may occur over a 2-3 year period
The Tilia amurensis, also known as Amur Lime or Amur Linden, is a medium-sized shade tree native to Manchuria and Korea. It is similar in appearance to Tilia japonica but with smaller leaves and bracts and a shorter cyme. It grows best in a woodland situation with good moist loamy alkaline to neutral soil and dislikes exposed positions. This species is closely related to T. cordata and tends to hybridize freely if other members of the genus are nearby. Its fragrant, pale yellow flowers bloom from late spring to early summer and give way to ovoid-globose nutlets that ripen in late summer. The Tilia amurensis is also notable for its antispasmodic, diaphoretic, and sedative properties, with tea made from its flowers being a common remedy. Trees in this genus are notably resistant to honey fungus, and semi-mature trees up to 5 metres tall have been successfully transplanted.