Женские костюмы и пиджаки с юбкой

Сортировать:

Показывать:

array(4) { [6604]=> array(49) { ["product_id"]=> string(4) "6604" ["name"]=> string(45) "Юбка женская черная Mattiolo" ["description"]=> string(715) "<p>Юбка женская черная Mattiolo прямого кроя. Длина изделия миди, разрез сзади, застежка молния.&nbsp;Базовый элемент гардероба. Универсальный фасон хорошо смотрится на девушках разного телосложения. Базовое цветовое решение позволяет легко комбинировать вещи и собирать новые луки.&nbsp;</p> <p>Купить&nbsp;юбку женскую черную Mattiolo можно на сайте нашего магазина&nbsp;DN8 SHOPPING SPACE.</p> " ["characteristics"]=> string(498) "<ul> <li>Код товара:6604</li> <li>Артикул: P73002-1600</li> <li>Бренд: Mattiolo</li> <li>Страна: Италия</li> <li>Модель: юбка</li> <li>Цвет: черный</li> <li>Принт: нет</li> <li>Материал: верх - вискоза 55%, ацетат 45%; подкл. - полиамид 97%, спандекс 3%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Юбка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "6604" ["sku"]=> string(11) "P73002-1600" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2021/mart/zhenskaya/img_9799-ds-1500px.jpg" ["manufacturer_id"]=> string(3) "163" ["manufacturer"]=> string(12) "Gai Mattiolo" ["manufacturer_size_table"]=> string(679) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>примечание</td> </tr> <tr> <td>Gai Mattiolo</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствует</td> </tr> </tbody> </table> " ["price"]=> string(9) "4800.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:23:27" ["date_modified"]=> string(19) "2021-04-27 12:02:05" ["viewed"]=> string(3) "117" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "179" [3]=> string(3) "361" [4]=> string(3) "387" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '361' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [17027]=> array(49) { ["product_id"]=> string(5) "17027" ["name"]=> string(58) "Пиджак женский с принтом Luisa Cerano" ["description"]=> string(953) "<p>Пиджак женский с принтом Luisa Cerano свободного кроя. А-силуэт, короткие лацканы, двубортный. Застежка пуговицы. Длина издели до начала бедра. Вертикальные прорезные карманы в листочку.&nbsp;</p> <p>Принт&nbsp;&laquo;гусиная лапка&raquo;, или pied-de-poule,&nbsp;символ аристократизма. В составе ткани преобладает хлопок.&nbsp;Хлопок&nbsp;- легкий, теплый, прочный материал, который защищает от ветра, дождя и холода.&nbsp;</p> <p>Купить пиджак женский с принтом Luisa Cerano можно на сайте нашего магазина&nbsp;DN8 SHOPPING SPACE.</p> " ["characteristics"]=> string(523) "<ul> <li>Код товара: 17027</li> <li>Артикул: 428093/2468</li> <li>Бренд: Luisa Cerano</li> <li>Страна: Германия</li> <li>Модель: пиджак</li> <li>Цвет: коричневый</li> <li>Принт: &quot;гусиная лапка&quot;</li> <li>Материал:&nbsp;хлопок 74%, полиакрил 24%, эластан 2%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Пиджак" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(177) "Жакет, женский, с отложным воротником, узор, гусиные лапки, Luisa Cerano, пиджак, хлопок, осенний, зимний" ["model"]=> string(5) "17027" ["sku"]=> string(11) "428093/2468" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(57) "catalog/dn8/fotosessija/2020/oktjabr/4_etazh/img_0901.jpg" ["manufacturer_id"]=> string(2) "32" ["manufacturer"]=> string(12) "Luisa Cerano" ["manufacturer_size_table"]=> string(690) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Luisa Cerano</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> </tbody> </table> " ["price"]=> string(10) "17600.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-10-21" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-21 10:01:17" ["date_modified"]=> string(19) "2021-03-17 12:36:52" ["viewed"]=> string(3) "397" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "318" [3]=> string(3) "361" [4]=> string(3) "363" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '361' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [17102]=> array(49) { ["product_id"]=> string(5) "17102" ["name"]=> string(60) "Трикотажный женский пиджак Le Coeur" ["description"]=> string(594) "<p>Трикотажный женский пиджак Le Coeur черного цвета. Приталенный фасон, баска, застежка пуговицы по всей длине. Принт полосы придает оригинальности классическому образу. Мягкая, эластичная ткань удобна в носке, не сковывает движений.</p> <p>Не деформируется, не скатывается, сохраняя привлекательный внешний вид.</p> " ["characteristics"]=> string(449) "<ul> <li>Код товара: 17102</li> <li>Артикул: 202ST3062</li> <li>Бренд: Le Coeur</li> <li>Страна: Италия</li> <li>Модель: пиджак</li> <li>Цвет: черный</li> <li>Принт: полосы</li> <li>Материал:&nbsp;вискоза 78%, нейлон 22%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Пиджак" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(304) "кардиган женский, кофта на пуговицах, трикотажная кофта, вязаная кофта, вязаный кардиган, тонкий кардиган, универсальный кардиган, стильный кардиган, темный кардиган" ["model"]=> string(5) "17102" ["sku"]=> string(9) "202ST3062" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(64) "catalog/dn8/fotosessija/2020/oktjabr/1etazhzhenskoe/img_1591.jpg" ["manufacturer_id"]=> string(3) "132" ["manufacturer"]=> string(19) "Le Coeur by Twinset" ["manufacturer_size_table"]=> string(1281) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Le Coeur by Twinset</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Le Coeur by Twinset(женские&nbsp;штаны, шорты)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "5400.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-10-20" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-20 13:25:06" ["date_modified"]=> string(19) "2021-06-08 09:55:01" ["viewed"]=> string(3) "307" ["categories"]=> array(7) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "318" [3]=> string(3) "361" [4]=> string(3) "364" [5]=> string(3) "509" [6]=> string(3) "511" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '361' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15589]=> array(49) { ["product_id"]=> string(5) "15589" ["name"]=> string(78) "Жакет женский с широкими карманами Liviana Conti" ["description"]=> string(1772) "<p>Женский жакет свободного кроя, не приталенный. Отложной рубашечный (плосколежащий) воротник&nbsp; с прямоугольными концами. Линия плеча слегка спущена. Втачные рукава длиной до косточки большого пальца. Полы пиджака расходятся книзу. Хорошо сидит на разных типах фигуры. Прорезной нагрудный карман с листочкой (пиджачный). По бокам на уровне талии широкие прорезные карманы с клапанами. Без шлиц. Длина до середины бедра.&nbsp;</p> <ul> <li>Натуральный состав ткани;</li> <li>стильный внешний вид;</li> <li>практичный в носке;</li> <li>универсальное цветовое решение.</li> </ul> <p>Если вам понравилась модель, купить женский черный жакет на пуговицах и с накладными карманами Liviana Conti можно на сайте нашего магазина.&nbsp;Бронирование проходит через личный кабинет сайта после предварительной регистрации. Оставить заявку на приобретение товара можно через менеджера магазина. Доставка работает по Киеву и Украине. Удачных покупок!</p> " ["characteristics"]=> string(658) "<ul> <li>Модель: женский пиджак;</li> <li>Фасон: свободный;</li> <li>Цвет: черный;</li> <li>Принт: нет;</li> <li>Материал верха: шерсть 60%, полиэстер 30%, полиуретан 10%;</li> <li>Подкладка: ацетат 67%, полиэстер 33%;</li> <li>Сезонность: демисезонный;</li> <li>Бренд:&nbsp;Liviana Conti;</li> <li>Страна регистрации бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Пиджак" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(148) "пиджак, костюм, одежда, женская, стильная, удобная, классика, черный, оригинальный" ["model"]=> string(5) "15589" ["sku"]=> string(10) "A9F F9AQ64" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(61) "catalog/dn8/fotosessija/2019/zhenskaja_oktjabr_1/ao6b5050.jpg" ["manufacturer_id"]=> string(3) "130" ["manufacturer"]=> string(13) "Liviana Conti" ["manufacturer_size_table"]=> string(859) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Liviana Conti</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "12600.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-10-18" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-10-18 16:36:57" ["date_modified"]=> string(19) "2021-05-18 09:48:02" ["viewed"]=> string(3) "479" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "318" [3]=> string(3) "361" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '361' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }

Юбка женская черная Mattiolo

4 800 грн.
Юбка женская черная Mattiolo прямого кроя. Длина изделия миди, разрез сзади, застежка молния. Б..

Пиджак женский с принтом Luisa Cerano

17 600 грн.
Пиджак женский с принтом Luisa Cerano свободного кроя. А-силуэт, короткие лацканы, двубортный. Засте..

Трикотажный женский пиджак Le Coeur

5 400 грн.
Трикотажный женский пиджак Le Coeur черного цвета. Приталенный фасон, баска, застежка пуговицы по вс..

Жакет женский с широкими карманами Liviana Conti

12 600 грн.
Женский жакет свободного кроя, не приталенный. Отложной рубашечный (плосколежащий) воротник  с ..
Показано с 1 по 4 из 4 (всего 1 страниц)