Logo
Search
Temple St. Clair
Locations
Shopping Bag
Categories > Bracelets
Item 18K Angel Charm Bracelet
18K Angel Charm Bracelet

$12,650
18K Angel Charm Bracelet
$12,650
Item 18K Granulated Vine Cuff Bracelet
18K Granulated Vine, Cesere and Oliva Cuffs
$12,500
18K Granulated Vine, Cesere ...
$12,500
Item 18K Bellina Bangle with Royal Blue Moonstone and diamond
18K Bellina Bangle with diamond
$3,500 - $4,200
More colors available
18K Bellina Bangle with diam...
$3,500 - $4,200
More colors available
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 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 Lion Arno Link Bracelet with diamond
18K Lion Arno Link Bracelet with diamond
$12,500
18K Lion Arno Link Bracelet ...
$12,500
Item 18K Small Single Round Bracelet with Royal Blue Moonstone and diamond
18K Small Single Round Bracelet with Royal Blue...
$3,750
18K Small Single Round Brace...
$3,750
Item 18K Turtle Oval Link Bracelet with blue sapphire, emerald and diamond
18K Turtle Oval Link Bracelet with blue sapphir...
$3,950
18K Turtle Oval Link Bracele...
$3,950
Item 18K Nomad Bella Bangle with diamond
18K Nomad Bella Bangle with diamond
$8,900
18K Nomad Bella Bangle with ...
$8,900
Item 18K Single Round Bracelet with Royal Blue Moonstone and diamond
18K Single Round Bracelet with Royal Blue Moons...
$7,950
18K Single Round Bracelet wi...
$7,950
Item 18K Small Flower Cluster Bracelet with Royal Blue Moonstone and diamond
18K Flower Cluster Bracelet with royal blue moo...
$13,500
18K Flower Cluster Bracelet ...
$13,500
Item 18K Iconic Charm Bracelet
18K Iconic Charm Bracelet
$13,200
18K Iconic Charm Bracelet
$13,200
Item 18K Nomad Bracelet with diamond
18K Nomad Bracelet with diamond
$35,000
18K Nomad Bracelet with diam...
$35,000
Item 18K Emerald Mandala Cuff
18K Emerald Mandala Cuff

$39,500
18K Emerald Mandala Cuff
$39,500
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 Evil Eye Bracelet in blue sapphire, emerald and diamond
18K Evil Eye Bracelet in blue sapphire, emerald...
$5,500
18K Evil Eye Bracelet in blu...
$5,500
Item 18K Cluster Bracelet in royal blue moonstone, aquamarine, tanzanite and diamond
18K Cluster Bracelet in royal blue moonstone, a...
$17,500
18K Cluster Bracelet in roya...
$17,500
Item 18K Scarab Bracelet in diamond
18K Scarab Bracelet in diamond
$7,500
18K Scarab Bracelet in diamo...
$7,500
Item 18K Deer Bracelet in diamond
18K Deer Bracelet in diamond

$85,000
18K Deer Bracelet in diamond
$85,000
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 Scarab Bellina Bangle in diamond
18K Scarab Bellina Bangle in diamond
$4,500
18K Scarab Bellina Bangle in...
$4,500
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 Scarab Bracelet in blue sapphire, emerald, and diamond
18K Scarab Bracelet in blue sapphire, emerald, ...
$11,500
18K Scarab Bracelet in blue ...
$11,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_classification_id=16
								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='BRACELETS')
					GROUP BY
						group_id
					ORDER BY 
						WebProduct.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => AB18810-5AP
            [web_name] => 18K Angel Charm Bracelet
            [price_retail] => 12650
            [group_id] => AB18810-5AP
        )

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

    [WebProductImage] => Array
        (
            [id] => 1210
            [navision_product_info_id] => AB18810-5AP
            [name] => 
        )

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

    [0] => Array
        (
            [group_id] => AB18810-5AP
        )

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

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

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

)