Blank-Guns-Depot.com - BB Guns, C02 Propelled

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='479' 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='479' 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 - BB Guns, C02 Propelled

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 :: BB Guns, C02 Propelled

YES WE ARE OPEN FOR BUSINESS AND SHIPPING MONDAY THROUGH FRIDAY; We sell Voltran Ekol of Turkey Co2 Propelled air gun 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 BB guns are made with all metal construction instead of plastic. Many BB gun models on the market are actually made of plastic. Each Voltran Ekol Air Gun is expertly crafted, manufactured then tested to exacting tolerances before they are approved for distribution. The Barrels of our BB 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 BB air guns are CO2 Propelled using 4.5MM BBs that fire at a velocity or speed of 360 Feed per second. That is the length of a football field in less than a second! The CO2 Cartridges and BBs are sold separately and are also available as an option as you add your BB Gun selection to your shopping cart. We are very proud of our new Voltran Ekol BB Gun addition to our Replica Weapons line and are certain that you will be well pleased with your purchase of our BB Guns.
YES WE ARE OPEN FOR BUSINESS AND SHIPPING MONDAY THROUGH FRIDAY;

BB Guns, C02 Propelled

There are no available products under this category.