• PhotosPhotos
  

JT FX 2.0 Paintball Pants - Black

Your Price: $150.00 + Free Shipping
Add to Wish List
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. 12281
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]