SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_products_lng_en.product, xcart_products_lng_en.descr, xcart_products_lng_en.fulldescr, xcart_variants.avail as avail, xcart_variants.weight as weight, xcart_variants.productcode as productcode FROM xcart_products INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_products.forsale = 'Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid AND xcart_products_categories.avail = 'Y' INNER JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_products_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid WHERE xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_products_categories.categoryid='4945' AND ( xcart_variants.avail > 0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY xcart_products_categories.orderby ASC, xcart_products_lng_en.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC
SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_products_lng_en.product, xcart_products_lng_en.descr, xcart_products_lng_en.fulldescr, xcart_variants.avail as avail, xcart_variants.weight as weight, xcart_variants.productcode as productcode FROM xcart_products INNER JOIN xcart_featured_products ON xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='4945' INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_products.forsale = 'Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid AND xcart_products_categories.avail = 'Y' INNER JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_products_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid WHERE xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND ( xcart_variants.avail > 0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY xcart_featured_products.product_order, xcart_products_lng_en.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC
Duca Shoes at Dellamoda.com
The website uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Click to learn more. 
    
Login or Register | (0)
?Help
  • Toll Free : 800-515-8523
  • International Calls : 310-622-4490
  • Contact Us
USD ($)

Duca Shoes

Result pages: View All 123Next page
Result pages: View All 123Next page

About the Brand:

DUCA SHOES by Matiste leather footwear and accessories have been manufacturing exceptional quality handmade products since 2004. DUCA has become a brand well known around the United States and internationally.   The products are exclusively handmade on Italy with delicate artisan workmanship who create products with great care for details.  The brand thrives on using vibrant colored leathers in creating fashionable products. DUCA by Matiste products are designed for comfort while keeping with the ever changing styles in the fashion industry.