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=1833 and productid=cache_Products.productid) order by PublishDate desc
KARA's second collection is a lineup of Sarah Law's already signature shapes, redone in mesh leathers and silky calf hair. Backpacks and cross-body bags are made in durable pebbled leather to survive even the busiest schedules. When you're running around the city, KARA's bags have got your back.
Leather and calf hair backpack | Back pocket with magnetic snap closure | Zip closure | Made in China.