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='299' 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 = '299' 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
Home 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
 
 

Home Theater Seating

Choose from our huge selection of Home Theater Seating including In-Stock Seats, Custom Home Theater models and more. Stargate Cinema has the largest selection of home theater seats and chairs anywhere and is pround to be fully Authorized Dealers for brands like Palliser, RowOne, Lane, Barcalounger, Klaussner, Jaymar, Albany Furniture and more. Select from Home Theater Recliners, Movie Theater Style seats or alternative style seating, all built to provide maximum comfort for the longest of movies.

Comfortable seating can play a huge role in the movie watching experience. Our seating line-up has been selected not only for comfort, but for durability too. Our perfect A+ BBB rating (with no complaints!) guarantees excellent customer service during your purchase and superior service backed by warranties of national brands after your purchase.
Home Theater Seating
There are no available products under this category.