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=873 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1738 and productid=cache_Products.productid) order by PublishDate desc
Good morning from Second Lab! New to OC this season, the Japanese brand specializes in taking retro ideas and making them into new items. There's no way to have a gloomy day with this rug smiling up at you. Throw it in your bathroom, kitchen, or wherever you may need a happy face.