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=530 and productid=cache_Products.productid) order by PublishDate desc
Perfectly proportioned and expertly crafted, Barton Perreira's Graftpn frames are timelessly handsome. You won't find any loud details or logos, just technical skill and sophisticated styling. Pair with the matching Grafton clip-on tinted lenses to transition from inside to out!
Round glasses | Clear zyl frame | Clear lens | Made in Japan.
Emergent eyewear label Barton Perreira has swiftly made its mark with an array of uniquely luxe sunnies. Magnetic, elegant, and covetable, the LA-based brand embodies forward-leaning design and superior quality–specifically without flashy insignia. Expertly balancing risk and restraint, Barton Perreira creates truly handsome, lovingly handcrafted eyewear.