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='111' 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='111' 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 - Blank Firing 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

We have front firing blank guns and top firing blank guns. They are called: Blank firing guns, Blank guns, blank shooting guns, blank gun, blank firers, fake blank guns, replica blank guns, cap guns, blank gun replicas, movie guns, stage guns, Prop guns, Old west blank guns, Cowboy Action shooters Blank guns, World war II blank firing guns, Military blank guns, Colt 1911 Blank Gun, Jackal Fully automatic blank gun, Beretta V92 Jackal fully automatic blank firing gun Replica, Fully Automatic Machine Gun Pistols, Replica Blank firer, Beretta PX4 Storm Blank Firing Gun, 8MM blank guns, 9MM Blank gun, Beretta M92 blank gun, Beretta M92F blank firing guns, Beretta V92 blank firing guns, Walther P 38 and Walther P99 blank guns, Blank ASI UZI, Blank Firing UZI, VPPK and PPK blank firing guns, Beretta Blank guns, P229 blank gun, ARAS Blank firing gun, Sava blank gun, blank firing colt .45 1873 peacemaker 9MM blank guns, .22/6mm caliber 1873 Peacemaker blank gun, 1894 Lever Action blank firing Western Rifle, Cowboy 6 shooters. Front Firing Blank Guns will have "Front Firing" in the name of the item.

25% discount on all items at check out!

  Blank Firing Guns

CLICK ON ANY CATEGORY BELOW TO VIEW
 Retay 9MMPA Blank Guns
 Modern Blank Guns
 Old West and Western Blank Guns
 World War II Blank Firing Guns
 Fully Automatic Blank Firing Guns
 Blank Firing Handgun Revolvers
 Front Fire Blank Firing Guns
 Blank Ammunition
 Blank Firing Pocket Pistols
 Blank Firing Gun Magazines
 Holsters-Modern
 Western Holsters and Scabbards
 
 

 

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