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=209 and productid=cache_Products.productid and cache_products.GroupID <> 5433) and exists (select top 1 1 from mss_index where typeid=254 and productid=cache_Products.productid) order by PublishDate desc
Nina Simone was London-based designer Peter Jensen's spring muse. Find Jensen's signature waisted dresses and capri pants patterned with bright safari scenes—a tribute to the singer's time in Africa—and crisp cotton blouses inspired by her childhood Sundays.
Cropped trousers | Hip pockets | Zip fly with hook and tab closure | Belt loops | 100% cotton | Made in Poland.
Even though the Danish designer is adventurous and often unpredictable, you can always count on Peter Jensen to bring the charm. Playful, vibrant, and boldly silhouetted, each piece in a Jensen collection is as classically ravishing as it is counter-culturally innovative. And with a bunny for a logo, what else would you expect?