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='237' 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 OR (xcart_variants.variantid = xcart_pricing.variantid)) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') 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, 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 OR (xcart_variants.variantid = xcart_pricing.variantid)) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_products_categories.categoryid='237' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
Old West Blank Firing Guns :: Old West Movie Props :: Stage-Props-Blank-Guns.com
Stage Props - Movie Props - Blank Guns Header.jpg
***MOVIE PROPS - STAGE PROPS - BLANK GUNS - MOVIE WEAPONS - FAKE GUNS***         THE DIRECTOR'S CHOICE MOVIE PROP AND STAGE PROP WEAPONS HOUSE!        ***REEL DEALS ON BLANK GUNS ***                CALL TOLL FREE: (866) 712-PROP (7767) 8 AM to 5 PM Central...        
  Search:      Advanced search   
HOME | MY ACCOUNT | HELP | CONTACT US
 
Printable Version 
 
     Categories
Movie Prop Blank Guns

Blank Firing Gun Ammunition

Old West Movie Props
Display Plaques Racks and Hangers
Old West Blank Firing Guns
Old West Lever Action Rifles
Old West Prop and Collectible Rifles
Old West Replica Derringers
Sword Letter Openers
Tomahawk Replicas
Western Badges
Western Display Gifts and Collectibles
Western Holsters and Scabbards
Western Prop and Collectible Pistols

Civil War Props and Collectibles

Colonial Stage Props and Collectibles

Pirate Stage Props

Medieval Stage Props

World War II Movie Props

Movie Prop Guns

Movie Prop Swords, Daggers, and Knives

Collectibles Displays and Gifts

Display Cannons



     Authentication
Secure login
Register
Recover password

If Javascript is disabled in your browser click here


     Your cart
Cart is empty

View cart
Checkout


     Help
Contact us
Privacy statement
Terms & Conditions
Customer Testimonials





Stage-Props-Blank-Guns.com Logo.jpg
131 Greenbriar Dr.
West Monroe La.
71291
Fax: (318) 397-7828
Toll Free Phone:
866 712-PROP (7767)
8 AM to 5 PM Central
Mon.Thru Fri.

Email Us


PCI Compliance | PCIDSScompliant.com

Geotrust Secure Site Banner.gif

We Accept:



 
Stage-Props-Blank-Guns.com :: Old West Movie Props :: Old West Blank Firing Guns

  Old West Blank Firing Guns

YES WE ARE OPEN FOR BUSINESS AND SHIP MONDAY THROUGH FRIDAY; Our Western blank guns are made of metal instead of plastic. We have the highest quality blank guns available for old west movie and stage props or western reenactments and shoot outs at tourist attractions, dude ranches and cattle drives. They are used for Annie get your gun, Oklahoma and many other theatrical productions calling for prop blank guns in a western setting. Many people use our blank firing colt 45 peacemaker for fast draw practice. Our western blank guns are available in loud 380/9MM models and 380/9MM half load quieter load blank ammunition. We have 22LR and 22/6mm western peacemaker blank guns that are much quieter than other 9MM/380. We have Blank shooting 6mm double barrel western Derringers used by gamblers and often hidden in the purse of “ladies of the night” for self defense and debt collection. We have the 1894 lever action 8MM blank firing lever action rifle and blank firing gun replicas of Revolvers used in Western days.
YES WE ARE OPEN FOR BUSINESS AND SHIP MONDAY THROUGH FRIDAY;
25% off blank guns at check out.

CLICK ON ANY CATEGORY BELOW TO VIEW
 Blank Firing Derringers
 Blank Cartridges Click Here
 Western Holsters and Scabbards
 
 

   

Accept Credit Cards




Copyright © 2005-2025 Stage-Props-Blank-Guns.com