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=14 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=670 and productid=cache_Products.productid) order by PublishDate desc
Thierry Lasry has never been one to play it safe. The renegade French sunglasses designer returns with another collection of scene-stealing shades and pulse-raising names. Complete with thick glossy frames and shiny metal arms, Thierry's glasses are hand-crafted in France using Italian acetate and traditional know-how.
Acetate sunglasses with metal arms | Hard and soft case included | Handmade in France.
As the son of an optician father and a designer mother, Thierry Lasry was certainly poised to become a force in the optical world. Committed to creating future vintage, the Frenchman designs eyewear that is authentically antique but also avant-gardist. Adding a touch of unorthodox texture and detail to traditional techniques, materials, and silhouettes, Lasry develops unique sunglasses for men and women of distinguished but daring taste.