Temple St Clair Logo
Search
Temple St. Clair
Locations
Shopping Bag
Collections > Royal Blue Moonstone
Collection
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 Cleo Necklace with royal blue moonstone and blue sapphire
18K Cleo Necklace with royal blue moonstone and...
$30,000
18K Cleo Necklace with royal...
$30,000
Item 18K Cleo Drop Necklace with royal blue moonstone and sapphire
18K Cleo Drop Necklace with royal blue moonston...
$19,500
18K Cleo Drop Necklace with ...
$19,500
Item 18K Cleo Drop Earrings with royal blue moonstone, sapphire and diamond
18K Cleo Drop Earrings with royal blue moonston...
$5,250
18K Cleo Drop Earrings with ...
$5,250
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 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 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 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 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 Moonface Ring with blue sapphire
18K Moonface Ring with blue sapphire
$4,200
18K Moonface Ring with blue ...
$4,200
Item 18K Astrid Ring with Blue Moonstone Face and mix color sapphire
18K Astrid Ring with Blue Moonstone Face and mi...
$8,900
18K Astrid Ring with Blue Mo...
$8,900
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 Moonface ring with diamond
18K Moonface ring with diamond

$4,900
18K Moonface ring with diamond
$4,900
Item 18K Moonface Earrings with royal blue moonstone and blue sapphire
18K Moonface Earrings with royal blue moonstone...
$5,900
18K Moonface Earrings with r...
$5,900
Item 18K Astrid Moonface Ring with royal blue moonstone and diamond
18K Astrid Moonface Ring with royal blue moonst...
$10,500
18K Astrid Moonface Ring wit...
$10,500
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
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 Moon Face Luna Pendant with Royal Blue Moonstone and sapphire
18K Moon Face Luna Pendant with Royal Blue Moonstone and sapphire

$7,200
18K Moon Face Luna Pendant with Royal Blue Moonstone and sapphire
$7,200
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 Classic Trio Earrings with Royal Blue Moonstone and diamond
18K Classic Trio Earrings
$2,300
18K Classic Trio Earrings
$2,300
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 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 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 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 Classic Oval Ring with Royal Blue Moonstone and diamond
18K Classic Oval Ring with diamond granulation ...
$3,250 - $6,200
More colors available
18K Classic Oval Ring with d...
$3,250 - $6,200
More colors available
Item 18K Bellina Bangle with Royal Blue Moonstone and diamond
18K Bellina Bangle with diamond
$4,200
18K Bellina Bangle with diam...
$4,200
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 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 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 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 Sea Star Amulet with rock crystal, Royal Blue Moonstone, blue sapphire and diamond
18K Sea Star Amulet with oval rock crystal, royal blue moonstone, blue sapphire and diamond

$6,950 - $10,500
More sizes available
18K Sea Star Amulet with oval rock crystal, royal blue moonstone, blue sapp...
$6,950 - $10,500
More sizes available
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 Halo Earrings with Royal Blue Moonstone and diamond pavé
18K Classic Halo Earrings with Royal Blue Moons...
$5,250
18K Classic Halo Earrings wi...
$5,250
Item 18K Classic Cushion Ring with royal blue moonstone and blue sapphire
18K Classic Cushion Ring with royal blue moonst...
$15,500
18K Classic Cushion Ring wit...
$15,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 Crown Ring with Royal Blue Moonstone
18K Crown Ring with Royal Blue Moonstone

$6,500
18K Crown Ring with Royal Blue Moonstone
$6,500
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 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 Fan Drop Earrings with royal blue moonstone and diamond
18K Fan Drop Earrings with royal blue moonstone...
$2,950
18K Fan Drop Earrings with r...
$2,950
Item 18K Classic Pear Necklace with Royal Blue Moonstone and diamond
18K Classic Pear Necklace with Royal Blue Moons...
$17,000
18K Classic Pear Necklace wi...
$17,000
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 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 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 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



Scroll Up


					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] => 61
            [web_product_image_id] => 
        )

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

    [WebProduct] => Array
        (
            [sort_weight] => 84
            [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] => 
        )

)