Logo
Search
Temple St. Clair
Locations
Shopping Bag
Categories > Earrings
Item 18K Classic Trio Earring in diamond
18K Classic Trio Earring in diamond

$2,500 - $15,000
More sizes available
18K Classic Trio Earring in diamond
$2,500 - $15,000
More sizes available
Item 18KW Classic Trio Earring in diamond
18K White Gold Classic Trio Earring in diamond
$2,500 - $5,900
More sizes available
18K White Gold Classic Trio ...
$2,500 - $5,900
More sizes available
Item 18K Classic Amulet Earrings with rock crystal and diamond granulation
18K Classic Amulet Earrings with rock crystal a...
$2,900
18K Classic Amulet Earrings ...
$2,900
Item 18K Small Cluster Earrings with Royal Blue Moonstone and diamond
18K Cluster Earrings with royal blue moonstone ...
$3,500 - $6,500
More sizes available
18K Cluster Earrings with ro...
$3,500 - $6,500
More sizes available
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 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 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 Fan Earrings with tanzanite and diamond
18K Fan Earrings with tanzanite and diamond
$3,450
18K Fan Earrings with tanzan...
$3,450
Item 18K Classic Oval Earrings with cabochon Royal Blue Moonstone and diamond
18K Classic Cabochon Oval Earring with diamond
$2,100
18K Classic Cabochon Oval Ea...
$2,100
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 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 Eternity Hoop Earrings with blue sapphire
18K Eternity Hoop Earrings
$3,250 - $4,500
More colors available
18K Eternity Hoop Earrings
$3,250 - $4,500
More colors available
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 Double Drop Earrings with Royal Blue Moonstone and diamond
18K Double Drop Earrings with diamond

$2,950
18K Double Drop Earrings with diamond
$2,950
Item 18K Classic Amulet Earrings with diamond pavé earwire
18K Classic Amulet Earrings with diamond pav&ea...
$2,500
18K Classic Amulet Earrings ...
$2,500
Item 18K Double Ring Spin Earrings
18K Double Ring Spin Earrings
$1,950
18K Double Ring Spin Earring...
$1,950
Item 18K Double Amulet Drop Earrings with rock crystal and diamond pavé
18K Double Amulet Drop Earrings with rock cryst...
$3,500
18K Double Amulet Drop Earri...
$3,500
Item 18K Foglia Earrings with diamond pavé
18K Foglia Earrings with diamond pavé
$4,750
18K Foglia Earrings with dia...
$4,750
Item 18K Magna Earring with green beryl and diamond
18K Magna Earring with green beryl and diamond

$12,500
18K Magna Earring with green beryl and diamond
$12,500
Item 18K Pavé Sea Star Earrings with diamond
18K Pavé Sea Star Earrings
$2,500
18K Pavé Sea Star Ear...
$2,500
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 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 Classic Trio Earrings with Royal Blue Moonstone and diamond
18K Classic Trio Earrings
$2,300
18K Classic Trio Earrings
$2,300
Item 18K Angel Earrings with diamond granulation
18K Angel Earrings with diamond
$1,750 - $2,700
More sizes available
18K Angel Earrings with diam...
$1,750 - $2,700
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 Angel Earrings
18K Angel Earrings
$1,350 - $2,200
More sizes available
18K Angel Earrings
$1,350 - $2,200
More sizes available
Item 18K Angel Earrings with diamond pavé
18K Angel Earrings with diamond pavé
$3,700
18K Angel Earrings with diam...
$3,700
Item 18K Classic Trio Earrings with blue sapphire and diamond
18K Classic Trio Earrings
$4,250
More colors available
18K Classic Trio Earrings
$4,250
More colors available
Item 18K Scarab Earring in blue sapphire and diamond
18K Scarab Earring
$2,950
More colors available
18K Scarab Earring
$2,950
More colors available
Item 18K Scarab Earring in diamond
18K Scarab Earring in diamond
$1,850
18K Scarab Earring in diamon...
$1,850
Item 18K Lotus Post Earring in diamond
18K Lotus Post Earring in diamond
$2,200
18K Lotus Post Earring in di...
$2,200
Item 18K Pavé Halo Pyramid Earrings with peridot and diamond
18K Pavé Halo Pyramid Earrings

$5,750 - $11,000
More colors available
18K Pavé Halo Pyramid Earrings
$5,750 - $11,000
More colors available
Item 18K Moonface Drop Earrings with royal blue moonstone and diamond pavé
18K Moonface Drop Earrings with royal blue moon...
$8,950
18K Moonface Drop Earrings w...
$8,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 Mandala Cutout Earrings with diamond
18K Mandala Cutout Earrings with diamond
$2,750
18K Mandala Cutout Earrings ...
$2,750
Item 18K Evil Eye Earrings in emerald and blue sapphire
18K Evil Eye Earrings in emerald and blue sapph...
$2,700
18K Evil Eye Earrings in eme...
$2,700
Item 18K Medium Granulated Hoop Earrings
18K Granulated Hoop Earrings

$1,950
18K Granulated Hoop Earrings
$1,950
Item 18K Classic Pear Drop Earrings with Royal Blue Moonstone and diamond
18K Classic Pear Drop Earrings with Royal Blue ...
$4,600
18K Classic Pear Drop Earrin...
$4,600
Item 18K Blossom Drop Earrings with Royal Blue Moonstone and diamond
18K Blossom Drop Earrings with Royal Blue Moons...
$7,500
18K Blossom Drop Earrings wi...
$7,500
Item 18K Small Eternity Hoop Earrings with diamond
18K Small Eternity Hoop Earrings
$2,750 - $3,250
More colors available
18K Small Eternity Hoop Earr...
$2,750 - $3,250
More colors available
Item 18K Pear Cluster Earring in blue sapphire and diamond
18K Pear Cluster Earrings
$7,500
More colors available
18K Pear Cluster Earrings
$7,500
More colors available
Item 18K Moonface Earrings with rock crystal and diamond - 10mm
18K Moonface Earrings with rock crystal and dia...
$1,250
18K Moonface Earrings with r...
$1,250
Item 18K Classic Triple Drop Earrings with chrome tourmaline , royal blue moonstone, and diamond
18K Classic Triple Drop Earrings with chrome to...
$7,500
18K Classic Triple Drop Earr...
$7,500
Item 18K Classic Oval Earrings with faceted aquamarine and diamond
18K Classic Oval Faceted Earrings with diamond ...
$2,950
18K Classic Oval Faceted Ear...
$2,950
Item 18K Scarab Drop Earring in diamond
18K Scarab Drop Earring in diamond
$2,750
18K Scarab Drop Earring in d...
$2,750
Item 18K Pavé Halo Pyramid Earrings with tanzanite and diamond pavé
18K Pavé Halo Pyramid Earrings with tanz...
$12,500
18K Pavé Halo Pyramid...
$12,500
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 Classic Amulet Earrings with rock crystal and diamond
18K Classic Amulet Earrings with rock crystal a...
$2,750
18K Classic Amulet Earrings ...
$2,750
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 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 Classic Cabochon Oval Earrings with Royal Blue Moonstone and diamond
18K Classic Cabochon Oval Earrings with diamond...
$3,600
18K Classic Cabochon Oval Ea...
$3,600
Item 18K Deer Earring in diamond
18K Deer Earring in diamond
$2,500
18K Deer Earring in diamond
$2,500
Item 18K Classic Oval Earrings with faceted aquamarine and diamond - 10x8mm
18K Classic Faceted Oval Earrings with diamond ...
$3,500 - $4,950
More colors available
18K Classic Faceted Oval Ear...
$3,500 - $4,950
More colors 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 Moonface Earrings with royla blue moonstone and blue sapphire
18K Moonface Earrings with royla blue moonstone and blue sapphire

$5,900
18K Moonface Earrings with royla blue moonstone and blue sapphire
$5,900
Item 18K Mosaic Earrings with emerald, blue sapphire, ruby and diamond
18K Mosaic Earrings with emerald, blue sapphire...
$9,200
18K Mosaic Earrings with eme...
$9,200
Item 18K Sole Earrings with royal blue moonstone and diamond
18K Sole Earrings with royal blue moonstone and...
$5,200
18K Sole Earrings with royal...
$5,200
Item 18K Lotus Earring in royal blue moonstone and diamond
18K Lotus Earring in royal blue moonstone and d...
$1,950
18K Lotus Earring in royal b...
$1,950
Item 18K Evil Eye Drop Earring in blue sapphire, emerald and diamond
18K Evil Eye Drop Earring in blue sapphire, eme...
$8,700
18K Evil Eye Drop Earring in...
$8,700
Item 18K Pear Drop Earring with green tourmaline and diamond
18K Pear Drop Earring with green tourmaline and...
$19,500
18K Pear Drop Earring with g...
$19,500
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 Vine Amulet Earrings with rock crystal and diamond
18K Vine Amulet Earrings with rock crystal and ...
$5,300
18K Vine Amulet Earrings wit...
$5,300
Item 18K Large Hoop Earrings with diamond pavé
18K Pavé Hoop Earrings with diamond
$3,500 - $4,850
More sizes available
18K Pavé Hoop Earrings with...
$3,500 - $4,850
More sizes available
Item 18K Lantern Amulet Earrings with rock crystal and diamond
18K Lantern Amulet Earrings with rock crystal a...
$3,500
18K Lantern Amulet Earrings ...
$3,500
Item 18K Classic Pearl Earrings with diamond granulation
18K Classic Pearl Earrings with diamond granula...
$1,950
18K Classic Pearl Earrings w...
$1,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
Item 18K Magna Earring with morganite and diamond
18K Magna Earring with morganite and diamond
$12,500
18K Magna Earring with morga...
$12,500
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 Classic Amulet Earrings with rock crystal
18K Classic Amulet Earrings with rock crystal
$1,500
18K Classic Amulet Earrings ...
$1,500
Item 18K Classic Halo Pear Drop Earrings with Royal Blue Moonstone and diamond pavé
18K Classic Halo Pear Drop Earrings with Royal ...
$6,950
18K Classic Halo Pear Drop E...
$6,950
Item 18K Monkey Earring with diamond
18K Monkey Earring with diamond
$2,700
18K Monkey Earring with diam...
$2,700





					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=2
								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='EARRINGS')
					GROUP BY
						group_id
					ORDER BY 
						WebProduct.sort_weight DESC
					LIMIT
						150
				Array
(
    [NavisionProductInfo] => Array
        (
            [id] => E11847-DIGRN1
            [web_name] => 18K Classic Trio Earring in diamond
            [price_retail] => 5900
            [group_id] => E11847-GROUP
        )

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

    [WebProductImage] => Array
        (
            [id] => 1432
            [navision_product_info_id] => E11847-DIGRN1
            [name] => 
        )

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

    [0] => Array
        (
            [group_id] => E11847-GROUP
        )

    [NavisionProductGroup] => Array
        (
            [total_products] => 3
            [min_price] => 2500
            [max_price] => 15000
            [web_name] => 18K Classic Trio Earring in diamond
            [web_product_image_id] => 0
            [type] => SIZE
        )

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

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

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

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

)