SELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SILBG8160'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Bracelet' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'GTB10250'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Bracelet' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SET2826-18'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'C16206-18'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC55003628-T'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC55008749'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC55022148'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Necklace' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC55008437'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC55022142'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC55013112'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Earrings' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC55022145'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Ring' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'C16861'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant#Locket' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'C17106'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant#Locket' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'C17138'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant#Locket' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'C17248'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant#Necklace' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'C17277'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant#Necklace' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = '51219-W'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Wedding Band' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = '51220-W'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '0.33' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Wedding Band' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = '51225-W'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '0.20' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Wedding Band' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'R41523-L'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'R41523-M'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'C17348'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'R5032-L'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC55022886'
AND product_center_stone_shape = 'Round to Near-Round'
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC55022877'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC36214781D0.65'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Earrings' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC55024656'
AND product_center_stone_shape = 'Multi-Stone'
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Ring' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC41002238'
AND product_center_stone_shape = 'Round'
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Pendant' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC41002241'
AND product_center_stone_shape = 'Round'
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Earrings' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASCSELECT product_center_stone_name, SUM(prod_sold_quantity) AS prod_sold_quantity FROM sky_products
WHERE 1
AND metal_group !='' AND metal_group = 'SC55025946'
AND product_center_stone_shape = ''
AND diamond_carat_weight = '' AND diamond_quality = '' AND product_center_stone_name!='' AND ( CASE WHEN product_gemstone != '' THEN product_type = 'Earrings' ELSE 1 END )
AND ( CASE WHEN zodiac_sign != '' THEN zodiac_sign = '' ELSE 1 END )
and status = '1' GROUP BY product_center_stone_name
ORDER BY product_center_stone_name ASC
BEAUTIFUL JEWELRY, EXPERT CRAFTSMANSHIP, HAPPY YOU! IT’S THAT SIMPLE!
At Allurez we have revolutionized how jewelry is purchased. No more crazy high markups, no more inferior quality jewelry, and no more dealing with high pressure commission sales people.
Now that you’ve found that perfect piece of jewelry, never search for it again.
We will keep your wishlist for one week on our site, but if you want to keep it for more time, create an account on our site to save the products for long period.
Not applicable on loose diamonds, loose gemstones, and clearance items. Cannot be applied to previous orders. Valid while supplies last. Allurez reserves the right to terminate this offer at anytime.
We fully stand behind the products we sell. Therefore, all of the products offered by Allurez are covered by a FREE 1-year limited warranty. Additional years of warranty can also be purchased for a low price.
Appraisal
A jewelry appraisal indicates the value of your jewelry and is used for insuring your jewelry. The appraisal is completed by an expert gemologist.