Temple St Clair Logo
Search
Temple St. Clair
Locations
Shopping Bag
Collections > Best Sellers
Item 18K Piccolo Tolomeo Earrings with mixed sapphire and blue sapphire center
18K Piccolo Tolomeo Earrings with mixed sapphire and blue sapphire center

$3,750
18K Piccolo Tolomeo Earrings with mixed sapphire and blue sapphire center
$3,750
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 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 Arno Link Bracelet
18K Arno Link Bracelet
$3,500 - $8,500
More sizes available
18K Arno Link Bracelet
$3,500 - $8,500
More sizes available
Item 18K Double Serpent Ring with blue sapphire and diamond pavé
18K Double Serpent Ring with blue sapphire and ...
$5,400
18K Double Serpent Ring with...
$5,400
Item 18K Angel Earrings with diamond granulation
18K Angel Earrings with diamond
$1,750 - $2,700
More sizes available
18K Angel Earrings with diam...
$1,750 - $2,700
More sizes available
Item 18K Angel Pendant with diamond, 14mm
18K Angel Pendant with diamond granulation
$950 - $2,350
More sizes available
18K Angel Pendant with diamo...
$950 - $2,350
More sizes available
Item 18K Foglia Earrings with diamond pavé
18K Foglia Earrings with diamond pavé
$4,750
18K Foglia Earrings with dia...
$4,750
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 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 Moonface Earrings with rock crystal and diamond - 10mm
18K Moonface Earrings with rock crystal and dia...
$1,250
18K Moonface Earrings with r...
$1,250
Item 18K Tree of Life Locket with diamond
18K Tree of Life Locket with diamond
$7,500
18K Tree of Life Locket with...
$7,500
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 Granulated Vine Cuff Bracelet
18K Granulated Vine, Cesere and Oliva Cuffs

$12,500
18K Granulated Vine, Cesere and Oliva Cuffs
$12,500
Item 18K Nomad Bella Bangle with diamond
18K Nomad Bella Bangle with diamond
$8,900
18K Nomad Bella Bangle with ...
$8,900
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 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 Dragonfly Earrings with diamond pavé
18K Dragonfly Earrings with diamond pavé
$3,950
18K Dragonfly Earrings with ...
$3,950
Item 18K Classic Amulet Earrings with rock crystal
18K Classic Amulet Earrings with rock crystal

$1,500
18K Classic Amulet Earrings with rock crystal
$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 Medium Hoop Earrings with diamond pavé
18K Pavé Hoop Earrings with diamond
$3,500 - $4,850
More sizes available
18K Pavé Hoop Earrings with...
$3,500 - $4,850
More sizes available
Item 18K Vine Ring with diamond pavé
18K Vine Ring with diamond pavé
$7,200
18K Vine Ring with diamond p...
$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



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=171
								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="Best Sellers" 
										or  
										NavisionProductInfo.collection_2="Best Sellers"
										or  
										NavisionProductInfo.collection_3="Best Sellers"
										or  
										NavisionProductInfo.id IN (
											SELECT
												navision_product_info_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=171
										)
										or
										NavisionProductInfo.group_id IN (
											SELECT
												navision_product_group_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=171
										)
									)
					GROUP BY
						group_id
					ORDER BY 
						WebProductSort.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => E76144-PVRNG
            [web_name] => 18K Piccolo Tolomeo Earrings with mixed sapphire and blue sapphire center
            [price_retail] => 3750
            [group_id] => E76144-PVRNG
        )

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

    [WebProductImage] => Array
        (
            [id] => 181
            [navision_product_info_id] => E76144-PVRNG
            [name] => E76144-PVRNG
        )

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

    [0] => Array
        (
            [group_id] => E76144-PVRNG
        )

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

)