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 cache_products.GroupID <> 5433) and exists (select top 1 1 from mss_index where typeid=980 and productid=cache_Products.productid) order by PublishDate desc
Based in forward-thinking East London but upholding traditional English production methods, D.S. Dundee is British through and through. Its latest collection offers colorful homespun knits made from soft fine gauge cotton, chinos with an easy old-school fit, and impeccable detailing throughout.
Short-sleeve linen shirt | Front button closure | Breast pocket | 100% linen | Made in Portugal.