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=1136 and productid=cache_Products.productid) order by PublishDate desc
For spring, Toga Pulla pulls paisley into the future. Designer Yasuko Furuta injects new passion into our favorite Summer-of-Love print with jewel tones and silk georgette. Mix it up with metallics and transparent vinyl for a truly Tokyo look.
Printed snakeskin belt | Snap button closure | Genuine leather | Dust bag included | Made in Japan.
Showstopping prints and dramatic silhouettes take center stage in Toga's younger, more playful line. With a background in costume design, Japanese designer Yasuko Furuta favors exclusive fabrics and statement details: fringe, cut-outs, swathes of sheerness, and vibrantly colored fur. The Pulla girl packs major personality.