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 `style_idx` ON style_idx.entity_id = e.entity_id AND style_idx.attribute_id = '136' AND style_idx.store_id = 1 AND style_idx.value in ('14') WHERE (`e`.`entity_id` IN('2740', '2826', '2875', '2928', '2954', '2968', '2970', '2982', '3112', '3132', '3134', '3143', '3151', '3152', '3153', '3175', '3176', '3208', '3210', '3327', '3328', '3332', '3349', '3350', '3351', '3352', '3353', '3355', '3358', '3359', '3360', '3361', '3362', '3414', '3446', '3448', '3510', '3512', '3513', '3514', '3515', '3526', '3528', '3533', '3537', '3540', '3542', '3548', '3550', '3552', '3558', '3559', '3561', '3562', '3563', '3564', '3567', '3568', '3569', '3578', '3599', '3601', '3602', '3603', '3604', '3605', '3611', '3612', '3676', '3681', '3728', '3729', '3730', '3743', '3748', '3749', '3750', '3767', '3768', '3786', '3787', '3788', '3797', '3799', '3800', '3804', '3805', '3807', '3821', '3826', '3849', '3850', '3852', '3854', '3856', '3866', '3867', '3873', '3874', '3875', '3884', '3887', '3888', '3889', '3891', '3899', '3901', '3902', '3903', '3905', '3907', '3909', '3911', '3912', '3913', '3914', '3916', '3932', '3934', '3935', '3936', '3937', '3943', '3944', '3945', '3946', '3948', '3951', '3952', '3954', '3956', '3961', '3962', '3963', '3964', '3966', '3967', '3968', '3969', '3970', '3972', '3973', '3974', '3975', '3976', '3978', '3980', '3981', '3983', '4020', '4023', '4025', '4026', '4027', '4028', '4029', '4039', '4049', '4051', '4057', '4058', '4059', '4061', '4062', '4066', '4067', '4068', '4071', '4072', '4073', '4074', '4076', '4077', '4078', '4079', '4080', '4081', '4085', '4086', '4087', '4088', '4090', '4091', '4093', '4095', '4096', '4099', '4100', '4102', '4103', '4104', '4106', '4108', '4109', '4110', '4111', '4113', '4114', '4115', '4116', '4117', '4119', '4120', '4121', '4123', '4127', '4129', '4131', '4133', '4137', '4138', '4139', '4140', '4141', '4142', '4145', '4155', '4156', '4157', '4158', '4159', '4162', '4165', '4168', '4174', '4175', '4176', '4177', '4178', '4179', '4180', '4181', '4182', '4183', '4184', '4185', '4187', '4188', '4194', '4195', '4196', '4198', '4200', '4201', '4202', '4203', '4204', '4205', '4206', '4212', '4213', '4214', '4215', '4216', '4217', '4218', '4220', '4222', '4223', '4224', '4234', '4235', '4236', '4237', '4238', '4240', '4241', '4242', '4243', '4244', '4245', '4246', '4249', '4250', '4251', '4252', '4254', '4255', '4256', '4257', '4258', '4263', '4264', '4265', '4266', '4269', '4272', '4273', '4304', '4305', '4369', '4370', '4451', '4452', '4455', '4498', '4501', '4502', '4504', '4525', '4526', '4561', '4563', '4636', '4637', '4957', '4958', '4959', '4960', '5007', '5019', '5020', '5042', '5050', '5086', '5133', '5401', '5410', '5474', '5475', '5484', '5489', '5491', '5492', '5493', '5498', '5504', '5563', '5564', '5609', '5613', '5616', '5617', '5618', '5619', '5621', '5622', '5624', '5680', '5681', '5682', '5683', '5684', '5749', '5751', '5761', '5763', '5764', '5799', '5800', '5801', '5802', '5806', '5807', '5808', '5809', '5810', '5836', '5837', '5958', '5984', '6000', '6001', '6002', '6031', '6104', '6105', '6127', '6128', '6149', '6187', '6191', '6193', '6194', '6195', '6196', '6197', '6198', '6199', '6200', '6202', '6203', '6263', '6264', '6265', '6266', '6267', '6300', '6302', '6304', '6305', '6306', '6307', '6308', '6316', '6318', '6325', '6327', '6328', '6329', '6417', '6419', '6420', '6464', '6465', '6493', '6494', '6495', '6537', '6597', '6610', '6617', '6619', '6630', '6642', '6644', '6655', '6656', '6657', '6658', '6659', '6660', '6661', '6662', '6684', '6695', '6696', '6699', '6700', '6708', '6709', '6710', '6737', '6744', '6747', '6748', '6749', '6750', '6751', '6778', '6779', '6780', '6781', '6782', '6793', '6830', '7034', '7035', '7036', '7037', '7038', '7039', '7040', '7041', '7043', '7046', '7093', '7094', '7095', '7099', '7102', '7104', '7105', '7106', '7179', '7190', '7191', '7211', '7252', '7253', '7254', '7255', '7256', '7374', '7392', '7402', '7404', '7407', '7408', '7412', '7413', '7414', '7439', '7489', '7490', '7491', '7508', '7545', '7557', '7571', '7572', '7573', '7575', '7576', '7577', '7578', '7579', '7580', '7581', '7582', '7583', '7591', '7621', '7622', '7650', '7686', '7706', '7719', '7720', '7742', '7768', '7788', '7790', '7802', '7811', '7812', '7813', '7814', '7816', '7817', '7819', '7820', '7821', '7824', '7825', '7829', '7831', '7833', '7834', '7943', '7950', '7952', '7954', '7955', '7972', '7994', '7995', '7996', '8060', '8061', '8062', '8066', '8179', '8182', '8191', '8192', '8193', '8225', '8303', '8304', '8306', '8307', '8308', '8349', '8355', '8356', '8357', '8358', '8359', '8360', '8361', '8362', '8366', '8368', '8370', '8372', '8373', '8374', '8376', '8377', '8378', '8409', '8410', '8411', '8418', '8420', '8478', '8511', '8512', '8514', '8515', '8516', '8521', '8522', '8523', '8524', '8527', '8528', '8529', '8530', '8574', '8593', '8595', '8596', '8597', '8628', '8629', '8693', '8699', '8700', '8702', '8787', '8821', '8823', '8824', '8825', '8877', '8878', '8881', '8913', '8918', '9002', '9003', '9005', '9006', '9061', '9112', '9174', '9180', '9182', '9186', '9208', '9217', '9218', '9219', '9220', '9222', '9223', '9224', '9225', '9227', '9228', '9229', '9253', '9256', '9257', '9301', '9302', '9303', '9304', '9305', '9306', '9325', '9521', '9730', '9825', '9826', '9917', '9918', '9919', '9960', '9961', '9962', '9976', '9977', '9978', '9979', '9996', '9997', '9998', '9999', '10000', '10018', '10122', '10123', '10124', '10125', '10126', '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: 1696217105556