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='66' 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='66' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
Western Collectibles, Display and Gifts - Collectible Weapons and Displays - Replica Guns, Swords and Collectible Weapons - Blank-Guns-Depot.com
Old West Blank Gun .gif

Welcome To:
Blank-Guns-Depot.com
Our Speciality is Blank Firing Guns!
winchester blank firing gun.jpg		 Modern Blank Gun .gif
  • Modern Blank Guns
  • Blank Firing Western Guns
  • Civil War Guns
    •
  • World War II Blank Guns
  • Blank Firing Automatic Guns
  • Blank Firing Replica Guns
    •
Product Search:  
  Advanced search
 
blank gun link menu button.jpg Blank Guns

blank gun link menu button.jpg Front Firing Blank Guns

blank gun link menu button.jpg Western Blank Firing Guns

blank gun link menu button.jpg World War II Blank Guns

blank gun link menu button.jpg Military Training Blank Guns

blank gun link menu button.jpg Police And Detective Blank guns

blank gun link menu button.jpg Automatic Blank Firing Guns

blank gun link menu button.jpg Modern Blank Guns

blank gun link menu button.jpg Fully Automatic Blank Firing Guns

blank gun link menu button.jpg Blank Revolvers

blank gun link menu button.jpg Blank Firing Rifles

blank gun link menu button.jpg BB Guns, C02 Propelled

blank gun link menu button.jpg Blank Firing Ammunition

blank gun link menu button.jpg Blank Firing Gun Magazines

blank gun link menu button.jpg Gun Holsters

blank gun link menu button.jpg Blank Firing Cannons And Artillery

blank gun link menu button.jpg Replica Guns, Swords and Collectible Weapons
 
     Your cart
Cart is empty
View cart
Checkout


     Authentication
Secure login
Register
Recover password

If Javascript is disabled in your browser click here


Blank-Guns-Depot.com
131 Greenbriar Dr.
West Monroe La.
71291
Fax: 318-397-7828
Toll Free Phone:
866 809-GUNS (4867)
8 AM to 5 PM Central
Monday Through Friday

Email Us

PCI Compliance | PCIDSScompliant.com

Geotrust Secure Site Banner.gif


We Accept:






 
  HOME LOG IN HELP CONTACT US TESTIMONIALS

Printable version 

Blank-Guns-Depot.com :: Replica Guns, Swords and Collectible Weapons :: Collectible Weapons and Displays :: Western Collectibles, Display and Gifts

 

Old west collectibles, Wild West collectibles, western collectibles, displays and gifts, miniature western gun fighter framed set, tombstone saloon towel, brass steer head boot jack, old west desk bell, old west detonator, wells Fargo money bag, Buffalo bill Cody gloves, bullwhip, steer skull, dummy ammo, dummy bullets, dummy cartridges, marshal badge, deputy badge, ranger badge, police badge, badges, fake badges, wanted posters, replica ball and chain with leg cuff, Wyatt Earp framed set, Texas Rangers framed set, Pat Garrett framed set, hand cuffs, western brass spittoon, Pharo cards, spurs, cat house tokens, Jailers keys, badges all types, barn wood pistol display shelf, wanted posters, Billy the Kid, the wild bunch, Jesse James wanted poster, dead wood framed poster, framed sets of General Custer, Mosby, Wild Bill Hickok, replica fools gold, dueling pistols, framed sets Alamo, Billy the kid, buffalo soldiers, the wild bunch, James brothers, Lonesome Dove Gus Historic Collage, Lonesome Dove Call historic collage, True grit historic collage, Rooster cogburn historic collage, John Wayne historic collage, Doc Holiday and Wyatt Earp Historic collage.



  Western Collectibles, Display and Gifts
There are no available products under this category.  
 

 


For More Information, Contact Us At:
Blank Guns Depot
Toll Free Phone: 1-866-604-4867 (GUNS)
8 AM to 5 PM Central
Mon.Thru Fri.
OR
Email Us




Accept Credit Cards


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