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=378 and productid=cache_Products.productid) order by PublishDate desc
IllestevaLimited Edition Dasha for Illesteva Leonard 2
This limited edition spin on Illesteva's all-time favorite frame, the Leonard, was designed in collaboration with model magnate Dasha Zhukova. Handmade in France using a unique blend of acetate, each pair is one of a limited run of 100. Part of the proceeds from every sale will be donated to Restoring Vision, which supplies glasses to over 1.3 million people in need.
Round acetate frames | Key-hole bridge | Silver-tone accents | Made in Italy.
Despite just debuting its first collection in the spring of 2010, young eyewear label Illesteva proves with their tastefully nostalgic frames that they have some serious vision (pun intended!). Drawing inspiration from the "Latin Las Vegas" that is 50s-era Havana and working with superior Italian and German manufacturers to craft the highest quality handmade pairs, founders Daniel Silberman and Jus Ske achieve a timelessly stylish aesthetic.