Shop with Confidence


Zippo Lighter - Named and Attributed to Korean War Veteran (2 RAR)

 Out of Stock 

To be notified when this product is back in stock please click here.

Description: Zippo Lighter - Named and Attributed to Korean War Veteran (2 RAR)

Maker: N/A

Comments: Zippo Lighter - Named and Attributed to Korean War Veteran (2 RAR). Missing the pin at hinge. Note this can be repaired by Zippo.

Attributed to WO2 Allan Gordon Dugan who served in Korea with the 2nd Battalion (The Royal Australian Regiment).

http://www.koreanroll.gov.au/veteran.aspx?id=1220702


  • Model: AM06060


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