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='350' 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='350' 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 - Modern Blank 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 :: Blank Firing Guns :: Modern Blank Guns

We have modern front firing and top firing blank firing guns that are great as movie prop blank shooting guns, stage prop blank firers, blank guns for sale online, reenactment blank firing guns, blank guns for collectors, 8MM blank guns, 9MM/380 blank firing guns, 9MMPA Blank guns, Walther P99 Blank Gun front Firing Blank Gun, ASI UZI blank guns or UZI blank firing, Jackal Fully automatic blank gun, Beretta fully automatic machine gun pistol, replica blank firers, Beretta V85 9MMPA blank firing gun replica, Beretta M92 8MM and V92 9MMPA replica blank guns, Beretta M92F blank firing gun fully automatic replica, P 38 Blank firing guns, VPPK 9MMPA blank firing guns, P229 or P29 blank firing guns, Browning ARAS SWATT, Colt .45 1911 blank firing guns, Sava blank gun. You can buy blank guns online here. Our front firing blank guns are mixed in here and in their own separate categories on the site. It is not front firing unless it says front firing in the name of the blank gun.
25% discount on all items at check out!

  Modern Blank Guns

There are no available products under this category.  
 

 

 
© Copyright - Blank-Guns-Depot.com - 2005