Blank-Guns-Depot.com - Air Gun-BB Guns

INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'ON'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='480' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'ON'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products_categories.categoryid='480' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
Blank-Guns-Depot.com - Air Gun-BB Guns

Blank-Guns-Depot.com
131 Greenbriar Dr.
West Monroe La.
71291
Fax: (318) 397-7828
Email: Help@Blank-Guns-Depot.com

Toll Free Phone:
866 809-GUNS (4867)
8 AM to 5 PM Central
Monday Through Friday

http://www.Blank-Guns-Depot.com

Blank-Guns-Depot.com :: Replica Guns, Swords and Collectible Weapons :: Replica Guns :: Air Gun-BB Guns

We sell Voltran Ekol of Turkey BB Guns exclusively. Ekol Voltran manufactures some of our best blank firing gun models. They are well known for their years of expertise in precision quality replica gun design and manufacturing. Like our blank guns our Air Guns are made with all metal construction instead of plastic. Many Cheap Air Gun models on the market are made of plastic instead of metal. Each Voltran Ekol Air Gun is expertly crafted, manufactured then tested to exacting tolerances before they are approved for distribution. The Barrels of our Air Guns are a precision Rifled Metal construction inside. As with a real fire arm a rifled barrel is what enables a projectile (BB in this case) to fire straight and allows an accurate shot. Our Air Gun BB Guns are CO2 Propelled using 4.5MM BBs that fire at a velocity or speed of 360 Feed per second. The CO2 Cartridges and BBs are sold separately and are also available as an option as you add your Air Gun selection to your shopping cart. We are very proud of our new Voltran Ekol Air Gun addition to our Replica Weapons line and are certain that you will be well pleased with your purchase of our Air Gun BB Guns.

25% discount on all items at check out!

Air Gun-BB Guns

There are no available products under this category.