SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '2000417:1001:S' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '2000410:1001:S' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '87283:119:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Yellow Gold' AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 5SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '22132:262232:S' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '88043:130:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '88142:100:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '87381:118:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Yellow Gold' AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 5SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '87331:103:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Rose Gold' AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 5SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '86688:102:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Yellow Gold' AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 5SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '86687:101:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '86797:101:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '86691:101:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '86941:101:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '86752:101:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '87161:1001:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '86442:101:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '86738:101:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '87554:100:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold') AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 3SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '688851:LG606:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Yellow Gold' AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 5SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '88081:100:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Rose Gold' AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 5SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '88367:100:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Rose Gold' AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 5SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '688879:LG600:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Yellow Gold' AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 5SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '87426:100:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Rose Gold' AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 5SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '688832:605:P' AND dia_shape = 'Round' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Gold' AND status = '1' GROUP BY metal_type ORDER BY metal_type ASC LIMIT 0, 5
Use this space to save the products you like. To add a product here, simply click the icon.