Logo
Search
Temple St. Clair
Locations
Shopping Bag
Collections > New Jewels
Item 18K Angel Crystal Locket with diamond
18K Angel Crystal Locket with diamond

$9,700
18K Angel Crystal Locket with diamond
$9,700
Item 18K Trio Bellina Bangle in 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 Lunar Phase Amulet in rock crystal, blue sapphire 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 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 Owl Amulet with blue sapphire in 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 Mini Evil Eye Ring in diamond
18K Mini Evil Eye Ring in diamond
$1,950
18K Mini Evil Eye Ring in di...
$1,950
Item 18K Mini Owl Ring in diamond pavé
18K Mini Owl Ring in diamond pavé
$1,950
18K Mini Owl Ring in diamond...
$1,950
Item 18K Mini Horseshoe Ring in diamond pavé
18K Mini Horseshoe Ring in diamond pavé
$1,950
18K Mini Horseshoe Ring in d...
$1,950
Item 18K Mini Clover  Ring in diamond pavé
18K Mini Clover Ring in diamond pavé
$1,950
18K Mini Clover Ring in dia...
$1,950
Item 18K Horseshoe Pendant in diamond
18K Horseshoe Pendant in diamond
$1,750
18K Horseshoe Pendant in dia...
$1,750
Item 18KW Classic Trio Earring in diamond
18K White Gold Classic Trio Earring in diamond
$2,500 - $5,900
More sizes available
18K White Gold Classic Trio ...
$2,500 - $5,900
More sizes available
Item 18K Monkey Earring with diamond
18K Monkey Earring with diamond
$2,700
18K Monkey Earring with diam...
$2,700
Item 18K Deer Bracelet in diamond
18K Deer Bracelet in diamond
$85,000
18K Deer Bracelet in diamond
$85,000
Item 18K Deer Earring in diamond
18K Deer Earring in diamond

$2,500
18K Deer Earring in diamond
$2,500
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 Lotus Necklace in blue moonstone and diamond
18K Lotus Necklace in blue moonstone and diamon...
$17,500
18K Lotus Necklace in blue m...
$17,500
Item 18K Lotus Earring in royal blue moonstone and diamond
18K Lotus Earring in royal blue moonstone and d...
$1,950
18K Lotus Earring in royal b...
$1,950
Item 18K Scarab Earring in diamond
18K Scarab Earring in diamond
$1,850
18K Scarab Earring in diamon...
$1,850
Item 18K Scarab Ring in diamond
18K Scarab Ring

$3,250
More colors available
18K Scarab Ring
$3,250
More colors available
Item 18K Lotus Post Earring in diamond
18K Lotus Post Earring in diamond
$2,200
18K Lotus Post Earring in di...
$2,200
Item 18K Scarab Bellina Bangle in diamond
18K Scarab Bellina Bangle in diamond
$4,500
18K Scarab Bellina Bangle in...
$4,500
Item 18K Scarab Drop Earring in diamond
18K Scarab Drop Earring in diamond
$2,750
18K Scarab Drop Earring in d...
$2,750
Item 18K Scarab Bracelet in blue sapphire, emerald, and diamond
18K Scarab Bracelet in blue sapphire, emerald, ...
$11,500
18K Scarab Bracelet in blue ...
$11,500
Item 18K Scarab Pendant in blue sapphire, emerald and diamond
18K Scarab Pendant in blue sapphire, emerald an...
$6,500
18K Scarab Pendant in blue s...
$6,500
Item 18K Scarab Earring in emerald and diamond
18K Scarab Earring
$2,950
More colors available
18K Scarab Earring
$2,950
More colors available
Item 18K Mini Scarab Ring in diamond pavé
18K Mini Scarab Ring in diamond pavé
$1,950
18K Mini Scarab Ring in diam...
$1,950
Item 18K Scarab Bracelet in diamond
18K Scarab Bracelet in diamond
$7,500
18K Scarab Bracelet in diamo...
$7,500
Item 18K Double Link Scarab Necklace in diamond
18K Double Link Scarab Necklace in diamond
$16,000
18K Double Link Scarab Neckl...
$16,000
Item 18K Evil Eye Pendant in diamond
18K Evil Eye Pendant in diamond
$2,850
18K Evil Eye Pendant in diam...
$2,850
Item 18K Evil Eye Pendant in diamond
18K Evil Eye Pendant in diamond
$3,250
18K Evil Eye Pendant in diam...
$3,250
Item 18K Evil Eye Necklace in blue sapphire and diamond
18K Evil Eye Necklace in blue sapphire and diam...
$12,500
18K Evil Eye Necklace in blu...
$12,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=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] => P56102-R25ANLOC
            [web_name] => 18K Angel Crystal Locket with diamond
            [price_retail] => 9700
            [group_id] => P56102-R25LOCAN
        )

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

    [WebProductImage] => Array
        (
            [id] => 1477
            [navision_product_info_id] => P56102-R25ANLOC
            [name] => 
        )

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

    [0] => Array
        (
            [group_id] => P56102-R25LOCAN
        )

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

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

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

)