HMS Lion and HMS Princess Royal - The Battlecruiser's Lair - Beatty's Ship off Edinburgh

HMS Lion and HMS Princess Royal - The Battlecruiser\'s Lair - Beatty\'s Ship off Edinburgh

Limited edition print from an original etching. Edition size: 49

460 x 180 mm

Whilst the dreadnought battleships of the Grand Fleet, together with their escorting squadrons, were based at Scapa Flow during the majority of the Great War, the Battle Cruiser Force was moved down to the Firth of Forth. This etching which depicts the scene around 1915/1916 shows HMS LION (Captain Ernle Chatfield CVO RN), wearing the flag of Vice Admiral Sir David Beatty KCB MVO DSO, with two other ships of the 1st Battle Cruiser Squadron in company, HMS PRINCESS ROYAL (Captain Walter Cowan MVO DSO RN) and one other Big Cat. Astern of LION in this beautifully executed etching (Edinburgh in the background is especially detailed) is a battleship of the King Edward VII class.

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 = '534' and opa.orders_id = opb.orders_id and opb.products_id != '534' 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