• PhotosPhotos

NcSTAR 1" Off-Set Mount For 1" Flashlight/Laser

CLEARANCE (once it's gone, it's gone!)
Model #:
Your Price: $5.00
Reg. Price: $11.00
You Save: $6.00 (55%)
This item is excluded from the free shipping offer due to weight.
Add to Wish List
In Stock
It's sitting in our warehouse itching for a new owner. Is it you?
Ships within:
1 business day

Customers Love Us

"Extremely happy with Paintballgear.ca. I had an question and upon emailing them, I received a reply, literally within minutes. Good Prices, Amazing"
John S., June 22, 2011
Product No. 10517
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND p.products_status = 1 GROUP BY ptc.products_id ORDER BY field(p.type, 'core' at line 5

SELECT ptc.*, p.products_status, p.special_order, p.preorder, p.products_price, p.sort_priority, pd.products_name FROM products_to_categories as ptc LEFT JOIN products as p ON p.products_id = ptc.products_id LEFT JOIN products_description as pd ON pd.products_id = ptc.products_id WHERE categories_id = AND p.products_status = 1 GROUP BY ptc.products_id ORDER BY field(p.type, 'core', 'upgrade', 'softgood', 'part', ''), p.sort_priority desc, pd.products_name