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=293 and productid=cache_Products.productid) and ( ( [Keywords] like '%suno%' ) or productname like '%suno%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%suno%' or Remark='suno'))) and GroupID <> 5433 order by PublishDate desc
Baja embroidery and basketball courts! Suno handpicks inspiration from all kinds of intriguing places for Resort. Ever the traveler, the Suno girl blends technicolor brocade with Mexican blouses and sporty outerwear. Only designers Max Osterweis and Erin Beatty could make it look so easy.
Denim drawstring pants | Side pockets | Elastic cuffs | 70% cotton, 20% linen, 10% rami | Made in Kenya.
Socially responsible, economically sustainable, and irresistibly adorable, New York label Suno delivers some of the most arresting East African inspired designs while upholding strong, foundational values. What's not to love?