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=25 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1836 and productid=cache_Products.productid) order by PublishDate desc
New Zealand-based lingerie brand Lonely launched in 2009. Inspired by the lack of feminine, vintage styles on the market, designer Helene Morris uses cut and subtle details to provide comfort and support without using padding or push-ups. It's a lingerie line for the woman who wears lingerie for herself. But you'll also want to show these pieces off.
Lace cut-out bra | Adjustable velvet elastic straps | Straps cross in back | Hook-and-eye closure | 90% nylon 10% spandex | Made in China.