Loading

Dinnerware

View a wide range of tableware patterns, whether you prefer a traditional pattern or an opulent and modern design for a fine dining experience to impress. The lightness, strength and durability of the fine bone china allows to balance and captivate the culinary experience of setting the standard in luxury dining.
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(at_product_customer_groups.value_id > 0, at_product_customer_groups.value, at_product_customer_groups_default.value) AS `product_customer_groups` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '7'
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
 LEFT JOIN `catalog_product_entity_text` AS `at_product_customer_groups_default` ON (`at_product_customer_groups_default`.`entity_id` = `e`.`entity_id`) AND (`at_product_customer_groups_default`.`attribute_id` = '157') AND `at_product_customer_groups_default`.`store_id` = 0
 LEFT JOIN `catalog_product_entity_text` AS `at_product_customer_groups` ON (`at_product_customer_groups`.`entity_id` = `e`.`entity_id`) AND (`at_product_customer_groups`.`attribute_id` = '157') AND (`at_product_customer_groups`.`store_id` = 1)
 INNER JOIN `catalog_product_index_eav` AS `color_specific_idx` ON color_specific_idx.entity_id = e.entity_id AND color_specific_idx.attribute_id = '166' AND color_specific_idx.store_id = 1 AND color_specific_idx.value in (122,138,55,141)
 INNER JOIN `catalog_product_index_eav` AS `item_type_idx` ON item_type_idx.entity_id = e.entity_id AND item_type_idx.attribute_id = '168' AND item_type_idx.store_id = 1 AND item_type_idx.value in (438) WHERE ((IF(at_product_customer_groups.value_id > 0, at_product_customer_groups.value, at_product_customer_groups_default.value) IS NULL) OR (FIND_IN_SET(0, IF(at_product_customer_groups.value_id > 0, at_product_customer_groups.value, at_product_customer_groups_default.value)))) ORDER BY `cat_index`.`position` ASC LIMIT 12

SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine

#0 /home/royalcrownderby/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/royalcrownderby/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/royalcrownderby/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/royalcrownderby/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT DISTINCT...', Array)
#4 /home/royalcrownderby/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT DISTINCT...', Array)
#5 /home/royalcrownderby/public_html/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query('SELECT DISTINCT...', Array)
#6 /home/royalcrownderby/public_html/lib/Varien/Data/Collection/Db.php(740): Zend_Db_Adapter_Abstract->fetchAll('SELECT DISTINCT...', Array)
#7 /home/royalcrownderby/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1047): Varien_Data_Collection_Db->_fetchAll('SELECT DISTINCT...')
#8 /home/royalcrownderby/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#9 /home/royalcrownderby/public_html/app/code/core/Mage/Review/Model/Observer.php(78): Mage_Eav_Model_Entity_Collection_Abstract->load()
#10 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Model/App.php(1340): Mage_Review_Model_Observer->catalogBlockProductCollectionBeforeToHtml(Object(Varien_Event_Observer))
#11 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Model/App.php(1313): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Review_Model_Observer), 'catalogBlockPro...', Object(Varien_Event_Observer))
#12 /home/royalcrownderby/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('catalog_block_p...', Array)
#13 /home/royalcrownderby/public_html/app/code/core/Mage/Catalog/Block/Product/List.php(165): Mage::dispatchEvent('catalog_block_p...', Array)
#14 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Abstract.php(922): Mage_Catalog_Block_Product_List->_beforeToHtml()
#15 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#16 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('product_list', true)
#17 /home/royalcrownderby/public_html/app/code/core/Mage/Catalog/Block/Category/View.php(90): Mage_Core_Block_Abstract->getChildHtml('product_list')
#18 /home/royalcrownderby/public_html/app/design/frontend/default/netbiz/template/netbiz/widget/category/layout/default.phtml(54): Mage_Catalog_Block_Category_View->getProductListHtml()
#19 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/royalcrow...')
#20 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#21 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#22 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#23 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#24 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml()
#25 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#26 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#27 /home/royalcrownderby/public_html/app/design/frontend/default/netbiz/template/page/category-stacked.phtml(25): Mage_Core_Block_Abstract->getChildHtml('content')
#28 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/royalcrow...')
#29 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#30 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#31 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#32 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Model/Layout.php(558): Mage_Core_Block_Abstract->toHtml()
#33 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#34 /home/royalcrownderby/public_html/app/code/core/Mage/Catalog/controllers/CategoryController.php(161): Mage_Core_Controller_Varien_Action->renderLayout()
#35 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Catalog_CategoryController->viewAction()
#36 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view')
#37 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#38 /home/royalcrownderby/public_html/app/code/core/Mage/Core/Model/App.php(355): Mage_Core_Controller_Varien_Front->dispatch()
#39 /home/royalcrownderby/public_html/app/Mage.php(689): Mage_Core_Model_App->run(Array)
#40 /home/royalcrownderby/public_html/index.php(101): Mage::run('', 'store')
#41 {main}