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=24 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1585 and productid=cache_Products.productid) order by PublishDate desc
Just like Jell-O, this clutch from Korean brand 202 Factory is one shiny morsel we can't get enough of. Its simple envelope shape is folded from transparent PVC and sealed with a silver stud. It's just the thing for keeping your day-to-day essentials at-hand and in clear sight.
Transparent PVC clutch with stud closure | 202 Factory charm attached inside | Made in Korea.