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=559 and productid=cache_Products.productid) order by PublishDate desc
Sweetened with polka dots and daisies, Mark "McNasty" McNairy's women's collection is about as far from nasty as it gets this season! Made in the famous shoe town of Northampton, England, these boots boast a timelessly classic shape and top-notch construction.
Polka-dot canvas chukka boots | Genuine leather inner sole | Padded heel | Ruber sole | Made in England.
When you look at his classic, Ivy League-inspired shoe label New Amsterdam, it's no secret that self-confessed prep Mark McNairy gravitates to the finer things in life. Committed to "undesigning," McNairy plays with traditionally debonair silhouettes like the brogue or chukka, and inserts youthful notes like colorblocking and red brick soles to bring new life to time-tested English and American style.