INVALID SQL: 1030 : Got error 28 from storage engine
SQL QUERY FAILURE:SELECT node.*, IF(xcart_categories_lng.categoryid IS NOT NULL AND xcart_categories_lng.category != '', xcart_categories_lng.category, node.category) AS category, xcart_categories_subcount.subcategory_count, xcart_categories_subcount.product_count, xcart_categories_subcount.top_product_count, xcart_images_C.image_path, xcart_images_C.image_x, xcart_images_C.image_y, xcart_images_C.imageid FROM xcart_categories AS node LEFT JOIN xcart_categories_lng USE INDEX (PRIMARY) ON xcart_categories_lng.code='en' AND xcart_categories_lng.categoryid=node.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = node.categoryid LEFT JOIN xcart_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = node.categoryid AND xcart_categories_subcount.membershipid = '' LEFT JOIN xcart_images_C ON node.categoryid = xcart_images_C.id WHERE node.parentid = '0' AND node.avail = 'Y' AND (xcart_category_memberships.membershipid IS NULL OR xcart_category_memberships.membershipid = '') GROUP BY node.categoryid ORDER BY node.lpos, category
INVALID SQL: 1030 : Got error 28 from storage engine
SQL QUERY FAILURE:SELECT node.*, IF(xcart_categories_lng.categoryid IS NOT NULL AND xcart_categories_lng.category != '', xcart_categories_lng.category, node.category) AS category, xcart_categories_subcount.subcategory_count, xcart_categories_subcount.product_count, xcart_categories_subcount.top_product_count, xcart_images_C.image_path, xcart_images_C.image_x, xcart_images_C.image_y, xcart_images_C.imageid FROM xcart_categories AS node LEFT JOIN xcart_categories_lng USE INDEX (PRIMARY) ON xcart_categories_lng.code='en' AND xcart_categories_lng.categoryid=node.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = node.categoryid LEFT JOIN xcart_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = node.categoryid AND xcart_categories_subcount.membershipid = '' LEFT JOIN xcart_images_C ON node.categoryid = xcart_images_C.id WHERE node.parentid = '0' AND node.avail = 'Y' AND (xcart_category_memberships.membershipid IS NULL OR xcart_category_memberships.membershipid = '') GROUP BY node.categoryid ORDER BY node.lpos, category
INVALID SQL: 1030 : Got error 28 from storage engine
SQL QUERY FAILURE:SELECT node.*, IF(xcart_categories_lng.categoryid IS NOT NULL AND xcart_categories_lng.category != '', xcart_categories_lng.category, node.category) AS category, xcart_categories_subcount.subcategory_count, xcart_categories_subcount.product_count, xcart_categories_subcount.top_product_count, (COUNT(parent.categoryid)-1) AS category_level, xcart_images_C.image_path, xcart_images_C.image_x, xcart_images_C.image_y, xcart_images_C.imageid FROM xcart_categories AS parent ,xcart_categories AS node LEFT JOIN xcart_categories_lng USE INDEX (PRIMARY) ON xcart_categories_lng.code='en' AND xcart_categories_lng.categoryid=node.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = node.categoryid LEFT JOIN xcart_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = node.categoryid AND xcart_categories_subcount.membershipid = '' LEFT JOIN xcart_images_C ON node.categoryid = xcart_images_C.id WHERE node.avail = 'Y' AND (xcart_category_memberships.membershipid IS NULL OR xcart_category_memberships.membershipid = '') AND node.lpos BETWEEN parent.lpos AND parent.rpos GROUP BY node.categoryid HAVING category_level <= 8 ORDER BY node.lpos, category
INVALID SQL: 1030 : Got error 28 from storage engine
SQL QUERY FAILURE:SELECT xcart_manufacturers.*, IFNULL(xcart_manufacturers_lng.manufacturer, xcart_manufacturers.manufacturer) AS manufacturer, IFNULL(xcart_manufacturers_lng.descr, xcart_manufacturers.descr) AS descr FROM xcart_manufacturers USE INDEX (avail) LEFT JOIN xcart_manufacturers_lng ON xcart_manufacturers.manufacturerid = xcart_manufacturers_lng.manufacturerid AND xcart_manufacturers_lng.code = 'en' WHERE avail = 'Y' ORDER BY orderby, manufacturer
INVALID SQL: 1030 : Got error 28 from storage engine
SQL QUERY FAILURE:SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_product_features.fclassid, IF(xcart_product_features.fclassid IS NULL || xcart_product_features.productid IN ('0'),'','Y') as is_clist, IF(xcart_products_lng.productid != '', xcart_products_lng.product, xcart_products.product) as product, IF(xcart_products_lng.productid != '', xcart_products_lng.descr, xcart_products.descr) as descr, IF(xcart_products_lng.productid != '', xcart_products_lng.fulldescr, xcart_products.fulldescr) as fulldescr, IFNULL(xcart_variants.avail, xcart_products.avail) as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode FROM xcart_products INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_products.forsale = 'Y' INNER JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_customers as ACHECK ON xcart_products.provider = ACHECK.id AND ACHECK.activity='Y' INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.avail = 'Y' LEFT JOIN xcart_product_features ON xcart_product_features.productid = xcart_products.productid LEFT JOIN xcart_feature_classes ON xcart_feature_classes.fclassid = xcart_product_features.fclassid AND xcart_feature_classes.avail = 'Y' LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'en' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid WHERE xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_products_categories.categoryid='335' GROUP BY xcart_products.productid ORDER BY xcart_products_categories.orderby ASC, product ASC, xcart_products.productcode ASC, xcart_products.productid ASC LIMIT 0, 48
Warning: Invalid argument supplied for foreach() in /home/stargatecinema/public_html/include/search.php on line 1236
INVALID SQL: 1030 : Got error 28 from storage engine
SQL QUERY FAILURE:SELECT node.*, IF(xcart_categories_lng.categoryid IS NOT NULL AND xcart_categories_lng.category != '', xcart_categories_lng.category, node.category) AS category, xcart_categories_subcount.subcategory_count, xcart_categories_subcount.product_count, xcart_categories_subcount.top_product_count, xcart_images_C.image_path, xcart_images_C.image_x, xcart_images_C.image_y, xcart_images_C.imageid FROM xcart_categories AS node LEFT JOIN xcart_categories_lng USE INDEX (PRIMARY) ON xcart_categories_lng.code='en' AND xcart_categories_lng.categoryid=node.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = node.categoryid LEFT JOIN xcart_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = node.categoryid AND xcart_categories_subcount.membershipid = '' LEFT JOIN xcart_images_C ON node.categoryid = xcart_images_C.id WHERE node.parentid = '335' AND node.avail = 'Y' AND (xcart_category_memberships.membershipid IS NULL OR xcart_category_memberships.membershipid = '') GROUP BY node.categoryid ORDER BY node.lpos, category
INVALID SQL: 1030 : Got error 28 from storage engine
SQL QUERY FAILURE:SELECT xcart_manufacturers.*, IFNULL(xcart_manufacturers_lng.manufacturer, xcart_manufacturers.manufacturer) AS manufacturer, IFNULL(xcart_manufacturers_lng.descr, xcart_manufacturers.descr) AS descr FROM xcart_manufacturers USE INDEX (avail) LEFT JOIN xcart_manufacturers_lng ON xcart_manufacturers.manufacturerid = xcart_manufacturers_lng.manufacturerid AND xcart_manufacturers_lng.code = 'en' WHERE avail = 'Y' ORDER BY orderby, manufacturer
Posts and Rope, Stanchions - Stargate Cinema
 
 
 
 
Sometimes it's easier to talk through your decision to purchase home theater seating and accessories with a real person. Our product experts would be glad to assist you!
Speak to a Product Expert now:
1.866.684.3843
We are here to help:
Mon - Fri 8:30 AM - 5 PM EST
Sat/Sun- Closed
Close X
 
 

Posts and Rope, Stanchions

Give your theater guests the feeling of "going behind the ropes" with our Authentic Theater Ropes at wholesale prices with Free Shipping! Our top quality theater posts and theater ropes turn your room into a first class theater! Get the same theater posts and theater ropes used in commercial theaters across the country.

Choose from our Velour, Naughahyde and Twisted Ropes in a variety of colors as well as our extensive selection of Posts (Stanchions) in a wide selection of finishes.

All of our posts and rope products are proudly made in the USA. Don't settle for lesser quality products made overseas.

While we specialize in supplying post and ropes for Home Theater owners, our wholesale pricing enables us to supply many commercial businesses, government, military, churches and organizations. Please call us at 866.684.3843 for a custom quote for larger quantities. Some of our recent clients include: Artists, Colleges, the U.S. Coast Guard, Libraries, Churches, Synagogues, Governments, Car Dealerships, Museums and of course, Theaters. Don't forget that each product is currently offered with Free Shipping!

Posts and Rope, Stanchions
There are no available products under this category.