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=14 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=817 and productid=cache_Products.productid) order by PublishDate desc
Zebra stripes, toucans, and palm trees team up in Heart Heart Heart's fourth collection. CSS bassist turned designer Iracema Trevisan channels all the hot pinks and sea blues of Brazil's coastline onto her color-blocked silks. This scarf has been finished with details carved from real wood to complement its painterly wood grain print.
Printed scarf with wooden details at corners | 100% silk | Made in France.