Oval Diamond Rings

Array ( [all_sql] => CENTER:SELECT stone_price_id, total_price, color, clarity FROM dd_stone_price WHERE status = '1' AND stone = 'DI' AND shape = 'RND' AND weight >= 0.2 AND weight <= 0.7 AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2','I1') AND color IN ('D','E','F','G','H') AND lab IN ('SUNSHINE','GIA') ORDER BY weight ASC, total_price ASC limit 1,1SIDE:SELECT stone_price_id, cert_no, carat_price, color, clarity, lab, stone FROM dd_stone_price WHERE status = '1' AND stone='DI' AND shape='PER' AND clarity IN ('VVS1','VVS2','VS1','VS2',' SI1','SI2') AND color IN ('D','E','F','G') AND lab IN ('SUNSHINE','GIA') AND crt_from <= 0.08 AND crt_to >= 0.08 ORDER BY weight ASC, carat_price ASC limit 0,1SIDE:SELECT stone_price_id, cert_no, carat_price, color, clarity, lab, stone FROM dd_stone_price WHERE status = '1' AND stone='DI' AND shape='RND' AND clarity IN ('VVS1','VVS2','VS1','VS2') AND color IN ('D','E','F','G') AND lab IN ('SUNSHINE','GIA') AND crt_from <= 0.08 AND crt_to >= 0.08 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 64.76928 [multi_stone_price] => 0 [side_stone_price] => 129.9892624 [price_before_markup] => 463 [all_stone_price] => 194.7585424 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 463 [metal_price_gm] => 60.0000 [metal_price] => 130.06451612903 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 394 [setting_final_price] => 157 [metal_weight] => 2.1677419354839 [no_price] => 0 [stone_ids] => Array ( [0] => 1942348 [1] => 1942306 [2] => 1941946 ) [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.011 AND crt_to >= 0.011 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 43.715364 [side_stone_price] => 0 [price_before_markup] => 266 [all_stone_price] => 43.715364 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 266 [metal_price_gm] => 93.0000 [metal_price] => 142.56 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 226 [setting_final_price] => 173 [metal_weight] => 1.5329032258065 [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.018 AND crt_to >= 0.018 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 45.521784 [side_stone_price] => 0 [price_before_markup] => 305 [all_stone_price] => 45.521784 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 305 [metal_price_gm] => 93.0000 [metal_price] => 168.48 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 259 [setting_final_price] => 204 [metal_weight] => 1.8116129032258 [no_price] => 0 [stone_ids] => Array ( [0] => 1929884 ) [no_option] => 0 [no_option_comb] => )