• PhotosPhotos
product
 

Valken Infinity Paintballs

Your Price: $30.50
Reg. Price: $40.00
You Save: $9.50 (24%)
Sale ends:
11:59pm Apr 21st
  • Buy 10-127 for:
    $35.00 each
This item is excluded from the free shipping for the Easter Sale.
Add to Wish List
Availability:
Temporarily Out of Stock
Email me when available!

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. 11912
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

[TEP STOP]