Temple St Clair Logo
Search
Temple St. Clair
Locations
Shopping Bag
Collections > Classic Color
Collection
Item 18K Bella Bangle with emerald and diamond
18K Bella Bangle

$8,900 - $23,000
More colors available
18K Bella Bangle
$8,900 - $23,000
More colors available
Item 18K Classic Trio Earrings with blue sapphire and diamond
18K Classic Trio Earrings
$4,250
More colors available
18K Classic Trio Earrings
$4,250
More colors available
Item 18K Eternity Ring with blue sapphire
18K Eternity Ring with blue sapphire
$1,500
More sizes available
18K Eternity Ring with blue ...
$1,500
More sizes available
Item 18K Triple Eternity Ring with tsavorite
18K Triple Eternity Ring with tsavorite
$7,200
18K Triple Eternity Ring wit...
$7,200
Item 18K Eternity Hoop Earrings with emerald
18K Eternity Hoop Earrings
$3,250 - $4,500
More colors available
18K Eternity Hoop Earrings
$3,250 - $4,500
More colors available
Item 18K Pavé Halo Pyramid Earrings with tanzanite and diamond pavé
18K Pavé Halo Pyramid Earrings with tanz...
$12,500
18K Pavé Halo Pyramid...
$12,500
Item 18K Pear Cluster Earring in emerald and diamond
18K Pear Cluster Earrings
$7,500
More colors available
18K Pear Cluster Earrings
$7,500
More colors available
Item 18K Eternity Ring with rose cut blue sapphire
18K Eternity Ring with rose cut sapphire
$2,400
More colors available
18K Eternity Ring with rose ...
$2,400
More colors available
Item 18K Mare Drop Earrings with royal blue moonstone, blue sapphire, tsavorite, and diamond
18K Mare Drop Earrings with royal blue moonston...
$2,950
18K Mare Drop Earrings with ...
$2,950
Item 18K Mare Necklace with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Mare Necklace with royal blue moonstone, bl...
$23,000
18K Mare Necklace with royal...
$23,000
Item 18K Mare Drop Earrings with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Mare Drop Earrings with royal blue moonston...
$8,750
18K Mare Drop Earrings with ...
$8,750
Item 18K Classic Link Necklace with peridot, Royal Blue Moonstone, aquamarine, iolite and diamond
18K Classic Link Necklace with peridot, Royal B...
$52,000
18K Classic Link Necklace wi...
$52,000
Item 18K Pear Drop Earring with green tourmaline and diamond
18K Pear Drop Earring with green tourmaline and...
$19,500
18K Pear Drop Earring with g...
$19,500
Item 18K Small Eternity Hoop Earrings with blue sapphire
18K Small Eternity Hoop Earrings

$2,750 - $3,250
More colors available
18K Small Eternity Hoop Earrings
$2,750 - $3,250
More colors available
Item 18K Classic Ring with aquamarine and diamond
18K Classic Ring with aquamarine and diamond
$12,500
18K Classic Ring with aquama...
$12,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  Trio Bellina Bangle in blue sapphire and diamond
18K Classic Trio Bellina Bangle
$7,500 - $8,500
More colors available
18K Classic Trio Bellina Ban...
$7,500 - $8,500
More colors available
Item 18K Classic Oval Earrings with faceted aquamarine and diamond - 10x8mm
18K Classic Faceted Oval Earrings with diamond ...
$3,500 - $4,950
More colors available
18K Classic Faceted Oval Ear...
$3,500 - $4,950
More colors available
Item 18K Pavé Halo Pyramid Earrings with peridot and diamond
18K Pavé Halo Pyramid Earrings

$5,750 - $11,000
More colors available
18K Pavé Halo Pyramid Earrings
$5,750 - $11,000
More colors available
Item 18K Classic Cross Pendant with blue sapphire
18K Classic Cross Pendant
$1,200 - $2,950
More colors available
18K Classic Cross Pendant
$1,200 - $2,950
More colors available
Item 18K Classic Horizontal Oval Ring with aquamarine and diamond
18K Classic Horizontal Oval Ring
$2,950
18K Classic Horizontal Oval ...
$2,950
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...
$3,700 - $5,500
More sizes available
18K Classic Light Mix Caboch...
$3,700 - $5,500
More sizes available
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 Mosaic Ring with emerald, ruby, blue sapphire and diamond
18K Mosaic Ring with emerald, ruby, blue sapphi...
$15,000
18K Mosaic Ring with emerald...
$15,000
Item 18K Mosaic Earrings with emerald, blue sapphire, ruby and diamond
18K Mosaic Earrings with emerald, blue sapphire...
$9,200
18K Mosaic Earrings with eme...
$9,200
Item 18K Classic Jean D'Arc Link Necklace with peridot and diamond
18K Classic Jean D'Arc Link Necklace
$29,500 - $69,000
More colors available
18K Classic Jean D'Arc Link ...
$29,500 - $69,000
More colors available
Item 18K Fan Earrings with tanzanite and diamond
18K Fan Earrings with tanzanite and diamond
$3,450
18K Fan Earrings with tanzan...
$3,450
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 Mare Link Necklace with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Mare Link Necklace with royal blue moonston...
$15,000
18K Mare Link Necklace with ...
$15,000
Item 18K Emerald Mandala Cuff
18K Emerald Mandala Cuff
$39,500
18K Emerald Mandala Cuff
$39,500
Item 18K Karina Necklace with ruby - 18
18K Karina Necklace with cabochon ruby
$2,350 - $3,100
More sizes available
18K Karina Necklace with cab...
$2,350 - $3,100
More sizes available
Item 18K Karina Necklace with emerald - 18
18K Karina Necklace with Emerald

$3,500 - $3,950
More sizes available
18K Karina Necklace with Emerald
$3,500 - $3,950
More sizes available
Item 18K Karina Necklace with  blue sapphire - 18
18K Karina Necklace with cabochon blue sapphire
$2,500 - $3,300
More sizes available
18K Karina Necklace with cab...
$2,500 - $3,300
More sizes available
Item 18K Classic Longchain Necklace with rose cut mixed sapphire - 24
18K Classic Longchain Necklace with rose cut mi...
$12,600 - $16,800
More sizes available
18K Classic Longchain Neckla...
$12,600 - $16,800
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
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 Small Classic Five-Stone Cross with pearl and diamond
18K Small Classic Five-Stone Cross with pearl and diamond

$1,750
18K Small Classic Five-Stone Cross with pearl and diamond
$1,750
Item 18K Classic Pearl Earrings with diamond granulation
18K Classic Pearl Earrings with diamond granula...
$1,950
18K Classic Pearl Earrings w...
$1,950
Item 18K Classic Pearl Pendant with diamond granulation
18K Classic Pearl Pendant with diamond granulat...
$850
18K Classic Pearl Pendant wi...
$850
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 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 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 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 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 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 Cross with royal blue moonstone
18k Small Cross with royal blue moonstone
$1,500
18k Small Cross with royal b...
$1,500
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 Small Cluster Earrings with Royal Blue Moonstone and diamond
18K Cluster Earrings with royal blue moonstone ...
$3,500 - $6,500
More sizes available
18K Cluster Earrings with ro...
$3,500 - $6,500
More sizes available
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



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=4
								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="CLASSIC COLOR" 
										or  
										NavisionProductInfo.collection_2="CLASSIC COLOR"
										or  
										NavisionProductInfo.collection_3="CLASSIC COLOR"
										or  
										NavisionProductInfo.id IN (
											SELECT
												navision_product_info_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=4
										)
										or
										NavisionProductInfo.group_id IN (
											SELECT
												navision_product_group_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=4
										)
									)
					GROUP BY
						group_id
					ORDER BY 
						WebProductSort.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => B16121-EMP
            [web_name] => 18K Bella Bangle with emerald and diamond
            [price_retail] => 23000
            [group_id] => B14121-GROUP
        )

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

    [WebProductImage] => Array
        (
            [id] => 1013
            [navision_product_info_id] => B16121-EMP
            [name] => 
        )

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

    [0] => Array
        (
            [group_id] => B14121-GROUP
        )

    [NavisionProductGroup] => Array
        (
            [total_products] => 3
            [min_price] => 8900
            [max_price] => 23000
            [web_name] => 18K Bella Bangle
            [web_product_image_id] => 837
            [type] => COLOR
        )

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

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

    [WebProductGroupImage] => Array
        (
            [navision_product_info_id] => B14121-BMP
        )

    [WebProductSortImage] => Array
        (
            [navision_product_info_id] => B16121-TZP
        )

)