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='110' 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='110' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
Stage-Props-Blank-Guns.com - Movie Prop Blank Guns

Stage-Props-Blank-Guns.com
131 Greenbriar Dr.
West Monroe La.
71291
Fax: (318) 397-7828

Email: Help@Stage-Props-Blank-Guns.com


Toll Free Phone:
866 712-PROP (7767)
8 AM to 5 PM Central
Monday Through Friday
http://www.Stage-Props-Blank-Guns.com



  Stage-Props-Blank-Guns.com :: Movie Prop Blank Guns

  Movie Prop Blank Guns

YES WE ARE OPEN FOR BUSINESS AND SHIP MONDAY THROUGH FRIDAY; We have very realistic blank guns made of metal instead of plastic. Our Automatic blank guns automatically eject and reload the next round from the magazine when fired just like a real gun. Our Revolver blank firing guns revolve the next round to fire just like a real Revolver Fire Arm. We have Zoraki blank guns, blank gun Replicas of V92F, V85, Cougar/V Cougar, VPPK, PX4, 1911, Jackal, ARAS, Sava, P38, Colt Python 4 Revolvers, Detective snub nose revolvers, Olympic 6, for athletic events starter pistols and dog and horse training with 2.5”, 4.5” and 6” barrels, Dirty Harry Revolvers, 1873 Peacemaker Western revolvers in both 380 and .22 6MM, Retay Blank guns, blank firing lever action western rifle, UZI blank firing Machine Gun, fully automatic blank firing pistols as well as single and double action blank gun hand guns. We have front firing or front venting blank guns that fire flame and smoke from the end of the Barrel. View several pages by changing pages at the bottom of each page.



CLICK ON ANY CATEGORY BELOW TO VIEW
 Retay Front Firing 9MMPA Blank Firing guns
 Zoraki Blank Guns Front Firing
 Military and Law Enforcement Blank Guns
 Front Firing Blank Guns
 Western Blank Guns
 WW II Blank Guns
 Blank Firing Revolver Pistols
 Full Automatic Blank Firing Guns
 Pocket Pistol Blank Guns
 Blank Firing Derringers
 Blank Ammunition
 Modern Holsters
 Magazines for Blank Guns
 Western Holsters and Scabbards
 
 

 


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