Logo
Search
Temple St. Clair
Locations
Shopping Bag
Collections > Royal Blue Moonstone
Item 18K Small Cluster Earrings with Royal Blue Moonstone and diamond
18K Cluster Earrings with royal blue moonstone and diamond

$3,500 - $6,500
More sizes available
18K Cluster Earrings with royal blue moonstone and diamond
$3,500 - $6,500
More sizes available
Item 18K Lariat Necklace with Royal Blue Moonstone, tanzanite and diamond
18K Lariat Necklace with Royal Blue Moonstone, ...
$32,000
18K Lariat Necklace with Roy...
$32,000
Item 18K Foglia Drop Earrings with Royal Blue Moonstone and diamond
18K Foglia Drop Earrings with Royal Blue Moonst...
$4,200
18K Foglia Drop Earrings wit...
$4,200
Item 18K Classic Trio Earrings with Royal Blue Moonstone and diamond
18K Classic Trio Earrings
$2,300
18K Classic Trio Earrings
$2,300
Item 18K Double Drop Earrings with Royal Blue Moonstone and diamond
18K Double Drop Earrings with diamond
$2,950
18K Double Drop Earrings wit...
$2,950
Item 18K Bombe Ring with Royal Blue Moonstone and diamond
18K Bombe Ring with Royal Blue Moonstone and di...
$7,500
18K Bombe Ring with Royal Bl...
$7,500
Item 18K Bellina Bangle with Royal Blue Moonstone and diamond
18K Bellina Bangle with diamond
$3,500 - $4,200
More colors available
18K Bellina Bangle with diam...
$3,500 - $4,200
More colors available
Item 18K Small Single Round Bracelet with Royal Blue Moonstone and diamond
18K Small Single Round Bracelet with Royal Blue...
$3,750
18K Small Single Round Brace...
$3,750
Item 18K Classic Halo Pear Drop Earrings with Royal Blue Moonstone and diamond pavé
18K Classic Halo Pear Drop Earrings with Royal ...
$6,950
18K Classic Halo Pear Drop E...
$6,950
Item 18K Wing Pendant with Royal Blue Moonstone and diamond
18K Wing Pendant with Royal Blue Moonstone and ...
$2,500
18K Wing Pendant with Royal ...
$2,500
Item 18K Single Mummy Ring with Royal Blue Moonstone and diamond
18K Mummy Ring with royal blue moonstone and di...
$6,500
18K Mummy Ring with royal bl...
$6,500
Item 18K Crown Ring with Royal Blue Moonstone
18K Crown Ring with Royal Blue Moonstone
$6,500
18K Crown Ring with Royal Bl...
$6,500
Item 18K Classic Amulet with rock crystal, Royal Blue Moonstone and tanzanite
18K Classic Cabochon Amulet with oval rock crys...
$3,700 - $5,500
More sizes available
18K Classic Cabochon Amulet ...
$3,700 - $5,500
More sizes available
Item 18K Small Cluster Ring with Royal Blue Moonstone, tsavorite and diamond
18K Small Cluster Ring with Royal Blue Moonstone, tsavorite and diamond

$5,500
18K Small Cluster Ring with Royal Blue Moonstone, tsavorite and diamond
$5,500
Item 18K Classic Graduated Round Necklace with Royal Blue Moonstone and diamond
18K Classic Graduated Round Necklace with Royal...
$17,500
18K Classic Graduated Round ...
$17,500
Item 18K Blossom Drop Earrings with Royal Blue Moonstone and diamond
18K Blossom Drop Earrings with Royal Blue Moons...
$7,500
18K Blossom Drop Earrings wi...
$7,500
Item 18K Bella Bangle with Royal Blue Moonstone and diamond
18K Bella Bangle
$8,900 - $23,000
More colors available
18K Bella Bangle
$8,900 - $23,000
More colors available
Item 18K Small Flower Necklace with Royal Blue Moonstone and diamond
18K Small Flower Necklace with Royal Blue Moons...
$35,000
18K Small Flower Necklace wi...
$35,000
Item 18K Classic Pear Necklace with Royal Blue Moonstone and diamond
18K Classic Pear Necklace with Royal Blue Moonstone and diamond

$17,000
18K Classic Pear Necklace with Royal Blue Moonstone and diamond
$17,000
Item 18K Medium Sea Star Pendant with Royal Blue Moonstone and diamond
18K Sea Star Pendant with royal blue moonstone ...
$2,200 - $4,700
More sizes available
18K Sea Star Pendant with ro...
$2,200 - $4,700
More sizes available
Item 18K Small Crescent Moon Pendant with Royal Blue Moonstone, blue sapphire and diamond
18K Crescent Moon Pendant
$1,500
18K Crescent Moon Pendant
$1,500
Item 18K Classic Oval Earrings with cabochon Royal Blue Moonstone and diamond
18K Classic Cabochon Oval Earring with diamond
$2,100
18K Classic Cabochon Oval Ea...
$2,100
Item 18K Single Round Bracelet with Royal Blue Moonstone and diamond
18K Single Round Bracelet with Royal Blue Moons...
$7,950
18K Single Round Bracelet wi...
$7,950
Item 18K Small Flower Cluster Bracelet with Royal Blue Moonstone and diamond
18K Flower Cluster Bracelet with royal blue moo...
$13,500
18K Flower Cluster Bracelet ...
$13,500
Item 18K Half Bib Necklace with Royal Blue Moonstone and diamond
18K Half Bib Necklace with Royal Blue Moonstone...
$9,800
18K Half Bib Necklace with R...
$9,800
Item 18K Classic Oval Necklace with Royal Blue Moonstone, faceted blue sapphire and diamond
18K Classic Oval Necklace with Royal Blue Moons...
$17,500
18K Classic Oval Necklace wi...
$17,500
Item 18k Small Cross with royal blue moonstone
18k Small Cross with royal blue moonstone
$1,500
18k Small Cross with royal b...
$1,500
Item 18K Moonface Drop Earrings with royal blue moonstone and diamond
18K Moonface Drop Earrings with royal blue moon...
$5,750
18K Moonface Drop Earrings w...
$5,750
Item 18K Moon Face Luna Pendant with Royal Blue Moonstone and sapphire
18K Moon Face Luna Pendant with Royal Blue Moon...
$7,200
18K Moon Face Luna Pendant w...
$7,200
Item 18K Classic Oval Ring with Royal Blue Moonstone and diamond
18K Classic Oval Ring with Royal Blue Moonstone...
$3,250
18K Classic Oval Ring with R...
$3,250
Item 18K Classic Charm Necklace featuring Royal Blue Moonstone, rock crytal amulet and angel charms with diamond on 18
18K Classic Charm Necklace featuring Royal Blue...
$3,250
18K Classic Charm Necklace f...
$3,250
Item 18K Classic Graduated Necklace with Royal Blue Moonstone and diamond
18K Classic Graduated Necklace with Royal Blue Moonstone and diamond

$16,000
18K Classic Graduated Necklace with Royal Blue Moonstone and diamond
$16,000
Item 18K Sea Star Earrings with Royal Blue Moonstone and diamond
18K Sea Star Earrings with Royal Blue Moonstone...
$3,950
18K Sea Star Earrings with R...
$3,950
Item 18K Classic Five-Stone Cross with Royal Blue Moonstone and diamond
18K Classic Five-Stone Cross with Royal Blue Mo...
$6,250
18K Classic Five-Stone Cross...
$6,250
Item 18K Classic Pear Drop Earrings with Royal Blue Moonstone and diamond
18K Classic Pear Drop Earrings with Royal Blue ...
$4,600
18K Classic Pear Drop Earrin...
$4,600
Item 18K Cluster Bracelet in royal blue moonstone, aquamarine, tanzanite and diamond
18K Cluster Bracelet in royal blue moonstone, a...
$17,500
18K Cluster Bracelet in roya...
$17,500
Item 18K Classic Cushion Ring with royal blue moonstone and blue sapphire
18K Classic Cushion Ring with royal blue moonstone and blue sapphire

$15,500
18K Classic Cushion Ring with royal blue moonstone and blue sapphire
$15,500
Item 18K Sole Earrings with royal blue moonstone and diamond
18K Sole Earrings with royal blue moonstone and...
$5,200
18K Sole Earrings with royal...
$5,200
Item 18K Classic Oval Ring with Royal Blue Moonstone and diamond
18K Classic Oval Ring with diamond granulation ...
$6,200
18K Classic Oval Ring with d...
$6,200
Item 18K Classic Cabochon Oval Earrings with Royal Blue Moonstone and diamond
18K Classic Cabochon Oval Earrings with diamond...
$3,600
18K Classic Cabochon Oval Ea...
$3,600
Item 18K Moonface Drop Earrings with royal blue moonstone and diamond pavé
18K Moonface Drop Earrings with royal blue moon...
$8,950
18K Moonface Drop Earrings w...
$8,950
Item 18K Sea Star Amulet with rock crystal, Royal Blue Moonstone, blue sapphire and diamond
18K Sea Star Amulet with oval rock crystal, roy...
$6,950 - $10,500
More sizes available
18K Sea Star Amulet with ova...
$6,950 - $10,500
More sizes available
Item 18K Sole Necklace with royal blue moonstone and diamond
18K Sole Necklace with royal blue moonstone and...
$5,500
18K Sole Necklace with royal...
$5,500





					SELECT
						NavisionProductInfo.id, NavisionProductInfo.web_name, NavisionProductInfo.price_retail, NavisionProductInfo.group_id,
						WebProductSort.sort_weight, WebProductSort.web_product_image_id,
						WebProductImage.id, WebProductImage.navision_product_info_id, WebProductImage.name,
						WebProduct.sort_weight, WebProduct.status, WebProduct.exclusive,
						IFNULL(NavisionProductInfo.group_id,UUID()) as group_id,
						NavisionProductGroup.total_products, NavisionProductGroup.min_price, NavisionProductGroup.max_price, NavisionProductGroup.web_name, NavisionProductGroup.web_product_image_id, NavisionProductGroup.type,
						NavisionClassification.web_sort_weight, NavisionCollection.web_sort_weight, NavisionProductInfo.id,
						WebProductGroupImage.`navision_product_info_id`,
						WebProductSortImage.`navision_product_info_id`
					FROM
						navision_product_infos NavisionProductInfo
							LEFT JOIN web_products WebProduct on NavisionProductInfo.id=WebProduct.navision_product_info_id
							LEFT JOIN web_product_images WebProductImage on NavisionProductInfo.id=WebProductImage.navision_product_info_id AND WebProductImage.primary="YES"
							LEFT JOIN navision_product_groups NavisionProductGroup ON NavisionProductInfo.group_id=NavisionProductGroup.navision_product_info_id
								LEFT JOIN web_product_images WebProductGroupImage ON NavisionProductGroup.web_product_image_id=WebProductGroupImage.id
							LEFT JOIN navision_collections NavisionCollection on NavisionProductInfo.collection_1=NavisionCollection.name
							LEFT JOIN navision_classifications NavisionClassification on NavisionProductInfo.classification=NavisionClassification.name
							LEFT JOIN web_product_sorts WebProductSort on NavisionProductInfo.group_id=WebProductSort.navision_product_info_id AND WebProductSort.navision_collection_id=8
								LEFT JOIN web_product_images WebProductSortImage ON WebProductSort.web_product_image_id=WebProductSortImage.id
					WHERE
						(NavisionProductInfo.status='ACTIVECORE' or NavisionProductInfo.status='ACTIVESPEC' or NavisionProductInfo.status='NEWCOLL') and NavisionProductInfo.number_in_stock>0 and NavisionProductInfo.price_retail>0 and ( 
										NavisionProductInfo.collection_1="ROYAL BLUE MOONSTONE" 
										or  
										NavisionProductInfo.collection_2="ROYAL BLUE MOONSTONE"
										or  
										NavisionProductInfo.collection_3="ROYAL BLUE MOONSTONE"
										or  
										NavisionProductInfo.id IN (
											SELECT
												navision_product_info_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=8
										)
										or
										NavisionProductInfo.group_id IN (
											SELECT
												navision_product_group_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=8
										)
									)
					GROUP BY
						group_id
					ORDER BY 
						WebProductSort.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => E41427-SMCLUSBM
            [web_name] => 18K Small Cluster Earrings with Royal Blue Moonstone and diamond
            [price_retail] => 3500
            [group_id] => E41427-BMGROUP
        )

    [WebProductSort] => Array
        (
            [sort_weight] => 50
            [web_product_image_id] => 
        )

    [WebProductImage] => Array
        (
            [id] => 241
            [navision_product_info_id] => E41427-SMCLUSBM
            [name] => E41427-SMCLUSBM
        )

    [WebProduct] => Array
        (
            [sort_weight] => 74
            [status] => 
            [exclusive] => NO
        )

    [0] => Array
        (
            [group_id] => E41427-BMGROUP
        )

    [NavisionProductGroup] => Array
        (
            [total_products] => 2
            [min_price] => 3500
            [max_price] => 6500
            [web_name] => 18K Cluster Earrings with royal blue moonstone and diamond
            [web_product_image_id] => 240
            [type] => SIZE
        )

    [NavisionClassification] => Array
        (
            [web_sort_weight] => 0
        )

    [NavisionCollection] => Array
        (
            [web_sort_weight] => 13
        )

    [WebProductGroupImage] => Array
        (
            [navision_product_info_id] => E41427-CLUSBM
        )

    [WebProductSortImage] => Array
        (
            [navision_product_info_id] => 
        )

)