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=1924 and productid=cache_Products.productid) order by PublishDate desc
French brand Le Gramme—named for the unit of measurement—is a jewelry line dedicated to a simple, universal look. Design duo Adrien Messié and Erwan Le Louër are committed to logical and ethical creations, naming each style for the amount of silver used. Each bracelet is made of 925• recycled sterling silver, and engraved with a unique batch number.
Cuff bracelet | 100% sterling silver | Made in France.