Pear Diamond Rings

Array ( [all_sql] => MULTI:SELECT stone_price_id, cert_no, carat_price, color, clarity, total_price, lab, stone FROM dd_stone_price_lbg WHERE status='1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.009 AND crt_to >= 0.009 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 42.270228 [side_stone_price] => 0 [price_before_markup] => 319 [all_stone_price] => 42.270228 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 319 [metal_price_gm] => 93.0000 [metal_price] => 181.44 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 271 [setting_final_price] => 220 [metal_weight] => 1.9509677419355 [no_price] => 0 [stone_ids] => Array ( [0] => 1929884 ) [no_option] => 0 [no_option_comb] => )

Array ( [all_sql] => MULTI:SELECT stone_price_id, cert_no, carat_price, color, clarity, total_price, lab, stone FROM dd_stone_price_lbg WHERE status='1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.01 AND crt_to >= 0.01 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 50.57976 [side_stone_price] => 0 [price_before_markup] => 570 [all_stone_price] => 50.57976 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 570 [metal_price_gm] => 93.0000 [metal_price] => 349.272 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 485 [setting_final_price] => 423 [metal_weight] => 3.7556129032258 [no_price] => 0 [stone_ids] => Array ( [0] => 1929884 ) [no_option] => 0 [no_option_comb] => )

Array ( [all_sql] => CENTER:SELECT stone_price_id, total_price, color, clarity FROM dd_stone_price_lbg WHERE status = '1' AND stone = 'LAB' AND shape = 'RND' AND weight >= 0.2 AND weight <= 0.7 AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') ORDER BY weight ASC, total_price ASC limit 0,1 [center_stone_price] => 64.228122 [multi_stone_price] => 0 [side_stone_price] => 0 [price_before_markup] => 232 [all_stone_price] => 64.228122 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 232 [metal_price_gm] => 60.0000 [metal_price] => 98.477419354839 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 197 [setting_final_price] => 119 [metal_weight] => 1.6412903225806 [no_price] => 0 [stone_ids] => Array ( [0] => 1930627 ) [no_option] => 0 [no_option_comb] => )

Array ( [all_sql] => CENTER:SELECT stone_price_id, total_price, color, clarity FROM dd_stone_price_lbg WHERE status = '1' AND stone = 'LAB' AND shape = 'RND' AND weight >= 0.2 AND weight <= 0.7 AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') ORDER BY weight ASC, total_price ASC limit 0,1SIDE:SELECT stone_price_id, cert_no, carat_price, color, clarity, lab, stone FROM dd_stone_price_lbg WHERE status = '1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.035 AND crt_to >= 0.035 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 64.228122 [multi_stone_price] => 0 [side_stone_price] => 19.507571661375 [price_before_markup] => 329 [all_stone_price] => 83.735693661375 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 329 [metal_price_gm] => 60.0000 [metal_price] => 146.78709677419 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 280 [setting_final_price] => 178 [metal_weight] => 2.4464516129032 [no_price] => 0 [stone_ids] => Array ( [0] => 1930627 [1] => 1929905 ) [no_option] => 0 [no_option_comb] => )

Array ( [all_sql] => CENTER:SELECT stone_price_id, total_price, color, clarity FROM dd_stone_price_lbg WHERE status = '1' AND stone = 'LAB' AND shape = 'RND' AND weight >= 0.2 AND weight <= 0.7 AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') ORDER BY weight ASC, total_price ASC limit 0,1 [center_stone_price] => 64.228122 [multi_stone_price] => 0 [side_stone_price] => 0 [price_before_markup] => 251 [all_stone_price] => 64.228122 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 251 [metal_price_gm] => 60.0000 [metal_price] => 111.48387096774 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 213 [setting_final_price] => 135 [metal_weight] => 1.858064516129 [no_price] => 0 [stone_ids] => Array ( [0] => 1930627 ) [no_option] => 0 [no_option_comb] => )

Array ( [all_sql] => MULTI:SELECT stone_price_id, cert_no, carat_price, color, clarity, total_price, lab, stone FROM dd_stone_price_lbg WHERE status='1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.017 AND crt_to >= 0.017 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 175.042098 [side_stone_price] => 0 [price_before_markup] => 1081 [all_stone_price] => 175.042098 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 1081 [metal_price_gm] => 93.0000 [metal_price] => 583.2 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 919 [setting_final_price] => 707 [metal_weight] => 6.2709677419355 [no_price] => 0 [stone_ids] => Array ( [0] => 1929884 ) [no_option] => 0 [no_option_comb] => )