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=209 and productid=cache_Products.productid and cache_products.GroupID <> 5433) and exists (select top 1 1 from mss_index where typeid=509 and productid=cache_Products.productid) order by PublishDate desc
Add luxe Italian leather to 80 years of French savoir-faire and what do you get? A pair of perfect Sartore shoes. The brand's latest collection showcases the company's time-tested knack for contrasting different finishes. Look out for pony-hair, nubuck, and matte black toe caps!
Pony-hair ankle boota | Zipper closure at inner ankle | 2" heel | Cowhide | Made in Italy.
From the hills above Nice come esteemed shoemakers Sartore, a French brand built on fifty years of refinement, innovation, and style. Recognized for their classic-yet-singular aesthetic and their simple luxury, a Sartore pair is the kind that fits all occasions and elevates any attire. Today under the helm of the founders’ daughters Catherine and Françoise, the brand continues to uphold the quality and values originally established in the humble Breuil-sur-Roya factory where it all began in 1959.