Temple St Clair Logo
Search
Temple St. Clair
Locations
Shopping Bag
Collections > My Life Aquatic
Collection
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 Turtle Earrings with diamond pavé
18K Turtle Earrings with diamond pavé
$5,200
18K Turtle Earrings with dia...
$5,200
Item 18K Spiral Turtle Locket with emerald 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 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 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 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 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 Flying Fish Earring with royal blue moonstone, tsavorite and diamond
18K Flying Fish Earring with royal blue moonsto...
$5,200
18K Flying Fish Earring with...
$5,200
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 Flying Fish Amulet with rock crystal, royal blue moonstone, blue sapphire and diamond
18K Flying Fish Amulet with rock crystal, royal...
$7,500 - $22,000
More sizes available
18K Flying Fish Amulet with ...
$7,500 - $22,000
More sizes available
Item 18K Mare Drop Earrings with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Mare Drop Earrings with royal blue moonston...
$8,750
18K Mare Drop Earrings with ...
$8,750
Item 18K Mare Link Necklace with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Mare Link Necklace with royal blue moonston...
$15,000
18K Mare Link Necklace with ...
$15,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 Mare Drop Earrings with royal blue moonstone, blue sapphire, tsavorite, and diamond
18K Mare Drop Earrings with royal blue moonstone, blue sapphire, tsavorite, and diamond

$2,950
18K Mare Drop Earrings with royal blue moonstone, blue sapphire, tsavorite,...
$2,950
Item 18K Mare Necklace with royal blue moonstone, blue sapphire, tsavorite and diamond
18K Mare Necklace with royal blue moonstone, bl...
$23,000
18K Mare Necklace with royal...
$23,000
Item 18K Pisces Zodiac pendant with diamond
18K Pisces Zodiac pendant with diamond
$1,850
18K Pisces Zodiac pendant wi...
$1,850
Item 18K Pavé Sea Star Earrings with diamond
18K Pavé Sea Star Earrings
$2,500
18K Pavé Sea Star Ear...
$2,500
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, Royal Blue Moonstone, blue sapphire and diamond
18K Sea Star Amulet with oval rock crystal, royal blue moonstone, blue sapphire and diamond

$6,950 - $10,500
More sizes available
18K Sea Star Amulet with oval rock crystal, royal blue moonstone, blue sapp...
$6,950 - $10,500
More sizes available
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 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 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 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



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=140
								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="MARE" 
										or  
										NavisionProductInfo.collection_2="MARE"
										or  
										NavisionProductInfo.collection_3="MARE"
										or  
										NavisionProductInfo.id IN (
											SELECT
												navision_product_info_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=140
										)
										or
										NavisionProductInfo.group_id IN (
											SELECT
												navision_product_group_id
											FROM
												web_collection_products
											WHERE
												navision_collection_id=140
										)
									)
					GROUP BY
						group_id
					ORDER BY 
						WebProductSort.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => R36819-PVTURTBS
            [web_name] => 18K Turtle Ring with blue sapphire pavé
            [price_retail] => 1950
            [group_id] => R36819-TURGROUP
        )

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

    [WebProductImage] => Array
        (
            [id] => 1574
            [navision_product_info_id] => R36819-PVTURTBS
            [name] => 
        )

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

    [0] => Array
        (
            [group_id] => R36819-TURGROUP
        )

    [NavisionProductGroup] => Array
        (
            [total_products] => 3
            [min_price] => 1950
            [max_price] => 1950
            [web_name] => 18K Pavé Turtle Ring
            [web_product_image_id] => 1575
            [type] => COLOR
        )

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

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

    [WebProductGroupImage] => Array
        (
            [navision_product_info_id] => R31819-PVTURTLE
        )

    [WebProductSortImage] => Array
        (
            [navision_product_info_id] => R36819-PVTURTEM
        )

)