"UNFORGETTABLE HISTORY, UNFORGETTABLE BOOKS"

SPECIALISING IN ORIGINAL, RARE AND EXPANDED AUSTRALIAN UNIT HISTORIES

1st Battalion The Kings Shropshire Light Infantry

$49.95

50 reward points

Title: 1st Battalion The Kings Shropshire Light Infantry Campaign Service 1939 - 1945

Author: Lt Col. R Evans, MC and M. E. Jones

Condition: Mint

Edition: 2nd Edition

Publication Date:

ISBN:

Cover: Soft Cover without Dust Jacket - 157 pages & 19 maps

Comments: The campaign service of a distinguished regiment - in France and Belgium, 1939-40,  North Africa, 1943 and Italy, 1943-45.


  • Item: RB09445
  • Shipping Weight: 0.5kgs


Do you like this product? Share it with your friends:

This product was added to our catalog on Sunday 28 March, 2010.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'regiment_zen.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from zen_orders_products opa, zen_orders_products opb, zen_orders o, zen_products p where opa.products_id = '1402' and opa.orders_id = opb.orders_id and opb.products_id != '1402' 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]