Shop with Confidence


4th Cavalry Regiment - Hat Badge (Pins)

$125.00

125 

Add to Cart:

Description: 4th Cavalry Regiment - Hat Badge

Maker's Name: N/A

Condition: Very Good

Comments: 4th Cavalry Regiment - hat badge. Complete with 2 pins.

The 4th Cavalry Regiment was an APC regiment based at Enoggera Barracks, Brisbane. It was raised on 11th October 1971 and was amalgamated with the 3rd Cavalry Regiment to form the 3rd/4th Cavalry Regiment in 1981.

 


  • Model: AM20826


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