Temple St Clair Logo
Search
Temple St. Clair
Locations
Shopping Bag
Categories > The Iconic Amulet
Classic Crystal
Item 18K Vine Amulet Earrings with rock crystal and diamond
18K Vine Amulet Earrings with rock crystal and diamond

$5,300
18K Vine Amulet Earrings with rock crystal and diamond
$5,300
Item 18K Classic Amulet Earrings with rock crystal and diamond granulation
18K Classic Amulet Earrings with rock crystal a...
$2,900
18K Classic Amulet Earrings ...
$2,900
Item 18K Classic Amulet Earrings with rock crystal and diamond
18K Classic Amulet Earrings with rock crystal a...
$2,750
18K Classic Amulet Earrings ...
$2,750
Item 18K Matisse Earrings with rock crystal and diamond pavé
18K Matisse Earrings with rock crystal and diam...
$8,900
18K Matisse Earrings with ro...
$8,900
Item 18K Vine Amulet with rock crystal and diamond
18K Vine Amulet with oval rock crystal and diam...
$1,750 - $6,950
More sizes available
18K Vine Amulet with oval ro...
$1,750 - $6,950
More sizes available
Item 18K Classic Amulet with round rock crystal and diamond
18K Classic Amulet with round rock crystal and ...
$1,300
18K Classic Amulet with roun...
$1,300
Item 18K Double Amulet Drop Earrings with rock crystal and diamond pavé
18K Double Amulet Drop Earrings with rock cryst...
$3,500
18K Double Amulet Drop Earri...
$3,500
Item 18K Classic Amulet with round rock crystal
18K Classic Amulet with round rock crystal
$800
18K Classic Amulet with roun...
$800
Item 18K Classic Amulet with rock crystal
18K Classic Amulet with oval rock crystal
$800 - $4,250
More sizes available
18K Classic Amulet with oval...
$800 - $4,250
More sizes available
Item 18K Classic Amulet with rock crystal and diamond pavé
18K Classic Amulet with oval rock crystal and d...
$2,200 - $5,600
More sizes available
18K Classic Amulet with oval...
$2,200 - $5,600
More sizes available
Item 18K Classic Amulet Earrings with rock crystal
18K Classic Amulet Earrings with rock crystal
$1,500
18K Classic Amulet Earrings ...
$1,500
Item 18K Owlet Amulet with blue sapphire and diamond pavé
18K Owl Amulet with blue sapphire and diamond p...
$3,750 - $15,500
More sizes available
18K Owl Amulet with blue sap...
$3,750 - $15,500
More sizes available
Item 18K Classic Amulet with rock crystal and diamond
18K Classic Amulet with oval rock crystal and d...
$1,300 - $6,500
More sizes available
18K Classic Amulet with oval...
$1,300 - $6,500
More sizes available
Item 18K Classic Amulet Earrings with diamond pavé earwire
18K Classic Amulet Earrings with diamond pavé earwire

$2,500
18K Classic Amulet Earrings with diamond pavé earwire
$2,500
Item 18K Lunar Phase Amulet in rock crystal and diamond pavé
18K Lunar Amulet with oval rock crystal and dia...
$2,750 - $3,750
More sizes available
18K Lunar Amulet with oval r...
$2,750 - $3,750
More sizes available
Item 18K Dragonfly Amulet with rock crystal and diamond pavé
18K Dragonfly Amulet with oval rock crystal and...
$2,950
18K Dragonfly Amulet with ov...
$2,950
Item 18K Classic Faceted Amulet with rock crystal, ruby, emerald and blue sapphire
18K Classic Faceted Amulet with oval rock cryst...
$1,250 - $3,500
More sizes available
18K Classic Faceted Amulet w...
$1,250 - $3,500
More sizes available
Item 18K Matisse Amulet with rock crystal and diamond pavé
18K Matisse Amulet with rock crystal - 16x11mm
$4,500
18K Matisse Amulet with rock...
$4,500
Item 18K Flying Fish Amulet with rock crystal, royal blue moonstone, blue sapphire and diamond
18K Flying Fish Amulet with rock crystal, royal blue moonstone, blue sapphire and diamond

$7,500 - $22,000
More sizes available
18K Flying Fish Amulet with rock crystal, royal blue moonstone, blue sapphi...
$7,500 - $22,000
More sizes available
Item 18K Sea Star Amulet with rock crystal and diamond pavé
18K Starfish Amulet with oval rock crystal and ...
$3,950 - $7,250
More sizes available
18K Starfish Amulet with ova...
$3,950 - $7,250
More sizes available
Item 18K Matisse Amulet with rock crystal, rose cut blue sapphire and diamond pavé
18K Matisse Amulet
$8,000
18K Matisse Amulet
$8,000
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 Matisse Amulet with rock crystal, rose cut blue sapphire and diamond pavé
18K Matisse Amulet with rock crystal, rose cut ...
$22,000
18K Matisse Amulet with rock...
$22,000
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 Amulet with round rock crystal and mixed sapphire pavé
18K Classic Amulet with round rock crystal and ...
$3,250
18K Classic Amulet with roun...
$3,250
Item 18K Amulet Necklace with rock crystal and diamond
18K Amulet Necklace with rock crystal and diamo...
$5,400 - $9,500
More sizes available
18K Amulet Necklace with roc...
$5,400 - $9,500
More sizes available
Item 18K Lantern Amulet with rock crystal and blue sapphire
18K Lantern Amulet with rock crystal - 16x11mm
$1,750 - $1,900
More colors available
18K Lantern Amulet with rock...
$1,750 - $1,900
More colors available
Item 18K Evil Eyelash Amulet in oval rock crystal, blue sapphire and diamond
18K Evil Eyelash Amulet in oval rock crystal, b...
$3,700 - $6,700
More sizes available
18K Evil Eyelash Amulet in o...
$3,700 - $6,700
More sizes available
Item 18K Lantern Amulet Earrings with rock crystal and diamond
18K Lantern Amulet Earrings with rock crystal a...
$3,500
18K Lantern Amulet Earrings ...
$3,500
Item 18K Amulet Bellina Bangle with rock crystal and diamond
18K Amulet Bellina Bangle with rock crystal and...
$3,200
18K Amulet Bellina Bangle wi...
$3,200
Item 18K Lotus Amulet in rock crystal and diamond
18K Lotus Amulet in rock crystal and diamond
$4,500 - $8,950
More sizes available
18K Lotus Amulet in rock cry...
$4,500 - $8,950
More sizes available
Item 18K Classic Light Mix Amulet with rock crystal, aquamarine, royal bluemoon stone, peridot, pink tourmaline and iolite
18K Classic Light Mix Cabochon Amulet with oval rock crystal and mixed cabochon gemstones

$3,700 - $5,500
More sizes available
18K Classic Light Mix Cabochon Amulet with oval rock crystal and mixed cabo...
$3,700 - $5,500
More sizes available
Item 18K Archival Amulet with round rock crystal and emerald
18K Archival Amulet with round rock crystal
$5,500 - $5,950
More colors available
18K Archival Amulet with rou...
$5,500 - $5,950
More colors available



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_classification_id=40
								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.classification='AMULETS')
					GROUP BY
						group_id
					ORDER BY 
						WebProduct.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => E51816-E11VINE
            [web_name] => 18K Vine Amulet Earrings with rock crystal and diamond
            [price_retail] => 5300
            [group_id] => E51816-E11VINE
        )

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

    [WebProductImage] => Array
        (
            [id] => 937
            [navision_product_info_id] => E51816-E11VINE
            [name] => 
        )

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

    [0] => Array
        (
            [group_id] => E51816-E11VINE
        )

    [NavisionProductGroup] => Array
        (
            [total_products] => 
            [min_price] => 
            [max_price] => 
            [web_name] => 
            [web_product_image_id] => 
            [type] => 
        )

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

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

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

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

)