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,97,133,428) 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)))) AND ((((price_index.min_price -(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 2 THEN       0.2000 WHEN 4 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 2 THEN       0.2000 WHEN 4 THEN       0.2000  ELSE 0 END)+((price_index.min_price-(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 2 THEN       0.2000 WHEN 4 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 2 THEN       0.2000 WHEN 4 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 2 THEN       0.2000 WHEN 4 THEN       0.2000  ELSE 0 END)  + COALESCE((SELECT SUM(super_price.pricing_value) FROM catalog_product_super_attribute AS super INNER JOIN catalog_product_super_attribute_pricing AS super_price ON super.product_super_attribute_id = super_price.product_super_attribute_id AND super_price.is_percent = 0 AND super_price.value_index IN (122,97,133,428) WHERE super.product_id = e.entity_id), 0)) * 1 >= 102) AND ((price_index.min_price -(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 2 THEN       0.2000 WHEN 4 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 2 THEN       0.2000 WHEN 4 THEN       0.2000  ELSE 0 END)+((price_index.min_price-(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 2 THEN       0.2000 WHEN 4 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 2 THEN       0.2000 WHEN 4 THEN       0.2000  ELSE 0 END))*CASE price_index.tax_class_id WHEN 2 THEN       0.2000 WHEN 4 THEN       0.2000  ELSE 0 END)  + COALESCE((SELECT SUM(super_price.pricing_value) FROM catalog_product_super_attribute AS super INNER JOIN catalog_product_super_attribute_pricing AS super_price ON super.product_super_attribute_id = super_price.product_super_attribute_id AND super_price.is_percent = 0 AND super_price.value_index IN (122,97,133,428) WHERE super.product_id = e.entity_id), 0)) * 1 < 153))) ORDER BY `cat_index`.`position` ASC LIMIT 12 OFFSET 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}