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=493 and productid=cache_Products.productid) order by PublishDate desc
Showing our favorite shapes some London love, Swear turns up the punk factor this season, adding platforms and plaid linings to its coveted ankle boots. Prowl the East End in creeper-style stompers and lace-ups with bright red soles!
Textured leather ankle boots | Contrast rubber sole | Plaid lining | Genuine leather | Made in Portugal.
Inspired by young, concert-going guys and their inability to find a middleground between Converse and Docs, Jose Neves put his mind to creating a "cross-over" sort of kick--one that would land halfway between classic and casual. And ever since designing that now-legendary first pair--the Dean--over a decade ago, Neves' London-based label, Swear, has proven to fill a void with its grown-up yet get-down sneakers for men and women.