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=21 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1757 and productid=cache_Products.productid) order by PublishDate desc
Who doesn't love Babar? Silas Adler of Danish line Soulland found inspiration in Jean de Brunhoff's illustrations of the lovable elephant for this special collection, creating all-over prints for shirts and shorts as well as an embroidered sweatshirt. A covetable trip down memory lane.
Sizes are listed in US men's sizing.
Printed T-shirt | Round neck | 100% cotton | Made in Portugal.