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=209 and productid=cache_Products.productid and cache_products.GroupID <> 5433) and exists (select top 1 1 from mss_index where typeid=159 and productid=cache_Products.productid) order by PublishDate desc
Flecked with color like a jawbreaker, these b store oxfords will sweeten up springtime strolls! The British footwear label’s latest collection expresses everything we love about the season, from floral-printed sandals to mesh oxfords that’ll reel in the compliments.
Printed lace-ups | Leather pull-tab at back | 1" heel | Made in Portugal.
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.