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)

Ring Designs Video Gallery

Watch your favorite custom ring designs from Lauren B all in HD quality;
sortable by shape, design, carat size and more
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 = '50'
 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_loose_idx` ON shape_loose_idx.entity_id = e.entity_id AND shape_loose_idx.attribute_id = '261' AND shape_loose_idx.store_id = 1 AND shape_loose_idx.value in ('109')
 INNER JOIN `catalog_product_index_eav` AS `gf_center_stone_size_idx` ON gf_center_stone_size_idx.entity_id = e.entity_id AND gf_center_stone_size_idx.attribute_id = '259' AND gf_center_stone_size_idx.store_id = 1 AND gf_center_stone_size_idx.value in ('95') WHERE (`e`.`entity_id` IN('4268', '4270', '4286', '4289', '4294', '4297', '4318', '4330', '4331', '4335', '4337', '4341', '4343', '4346', '4355', '4366', '4367', '4383', '4384', '4393', '4398', '4418', '4420', '4432', '4433', '4440', '4442', '4447', '4459', '4465', '4477', '4486', '4492', '4528', '4529', '4538', '4539', '4548', '4549', '4555', '4559', '4565', '4567', '4577', '4589', '4594', '4607', '4608', '4619', '4635', '4640', '4643', '4645', '4646', '4647', '4649', '4654', '4655', '4657', '4659', '4660', '4666', '4668', '4672', '4674', '4685', '4689', '4705', '4709', '4718', '4719', '4720', '4722', '4723', '4724', '4732', '4738', '4742', '4743', '4749', '4751', '4753', '4756', '4758', '4771', '4773', '4777', '4784', '4791', '4792', '4799', '4804', '4809', '4811', '4814', '4824', '4833', '4837', '4838', '4841', '4843', '4844', '4845', '4848', '4853', '4858', '4861', '4862', '4863', '4864', '4865', '4866', '4871', '4874', '4879', '4881', '4887', '4888', '4890', '4894', '4909', '4911', '4913', '4914', '4917', '4919', '4923', '4926', '4929', '4930', '4931', '4932', '4936', '4938', '4940', '4942', '4943', '4947', '4950', '4953', '4954', '4956', '5268', '5271', '5275', '5277', '5278', '5279', '5283', '5284', '5290', '5293', '5308', '5314', '5315', '5322', '5327', '5333', '5335', '5342', '5346', '5351', '5363', '5364', '5368', '5402', '5405', '5406', '5408', '5409', '5417', '5419', '5424', '5425', '5432', '5443', '5445', '5448', '5451', '5456', '5461', '5462', '5472', '5525', '5529', '5532', '5535', '5536', '5537', '5538', '5541', '5542', '5554', '5561', '5565', '5570', '5578', '5583', '5588', '5596', '5602', '5630', '5632', '5636', '5637', '5643', '5644', '5645', '5662', '5665', '5666', '5668', '5670', '5677', '5701', '5708', '5713', '5719', '5720', '5723', '5732', '5738', '5741', '5745', '5748', '5753', '5756', '5766', '5767', '5769', '5770', '5777', '5784', '5787', '5793', '5796', '5797', '5815', '5819', '5820', '5823', '5829', '5832', '5839', '5845', '5854', '5857', '5860', '5863', '5866', '5868', '5875', '5876', '5877', '5893', '5895', '5896', '5905', '5907', '5916', '5917', '5932', '5937', '5939', '5941', '5961', '5965', '5966', '5967', '5979', '5989', '5992', '6006', '6010', '6012', '6016', '6017', '6019', '6022', '6028', '6039', '6041', '6043', '6045', '6049', '6052', '6061', '6109', '6113', '6114', '6121', '6133', '6140', '6143', '6144', '6147', '6160', '6164', '6167', '6169', '6170', '6171', '6173', '6184', '6185', '6212', '6213', '6217', '6218', '6221', '6222', '6223', '6224', '6229', '6231', '6232', '6236', '6243', '6253', '6255', '6260', '6272', '6283', '6284', '6285', '6288', '6291', '6297', '6326', '6332', '6333', '6334', '6347', '6348', '6352', '6353', '6368', '6372', '6380', '6381', '6388', '6390', '6398', '6399', '6400', '6406', '6421', '6426', '6436', '6439', '6442', '6450', '6460', '6461', '6475', '6477', '6480', '6483', '6484', '6497', '6499', '6501', '6505', '6506', '6509', '6511', '6514', '6515', '6516', '6518', '6520', '6527', '6528', '6532', '6541', '6548', '6553', '6557', '6558', '6559', '6563', '6564', '6584', '6585', '6592', '6598', '6601', '6602', '6605', '6606', '6611', '6614', '6621', '6623', '6649', '6676', '6678', '6685', '6686', '6702', '6703', '6704', '6705', '6706', '6715', '6716', '6722', '6727', '6731', '6736', '6757', '6763', '6766', '6769', '6784', '6786', '6790', '6792', '6795', '6803', '6804', '6808', '6810', '6817', '6828', '6875', '6880', '6881', '6885', '6887', '6915', '6919', '6926', '6950', '6952', '6954', '6955', '6956', '6963', '6966', '6971', '6978', '6980', '6989', '6991', '6993', '7002', '7008', '7014', '7016', '7049', '7055', '7057', '7062', '7063', '7069', '7074', '7083', '7109', '7112', '7116', '7118', '7148', '7151', '7154', '7157', '7159', '7160', '7166', '7185', '7186', '7200', '7204', '7208', '7210', '7213', '7222', '7226', '7228', '7230', '7232', '7233', '7264', '7265', '7270', '7274', '7276', '7287', '7288', '7296', '7299', '7302', '7303', '7304', '7308', '7315', '7318', '7323', '7327', '7330', '7332', '7344', '7348', '7349', '7351', '7352', '7364', '7369', '7381', '7386', '7388', '7389', '7390', '7391', '7395', '7400', '7401', '7416', '7419', '7427', '7432', '7434', '7449', '7452', '7457', '7460', '7463', '7465', '7467', '7468', '7469', '7470', '7473', '7495', '7502', '7505', '7520', '7526', '7527', '7535', '7538', '7540', '7548', '7551', '7552', '7560', '7565', '7567', '7592', '7593', '7597', '7604', '7612', '7616', '7618', '7619', '7629', '7633', '7635', '7640', '7646', '7647', '7648', '7651', '7658', '7662', '7667', '7668', '7675', '7678', '7684', '7685', '7693', '7694', '7696', '7705', '7714', '7726', '7727', '7736', '7744', '7745', '7747', '7757', '7765', '7774', '7783', '7785', '7792', '7793', '7795', '7798', '7807', '7838', '7842', '7847', '7849', '7850', '7851', '7857', '7859', '7860', '7862', '7865', '7867', '7868', '7870', '7878', '7879', '7891', '7897', '7898', '7902', '7906', '7909', '7912', '7913', '7947', '7969', '7970', '7982', '7999', '8012', '8015', '8017', '8024', '8026', '8028', '8033', '8035', '8041', '8043', '8047', '8086', '8088', '8094', '8112', '8113', '8115', '8117', '8118', '8119', '8122', '8125', '8130', '8131', '8138', '8195', '8197', '8199', '8205', '8216', '8221', '8228', '8250', '8251', '8268', '8271', '8280', '8292', '8339', '8340', '8342', '8390', '8391', '8393', '8400', '8402', '8404', '8406', '8407', '8408', '8434', '8467', '8472', '8477', '8493', '8497', '8540', '8543', '8544', '8547', '8554', '8570', '8573', '8599', '8606', '8608', '8609', '8632', '8639', '8656', '8666', '8675', '8681', '8682', '8684', '8713', '8715', '8716', '8725', '8733', '8736', '8739', '8742', '8744', '8798', '8803', '8804', '8807', '8809', '8811', '8814', '8816', '8817', '8826', '8835', '8845', '8847', '8849', '8892', '8894', '8895', '8898', '8933', '8940', '8941', '8944', '8952', '8953', '8955', '8959', '8964', '8983', '8984', '8988', '8992', '8996', '8997', '8998', '8999', '9011', '9012', '9017', '9021', '9022', '9023', '9025', '9064', '9067', '9068', '9071', '9075', '9077', '9083', '9086', '9118', '9122', '9123', '9125', '9132', '9133', '9136', '9140', '9146', '9151', '9153', '9156', '9159', '9164', '9237', '9238', '9240', '9286', '9289', '9292', '9295', '9296', '9310', '9312', '9314', '9316', '9324', '9326', '9327', '9328', '9333', '9334', '9336', '9339', '9343', '9345', '9374', '9378', '9379', '9386', '9399', '9407', '9413', '9420', '9429', '9468', '9515', '9516', '9517', '9518', '9520', '9607', '9612', '9614', '9621', '9623', '9628', '9630', '9633', '9636', '9641', '9642', '9646', '9667', '9670', '9671', '9672', '9680', '9687', '9688', '9701', '9704', '9705', '9715', '9716', '9717', '9718', '9719', '9724', '9725', '9726', '9728', '9733', '9734', '9735', '9739', '9741', '9742', '9744', '9797', '9800', '9802', '9805', '9807', '9813', '9814', '9815', '9817', '9834', '9836', '9837', '9838', '9841', '9849', '9850', '9852', '9853', '9910', '9912', '9914', '9916', '9922', '9925', '9926', '9927', '9929', '9936', '9938', '9942', '9944', '9952', '9953', '9969', '9984', '9986', '9987', '9989', '9990', '9993', '10002', '10004', '10009', '10011', '10014', '10024', '10025', '10028', '10034', '10048', '10049', '10051', '10056', '10058', '10059', '10069', '10070', '10071', '10074', '10075', '10077', '10083', '10084', '10085', '10088', '10106', '10107', '10108', '10112', '10113', '10116', '10128', '10149', '10151', '10175', '10178', '10179', '10183', '10184', '10210', '10214', '10215', '10220', '10223', '10225', '10227', '10228', '10231', '10244', '10253', '10264', '10265', '10267', '10274', '10281', '10283', '10289', '10290', '10302', '10304', '10308', '10313', '10314', '10315', '10316', '10321', '10333', '10334', '10337', '10338', '10342', '10382', '10383', '10392', '10394', '10395', '10402', '10407', '10409', '10410', '10413', '10419', '10425', '10436', '10446', '10447', '10449', '10454', '10459', '10473', '10477', '10479', '10480', '10486', '10490', '10494', '10501', '10503', '10509', '10518', '10519', '10520', '10522', '10525', '10528', '10530', '10538', '10539', '10547', '10554', '10555', '10559', '10571', '10573', '10574', '10576', '10587', '10592', '10597', '10611', '10616', '10617', '10618', '10620', '10640', '10644', '10646', '10650', '10653', '10659', '10674', '10677', '10680', '10683', '10685', '10688', '10689', '10693', '10695', '10709', '10710', '10720', '10735', '10736', '10738', '10744', '10747', '10750', '10754', '10762', '10769', '10782', '10783', '10785', '10786', '10787', '10791', '10792', '10802', '10804', '10806', '10808', '10809', '10811', '10815', '10816', '10832', '10833', '10836', '10837', '10845', '10850', '10852', '10855', '10856', '10857', '10867', '10870', '10871', '10873', '10874', '10880', '10888', '10890', '10892', '10911', '10912', '10914', '10923', '10927', '10929', '10979', '10986', '10987', '11036', '11039', '11044', '11047', '11053', '11081', '11089', '11093', '11097', '11118', '11123', '11124', '11125', '11128', '11134', '11159', '11168', '11169', '11171', '11191', '11197', '11203', '11222', '11223', '11226', '11229', '11240', '11246', '11251', '11252', '11331', '11333', '11335', '11337', '11343', '11345', '11367', '11368', '11385', '11400', '11402', '11403', '11410', '11411', '11421', '11444', '11446', '11456', '11458', '11466', '11472', '11488', '11496', '11500', '11515', '11516', '11526', '11527', '11558', '11567', '11568', '11571', '11578', '11612', '11613', '11614', '11615', '11618', '11625', '11636', '11638', '11640', '11642', '11644', '11648', '11655', '11657', '11658', '11669', '11670', '11677', '11680', '11683', '11685', '11686', '11689', '11693', '11694', '11695', '11696', '11697', '11699', '11700', '11703', '11748', '11749', '11752', '11755', '11757', '11758', '11761', '11762', '11764', '11765', '11801', '11887', '11963', '11967')) 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: 1685992792492