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=1 and productid=cache_Products.productid and cache_products.GroupID <> 5433) and exists (select top 1 1 from mss_index where typeid=991 and productid=cache_Products.productid) and ( ( [Keywords] like '%bracelet%' ) or productname like '%bracelet%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%bracelet%' or Remark='bracelet'))) and GroupID <> 5433 order by PublishDate desc
Hand-carved skulls decorate each of Thomas Franc and Vincent Ribat's colorful memento moris. The pair reworks vintage scarves and ribbons into bracelets, bow ties, and cufflinks that charm with all the laid-back elegance of their native St. Tropez. The latest addition to their repertoire? Stretchy bungee cord bracelets!
Woven string wraparound bracelet with skull charm | Made in France.