CategoriesAirsoft Innovations (11)ASC Wear (2)BBBastard BBs (1)Pantac Gear (67)  Bags/Cases (10)
  Belts/Personal (8)
  Holsters (2)
  Hydration (4)
  Miscellaneous (1)
  Pouches (26)
  Slings (3)
  Vests - Modular (7)
  Vests - Static (6)
Tachyon XC (5)
Your Email Address
Your Password
Create Account

Cart0 items

One Point Sling - Pantac

From RedWolf Airsoft:

1.5 inch nylon sling provides both comfort and stability.

You Buy Now

Black [SL-N13B-BK-A]  $18.99CAD 

Out of Stock

Coyote Brown [SL-N13B-CB-A]  $18.99CAD 

Out of Stock

Olive Drab [SL-N13B-OD-A]  $18.99CAD 

Out of Stock

Khaki [SL-N13B-TN-A]  $18.99CAD  Quantity :
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'ascmart_ascmart.xp.products_id' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from products_xsell xp, products p, products_description pd where xp.products_id = '51' 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.products_id asc limit 6