SELECT image, image_url, metal_type FROM product WHERE vendor_sku = 'CH1232:104:P' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = '88055:100:S' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = 'R16342:304656:P' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%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 = '88260:105:P' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = '86564:1001:S' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = 'YC999' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = 'CH1096:600:P' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = 'CH11:244661:P' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = 'CH1210:100:P' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = '86832:104:S' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%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 = '86969:101:S' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%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 = '86868:101:S' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%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 = '2000898:100:P' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%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 = '87595:111:P' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%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 = '88403:100:S' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = 'CH1213:100:P' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = '86843:101:S' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%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 = '87276:101:S' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = '87184:100:P:CONTSTER' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = '2002021:100:P' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = '87077:101:S' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%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 = '88209:101:S' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%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 = '87143:101:S' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%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 = '2001002:100:P' AND dia_shape = '' AND (metal_type LIKE '%yellow gold' OR metal_type LIKE '%rose gold' OR metal_type LIKE '%white gold' OR metal_type LIKE '%platinum' OR metal_type LIKE '%sterling silver') AND metal_type != 'Yellow 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.