Civil War Reenactment Accessories :: Civil War Props and Collectibles

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='199' 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='199' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
Civil War Reenactment Accessories :: Civil War Props and Collectibles :: 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

Civil War Props and Collectibles

Civil War Collectibles and Gifts
Civil War Flintlock Rifle Replicas
Civil War Holsters and Scabbards
Civil War Miniature Display Cannons
Civil War Non Firing Replica Pistols
Civil War Non Firing Replica Rifles
Civil War Reenactment Accessories
Civil War Replica Flintlock Pistols
Civil War Replica Swords, Daggers and Knives
Civil War Sword Letter Openers
Display Plaques, Racks and Hangers

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

Recover password

If Javascript is disabled in your browser click here

Your cart

	Cart is empty

View cart
Checkout

Help

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

*We Accept:*

Stage-Props-Blank-Guns.com :: Civil War Props and Collectibles :: Civil War Reenactment Accessories

Civil War Reenactment Accessories

Civil war field gear, weapons, insignia, accessories, props, civil war swords and pistol, metals, badges, slouch hats, civil war bugle, officer's knot, officer's sword, trooper's sword, Kepi, officer's gloves, belt buckles, sword belt, sword hanger, Patches, badges, hat Pins, buttons, cuff links, officer's gray, officerâ€™s blue, hat cord, civil war confederate and union flag, canteen, flask, buttons, union eagle, civil war southern cross, Calvary insignia, confederate and union reenactment equipment.

CLICK ON ANY CATEGORY BELOW TO VIEW

Civil War Reenactment Nonfiring Pistols

Civil War Reenactment Nonfiring Rifles

Civil War Reenactment and Collectible Swords

Civil War Flags and Field Gear

Civil War Kepis and Slouch Hats

Civil War Insignia, Metals and Pins

Buckles, Buttons and Cuff Links

Accept Credit Cards