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=354 and productid=cache_Products.productid) order by PublishDate desc
Weaving together Moorish and Southwestern influences, Pamela Love's pre-fall collection is a wild story of east meets west. Silver arrowhead pendants sit side by side with hammered gold cuffs and bronze rings topped with pyramids—think Indiana Jones in Africa!
Cut-out silver ring with sapphire | Made in the USA.
Drummer-artist-designer Pamela Love may wear many hats, but it clearly hasn’t deterred her from exerting her fullest creative energies into each. Inspired by a myriad of sometimes merry, sometimes macabre influences, the New York-based triple threat crafts instantly affecting, animal-like pieces that seriously construe a mood, adding stunning character to the look of its wearer.