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

array(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(2) "11" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 10:32:01" ["viewed"]=> string(3) "700" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [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 = '437' 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" } [15327]=> array(49) { ["product_id"]=> string(5) "15327" ["name"]=> string(44) "Бордовый пиджак Pal Zileri Lab" ["description"]=> string(1109) "<p>Бордовый пиджак Pal Zileri Lab из фактурной жатой ткани в мелкую клетку. Отложной воротник и длинные лацканы прямоугольной формы. Декоративная петля, нагрудный карман с листочкой. Рукав начинается точно по плечу, декорирован 4 пуговицами. Длина до косточки большого пальца. Застегивается на 2 пуговицы. Сзади 2 шлицы. Выточки по фигуре, полу приталенный фасон. Широкие карманы на уровне талии.&nbsp;</p> <ul style="list-style-type:disc"> </ul> <p>Если вам понравилась модель, приобрести пиджак мужской однобортный бордового цвета Pal Zileri Lab вы сможете в нашем магазине. Удачных покупок!</p> <p>&nbsp;</p> " ["characteristics"]=> string(643) "<ul style="list-style-type:disc"> <li>Модель: непарный мужской пиджак;</li> <li>Фасон: однобортный мужской пиджак на 2 пуговицы;</li> <li>Цвет: бордовый;</li> <li>Узор: мелкая клетка;</li> <li>Состав: шерсть 54%, полиэстер 45%, эластан 1%;</li> <li>Сезонность: весна-лето;</li> <li>Бренд:Pal Zileri;</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) "15327" ["sku"]=> string(15) "OP2I03S-2 58353" ["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(51) "catalog/fotosessijasmodeljami_ijun2019/ao6b1167.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<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>Pal Zileri Lab</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) "15800.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(2) "10" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 10:32:54" ["viewed"]=> string(3) "565" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [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 = '437' 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" } [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"]=> string(9) "5180.0000" ["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) "9" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 10:35:10" ["viewed"]=> string(3) "413" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [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 = '437' 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" } [13543]=> array(49) { ["product_id"]=> string(5) "13543" ["name"]=> string(37) "Бордовый пиджак Cadini " ["description"]=> string(0) "" ["characteristics"]=> string(64) "<p>Шерсть 40%, лен 30 %, шелк 30%</p> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(35) "Пиджак мужской Cadini " ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Пиджак" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "13543" ["sku"]=> string(12) "23000 305 6L" ["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/muzhskaja/img_9499-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) "15990.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(1) "8" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 10:36:05" ["viewed"]=> string(3) "896" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [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 = '437' 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" } [14713]=> array(49) { ["product_id"]=> string(5) "14713" ["name"]=> string(47) "Блейзер мужской синий Cadini" ["description"]=> string(0) "" ["characteristics"]=> string(38) "<p>шерсть 100%</p> " ["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) "0" ["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) "7" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-19 15:44:31" ["date_modified"]=> string(19) "2021-07-12 10:36:44" ["viewed"]=> string(3) "111" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [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 = '437' 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" } [12187]=> array(49) { ["product_id"]=> string(5) "12187" ["name"]=> string(64) "Темно-серый клетчатый пиджак Carl Gross" ["description"]=> string(284) "<p>Верх:</p> <p>&bull; полиэстер 83%;</p> <p>&bull; вискоза 17%</p> <p>Подкладка:</p> <p>&bull; вискоза 51%;</p> <p>&bull; ацетат 49%</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(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) "0" ["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"]=> 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) "6" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-07-12 10:37:25" ["viewed"]=> string(4) "1211" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [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 = '437' 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" } [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) "0" ["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(1) "5" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 10:38:10" ["viewed"]=> string(3) "787" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [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 = '437' 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" } [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(689) "<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"]=> NULL ["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(1) "4" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-07-12 10:39:22" ["viewed"]=> string(4) "1098" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [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 = '437' 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" } [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) "0" ["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) "3" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 10:40:14" ["viewed"]=> string(4) "1098" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [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 = '437' 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" } [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"]=> NULL ["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(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-30 16:49:16" ["date_modified"]=> string(19) "2021-08-16 14:39:14" ["viewed"]=> string(3) "190" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [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 = '437' 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" } [15262]=> array(49) { ["product_id"]=> string(5) "15262" ["name"]=> string(61) "Пиджак голубого цвета Harmont & Blaine" ["description"]=> string(903) "<p>Пиджак мужской однобортный голубого цвета Harmont &amp; Blaine на 2 пуговицы. Отложной воротник и длинные широкие лацканы. Декоративный металлический элемент с символикой бренда.&nbsp; Прорезной нагрудный карман с косой листочкой. Широкие накладные карманы на уровне талии. Сзади 2 шлицы.</p> <p>Если вас заинтересовала модель, приобрести&nbsp;пиджак мужской однобортный голубого цвета Harmont &amp; Blaine вы можете в нашем магазине, сделав заказ удобным для вас способом. Удачных покупок!</p> " ["characteristics"]=> string(732) "<ul style="list-style-type:disc"> <li>Модель: мужской летний непарный пиджак;</li> <li>Фасон: мужской однобортный пиджак с 2 шлицами;</li> <li>Цвет: голубой;</li> <li>Узор: нет;</li> <li>Состав верха: лен 100%;</li> <li>Подкладка: полиэстер 100%;</li> <li>Сезонность: весна-лето-осень;</li> <li>Бренд:&nbsp;Harmont &amp; Blaine (Хармонт энд Блейн);</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) "15262" ["sku"]=> string(12) "V0B020052768" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(51) "catalog/fotosessijasmodeljami_ijun2019/ao6b0913.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) "14980.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(2) "14" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 10:45:08" ["viewed"]=> string(3) "850" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "316" [3]=> string(3) "437" } [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 = '437' 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" } [16839]=> array(49) { ["product_id"]=> string(5) "16839" ["name"]=> string(41) "Блейзер в клетку Carl Gross" ["description"]=> string(3055) "<p><span style="font-family:&quot;Century Gothic&quot;,sans-serif; font-size:16px"><span style="color:black">Однобортный блейзер Carl</span></span><span style="font-family:Calibri,sans-serif; font-size:16px"> </span><span style="font-family:&quot;Century Gothic&quot;,sans-serif; font-size:16px"><span style="color:black">Gross для теплого сезона.</span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Подкладка полная, две шлицы. Боковые карманы врезные, с клапаном, нагрудный &ndash; с листочкой.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Модель <strong>в комфортном полуприталенном силуэте</strong>.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Сшит из облегченной шерстяной ткани произведенной Filli</span></span> <span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Cerruti 1881.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Застежка на роговые пуговицы.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Классический голубой цвет и неформальная клетка позволяют комбинировать блейзер как в классическом, так и в спортивном стилях.</span></span></span></span></p> " ["characteristics"]=> string(843) "<ul> <li>Код товара: 16839</li> <li>Артикул: 01.149S3-61</li> <li>Бренд: Carl Gross</li> <li>Страна: Германия</li> <li>Цвет: голубой</li> <li>Рисунок: клетка</li> <li>Сезон: весна-лето</li> <li>Материал лицевой стороны: шерсть 100%</li> <li>Материал подкладки: вискоза 100%</li> <li>Застежка пиджака: на две пуговицы</li> <li>Модель: Tailor Fit</li> <li>Параметры модели:&nbsp;102-84-99, рост 185 см&nbsp;</li> <li>На модели надет: 50</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(118) "Пиджак, мужской, голубой, с узором, клеточка, Carl Gross, классический " ["model"]=> string(5) "16839" ["sku"]=> string(11) "01.149S3-61" ["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(66) "catalog/dn8/fotosessija/2020/ijul/2_etazh_muzhskoe/img_4687-ds.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) "15500.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(2) "13" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 10:45:42" ["viewed"]=> string(3) "526" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "316" [3]=> string(3) "437" } [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 = '437' 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" } }