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=433 and productid=cache_Products.productid) order by PublishDate desc
Gaultier says "Bonjour!" to French Polynesia, taking us on a voyage to the island of Tahiti. Tropical florals and patterns in vivid colors brighten up maxi dresses and swimsuits, perfect for a day on the beach sipping from a coconut (or pounding pavement with a bottle of coconut water!)
Long-sleeve ruched dress | Body: 100% nylon | Lining: 86% polyester, 14% elastane | Made in Italy.
Never a follower, seminal designer and demagogue Jean Paul Gaultier has been honing an irreverent and mesmerizing aesthetic for nearly 40 years. Known for mixing men’s and womenswear as well as for sending unconventional models down the runway, the French firebrand bothers less with submitting to the norms of fashion and more with inventing sophisticated, surprising designs that do justice to his above-and-beyond creative vision.