608 5th Avenue, Third Floor ยท New York, NY 10020       Phone Icon  (212) 391-0633

  • Instagram Page Lauren B
  • Pinterest Page Lauren B
  • YouTube Page Lauren B
  • Blog Lauren B

CART (0)

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.

Engagement Rings

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` 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 ('7')
 INNER JOIN `catalog_product_index_eav` AS `extras_idx` ON extras_idx.entity_id = e.entity_id AND extras_idx.attribute_id = '252' AND extras_idx.store_id = 1 AND extras_idx.value in ('110') WHERE (`e`.`entity_id` IN('2695', '2821', '2918', '2928', '3153', '3159', '3210', '3328', '3350', '3355', '3358', '3360', '3448', '3546', '3550', '3568', '3576', '3578', '3605', '3612', '3676', '3787', '3788', '3821', '3866', '3886', '3888', '3902', '3944', '3951', '3952', '3954', '3966', '3976', '3978', '4039', '4057', '4061', '4067', '4069', '4070', '4074', '4091', '4113', '4119', '4158', '4159', '4174', '4180', '4181', '4182', '4183', '4195', '4205', '4228', '4229', '4231', '4232', '4244', '4250', '4269', '4370', '4498', '4499', '4561', '4563', '4636', '4959', '4961', '4964', '5007', '5043', '5046', '5047', '5048', '5049', '5496', '5609', '5613', '5621', '5681', '5683', '5751', '5764', '5799', '5884', '5887', '5889', '5890', '5891', '6033', '6034', '6103', '6191', '6194', '6197', '6198', '6263', '6264', '6265', '6266', '6267', '6269', '6300', '6302', '6304', '6305', '6307', '6309', '6312', '6313', '6315', '6316', '6318', '6327', '6328', '6394', '6417', '6420', '6464', '6465', '6493', '6494', '6495', '6597', '6617', '6619', '6642', '6643', '6655', '6656', '6657', '6660', '6661', '6662', '6696', '6697', '6698', '6700', '6709', '6741', '6742', '6744', '6745', '6748', '6778', '6779', '6780', '6782', '6793', '6830', '6834', '6837', '6852', '6853', '6854', '6872', '6974', '7035', '7037', '7038', '7042', '7044', '7046', '7093', '7097', '7099', '7103', '7104', '7105', '7106', '7243', '7244', '7245', '7246', '7247', '7248', '7256', '7336', '7337', '7407', '7409', '7411', '7412', '7414', '7483', '7484', '7485', '7487', '7488', '7545', '7571', '7573', '7578', '7579', '7580', '7582', '7583', '7622', '7650', '7687', '7706', '7713', '7788', '7789', '7801', '7813', '7818', '7819', '7820', '7821', '7822', '7823', '7824', '7825', '7826', '7828', '7829', '7832', '7834', '7936', '7937', '7940', '7941', '7943', '7950', '7952', '7993', '7995', '8060', '8062', '8063', '8064', '8065', '8067', '8164', '8165', '8167', '8177', '8178', '8179', '8183', '8192', '8193', '8296', '8300', '8301', '8303', '8304', '8305', '8306', '8307', '8355', '8356', '8357', '8358', '8359', '8360', '8365', '8372', '8375', '8376', '8414', '8415', '8416', '8417', '8419', '8420', '8421', '8511', '8512', '8514', '8515', '8516', '8530', '8574', '8584', '8593', '8595', '8596', '8628', '8629', '8652', '8654', '8655', '8697', '8699', '8700', '8701', '8702', '8819', '8820', '8821', '8824', '8825', '8877', '8878', '8881', '8882', '8918', '8919', '8971', '9003', '9004', '9005', '9006', '9092', '9093', '9106', '9107', '9108', '9111', '9112', '9167', '9168', '9169', '9170', '9183', '9184', '9186', '9213', '9218', '9219', '9220', '9221', '9222', '9223', '9224', '9226', '9228', '9251', '9252', '9253', '9254', '9256', '9257', '9299', '9301', '9303', '9304', '9305', '9306', '9690', '9822', '9823', '9824', '9934', '9935', '9976', '9977', '9978', '9979', '9996', '9997', '9999', '10000', '10064', '10066', '10100', '10122', '10123', '10125', '10126', '10141', '10142', '10143', '10144')) ORDER BY CAST( display_sort_order AS SIGNED ) desc, `e`.`entity_id` 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: 1293983142197