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 = '1487'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 180 days, cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for an attractive deciduous shrub that will add beauty to your garden? Look no further than Viburnum dilatatum Linden Arrowwood, also known as Linden Viburnum. This stunning plant has dark green, orbicular to broad-ovate, wrinkled leaves that turn attractive shades of bronze, burgundy, and red in the fall. In late spring, the plant produces creamy white flowers in flat-topped clusters of up to 5 inches wide, which are followed by an abundance of 1/3 inch fruit in a bright red hue, holding until December. The plant is indigenous to China and Japan and can grow up to 10 feet tall and 8 feet wide. It thrives in average, well-drained soil and requires full sun to part shade. For best fruit production, plant two or more shrubs near each other. Order your Viburnum dilatatum Linden Arrowwood today and beautify your garden!