Logo
Search
Temple St. Clair
Locations
Shopping Bag
Collections > Tree Of Life
Item 18K Small Tree of Life Pendant with diamond pavé
18K Pavé Tree of Life Pendant with diamond

$11,000 - $19,500
More sizes available
18K Pavé Tree of Life Pendant with diamond
$11,000 - $19,500
More sizes available
Item 18K Dragonfly Earrings with diamond pavé
18K Dragonfly Earrings with diamond pavé
$3,950
18K Dragonfly Earrings with ...
$3,950
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 Standing Lion Pendant with diamond
18K Standing Lion Pendant with diamond
$8,700
18K Standing Lion Pendant wi...
$8,700
Item 18K Vine Amulet with rock crystal and diamond
18K Vine Amulet with oval rock crystal and diam...
$1,750 - $6,950
More sizes available
18K Vine Amulet with oval ro...
$1,750 - $6,950
More sizes available
Item 18K Dragonfly Amulet with rock crystal and diamond pavé
18K Dragonfly Amulet with oval rock crystal and...
$2,950
18K Dragonfly Amulet with ov...
$2,950
Item 18K Dragonfly Pendant with diamond pavé
18K Dragonfly Pendant with diamond pavé
$2,000
18K Dragonfly Pendant with d...
$2,000
Item 18K Lion Ring with diamond
18K Lion Ring with diamond
$4,950
18K Lion Ring with diamond
$4,950
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 Cutout Tree Pendant with diamond pavé
18K Cutout Tree Pendant with diamond pavé...
$2,500
18K Cutout Tree Pendant with...
$2,500
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 Owlet Amulet with blue sapphire and 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 Foglia Drop Earrings with Royal Blue Moonstone and diamond
18K Foglia Drop Earrings with Royal Blue Moonst...
$4,200
18K Foglia Drop Earrings wit...
$4,200
Item 18K Dragonfly Locket with diamond
18K Dragonfly Locket with diamond

$6,950
18K Dragonfly Locket with diamond
$6,950
Item 18K Sea Star Pendant with diamond pavé
18K Sea Star Pendant with diamond pavé
$1,300
18K Sea Star Pendant with di...
$1,300
Item 18K Sea Star Amulet with rock crystal and diamond pavé
18K Starfish Amulet with oval rock crystal and ...
$3,950 - $7,250
More sizes available
18K Starfish Amulet with ova...
$3,950 - $7,250
More sizes available
Item 18K Sea Star Amulet with rock crystal, Royal Blue Moonstone, blue sapphire and diamond
18K Sea Star Amulet with oval rock crystal, roy...
$6,950 - $10,500
More sizes available
18K Sea Star Amulet with ova...
$6,950 - $10,500
More sizes available
Item 18K Medium Sea Star Pendant with Royal Blue Moonstone and diamond
18K Sea Star Pendant with royal blue moonstone ...
$2,200 - $4,700
More sizes available
18K Sea Star Pendant with ro...
$2,200 - $4,700
More sizes available
Item 18K Mermaid Locket with diamond
18K Mermaid Locket with diamond

$6,950
18K Mermaid Locket with diamond
$6,950
Item 18K Matisse Amulet with rock crystal, rose cut blue sapphire and diamond pavé
18K Matisse Amulet
$8,000
18K Matisse Amulet
$8,000
Item 18K Foglia Earrings with diamond pavé
18K Foglia Earrings with diamond pavé
$4,750
18K Foglia Earrings with dia...
$4,750
Item 18K Pavé Halo Mandala Cutout Pendant with diamond
18K Pavé Halo Mandala Cutout Pendant wit...
$2,500
18K Pavé Halo Mandala...
$2,500
Item 18K Spiral Turtle Locket with tanzanite, blue sapphire and diamond
18K Spiral Turtle Locket
$6,950 - $7,600
More colors available
18K Spiral Turtle Locket
$6,950 - $7,600
More colors available
Item 18K Athena Owl Ring with blue green tourmaline, Royal Blue Moonstone, emerald, blue sapphire and diamond
18K Athena Owl Ring
$37,000
More colors available
18K Athena Owl Ring
$37,000
More colors available
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 Small Sea Star Locket with diamond
18K Small Sea Star Locket with diamond
$2,950
18K Small Sea Star Locket wi...
$2,950
Item 18K Matisse Amulet with rock crystal, rose cut blue sapphire and diamond pavé
18K Matisse Amulet with rock crystal, rose cut ...
$22,000
18K Matisse Amulet with rock...
$22,000
Item 18K Volo Necklace with diamond
18K Volo Necklace with diamond
$20,000
18K Volo Necklace with diamo...
$20,000
Item 18K Double Serpent Ring with diamond eyes
18K Double Serpent Ring with diamond eyes
$3,500
18K Double Serpent Ring with...
$3,500
Item 18K Small Turtle Locket with diamond pavé
18K Small Turtle Locket
$3,250 - $3,950
More colors available
18K Small Turtle Locket
$3,250 - $3,950
More colors available
Item 18K Pavé Sea Star Earrings with diamond
18K Pavé Sea Star Earrings
$2,500
18K Pavé Sea Star Ear...
$2,500
Item 18K Vine Amulet Earrings with rock crystal and diamond
18K Vine Amulet Earrings with rock crystal and diamond

$5,300
18K Vine Amulet Earrings with rock crystal and diamond
$5,300
Item 18K Matisse Amulet with rock crystal and diamond pavé
18K Matisse Amulet with rock crystal - 16x11mm
$4,500
18K Matisse Amulet with rock...
$4,500
Item 18K Matisse Earrings with rock crystal and diamond pavé
18K Matisse Earrings with rock crystal and diam...
$8,900
18K Matisse Earrings with ro...
$8,900
Item 18K Vine Ring with tanzanite and diamond
18K Vine Ring with tanzanite and diamond
$15,000
18K Vine Ring with tanzanite...
$15,000
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 Small Dragonfly Locket with diamond
18K Small Dragonfly Locket with diamond

$2,950
18K Small Dragonfly Locket with diamond
$2,950
Item 18K Owl Face Ring with emerald and blue sapphire
18K Owl Face Ring with emerald and blue sapphir...
$6,700
18K Owl Face Ring with emera...
$6,700
Item 18K Sea Biscuit Earrings with blue sapphire and diamond pavé
18K Sea Biscuit Earrings with blue sapphire and...
$6,950
More colors available
18K Sea Biscuit Earrings wit...
$6,950
More colors available
Item 18K Flying Fish Pendant with royal blue moonstone, blue sapphire and tsavorite
18K Flying Fish Pendant with royal blue moonsto...
$5,950
18K Flying Fish Pendant with...
$5,950
Item 18K Large Sea Biscuit Ring with tsavorite and diamond pavé
18K Sea Biscuit Ring with tsavorite and diamond...
$7,500 - $13,500
More sizes available
18K Sea Biscuit Ring with ts...
$7,500 - $13,500
More sizes available
Item 18K Tree Cutout Earrings with diamond pavé
18K Tree Cutout Earrings with diamond pav&eacut...
$2,750
18K Tree Cutout Earrings wit...
$2,750
Item 18K Mandala Cutout Earrings with diamond
18K Mandala Cutout Earrings with diamond
$2,750
18K Mandala Cutout Earrings ...
$2,750
Item 18K Dolphin Pendant with diamond pavé
18K Dolphin Pendant with diamond pavé
$2,800
18K Dolphin Pendant with dia...
$2,800
Item 18K Vine Ring
18K Vine Ring
$1,950
More sizes available
18K Vine Ring
$1,950
More sizes available
Item 18K Owl Locket with tanzanite and diamond
18K Owl Locket
$6,950
18K Owl Locket
$6,950
Item 18K Pavé Halo Cutout Dragonfly Earrings with diamond
18K Pavé Halo Cutout Dragonfly Earrings ...
$2,350
18K Pavé Halo Cutout ...
$2,350
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 Volo Drop Earrings with diamond
18K Volo Drop Earrings with diamond
$3,200
18K Volo Drop Earrings with ...
$3,200
Item 18K Flying Fish Earring with royal blue moonstone, tsavorite and diamond
18K Flying Fish Earring with royal blue moonstone, tsavorite and diamond

$5,200
18K Flying Fish Earring with royal blue moonstone, tsavorite and diamond
$5,200
Item 18K Monkey Earring with diamond
18K Monkey Earring with diamond
$2,700
18K Monkey Earring with diam...
$2,700
Item 18K Large Pavé Halo Cutout Dragonfly Pendant with diamond
18K Pavé Halo Cutout Dragonfly Pendant w...
$1,100 - $4,500
More sizes available
18K Pavé Halo Cutout ...
$1,100 - $4,500
More sizes available
Item 18K Sea Biscuit Pendant with blue sapphire and diamond pavé
18K Sea Biscuit Pendant with blue sapphire and ...
$6,500
More colors available
18K Sea Biscuit Pendant with...
$6,500
More colors available
Item 18K Small Owl Locket with tanzanite and diamond
18K Small Owl Locket with tanzanite and diamond
$1,850
18K Small Owl Locket with ta...
$1,850
Item 18K Flying Fish Amulet with rock crystal, royal blue moonstone, blue sapphire and diamond
18K Flying Fish Amulet with rock crystal, royal blue moonstone, blue sapphire and diamond

$7,500 - $22,000
More sizes available
18K Flying Fish Amulet with rock crystal, royal blue moonstone, blue sapphi...
$7,500 - $22,000
More sizes available
Item 18K Granulated Vine Cuff Bracelet
18K Granulated Vine, Cesere and Oliva Cuffs
$12,500
18K Granulated Vine, Cesere ...
$12,500
Item 18K Foglia Ring with diamond pavé
18K Foglia Ring with diamond pavé
$5,000
18K Foglia Ring with diamond...
$5,000
Item 18K Sea Star Earrings with Royal Blue Moonstone and diamond
18K Sea Star Earrings with Royal Blue Moonstone...
$3,950
18K Sea Star Earrings with R...
$3,950
Item 18K Foglia Double Drop Earrings with diamond pavé
18K Foglia Double Drop Earrings with diamond pa...
$7,500
18K Foglia Double Drop Earri...
$7,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=12
								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="TREE OF LIFE" 
										or  
										NavisionProductInfo.collection_2="TREE OF LIFE"
										or  
										NavisionProductInfo.collection_3="TREE OF LIFE"
										or  
										NavisionProductInfo.id IN (
											SELECT
												navision_product_info_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=12
										)
										or
										NavisionProductInfo.group_id IN (
											SELECT
												navision_product_group_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=12
										)
									)
					GROUP BY
						group_id
					ORDER BY 
						WebProductSort.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => P31842-SMPVTREE
            [web_name] => 18K Small Tree of Life Pendant with diamond pavé
            [price_retail] => 11000
            [group_id] => P31842-PVGROUP
        )

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

    [WebProductImage] => Array
        (
            [id] => 404
            [navision_product_info_id] => P31842-SMPVTREE
            [name] => P31842-SMPVTREE
        )

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

    [0] => Array
        (
            [group_id] => P31842-PVGROUP
        )

    [NavisionProductGroup] => Array
        (
            [total_products] => 2
            [min_price] => 11000
            [max_price] => 19500
            [web_name] => 18K Pavé Tree of Life Pendant with diamond
            [web_product_image_id] => 403
            [type] => SIZE
        )

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

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

    [WebProductGroupImage] => Array
        (
            [navision_product_info_id] => P31842-PVTREE
        )

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

)