15% off AW14 menswear
15% off AW14 ladieswear
METROPOLITAN BY COMO COMPETITION
  • Your Selection
NEW SEASON COLLECTIONS AW14 - LADIES
NEW SEASON COLLECTIONS AW14 - MENS

Men's Di Stilo

A little known hidden gem that Jules B has uncovered in the trade shows of Milan. Di Stilo bring these high quality and very unusual hand-made suede pinstripe shoes and belts to the offer for 2008

Unknown column 'Array' in 'where clause'

SELECT s.product_id,MIN( IF(s.sale='Y', s.sale_price_calculated, s.price_calculated )) as min_sort_price,MAX( IF(s.sale='Y', s.sale_price_calculated, s.price_calculated )) as max_sort_price,p.title as sort_title , ptms.manufacturer_id as forced_sort_order , pta.attribute_value_id , IF (s.pre_order = 'Y', 1,0) AS pre_order_count FROM products p, products_to_categories p2c, categories LEFT JOIN products s ON (p.product_id = s.parent_product_id) LEFT JOIN manufacturers m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN products_to_manufacturers ptm ON p.manufacturer_id = ptm.manufacturer_id AND p.product_id = ptm.product_id LEFT JOIN products_to_manufacturers ptms ON p.manufacturer_id = ptms.manufacturer_id AND s.product_id = ptms.product_id LEFT JOIN product_to_attributes pta ON (s.product_id = pta.product_id) WHERE s.product_id = p2c.product_id AND p2c.category_id = categories.category_id AND p.parent_product_id = 0 AND p.deleted = 'N' AND p.active = 'Y' AND s.deleted = 'N' AND s.active = 'Y' AND categories.active = 'Y' AND categories.deleted = 'N' AND s.price > 0 AND (s.stock > 0 OR s.stock = 999 OR p.show_zero_stock = 'Y' OR s.pre_order = 'Y' ) AND p2c.category_id IN (1,1, 8, 9, 475, 476, 477, 478, 479, 481, 482, 10, 11, 410, 12, 546, 547, 548, 550, 551, 521, 14, 17, 18, 50, 71, 408, 52, 54, 587, 588, 589, 590, 591, 90, 91, 123, 290, 58, 401, 399, 282, 423, 540, 644, 304, 340, 370, 13, 497, 498, 15, 101, 367, 483, 484, 485, 487, 488, 489, 490, 491, 39, 42, 564, 565, 566, 567, 40, 466, 467, 468, 469, 471, 472, 65, 492, 493, 494, 496, 92, 505, 506, 95, 97, 441, 442, 443, 246, 500, 501, 502, 503, 504, 103, 227, 645, 519, 520, 113, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 581, 120, 183, 49, 516, 647, 215) AND p.manufacturer_id = Array AND pta.attribute_id = 2 GROUP BY pta.attribute_value_id, s.parent_product_id ORDER BY IF(ptms.sort_order IS NOT NULL, ptms.sort_order, ptm.sort_order) ASC, p.sale DESC, p.last_modified DESC, min_sort_price ASC,max_sort_price ASC