SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '2000316: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 = '88018:110: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 = '88090:135: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 = '87751:100: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 = '688991:100:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Sterling Silver ' 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 = '23482:101:S' 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 = '87505: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 = '87095: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 = '87692:101:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Sterling Silver ' 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 = '88157:137: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 = '88204: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 = '86805:104: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 = '88051:100: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 = '86767: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 = '87285:104: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 = '88085: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 = '87523: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 = '87181:104: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 = '88270: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 = '87317:121: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 = '88437: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 = '88035: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 = '688955:100: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 = '88245:101:P' AND dia_shape = '' AND metal_type IN ('yellow gold', 'rose gold', 'white gold', 'platinum', 'sterling silver') AND metal_type != 'Sterling Silver ' 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.