Women's Barbara Reis
Exclusive women's clothing by Barbara Reis. The Austrian native born and graduate of famous fashion school of Hetzendorf in Austria has committed herself to innovative lambskin creations. In this area of expertise, Barbara belongs to the real pros. Staying ahead by a nose to her competitors, she is permanently looking for innovations. This year's excellent selling line is of soft, cuddly and slightly metallic looking designed lambskin in colours like anthra, handmade to exceptionally created jackets, coats, bags and caps of highest quality and lightness.
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 (2,2, 332, 19, 212, 213, 510, 511, 512, 513, 514, 515, 21, 22, 211, 557, 556, 529, 530, 531, 532, 533, 534, 535, 536, 537, 555, 23, 234, 538, 235, 539, 24, 20, 203, 552, 204, 553, 561, 25, 30, 35, 146, 187, 188, 189, 283, 402, 400, 327, 424, 554, 305, 369, 560, 26, 459, 460, 461, 462, 463, 464, 465, 27, 224, 225, 226, 281, 284, 28, 29, 192, 559, 558, 193, 207, 366, 549, 31, 312, 313, 33, 541, 542, 543, 544, 545, 34, 522, 523, 524, 525, 526, 528, 51, 81, 407, 201, 409, 121, 190, 214, 280, 377, 384, 428, 439) 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