Home / Engagement Rings Engagement Rings Browse Lauren B's collection of Engagement Rings all available for custom order with any size, shape, type or quality center-stone. Use the filters below to help refine your search and find the perfect ring. There has been an error processing your request There has been an error processing your request 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`, `at_price`.`price`, `at_priceN`.`price` AS `priceN`, `at_jewelry_price_idx`.`value` AS `jewelry_price_idx`, `at_display_order_number`.`value` AS `display_order_number` 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 = '9' 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 INNER JOIN `catalog_product_index_eav` AS `shape_idx` ON shape_idx.entity_id = e.entity_id AND shape_idx.attribute_id = '135' AND shape_idx.store_id = 1 AND shape_idx.value in ('6') INNER JOIN `catalog_product_index_eav` AS `category_cl_idx` ON category_cl_idx.entity_id = e.entity_id AND category_cl_idx.attribute_id = '280' AND category_cl_idx.store_id = 1 AND category_cl_idx.value in ('236') LEFT JOIN `catalog_product_index_price` AS `at_price` ON (at_price.`entity_id`=e.entity_id) AND (at_price.price > 0) LEFT JOIN `catalog_product_index_price` AS `at_priceN` ON (at_priceN.`entity_id`=e.entity_id) AND (at_priceN.price = 0) LEFT JOIN `catalog_product_index_eav` AS `at_jewelry_price_idx` ON (at_jewelry_price_idx.`entity_id`=e.entity_id) AND (at_jewelry_price_idx.attribute_id = 286) LEFT JOIN `catalog_product_entity_decimal` AS `at_display_order_number` ON (`at_display_order_number`.`entity_id` = `e`.`entity_id`) AND (`at_display_order_number`.`attribute_id` = '299') AND (`at_display_order_number`.`store_id` = 0) WHERE (( (at_price.price >= '' AND at_price.price <= '') ) OR (at_priceN.price = '0' AND at_jewelry_price_idx.value in (228%2C223) ) ) ORDER BY `display_order_number` desc, `e`.`entity_id` DESC, `at_display_order_number`.`value` DESC Trace: #0 /home/laurenbgem/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/laurenbgem/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/laurenbgem/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /home/laurenbgem/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT DISTINCT...', Array) #4 /home/laurenbgem/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT DISTINCT...', Array) #5 /home/laurenbgem/public_html/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query('SELECT DISTINCT...', Array) #6 /home/laurenbgem/public_html/lib/Varien/Data/Collection/Db.php(740): Zend_Db_Adapter_Abstract->fetchAll('SELECT DISTINCT...', Array) #7 /home/laurenbgem/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1047): Varien_Data_Collection_Db->_fetchAll('SELECT DISTINCT...') #8 /home/laurenbgem/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false) #9 /home/laurenbgem/public_html/lib/Varien/Data/Collection.php(313): Mage_Eav_Model_Entity_Collection_Abstract->load() #10 /home/laurenbgem/public_html/app/code/local/Mage/Catalog/Block/Product/List.php(365): Varien_Data_Collection->getColumnValues('entity_id') #11 /home/laurenbgem/public_html/app/code/local/Mage/Catalog/Block/Product/List.php(355): Mage_Catalog_Block_Product_List->saveOrderedIds() #12 /home/laurenbgem/public_html/app/code/local/Mage/Catalog/Block/Product/List.php(227): Mage_Catalog_Block_Product_List->sortCollection() #13 /home/laurenbgem/public_html/app/code/local/Mage/Catalog/Block/Product/List.php(420): Mage_Catalog_Block_Product_List->_getProductCollection() #14 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Abstract.php(922): Mage_Catalog_Block_Product_List->_beforeToHtml() #15 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml() #16 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('product_list', true) #17 /home/laurenbgem/public_html/app/code/core/Mage/Catalog/Block/Category/View.php(104): Mage_Core_Block_Abstract->getChildHtml('product_list') #18 /home/laurenbgem/public_html/app/design/frontend/default/MAG090181/template/catalog/category/view.phtml(129): Mage_Catalog_Block_Category_View->getProductListHtml() #19 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Template.php(242): include('/home/laurenbge...') #20 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Template.php(273): Mage_Core_Block_Template->fetchView('frontend/defaul...') #21 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Template.php(287): Mage_Core_Block_Template->renderView() #22 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml() #23 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #24 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml() #25 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml() #26 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('content', true) #27 /home/laurenbgem/public_html/app/design/frontend/default/MAG090181/template/page/1column.phtml(73): Mage_Core_Block_Abstract->getChildHtml('content') #28 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Template.php(242): include('/home/laurenbge...') #29 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Template.php(273): Mage_Core_Block_Template->fetchView('frontend/defaul...') #30 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Template.php(287): Mage_Core_Block_Template->renderView() #31 /home/laurenbgem/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml() #32 /home/laurenbgem/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #33 /home/laurenbgem/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #34 /home/laurenbgem/public_html/app/code/core/Mage/Catalog/controllers/CategoryController.php(161): Mage_Core_Controller_Varien_Action->renderLayout() #35 /home/laurenbgem/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Catalog_CategoryController->viewAction() #36 /home/laurenbgem/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view') #37 /home/laurenbgem/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/laurenbgem/public_html/app/code/core/Mage/Core/Model/App.php(370): Mage_Core_Controller_Varien_Front->dispatch() #39 /home/laurenbgem/public_html/app/Mage.php(692): Mage_Core_Model_App->run(Array) #40 /home/laurenbgem/public_html/index.php(89): Mage::run('', 'store') #41 {main} Error log record number: 1648330075163