Stage-Props-Blank-Guns.com

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='0' 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
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

Welcome to Stage-Props-Blank-Guns.com

Click here HOME to go to Stage-Props-Blank-Guns.com Home Page

Registration is not required to shop or make purchases in our store, but is offered as a convenience to all our customers to facilitate ease of checkout, order management, special discount news and other membership benefits. If you currently are not a member of our store and would like to register, simply click on the "register" link below. If you are a registered customer and would like to log in, please proceed to our secure log in page by clicking the "secure log in button" below.

Authentication

Secure login

Register

Recover password

If Javascript is disabled in your browser click here

Accept Credit Cards