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 = '6230'
group by i.id
Scarification: Soak in hot water (120degrees F), let stand in water for 24 to 48 hours, cover seed with water.
Stratification: Drain water from seed mix 50/50 with peat moss, place in polybag. Warm stratify at room temperature 70 degrees for 60+ days, then cold stratify for not less than 60 days and up to 120 days.
Germination: sow seed 1/8" deep , tamp the soil, mulch the seed bed
Introducing the Acer palmatum ssp. matsumurae 'Oshio Beni', also known as the Oshio Beni Japanese Maple. This beautiful deciduous tree has been cultivated in Japan for centuries and is highly sought after for its attractive leaf shapes and colors. With finely-divided, lacy leaves of a deep red in the spring, this tree puts on a show-stopping display of fall color in shades of golden, orange, and red. It does well in most soils preferring a good moist well-drained soil on the acid side and partial shade. Grown for its interesting growth habit and vivid foliage, this tree can reach up to 26ft in height and is hardy to zone 5. It is not frost tender and blooms from May to June. The plant prefers light, medium, and heavy soils, can grow in heavy clay soils, and requires a well-drained soil. It prefers acid, neutral, and basic soils and can grow in very acid soils. This tree grows in semi-shade or no shade and requires moist soil. While seedlings grown from collected cultivars may vary, this unique variety is one you won't want to miss. Add this stunning Oshio Beni Japanese Maple to your landscape for sensational color and interest all year round.