Мужские блейзеры

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

Показывать:

array(12) { [13542]=> array(49) { ["product_id"]=> string(5) "13542" ["name"]=> string(44) "Блейзер темно-синий Cadini " ["description"]=> string(921) "<p>Блейзер мужской однобортный темно-синий Cadini в элегантном стиле из благородной узорчатой ткани. Подходит ля создания формального делового образа. Воротник прямоугольный. Длинные лацканы. Нагрудный карман с листочкой. Пуговицы на рукавах. Две шлицы по бокам. Изделие на 2 пуговицы. Боковые карманы с клапаном. Классический крой.&nbsp;</p> <ul> </ul> <p>Если вам понравилась модель, купить&nbsp;блейзер мужской однобортный темно-синий Cadini можно в нашем магазине.&nbsp;</p> <p>&nbsp;</p> " ["characteristics"]=> string(442) "<ul> <li>Модель: блейзер;</li> <li>Фасон: приталенный;</li> <li>Цвет: синий;</li> <li>Узор: мелкий принт;</li> <li>Сезон: демисезонный;</li> <li>Бренд:&nbsp;Cadini (Кадини);</li> <li>Страна бренда: Италия.&nbsp;</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(15) " Блейзер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "13542" ["sku"]=> string(8) "82500 6R" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "9" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(42) "catalog/campaignss2019/2etazh/ao6b5020.jpg" ["manufacturer_id"]=> string(2) "75" ["manufacturer"]=> string(7) "Cadini " ["manufacturer_size_table"]=> string(682) "<table class="men"> <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>Cadini</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(10) "16600.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-09-14" ["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(2) "98" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-11-26 16:23:06" ["viewed"]=> string(3) "894" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14458]=> array(49) { ["product_id"]=> string(5) "14458" ["name"]=> string(53) "Серый однобортный пиджак Cadini" ["description"]=> string(931) "<p>Серый однобортный пиджак Cadini идеально подходит для создания безупречного элегантного образа.&nbsp;Отложной воротник и заостренные лацканы, на левом декоративная петля. Рукава втачные, длиной до запястья с открытой шлицей на 4 пуговицах. Широкие накладные карманы на уровне талии. Две шлицы, выточки по талии, средний шов спинки гарантируют хорошую посадку по фигуре.&nbsp;</p> <p>Купить пиджак серый однобортный пиджак Cadini Вы можете в нашем магазине, оформив заказ по телефону или через сайт.</p> " ["characteristics"]=> string(683) "<ul> <li>Модель: блейзер;</li> <li>Фасон: приталенный;</li> <li>Цвет: серый, черный;</li> <li>Узор: косая полоска;</li> <li>Состав верха: хлопок 47%, шерсть 33%, лен 20%;</li> <li>Подкладка: вискоза 100%;</li> <li>Состав: полиэстер 96%, эластен 4%;</li> <li>Сезон: демисезон;</li> <li>Бренд:&nbsp;Cadini (Кадини, Италия);</li> <li>Страна: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(13) "Пиджак " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14458" ["sku"]=> string(5) "J2001" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "8" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(35) "catalog/novinki/2etazh/ao6b0576.jpg" ["manufacturer_id"]=> string(2) "75" ["manufacturer"]=> string(7) "Cadini " ["manufacturer_size_table"]=> string(682) "<table class="men"> <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>Cadini</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(10) "19500.0000" ["special"]=> string(10) "11700.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-01" ["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(2) "97" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-11-26 16:23:29" ["viewed"]=> string(4) "1229" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14128]=> array(49) { ["product_id"]=> string(5) "14128" ["name"]=> string(46) "Синий блейзер Harmont & Blaine" ["description"]=> string(789) "<p>Стильный мужской пиджак от итальянского бренда Harmont &amp; Blaine. Однобортный блейзер с застежкой на две круглых пуговицы черного цвета. Есть 2 боковых&nbsp;накладных&nbsp;и внутренних&nbsp;потайных&nbsp;карманов, также есть нагрудный карман, отложной воротник. По бокам на рукавах несколько темных пуговиц в ряд.</p> <p>Понравился синий блейзер Harmont &amp; Blaine? Вы можете купить его на нашем сайте. DN8: мы знаем о моде все!</p> " ["characteristics"]=> string(590) "<ul> <li>Код товара:&nbsp;14128</li> <li>Артикул:&nbsp;HBV0A005060415 808</li> <li>Цвет: синий</li> <li>Рисунок: нет</li> <li>Сезон: осень-зима</li> <li>Материал: верх - шерсть 70%, полиэстер 15%, полиамид 15%; подкладка - полиэстер 100%&nbsp;</li> <li>Бренд: Harmont &amp; Blaine</li> <li>Страна бренда: Италия</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Блейзер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(109) "Блейзер, мужской, синий, Harmont & Blaine, с пуговицами, шерстяной" ["model"]=> string(5) "14128" ["sku"]=> string(18) "HBV0A005060415 808" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "7" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(57) "catalog/dn8/fotosessija/2020/oktjabr/2_etazh/img_1846.jpg" ["manufacturer_id"]=> string(2) "55" ["manufacturer"]=> string(18) "Harmont&Blaine" ["manufacturer_size_table"]=> string(1718) "<table class="men"> <tbody> <tr> <td>Верхняя одежда, костюм, пиджак, трикотаж, рубашки, брюки</td> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> </tr> </tbody> <tbody> <tr> </tr> <tr> <td>Рубашки</td> <td>Европа (EU)</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> <td>42</td> <td>43</td> <td>44</td> <td>45</td> <td>46</td> <td>47</td> <td>48</td> <td>49</td> <td>50</td> </tr> </tbody> <tbody> <tr> <td>Джинсы</td> <td>Европа (EU)</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> </tr> <tr> <td>Головные уборы</td> <td>one size</td> </tr> </tbody> <tbody> </tbody> </table> " ["price"]=> string(10) "18300.0000" ["special"]=> string(10) "10980.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-10-30" ["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(2) "91" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-30 16:49:16" ["date_modified"]=> string(19) "2021-11-30 14:44:16" ["viewed"]=> string(3) "303" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3896]=> array(49) { ["product_id"]=> string(4) "3896" ["name"]=> string(37) "Черный блейзер van Laack" ["description"]=> string(1023) "<p>Мужской блейзер, черный цвет, силуэт классический, приталенная модель, воротник с лацканами, аккуратная подкладка, изготовлен из чистой шерсти, накладные боковые карманы, есть нагрудный карман, который можно использовать для платка. На модели 177 см, размер 50.</p> <p>Как известно, шерсть хорошо сохраняет тепло, устойчива к загрязнениям и практически не мнется. Чтобы поддерживать вещь в хорошем состоянии, стоит придерживаться рекомендаций по уходу на этикетке.</p> <p>Купить черный блейзер van Laack в интернет-магазине dn8.ua по хорошей цене.</p> " ["characteristics"]=> string(408) "<ul> <li>Модель: мужской блейзер;</li> <li>Цвет: черный;</li> <li>Узор: нет;</li> <li>Состав: шерсть 100%;</li> <li>Сезон: осень, зима;</li> <li>Бренд: van Laack;</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(21) "Пиджак VanLaack" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Блейзер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "3896" ["sku"]=> string(10) "H00627 790" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "8" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(38) "data/1c/utp003702_catalog_820f8850.JPG" ["manufacturer_id"]=> string(3) "110" ["manufacturer"]=> string(9) "van Laack" ["manufacturer_size_table"]=> string(3523) "<div class="men"> <p>Мужские&nbsp;верхняя одежда, костюм, пиджак, трикотаж, брюки</p> <table class="men"> <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> </tr> <tr> <td>van Laack</td> <td>&nbsp;</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> <p>Мужские рубашки</p> <table class="men"> <tbody> <tr> <td>Международный (INT)</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>van Laack</td> <td>38-39</td> <td>40-41</td> <td>42-43</td> <td>44-45</td> <td>46-47</td> <td>48-49</td> <td>50</td> </tr> </tbody> </table> <p>Мужское нижнее белье&nbsp;</p> <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>боксеры</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> </div> <div class="women"> <p>Женские верхняя одежда, костюм, пиджак, трикотаж, блузы, брюки</p> <table class="women"> <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> </tr> <tr> <td>van Laack&nbsp;</td> <td>&nbsp;</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> </div> " ["price"]=> string(10) "16990.0000" ["special"]=> string(10) "10194.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-28" ["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(2) "90" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-11 16:59:20" ["date_modified"]=> string(19) "2021-11-25 17:02:06" ["viewed"]=> string(4) "1117" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [12187]=> array(49) { ["product_id"]=> string(5) "12187" ["name"]=> string(64) "Темно-серый клетчатый пиджак Carl Gross" ["description"]=> string(994) "<p>Однобортный пиджак от немецкого бренда Carl Gross для осенне-зимнего&nbsp;сезона.<br /> Подкладка выполнена из вискозы&nbsp;(51%) и ацетата (49%). Боковые карманы накладные, нагрудный &ndash; врезной, с листочкой.<br /> Модель в комфортном полуприталенном силуэте.<br /> Сшит из смесовой ткани, в составе которой входит полиэстер 83% и&nbsp;вискоза 17%.&nbsp;<br /> Застежка на 2 темные пуговицы кругллой формы.<br /> Классический пиджак можно сочетать&nbsp;как с брюками, так и джинсами.</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> " ["characteristics"]=> string(792) "<ul> <li>Код товара:&nbsp;12187</li> <li>Артикул:&nbsp;72 300N1 83</li> <li>Бренд: Carl Gross</li> <li>Страна: Германия</li> <li>Цвет: темно-серый</li> <li>Рисунок: клетка</li> <li>Сезон: осень-зима</li> <li>Материал лицевой стороны:&nbsp;полиэстер 83%,&nbsp;вискоза 17%</li> <li>Материал подкладки:&nbsp;вискоза 51%;&nbsp;ацетат 49%</li> <li>Застежка пиджака: две пуговицы</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(0) "" ["model"]=> string(5) "12187" ["sku"]=> string(11) "72 300N1 83" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "7" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(55) "data/1c/utp008958_catalog_foto_modeli_1412_ao6b6198.jpg" ["manufacturer_id"]=> string(2) "60" ["manufacturer"]=> string(10) "Carl Gross" ["manufacturer_size_table"]=> string(759) "<p>Внимание! Линия CG маломерит</p> <table class="men"> <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>Carl Gross</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(9) "8900.0000" ["special"]=> string(9) "5340.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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(2) "85" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-12-14 14:53:20" ["viewed"]=> string(4) "1372" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3863]=> array(49) { ["product_id"]=> string(4) "3863" ["name"]=> string(36) "Черный пиджак Carl Gross" ["description"]=> string(390) "<p>Силуэт - приталенный</p> <p>Особенности модели - накладные карманы, фактурная ткань</p> <p>Цвет - черный</p> <p>верх - шерсть 60%, хлопок&nbsp;40%; подкл.- ацетат 52%, вискоза 48%</p> <p>&nbsp;</p> " ["characteristics"]=> string(0) "" ["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(0) "" ["model"]=> string(4) "3863" ["sku"]=> string(11) "61-234N1 90" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "7" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(38) "data/1c/utp005174_catalog_820f8797.JPG" ["manufacturer_id"]=> string(2) "60" ["manufacturer"]=> string(10) "Carl Gross" ["manufacturer_size_table"]=> string(759) "<p>Внимание! Линия CG маломерит</p> <table class="men"> <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>Carl Gross</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(9) "8900.0000" ["special"]=> string(9) "5340.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-20 16:59:20" ["date_modified"]=> string(19) "2021-12-14 15:11:48" ["viewed"]=> string(4) "1506" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11305]=> array(49) { ["product_id"]=> string(5) "11305" ["name"]=> string(50) "Пиджак серого цвета Antony Morato" ["description"]=> string(750) "<p>Стильный пиджак для весенне-летнего сезона от итальянского бренда Antony Morato. Однобортный пиджак с застежкой на черные пуговицы круглой формы. Есть нагрудный и боковые карманы с отворотами и отложным воротником, ситуэт - приталенный.<br /> Понравился пиджак серого цвета Antony Morato? Вы можете заказать его на нашем сайте незамедлительно по весьма интересной цене. Удачных покупок в DN8!</p> <p>&nbsp;</p> " ["characteristics"]=> string(482) "<ul> <li>Код товара:&nbsp;11305</li> <li>Артикул:&nbsp;MMJA281FA9575</li> <li>Цвет: серый</li> <li>Рисунок: нет</li> <li>Сезон: весна-лето</li> <li>Материал: хлопок 58%, лен 42%</li> <li>Бренд:&nbsp;Antony Morato</li> <li>Страна бренда: Италия</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(26) "Пиджак Antony Morato" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Пиджак" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11305" ["sku"]=> string(13) "MMJA281FA9575" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "3" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(46) "data/1c/utp007703_catalog_loading_img_7222.jpg" ["manufacturer_id"]=> string(2) "44" ["manufacturer"]=> string(13) "Antony Morato" ["manufacturer_size_table"]=> string(762) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> <td>4XL</td> <td>5XL</td> </tr> <tr> <td>Antony Morato</td> <td>28-29</td> <td>30-31</td> <td>32-33</td> <td>34-35</td> <td>36-37</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> </tr> </tbody> </table> " ["price"]=> string(9) "7400.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-29" ["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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-20 16:59:20" ["date_modified"]=> string(19) "2021-08-05 13:03:00" ["viewed"]=> string(4) "1033" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14713]=> array(49) { ["product_id"]=> string(5) "14713" ["name"]=> string(47) "Блейзер мужской синий Cadini" ["description"]=> string(850) "<p>Вы еще не в блейзере? Тогда вам стоит непременно купить его прямо сейчас. Данная модель выполнена в приятном синем цвете.&nbsp;Подходит для создания формального делового образа. С отложным воротник и застежкой на 2 круглые пуговицы черного цвета, с боковыми карманами, которые фиксируются клапанами. Пуговицы в ряд на рукавах.&nbsp;Классический крой.&nbsp;<br /> Если вам понравилась модель, купить блейзер мужской синий Cadini можно в нашем магазине.&nbsp;</p> " ["characteristics"]=> string(480) "<ul> <li>Код товара:&nbsp;14713&nbsp;</li> <li>Артикул:&nbsp;K2020 CT12120Z</li> <li>Цвет: синий</li> <li>Рисунок: однотонный</li> <li>Сезон: весна-лето</li> <li>Материал: шерсть 100%</li> <li>Бренд: Cadini</li> <li>Страна бренда: Италия</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Блейзер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(158) "Блейзер, мужской, синий, Cadini, пиджак, стильный. модный, на каждый день, шерстяной, шерсть" ["model"]=> string(5) "14713" ["sku"]=> string(14) "K2020 CT12120Z" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "5" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2021/mart/muzhskaja/img_9505-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "75" ["manufacturer"]=> string(7) "Cadini " ["manufacturer_size_table"]=> string(682) "<table class="men"> <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>Cadini</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(10) "16900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-19" ["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-19 15:44:31" ["date_modified"]=> string(19) "2021-11-01 16:20:16" ["viewed"]=> string(3) "256" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14712]=> array(49) { ["product_id"]=> string(5) "14712" ["name"]=> string(41) "Темно-синий пиджак Cadini" ["description"]=> string(934) "<p>Темно-синий пиджак Cadini из мелкоузорчатого материала хорошо сидит по фигуре. Полу прилегающий силуэт. Воротник и длинные лацканы прямоугольной формы. Петля на левом лацкане.&nbsp; Модель застегивается на две пуговицы. Четыре пуговицы на манжете рукава. По бокам карманы с клапаном на уровне талии. Две шлицы. Непарный пиджак сочетает в себе простые линии, идеальные пропорции и изысканную эстетику.</p> <p>Если вас заинтересовала модель, приобрести темно-синий пиджак Cadini можно у нас в магазине.</p> " ["characteristics"]=> string(590) "<ul> <li>Модель: мужской однобортный пиджак;</li> <li>Фасон: приталенный;</li> <li>Расцветка: темно-синяя;</li> <li>Узор: мелкий принт;</li> <li>Материал: вискоза 52%, хлопок 48%;</li> <li>Сезон: весна-лето;</li> <li>Производство: Cadini (Кадини);</li> <li>Страна производства: Италия.&nbsp;</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(0) "" ["model"]=> string(5) "14712" ["sku"]=> string(14) "K2007 CT12120Z" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "8" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(48) "catalog/aproduct/folder-2/ao6b4893-1000x1500.jpg" ["manufacturer_id"]=> string(2) "75" ["manufacturer"]=> string(7) "Cadini " ["manufacturer_size_table"]=> string(682) "<table class="men"> <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>Cadini</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(10) "15900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-04-08" ["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-12-30 16:59:20" ["date_modified"]=> string(19) "2021-11-17 16:53:07" ["viewed"]=> string(4) "1259" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16580]=> array(49) { ["product_id"]=> string(5) "16580" ["name"]=> string(50) "Темно-синий блейзер Antony Morato" ["description"]=> string(1897) "<p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="background-color:white"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Особенности:</span></span></span></span></p> <ul> <li><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="background-color:white"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="font-family:Calibri,sans-serif"><span style="background-color:white"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Посадка SLIM-FIT</span></span></span></span></span></span></span></li> </ul> <p><span style="font-size:16px"><span style="background-color:white"><span style="font-family:&quot;Times New Roman&quot;,serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Однобортный пиджак с двумя пуговицами, выполненный в цветах, которые очень легко смешивать и сочетать. Благодаря посадке SLIM-FIT и изысканным деталям швов, эта <strong>одежда гармонично впишется в гардероб мужчины</strong> ведущего активный образ жизни. </span></span></span></span></span></p> " ["characteristics"]=> string(801) "<ul> <li><span style="font-size:14px">Код товара: 16580</span></li> <li><span style="font-size:14px">Артикул: MMJA00417FA400060</span></li> <li><span style="font-size:14px">Бренд: Antony Morato</span></li> <li><span style="font-size:14px">Страна: Италия</span></li> <li><span style="font-size:14px">Модель: пиджак</span></li> <li><span style="font-size:14px">Цвет: синий</span></li> <li><span style="font-size:14px">Материал: 45% лен, 55% хлопок</span></li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Блейзер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(122) "Пиджак, мужской, темно-синий, синий, однобортный, Antony Morato, брендовый" ["model"]=> string(5) "16580" ["sku"]=> string(17) "MMJA00417FA400060" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "5" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(65) "catalog/dn8/fotosessija/2020/ijul/1etazh_muzhskoe/img_3981-ds.jpg" ["manufacturer_id"]=> string(2) "44" ["manufacturer"]=> string(13) "Antony Morato" ["manufacturer_size_table"]=> string(762) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> <td>4XL</td> <td>5XL</td> </tr> <tr> <td>Antony Morato</td> <td>28-29</td> <td>30-31</td> <td>32-33</td> <td>34-35</td> <td>36-37</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> </tr> </tbody> </table> " ["price"]=> string(9) "7400.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-14" ["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-12-30 16:59:20" ["date_modified"]=> string(19) "2021-11-01 16:15:02" ["viewed"]=> string(3) "577" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11376]=> array(49) { ["product_id"]=> string(5) "11376" ["name"]=> string(49) "Светло-синий блейзер Carl Gross" ["description"]=> string(365) "<p>Силуэт- приталенный</p> <p>На модели (177см.) 42</p> <p>Боковые карманы</p> <p>Цвет-светло синий</p> <p>верх - лен 60%, шерсть 40%; подкл.- вискоза 51%, ацетат 49%%</p> <p>&nbsp;</p> " ["characteristics"]=> string(0) "" ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(17) "Пиджак C.G." ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Блейзер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11376" ["sku"]=> string(11) "71-361N1 61" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "5" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(63) "data/1c/utp007938_catalog_loading_2_myjskoe_img_7625_kopiya.jpg" ["manufacturer_id"]=> string(2) "60" ["manufacturer"]=> string(10) "Carl Gross" ["manufacturer_size_table"]=> string(759) "<p>Внимание! Линия CG маломерит</p> <table class="men"> <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>Carl Gross</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(10) "10500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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-12-30 16:59:20" ["date_modified"]=> string(19) "2021-12-14 15:29:57" ["viewed"]=> string(4) "1038" ["categories"]=> array(2) { [0]=> string(3) "437" [1]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15263]=> array(49) { ["product_id"]=> string(5) "15263" ["name"]=> string(52) "Полосатый пиджак Harmont & Blaine" ["description"]=> string(1112) "<p>Полосатый пиджак мужской однобортный Harmont &amp; Blaine в элегантном стиле подходит для как формальных мероприятий, так и для встреч с друзьями. Отложной воротник и длинные лацканы прямоугольной формы. Металлический логотип бренда. Рукав назначается ровно на линии плеча. Длина до косточки большого пальца, декорирован 4 пуговицами. Выточки по фигуре. Прорезной карман на груди слева Удобные карманы по бокам на уровне талии. Сзади 2 шлицы. Застегивается на 2 пуговицы.</p> <p>Если вас заинтересовала модель, приобрести пиджак полосатый мужской&nbsp;Harmont &amp; Blaine у нас через сайт или по телефону.</p> " ["characteristics"]=> string(685) "<ul> <li>Модель: летний мужской однобортный пиджак;</li> <li>Фасон: непарный мужской пиджак свободного кроя;</li> <li>Цвет: белый, голубой;</li> <li>Расцветка: тонкая вертикальная полоска;</li> <li>Состав: нейлон 29%, полиэстер 33%, хлопок 38%;</li> <li>Сезонность: весна-лето;</li> <li>Производитель: Harmont &amp; Blaine (Хармонт энд Блейн, Италия).</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(0) "" ["model"]=> string(5) "15263" ["sku"]=> string(12) "V0B022052897" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "5" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(51) "catalog/fotosessijasmodeljami_ijun2019/ao6b0820.jpg" ["manufacturer_id"]=> string(2) "55" ["manufacturer"]=> string(18) "Harmont&Blaine" ["manufacturer_size_table"]=> string(1718) "<table class="men"> <tbody> <tr> <td>Верхняя одежда, костюм, пиджак, трикотаж, рубашки, брюки</td> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> </tr> </tbody> <tbody> <tr> </tr> <tr> <td>Рубашки</td> <td>Европа (EU)</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> <td>42</td> <td>43</td> <td>44</td> <td>45</td> <td>46</td> <td>47</td> <td>48</td> <td>49</td> <td>50</td> </tr> </tbody> <tbody> <tr> <td>Джинсы</td> <td>Европа (EU)</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> </tr> <tr> <td>Головные уборы</td> <td>one size</td> </tr> </tbody> <tbody> </tbody> </table> " ["price"]=> string(10) "11980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-08" ["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-12-30 16:59:20" ["date_modified"]=> string(19) "2021-12-02 10:35:54" ["viewed"]=> string(3) "868" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(2053) "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 = '438' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }

Блейзер темно-синий Cadini

16 600 грн.
Блейзер мужской однобортный темно-синий Cadini в элегантном стиле из благородной узорчатой ткани. По..
-40%
Серый однобортный пиджак Cadini

Серый однобортный пиджак Cadini

19 500 грн.

11 700 грн.

Серый однобортный пиджак Cadini идеально подходит для создания безупречного элегантного образа. ..
-40%
Синий блейзер Harmont & Blaine

Синий блейзер Harmont & Blaine

18 300 грн.

10 980 грн.

Стильный мужской пиджак от итальянского бренда Harmont & Blaine. Однобортный блейзер с застежкой..
-40%
Черный блейзер van Laack

Черный блейзер van Laack

16 990 грн.

10 194 грн.

Мужской блейзер, черный цвет, силуэт классический, приталенная модель, воротник с лацканами, аккурат..
-40%
Темно-серый клетчатый пиджак Carl Gross

Темно-серый клетчатый пиджак Carl Gross

8 900 грн.

5 340 грн.

Однобортный пиджак от немецкого бренда Carl Gross для осенне-зимнего сезона. Подкладка выполне..
-40%
Черный пиджак Carl Gross

Черный пиджак Carl Gross

8 900 грн.

5 340 грн.

Силуэт - приталенный Особенности модели - накладные карманы, фактурная ткань Цвет - черный ..

Пиджак серого цвета Antony Morato

7 400 грн.
Стильный пиджак для весенне-летнего сезона от итальянского бренда Antony Morato. Однобортный пиджак ..

Блейзер мужской синий Cadini

16 900 грн.
Вы еще не в блейзере? Тогда вам стоит непременно купить его прямо сейчас. Данная модель выполнена в ..

Темно-синий пиджак Cadini

15 900 грн.
Темно-синий пиджак Cadini из мелкоузорчатого материала хорошо сидит по фигуре. Полу прилегающий силу..

Темно-синий блейзер Antony Morato

7 400 грн.
Особенности: Посадка SLIM-FIT Однобортный пиджак с двумя пуговицами, выполненный в цветах..

Светло-синий блейзер Carl Gross

10 500 грн.
Силуэт- приталенный На модели (177см.) 42 Боковые карманы Цвет-светло синий верх - лен 6..

Полосатый пиджак Harmont & Blaine

11 980 грн.
Полосатый пиджак мужской однобортный Harmont & Blaine в элегантном стиле подходит для как формал..
Показано с 1 по 12 из 14 (всего 2 страниц)