select ProductID , GroupID,PreOrder,0 as LC,(select top 1 TypeID from mss_Types where TypeID in (select typeid from mss_types where [sign]='DESIGNERS') and TypeID in (select TypeID from mss_Index where ProductID=cache_products.ProductID)) AS DesignerID from cache_Products where (publishdate < getdate() or publishdate is null) and 1=1 and exists (select top 1 1 from mss_index where typeid=2 and productid=cache_Products.productid and cache_products.GroupID <> 5433) and exists (select top 1 1 from mss_index where typeid=26 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=272 and productid=cache_Products.productid) order by PublishDate desc
Giles & Brother’s Resort collection lets you raid the jewelry stash of a queen! Designer Philip Crangi pays tribute to Hippolyta, daughter of Ares and queen of the Amazons, with royal purple shell necklaces and sawlike bangles. Think elegant armor for the urban jungle.
Chain necklace with shell pendant | Spring ring closure | Antique brass | Made in China.