Mixed Shape Gemstone

Array ( [all_sql] => SIDE: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','I1') AND color IN ('D','E','F','G','H') AND lab IN ('SUNSHINE','GIA') AND crt_from <= 0.005 AND crt_to >= 0.005 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',' SI1','SI2','I1') AND color IN ('D','E','F','G','H') AND lab IN ('SUNSHINE','GIA') AND crt_from <= 0.0025 AND crt_to >= 0.0025 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',' SI1','SI2','I1') AND color IN ('D','E','F','G','H') AND lab IN ('SUNSHINE','GIA') AND crt_from <= 0.01 AND crt_to >= 0.01 ORDER BY weight ASC, carat_price ASC limit 0,1MULTI:SELECT stone_price_id, cert_no, carat_price, color, clarity, total_price, lab, stone FROM dd_stone_price WHERE status='1' AND stone='PE' AND shape='RND' AND lab IN ('SUNSHINE') AND (weight >= 2 AND weight <= 2.5) ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 0 [side_stone_price] => 4.16842125 [price_before_markup] => 149 [all_stone_price] => 4.16842125 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 66 [original_price] => 149 [metal_price_gm] => 93.0000 [metal_price] => 47.304 [chain_price] => 66 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 127 [setting_final_price] => 122 [metal_weight] => 0.50864516129032 [no_price] => 1 [stone_ids] => Array ( [0] => 1945265 [1] => 1945265 [2] => 1945265 ) [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='PE' AND shape='RND' AND lab IN ('SUNSHINE') AND crt_from <= 0.18 AND crt_to >= 0.18 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 0 [side_stone_price] => 0 [price_before_markup] => 118 [all_stone_price] => 0 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 118 [metal_price_gm] => 60.0000 [metal_price] => 92.903225806452 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 100 [setting_final_price] => 100 [metal_weight] => 1.5483870967742 [no_price] => 1 [stone_ids] => Array ( ) [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='PE' AND shape='RND' AND lab IN ('SUNSHINE') AND (weight >= 0.444 AND weight <= 0.944) ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 0 [side_stone_price] => 0 [price_before_markup] => 178 [all_stone_price] => 0 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 178 [metal_price_gm] => 93.0000 [metal_price] => 140.616 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 151 [setting_final_price] => 151 [metal_weight] => 1.512 [no_price] => 1 [stone_ids] => Array ( ) [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='PE' AND shape='RND' AND lab IN ('SUNSHINE') AND (weight >= 4 AND weight <= 4.5) ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 0 [side_stone_price] => 0 [price_before_markup] => 108 [all_stone_price] => 0 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 66 [original_price] => 108 [metal_price_gm] => 93.0000 [metal_price] => 19.44 [chain_price] => 66 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 92 [setting_final_price] => 92 [metal_weight] => 0.20903225806452 [no_price] => 1 [stone_ids] => Array ( ) [no_option] => 0 [no_option_comb] => )