Temple St Clair Logo
Search
Temple St. Clair
Locations
Shopping Bag
Categories > Rings
Item 18K Mini Horseshoe Ring in diamond pavé
18K Mini Horseshoe Ring in diamond pavé

$1,950
18K Mini Horseshoe Ring in diamond pavé
$1,950
Item 18K Angel Ring in diamond pavé
18K Angel Ring in diamond pavé
$1,950
18K Angel Ring in diamond pa...
$1,950
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 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 Evil Eyelash Ring in sapphire and diamond
18K Evil Eyelash Ring in sapphire and diamond
$6,500
18K Evil Eyelash Ring in sap...
$6,500
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 Clover  Ring in diamond pavé
18K Mini Clover Ring in diamond pavé
$1,950
18K Mini Clover Ring in dia...
$1,950
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 Double Serpent Ring with diamond eyes
18K Double Serpent Ring with diamond eyes
$3,500
18K Double Serpent Ring with...
$3,500
Item 18k Evil Eye Ring in emerald and blue sapphire
18k Evil Eye Ring in emerald and blue sapphire
$3,250
18k Evil Eye Ring in emerald...
$3,250
Item 18K Lion Ring with diamond
18K Lion Ring with diamond
$4,950
18K Lion Ring with diamond
$4,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 Sorcerer Ring in mixed sapphire and diamond
18K Sorcerer Ring in mixed sapphire and diamond
$3,250
18K Sorcerer Ring in mixed s...
$3,250
Item 18K Scarab Ring in diamond
18K Scarab Ring

$3,250
More colors available
18K Scarab Ring
$3,250
More colors available
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 Arcadia Ring with emerald and diamond
18K Arcadia Ring with emerald and diamond
$45,000
18K Arcadia Ring with emeral...
$45,000
Item 18K Mare Ring with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Mare Ring with royal blue moonstone, blue s...
$2,950
18K Mare Ring with royal blu...
$2,950
Item 18K Scarab Ring in blue sapphire and emerald
18K Scarab Ring in blue sapphire and emerald
$6,500
18K Scarab Ring in blue sapp...
$6,500
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 Mosaic Ring with emerald, ruby, blue sapphire and diamond
18K Mosaic Ring with emerald, ruby, blue sapphi...
$15,000
18K Mosaic Ring with emerald...
$15,000
Item 18K Bombe Ring with Royal Blue Moonstone and diamond
18K Bombe Ring with Royal Blue Moonstone and di...
$7,500
18K Bombe Ring with Royal Bl...
$7,500
Item 18K Classic Cushion Ring with royal blue moonstone and blue sapphire
18K Classic Cushion Ring with royal blue moonst...
$15,500
18K Classic Cushion Ring wit...
$15,500
Item 18K Crown Ring with Royal Blue Moonstone
18K Crown Ring with Royal Blue Moonstone
$6,500
18K Crown Ring with Royal Bl...
$6,500
Item 18K Classic Cushion Ring with tanzanite and diamond
18K Classic Cushion Ring with tanzanite and dia...
$37,000
18K Classic Cushion Ring wit...
$37,000
Item 18K Small Sea Biscuit Ring with tsavorite and diamond pavé
18K Sea Biscuit Ring with tsavorite and diamond...
$7,500
18K Sea Biscuit Ring with ts...
$7,500
Item 18K Classic Oval Ring with pink tourmaline and diamond
18K Classic Oval Ring with pink tourmaline and ...
$9,800
18K Classic Oval Ring with p...
$9,800
Item 18K Eternity Ring with diamond
18K Eternity Ring with diamond
$2,950
More sizes available
18K Eternity Ring with diamo...
$2,950
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 Eternity Ring with rose cut blue sapphire
18K Eternity Ring with rose cut sapphire
$2,400
More colors available
18K Eternity Ring with rose ...
$2,400
More colors available
Item 18K Classic Horizontal Oval Ring with aquamarine and diamond
18K Classic Horizontal Oval Ring
$2,950
18K Classic Horizontal Oval ...
$2,950
Item 18K Foglia Ring with diamond pavé
18K Foglia Ring with diamond pavé
$5,000
18K Foglia Ring with diamond...
$5,000
Item 18K Vine Ring with tanzanite and diamond
18K Vine Ring with tanzanite and diamond

$15,000
18K Vine Ring with tanzanite and diamond
$15,000
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 Ring with aquamarine and diamond
18K Classic Ring with aquamarine and diamond
$12,500
18K Classic Ring with aquama...
$12,500
Item 18K Astrid Moonface Ring with royal blue moonstone and diamond
18K Astrid Moonface Ring with royal blue moonst...
$10,500
18K Astrid Moonface Ring wit...
$10,500
Item 18K Triple Eternity Ring with tsavorite
18K Triple Eternity Ring with tsavorite
$7,200
18K Triple Eternity Ring wit...
$7,200
Item 18K Single Mummy Ring with Royal Blue Moonstone and diamond
18K Mummy Ring with royal blue moonstone and diamond granulation

$6,500
18K Mummy Ring with royal blue moonstone and diamond granulation
$6,500
Item 18K Turtle Ring with blue sapphire pavé
18K Pavé Turtle Ring
$1,950
More colors available
18K Pavé Turtle Ring
$1,950
More colors available
Item 18K Moonface ring with diamond
18K Moonface ring with diamond
$4,900
18K Moonface ring with diamo...
$4,900
Item 18K Astrid Ring with Blue Moonstone Face and mix color sapphire
18K Astrid Ring with Blue Moonstone Face and mi...
$8,900
18K Astrid Ring with Blue Mo...
$8,900
Item 18K Moonface Ring with blue sapphire
18K Moonface Ring with blue sapphire
$4,200
18K Moonface Ring with blue ...
$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



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_classification_id=20
								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='RINGS')
					GROUP BY
						group_id
					ORDER BY 
						WebProduct.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => R11827-PVHORSE
            [web_name] => 18K Mini Horseshoe Ring in diamond pavé
            [price_retail] => 1950
            [group_id] => R11827
        )

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

    [WebProductImage] => Array
        (
            [id] => 1414
            [navision_product_info_id] => R11827-PVHORSE
            [name] => 
        )

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

    [0] => Array
        (
            [group_id] => R11827
        )

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

)