Mixed Shape 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.1 AND weight <= 0.6 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 WHERE status = '1' AND stone='DI' AND shape='RND' 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.006 AND crt_to >= 0.006 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 46.736 [multi_stone_price] => 0 [side_stone_price] => 131.5476558 [price_before_markup] => 572 [all_stone_price] => 178.2836558 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 572 [metal_price_gm] => 60.0000 [metal_price] => 222.96774193548 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 486 [setting_final_price] => 270 [metal_weight] => 3.7161290322581 [no_price] => 0 [stone_ids] => Array ( [0] => 1941924 [1] => 1945270 ) [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.13 AND crt_to >= 0.13 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 64.228122 [multi_stone_price] => 0 [side_stone_price] => 177.430187025 [price_before_markup] => 669 [all_stone_price] => 241.658309025 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 669 [metal_price_gm] => 60.0000 [metal_price] => 227.42709677419 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 569 [setting_final_price] => 275 [metal_weight] => 3.7904516129032 [no_price] => 0 [stone_ids] => Array ( [0] => 1930627 [1] => 1930216 ) [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 WHERE status='1' AND stone='DI' AND shape='RND' 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.01 AND crt_to >= 0.01 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 48.851625 [side_stone_price] => 0 [price_before_markup] => 254 [all_stone_price] => 48.851625 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 254 [metal_price_gm] => 93.0000 [metal_price] => 129.6 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 216 [setting_final_price] => 157 [metal_weight] => 1.3935483870968 [no_price] => 0 [stone_ids] => Array ( [0] => 1945270 ) [no_option] => 0 [no_option_comb] => )