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 = '303'
group by i.id
Germination: requires light for germination, surface sow and keep moist
Other: stratification may be used instread of surface sowing, it is better to surface sow if possible.
Introducing the Betula tianschanica, also known as the Tian-shan Birch or Tianan Birch. This medium-sized tree from the mountains of Soviet Central-Asia showcases beautiful creamy-pink peeling bark and double-toothed leaves that turn a nice yellow in the fall. The tree grows up to 40 ft tall, with bark that exfoliates in flakes of yellow-white or yellow-brown. Its branchlets are densely pubescent and villous, and its branches are gray-brown or dark brown and glabrous. The leaf blade is broadly ovate-rhombic or ovate-rhombic, rarely ovate or rhombic, and measures 2-7 × 1-6 cm, with a base that is broadly cuneate or cuneate. The tree is perfect for small gardens and blooms from June to July, with fruit developing from July to August. The female inflorescence is oblong-cylindric, 1-4 cm × 5-10 mm, and has peduncle that is pendulous and densely pubescent. It is deemed endangered due to limited distribution and rapid decline. Betula tianschanica is an attractive tree that will undoubtedly add a unique flair to your garden with its beautiful bark and double-toothed leaves.