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=209 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=5 and productid=cache_Products.productid) order by PublishDate desc
call me Ishmael in this anchor stitched sweater by norsea. Sweater features an exquisitely stitched wool with ribbing at the high collar, wrists, and waist. Waist features a split at either end. Available in creme and navy.