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 = '3174'
group by i.id
The Hydrangea paniculata 'Grandiflora' Pee Gee Hydrangea is a stunning addition to any garden. This fast-growing shrub can reach up to 25 feet tall and produces large white flowerheads that turn pinkish with age. It is one of the most cold-hardy species of hydrangea and can be grown as a single-stemmed tree or multi-stemmed shrub. Not only is it beautiful, but the bark is also used to make Japanese paper, and the wood can be used for small items, nails, and walking sticks. This shrub is low maintenance and perfect for hedging, beds, borders, and as a specimen plant/focal point. It blooms on current season's wood and may be cut back to produce larger flowers or allowed to grow with minimal pruning. Don't miss out on the beautiful display of flowers and the versatile uses of this incredible shrub.