Shop with Confidence


[NZ] - Royal New Zealand Armoured Corps (RNZAC) anodised hat badge

$55.00

55 

Add to Cart:

Description: [NZ] - Royal New Zealand Armoured Corps (RNZAC) anodised hat badge

Maker's Name: JR Gaunt, London

Condition: Mint

Comments: Royal New Zealand Armoured Corps (RNZAC) anodised hat badge. Complete with two lugs.

The Royal New Zealand Armoured Corps (RNZAC) is the overall umbrella grouping of Regular Force and Territorial Force units equipped with armoured vehicles in the New Zealand Army. The corps was formed in 1942 as the New Zealand Armoured Corps, before being given the Royal prefix in 1947. The RNZAC is second in seniority of corps within the New Zealand Army. It saw service in North Africa and Italy during World War 2.


  • Model: AM20868


3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'militari_zenshop.xp.sort_order' which is not in SELECT list; this is incompatible with DISTINCT
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell1 xp, zen_products p, zen_products_description pd where xp.products_id = '7259' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit 6]