SELECT image, image_url, metal_type FROM product WHERE vendor_sku = '72176:126: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 = '72315:109: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 = '72309:146: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 = '72325: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 = 'S1DR147-SA' 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 = '72356: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 = '72173:600: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 = '72370: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 = 'FCD0-04' 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, 5
Use this space to save the products you like. To add a product here, simply click the icon.