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=1 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=824 and productid=cache_Products.productid) order by PublishDate desc
The third collection of luxe leather bags from Tim and Dan Joo takes its cue from American Minimalism. Rather than realizing their subtle multi-tonal modulations on canvas or their clean lines in architecture, the brothers bring modern shapes and 60s colors to smooth leather backpacks and elegant leather duffels!
Leather duffel with contrast handles | Detachable shoulder strap | Zipper closure at top | Zippered interior compartment and inner pockets | Body: 100% leather | Lining: 100% cotton | Trim: 100% polyester | Made in Korea.
An exercise in spellbinding simplicity, Haerfest (pronounced "harvest") presents unisex accessories that begin with the commonplace and end with the exemplary. Seeking to create that perfect partner, brothers Tim & Dan design enduring objects that you'll want to keep close to you for many years to come.