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=1585 and productid=cache_Products.productid) order by PublishDate desc
Time to downsize your bag! For fall, 202 Factory brings you mini bags in denim, leather, and velvet. These adorable bags are perfect for when you're traveling light for the night and need a suitably lightweight accessory.
Velvet belted bag | Buckle & toggle closure | Gold accents | Leather lining | 100% polyester | Made in Korea.