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=378 and productid=cache_Products.productid) and ( ( [Keywords] like '%Illesteva%' and [Keywords] like '%Leonard%' ) or productname like '%Illesteva Leonard%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%Illesteva Leonard%' or Remark='Illesteva Leonard'))) and GroupID <> 5433 order by PublishDate desc
Eyewear impresarios Daniel Silberman and DJ Jus Ske bring us another collection of 50s-inspired summer staples. Their most popular round frame—the Leonard—returns in clear acetate with tortoiseshell arms, and the multi-tonal, streaked brown "leopard"!
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.