Logo
Search
Temple St. Clair
Locations
Shopping Bag
Collections > Celestial
Item 18K Eight Ring Tolomeo Pendant with mixed sapphire and diamond
18K Eight Ring Tolomeo Pendant with mixed sapphire and diamond

$25,000
18K Eight Ring Tolomeo Pendant with mixed sapphire and diamond
$25,000
Item 18K Three Ring Tolomeo Pendant with mixed sapphire and diamond
18K Three Ring Tolomeo Pendant with mixed sapph...
$10,000
18K Three Ring Tolomeo Penda...
$10,000
Item 18K Sorcerer Pendant with mixed sapphire pavé
18K Sorcerer Pendant with mixed sapphire pav&ea...
$2,750
18K Sorcerer Pendant with mi...
$2,750
Item 18K Sorcerer Earrings with mixed sapphire pavé
18K Sorcerer Earrings with mixed sapphire pav&e...
$3,250
18K Sorcerer Earrings with m...
$3,250
Item 18K Piccolo Tolomeo Pendant with mixed sapphire and diamond
18K Piccolo Tolomeo Pendant with mixed sapphire...
$1,750
18K Piccolo Tolomeo Pendant ...
$1,750
Item 18K Piccolo Tolomeo Pendant with Royal Blue Moonstone and diamond
18K Piccolo Tolomeo Pendant with Royal Blue Moo...
$2,400
18K Piccolo Tolomeo Pendant ...
$2,400
Item 18K Three Ring Tolomeo Pendant with diamond
18K Three Ring Tolomeo Pendant with diamond
$10,500
18K Three Ring Tolomeo Penda...
$10,500
Item 18K Classic Amulet with round rock crystal and mixed sapphire pavé
18K Classic Amulet with round rock crystal and ...
$3,250
18K Classic Amulet with roun...
$3,250
Item 18K Triple Drop Tolomeo Earrings with mixed sapphire and diamond
18K Triple Drop Tolomeo Earrings with mixed sap...
$5,200
18K Triple Drop Tolomeo Earr...
$5,200
Item 18K Piccolo Tolomeo Earrings with mixed sapphire and blue sapphire center
18K Piccolo Tolomeo Earrings with mixed sapphir...
$3,750
18K Piccolo Tolomeo Earrings...
$3,750
Item 18K Sorcerer Locket with blue sapphire and diamond
18K Sorcerer Locket with blue sapphire and diam...
$6,950
18K Sorcerer Locket with blu...
$6,950
Item 18K Cutout Sorcerer Pendant with diamond pavé
18K Cutout Sorcerer Pendant with diamond pav&ea...
$3,200
18K Cutout Sorcerer Pendant ...
$3,200
Item 18K Emerald Mandala Cuff
18K Emerald Mandala Cuff
$39,500
18K Emerald Mandala Cuff
$39,500
Item 18K Buddha Pendant with ruby and diamond
18K Buddha Pendant with ruby and diamond

$23,000
18K Buddha Pendant with ruby and diamond
$23,000
Item 18K Stupa Ring with blue sapphire, tsavorite and diamond
18K Stupa Ring with blue sapphire, tsavorite an...
$18,500
18K Stupa Ring with blue sap...
$18,500
Item 18K Lunar Phase Amulet in rock crystal 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 Moonface Pendant with rock crystal and diamond
18K Moonface Pendant with carved rock crystal a...
$650 - $1,850
More sizes available
18K Moonface Pendant with ca...
$650 - $1,850
More sizes available
Item 18K Stupa Ring with orange sapphire, ruby and diamond
18K Stupa Ring with orange sapphire, ruby and d...
$18,500
18K Stupa Ring with orange s...
$18,500
Item 18K Moonface Earrings with rock crystal and diamond - 10mm
18K Moonface Earrings with rock crystal and diamond ganulation

$1,250
18K Moonface Earrings with rock crystal and diamond ganulation
$1,250
Item 18K Double Ring Spin Earrings
18K Double Ring Spin Earrings
$1,950
18K Double Ring Spin Earring...
$1,950
Item 18K Small Crescent Moon Pendant with Royal Blue Moonstone, blue sapphire and diamond
18K Crescent Moon Pendant
$1,500
18K Crescent Moon Pendant
$1,500
Item 18K Aquarius Zodiac pendant with diamond
18K Aquarius Zodiac pendant with diamond
$1,850
18K Aquarius Zodiac pendant ...
$1,850
Item 18K Pisces Zodiac pendant with diamond
18K Pisces Zodiac pendant with diamond
$1,850
18K Pisces Zodiac pendant wi...
$1,850
Item 18K Aries Zodiac pendant with diamond
18K Aries Zodiac pendant with diamond
$1,850
18K Aries Zodiac pendant wit...
$1,850
Item 18K Taurus Zodiac pendant with diamond
18K Taurus Zodiac pendant with diamond
$1,850
18K Taurus Zodiac pendant wi...
$1,850
Item 18K Gemini Zodiac pendant with diamond
18K Gemini Zodiac pendant with diamond
$1,850
18K Gemini Zodiac pendant wi...
$1,850
Item 18K Cancer Zodiac pendant with diamond
18K Cancer Zodiac pendant with diamond
$1,850
18K Cancer Zodiac pendant wi...
$1,850
Item 18K Leo Zodiac pendant with diamond
18K Leo Zodiac pendant with diamond
$1,850
18K Leo Zodiac pendant with ...
$1,850
Item 18K Virgo Zodiac pendant with diamond
18K Virgo Zodiac pendant with diamond
$1,850
18K Virgo Zodiac pendant wit...
$1,850
Item 18K Libra Zodiac pendant with diamond
18K Libra Zodiac pendant with diamond
$1,850
18K Libra Zodiac pendant wit...
$1,850
Item 18K Scorpio Zodiac pendant with diamond
18K Scorpio Zodiac pendant with diamond
$1,850
18K Scorpio Zodiac pendant w...
$1,850
Item 18K Sagittarius Zodiac pendant with diamond
18K Sagittarius Zodiac pendant with diamond

$1,850
18K Sagittarius Zodiac pendant with diamond
$1,850
Item 18K Capricorn Zodiac pendant with diamond
18K Capricorn Zodiac pendant with diamond
$1,850
18K Capricorn Zodiac pendant...
$1,850
Item 18K Sorcerer Ring with black opal and diamond
18K Sorcerer Ring with black opal and diamond
$15,000
18K Sorcerer Ring with black...
$15,000
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 Small Sorcerer Locket with diamond
18K Small Sorcerer Locket with diamond
$2,950
18K Small Sorcerer Locket wi...
$2,950
Item 18K Moonface Drop Earrings with royal blue moonstone and diamond pavé
18K Moonface Drop Earrings with royal blue moonstone and diamond pavé

$8,950
18K Moonface Drop Earrings with royal blue moonstone and diamond pavé...
$8,950
Item 18K Lunar Phase Locket with blue sapphire in diamond
18K Lunar Phase Locket with blue sapphire in di...
$11,500
18K Lunar Phase Locket with ...
$11,500
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 Buddha Pendant with emerald and diamond
18K Buddha Pendant with emerald and diamond
$23,000
18K Buddha Pendant with emer...
$23,000
Item 18K Moonface Drop Earrings with royal blue moonstone and diamond
18K Moonface Drop Earrings with royal blue moon...
$5,750
18K Moonface Drop Earrings w...
$5,750
Item 18K Evil Eyelash Amulet in oval rock crystal, blue sapphire and diamond
18K Evil Eyelash Amulet in oval rock crystal, b...
$3,700 - $6,700
More sizes available
18K Evil Eyelash Amulet in o...
$3,700 - $6,700
More sizes available
Item 18K Double Ring Spin Earrings with diamond pavé
18K Double Ring Spin Earrings with diamond pav&...
$5,950
18K Double Ring Spin Earring...
$5,950
Item 18K Horseshoe Pendant in diamond
18K Horseshoe Pendant in diamond
$1,750
18K Horseshoe Pendant in dia...
$1,750





					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=18
								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="CELESTIAL" 
										or  
										NavisionProductInfo.collection_2="CELESTIAL"
										or  
										NavisionProductInfo.collection_3="CELESTIAL"
										or  
										NavisionProductInfo.id IN (
											SELECT
												navision_product_info_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=18
										)
										or
										NavisionProductInfo.group_id IN (
											SELECT
												navision_product_group_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=18
										)
									)
					GROUP BY
						group_id
					ORDER BY 
						WebProductSort.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => P46876-MXSP8RG
            [web_name] => 18K Eight Ring Tolomeo Pendant with mixed sapphire and diamond
            [price_retail] => 25000
            [group_id] => P46876-MXSP8RG
        )

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

    [WebProductImage] => Array
        (
            [id] => 485
            [navision_product_info_id] => P46876-MXSP8RG
            [name] => P46876-MXSP8RG
        )

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

    [0] => Array
        (
            [group_id] => P46876-MXSP8RG
        )

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

)