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 = '2009'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: fall sowing in mulched beds is prefered to artificial stratification
Looking for an ornamental tree that can withstand cold temperatures? Look no further than Acer tegmentosum, also known as the Manchurian striped maple. Native to northeast Asia, this tree boasts green to greenish-purple stems with white stripes, and an open habit with yellow fall color. It's cold-hardy down to USDA Hardiness zone 54(-29 °C), making it an excellent choice for colder climates. At maturity, it can reach a height of 20-30 ft with a spread of 25 ft, and features greenish-grey bark with bright white stripes. The leaves are not compound, each up to 12 cm across, round in general outline but with 3 shallow lobes, which turn bright yellow in the fall before falling. In the UK, it has gained the Royal Horticultural Society’s Award of Garden Merit. This unique and eye-catching tree is sure to make a statement in any garden.