Mixed Shape Yellow Gold Diamond Earrings

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='MS' AND clarity IN ('VS') AND color IN ('F') AND lab IN ('SUNSHINE') AND (weight >= 0.282 AND weight <= 0.782) 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] => 0 [all_stone_price] => 0 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 7.25 [original_price] => 0 [metal_price_gm] => 106.0000 [metal_price] => 489.16743225806 [chain_price] => 0 [back_price] => 7.25 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 0 [setting_final_price] => 0 [metal_weight] => 4.6147870967742 [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='RB' AND shape='PER' AND lab IN ('SUNSHINE') AND crt_from <= 0.16 AND crt_to >= 0.16 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 13.76 [side_stone_price] => 0 [price_before_markup] => 169 [all_stone_price] => 13.76 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 169 [metal_price_gm] => 93.0000 [metal_price] => 107.568 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 144 [setting_final_price] => 128 [metal_weight] => 1.1566451612903 [no_price] => 0 [stone_ids] => Array ( [0] => 1968697 ) [no_option] => 0 [no_option_comb] => )

Array ( [all_sql] => CENTER:SELECT stone_price_id, total_price, color, clarity FROM dd_stone_price WHERE status = '1' AND stone = 'YD' AND shape = 'RND' AND weight >= 0.6 AND weight <= 1.1 AND clarity = 'SI2' AND color = 'YLW' AND lab = '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.005 AND crt_to >= 0.005 ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 0 [side_stone_price] => 58.62195 [price_before_markup] => 295 [all_stone_price] => 58.62195 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 295 [metal_price_gm] => 93.0000 [metal_price] => 153.5112 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 251 [setting_final_price] => 182 [metal_weight] => 1.6506580645161 [no_price] => 1 [stone_ids] => Array ( [0] => 1945270 ) [no_option] => 0 [no_option_comb] => )

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='PER' AND clarity IN ('VVS1','VVS2','VS1','VS2','SI1') AND color IN ('D','E','F','G','H') AND lab IN ('GIA','SUNSHINE') AND crt_from <= 0.2 AND crt_to >= 0.2 ORDER BY weight ASC, carat_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='MQS' AND clarity IN ('VVS1','VVS2','VS1','VS2','SI1') AND color IN ('D','E','F','G','H') AND lab IN ('GIA','SUNSHINE') AND crt_from <= 0.2 AND crt_to >= 0.2 ORDER BY weight ASC, carat_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='MQS' AND clarity IN ('VVS1','VVS2','VS1','VS2','SI1') AND color IN ('D','E','F','G','H') AND lab IN ('GIA','SUNSHINE') AND weight >= 0.25 AND weight <= 0.75 ORDER BY weight ASC, carat_price ASC limit 1,1MULTI:SELECT stone_price_id, cert_no, carat_price, color, clarity, total_price, lab, stone FROM dd_stone_price WHERE status='1' AND stone='YD' AND shape='CUS' AND clarity IN () AND color IN ('YLW') AND lab IN ('SUNSHINE') AND (weight >= 5 AND weight <= 5.5) ORDER BY weight ASC, carat_price ASC limit 0,1 [center_stone_price] => 0 [multi_stone_price] => 0 [side_stone_price] => 4694.07 [price_before_markup] => 9169 [all_stone_price] => 4694.07 [all_stone_price_original] => 0 [all_stone_price_discount] => 0 [making_charges] => 0 [all_chain_price] => 0 [original_price] => 9169 [metal_price_gm] => 93.0000 [metal_price] => 1895.4 [chain_price] => 0 [back_price] => 0 [stone_price] => 0 [sidestone_price] => 0 [multistone_price] => 0 [final_price] => 7794 [setting_final_price] => 2241 [metal_weight] => 20.38064516129 [no_price] => 1 [stone_ids] => Array ( [0] => 1942744 [1] => 1942648 [2] => 1943080 ) [no_option] => 0 [no_option_comb] => )