Chester Teddy Bear in HELLO SAILOR T-shirt

Chester Teddy Bear in HELLO SAILOR T-shirt

Approximate size: 200 mm tall x 150mm wide x 100mm

A teddy bear in a HELLO SAILOR T-shirt on an art gallery website?????

Forgive us for this bear - he's an indulgence as our gallery lives in an ancient naval gunstore in Portsmouth Historic Dockyard, part of the home of the Royal Navy at Her Majesty's Naval Base Portsmouth.

Chester is an adorable souvenir of the Navy who keeps kids quiet while their parents browse the art on our 225-year-old walls... and gives sailor's kids something to hug while their parent is away at sea serving Queen & Country!

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'leonarts_SHOP.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '231' and opa.orders_id = opb.orders_id and opb.products_id != '231' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6