Temple St Clair Logo
Search
Temple St. Clair
Locations
Shopping Bag
Collections > New Jewels
Item 18K Cosmos Bellina with diamond
18K Cosmos Bellina with diamond

$4,950
18K Cosmos Bellina with diamond
$4,950
Item 18K Triple Cosmos Drop Earrings with diamond
18K Triple Cosmos Drop Earrings with diamond
$5,200
18K Triple Cosmos Drop Earri...
$5,200
Item 18K Cosmos Pendant with diamond
18K Cosmos Pendant with diamond
$4,950
18K Cosmos Pendant with diam...
$4,950
Item 18K Cosmos Bellina with royal blue moonstone, tsavorite, tanzanite, pink tourmaline and diamond
18K Cosmos Bellina with royal blue moonstone, t...
$5,700
18K Cosmos Bellina with roya...
$5,700
Item 18K Cosmos Bombe Ring with royal blue moonstone, tsavorite, tanzanite, pink tourmaline and diamond
18K Cosmos Bombe Ring with royal blue moonstone...
$5,900
18K Cosmos Bombe Ring with r...
$5,900
Item 18K Large Cosmo Earrings with royal blue moonstone, tsavorite, tanzanite, pink tourmaline and diamond
18K Large Cosmo Earrings with royal blue moonst...
$5,500
18K Large Cosmo Earrings wit...
$5,500
Item 18K Small Cosmos Double Drop Earrings with royal blue moonstone, tsavorite, tanzanite, pink tourmaline and diamond
18K Small Cosmos Double Drop Earrings with roya...
$6,500
18K Small Cosmos Double Drop...
$6,500
Item 18K Cosmos Pendant with royal blue moonstone, tsavorite, tanzanite, pink tourmaline and diamond
18K Cosmos Pendant with royal blue moonstone, t...
$7,950
18K Cosmos Pendant with roya...
$7,950
Item 18K Large Cosmos Double Drop Earrings with royal blue moonstone, tsavorite, tanzanite, pink tourmaline and diamond
18K Large Cosmos Double Drop Earrings with roya...
$9,500
18K Large Cosmos Double Drop...
$9,500
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 Flower Serpent Amulet with rock crystal, royal blue moonstone, blue sapphire, and diamond
18K Flower Serpent Amulet with rock crystal, ro...
$8,500
18K Flower Serpent Amulet wi...
$8,500
Item 18K Flower Serpent Bracelet with royal blue moonstone and diamond
18K Flower Serpent Bracelet with royal blue moo...
$17,500
18K Flower Serpent Bracelet ...
$17,500
Item 18K Serpent Bella with royal blue moonstone and diamond
18K Serpent Bella with royal blue moonstone and...
$8,500
18K Serpent Bella with royal...
$8,500
Item 18K Flower Cluster Earrings with royal blue moonstone and diamond
18K Flower Cluster Earrings with royal blue moonstone and diamond

$6,950
18K Flower Cluster Earrings with royal blue moonstone and diamond
$6,950
Item 18K Flower Serpent Amulet with rock crystal, royal blue moonstone, blue sapphire, tsavorite,and diamond
18K Flower Serpent Amulet with rock crystal, ro...
$19,500
18K Flower Serpent Amulet wi...
$19,500
Item 18K Flower Serpent Bracelet with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Flower Serpent Bracelet with royal blue moo...
$23,000
18K Flower Serpent Bracelet ...
$23,000
Item 18K Flower Cluster Earrings with blue sapphire, tsavorite and diamond
18K Flower Cluster Earrings with blue sapphire,...
$11,500
18K Flower Cluster Earrings ...
$11,500
Item 18K Flower Serpent Ring with royal blue moonstone, blue sapphire, tsavorite, pink tourmaline and diamond
18K Flower Serpent Ring with royal blue moonsto...
$15,000
18K Flower Serpent Ring with...
$15,000
Item 18K Serpent Drop Earrings with royal blue moonstone, tsavorite and diamond
18K Serpent Drop Earrings with royal blue moonstone, tsavorite and diamond

$12,500
18K Serpent Drop Earrings with royal blue moonstone, tsavorite and diamond
$12,500
Item 18K Serpent Bella with tsavorite and diamond
18K Serpent Bella with tsavorite and diamond
$10,500
18K Serpent Bella with tsavo...
$10,500
Item 18K Serpent Earrings with diamond
18K Serpent Earrings with diamond
$2,500
18K Serpent Earrings with di...
$2,500
Item 18K Flower Drop Earrings with royal blue moonstone, blue sapphire, tsavorite, pink tourmaline and diamond
18K Flower Drop Earrings with royal blue moonst...
$7,500
18K Flower Drop Earrings wit...
$7,500
Item 18K Large Pod Earrings with diamond
18K Large Pod Earrings with diamond
$4,750
18K Large Pod Earrings with ...
$4,750
Item 18K Large Pod Ring with diamond
18K Large Pod Ring with diamond
$3,850
18K Large Pod Ring with diam...
$3,850
Item 18K Large Pod Pendant with diamond
18K Large Pod Pendant with diamond
$2,600
18K Large Pod Pendant with d...
$2,600
Item 18K Mini Pod Drop Earrings with diamond
18K Mini Pod Drop Earrings with diamond
$2,300
18K Mini Pod Drop Earrings w...
$2,300
Item 18K Mini Pod Charm Necklace with diamond
18K Mini Pod Charm Necklace with diamond
$2,850
18K Mini Pod Charm Necklace ...
$2,850



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=75
								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="New Jewels" 
										or  
										NavisionProductInfo.collection_2="New Jewels"
										or  
										NavisionProductInfo.collection_3="New Jewels"
										or  
										NavisionProductInfo.id IN (
											SELECT
												navision_product_info_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=75
										)
										or
										NavisionProductInfo.group_id IN (
											SELECT
												navision_product_group_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=75
										)
									)
					GROUP BY
						group_id
					ORDER BY 
						WebProductSort.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => B41822-COSMOS
            [web_name] => 18K Cosmos Bellina with diamond
            [price_retail] => 4950
            [group_id] => B41822-COSMOS
        )

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

    [WebProductImage] => Array
        (
            [id] => 1664
            [navision_product_info_id] => B41822-COSMOS
            [name] => 
        )

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

    [0] => Array
        (
            [group_id] => B41822-COSMOS
        )

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

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

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

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

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

)