"UNFORGETTABLE HISTORY, UNFORGETTABLE BOOKS"

SPECIALISING IN ORIGINAL, RARE AND EXPANDED AUSTRALIAN UNIT HISTORIES

Duty First - 60 years of the Royal Australian Regiment

$29.95

30 reward points

Duty First - 60 years of the Royal Australian Regiment 1948 - 2008

2008 Special Edition - Special Anniversary issue - 60 years of the Royal Australian Regiment 1948 to 2008 - 88 pages.

Full of great information and pictures of the battalions of The Royal Australian Regiment


  • Item: RB02353
  • Shipping Weight: 0.6kgs


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

This product was added to our catalog on Sunday 25 October, 2009.

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