Shop with Confidence


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

$55.00

55 

Add to Cart:

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

Maker's Name: N/A

Condition: Mint

Comments: Royal New Zealand Armoured Corps (RNZAC) anodised collar badge pair. Complete with two pins.

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: AM20869


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 = '7261' 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]