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=1 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=5 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=63 and productid=cache_Products.productid) order by PublishDate desc
There's something effortlessly vintage and European about these shoes - it's as if they took a walk down Via Veneto fifty years before B Store designed them. 100% suede upper. Available in off white.
Established: 2001 by José Neves, Matthew Murphy, and Kirk Beattie
London-based brand b Store has captured the affections of those at home and abroad with its classic-meets-contemporary-meets-counterculture aesthetic. Firmly planted on Savile Row, the boutique and shoe label share the same forward-thinking aim: to harness the energy of creative youth with ever-evolving modes of design. And considering they just skated past a 10th anniversary, we think the shoe gurus have it right.