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 = '846'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Discover the beauty of Maackia amurensis, commonly known as Amur Maackia or Chinese Yellow Wood. This tree can grow up to 15 meters tall and boasts gray-green, compound leaves that turn olive green as they mature. In June and July, admire the tree's 5-inch erect clusters of white flowers that exude a fragrance reminiscent of new mown grass. The bark is just as impressive, peeling as it matures to reveal a rich, shiny amber-brown with a curly texture. The wood is heavy and strong, making it perfect for indoor use, utensils, and tool handles. Native to Manchuria and named after the 19th-century explorer, Karlovich Maack, who discovered it on the border between Siberia and China. Amur Maackia is highly adaptable to severe dryness, cold, and heavy soils. A small round-topped tree, it is ideal for planting on streets or in confined urban spaces where the peeling bark stands out. Also, appreciate the springtime show of its unfolding silvery buds that resemble flowers frosted with ice.