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 = '6581'
group by i.id
Scarification: soak in warm water, let stand in water for 24 hours
Stratification: warm stratify for 120 days, cold stratify for 120 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Introducing the Acer shirasawanum 'Ogurayama' - a stunning Full Moon Maple that offers a brilliant display of colors every Fall. This medium-sized cultivar has been described by renowned horticulturist, Vertrees, as one of his favorites. Its rich orange and scarlet hues dominate any garden, creating an attractive display that persists for several weeks. In just 12 years, this cultivar forms a round-topped bush that can reach up to 4 meters in height. Add the Acer shirasawanum 'Ogurayama' to your garden and experience the beauty and elegance that this tree can bring.