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 = '847'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 24 hours, repeat process on seed that did not imbibe
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Maackia amurensis 'Buergeri', also known as Asiatic Yellowwood or Buergeri Amur Maackia, is a small round-topped tree that is native to Manchuria. It is a slow-growing, deciduous tree that reaches up to 45 feet tall in the wild, but is most often seen at 20 to 30 feet in landscapes. The compound leaves of Maackia amurensis 'Buergeri' are gray-green when young and olive green when mature. In June and July, it produces attractive white flowers in 5" erect clusters that "smell like new mown grass" (Dirr). The tree has an attractive peeling bark that matures to a rich, shining amber to brown with a curly consistency. The wood is heavy, strong, and very hard, and is used for the interior of houses, utensils, tool handles, and more. Forest Service of US Department of Agriculture describes this tree as very hardy and adaptable, well-suited for use as a street or container tree, or in other confined soil spaces in urban areas, where the peeling, orange/brown, shiny bark is especially noticeable. Maackia amurensis 'Buergeri' is likely hardier than the species, making it an excellent choice for colder climates. It is hardy to zone 4 and cannot grow in the shade. If you're looking for a small, hardy tree that adds interest to your landscape, consider Maackia amurensis 'Buergeri'. Visit http://plants.usda.gov for more information.