First Light, San Carlos Water

First Light, San Carlos Water

Limited edition print from an original oil. Edition size: 99

300 x 225 mm

The liner CANBERRA lies quietly at anchor, half-way down the confined spaces of San Carlos Water. Having successfully discharged half of her embarked assault force (40 Cdo RM, into ‘Blue Beach’ - the San Carlos Settlement area) she now holds 42 Cdo RM in reserve as the Brigade’s helicopters begin the process of lifting Rapier missile units, 105 mm Light Guns - and all the associated combat supplies - into position on the high ground surrounding the anchorage. Just before sunrise, the artist has caught this moment perfectly as an armed Gazelle of 3 Commando Brigade’s Air Sqn scouts forward for a load-lifting Sea King 4 of 846 Naval Air Squadron. Two Gazelles and three of their four crewmen were lost on this day.

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