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='329' 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 = '329' 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
Movie Theater Seating - 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
 
 

Movie Theater Seating

Stargate Cinema now offers free shipping on our Authentic Movie Theater Seats as well as quantity pricing! Now you can finally get the real theater seats that you've always wanted at the lowest prices anywhere.
Comfortable seating can play a huge role in the movie watching experience. Our movie theater seating line-up has been selected not only for comfort, but for durability too. The seats we sell are not only installed in many home theaters, but in commercial theaters, churches and auditoriums as well. All major credit cards and Government Purchase Orders are accepted. Please contact our seating experts, toll free, for a custom quote: 866.684.3843.
Movie Theater Seating
There are no available products under this category.