Мужские шарфы

array(12) { [11014]=> array(49) { ["product_id"]=> string(5) "11014" ["name"]=> string(29) "Шарф шелковый PNA" ["description"]=> string(1109) "<p>Благодаря многолетнему опыту работы в текстильной промышленности, компания PNA fashion details точно знает, каким критериям должна отвечать ткань, используемая в производстве шарфов. Основа создания каждого изделия &ndash; внимание к деталям. Качественный стильный шелковый шарф отлично дополнит выбранный классический или casual образ. Купить шарф шелковый PNA в DN8 SHOPPING SPACE в удобное для себя время.</p> <ul> <li>Необработанный край;</li> <li>длина 176 см, ширина 29 см;</li> <li>двухсторонний: с одной стороны черный с серыми краями и полоской, с другой серый с черными краями и полоской.</li> </ul> " ["characteristics"]=> string(389) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: серый, черный;</li> <li>Материал: шелк 100%;</li> <li>Сезонность: осень, зима, весна;</li> <li>Бренд: PNA;</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(113) "шарф, серый, с бахромой, черный, демисезонный, базовый, удобный" ["model"]=> string(5) "11014" ["sku"]=> string(13) "991031066-129" ["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(68) "catalog/dn8/fotosessija/2020/nojabr/predmetka/img_6247-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "69" ["manufacturer"]=> string(19) "PNA fashion details" ["manufacturer_size_table"]=> string(147) "<p><span style="font-family:&quot;Times New Roman&quot;; font-size:7pt">&nbsp;&nbsp;</span></p> " ["price"]=> string(9) "1700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-11-25" ["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-11-25 10:44:06" ["date_modified"]=> string(19) "2021-06-25 15:40:07" ["viewed"]=> string(3) "214" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } [11006]=> array(49) { ["product_id"]=> string(5) "11006" ["name"]=> string(34) "Шарф темно-серый PNA" ["description"]=> string(1117) "<p>Шелковый шарф &ndash; прекрасное решение для мужчины, который привык к наполнению гардероба стильными, необходимыми и, главное качественными вещами. Благородная шелковая ткань имеет ряд преимуществ: натуральная, приятная на ощупь, внешне привлекательная, объемная, мягкая. А бахрома придаст образу легкости. Удачное дополнение в межсезонье и холодное время года.&nbsp;Купить&nbsp;шарф темно-серый PNA двысторонний онлайн dn8.ua.</p> <ul> <li>Необработанный край;</li> <li>длина 176 см, ширина 29 см;</li> <li>двухсторонний: с одной стороны угольно-серый, с другой серый в черную клетку.</li> </ul> " ["characteristics"]=> string(389) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: серый, черный;</li> <li>Материал: шелк 100%;</li> <li>Сезонность: осень, зима, весна;</li> <li>Бренд: PNA;</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(93) "шарф, серый, с бахромой, двусторонний, демисезонный" ["model"]=> string(5) "11006" ["sku"]=> string(13) "991031070-629" ["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(68) "catalog/dn8/fotosessija/2020/nojabr/predmetka/img_6248-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "69" ["manufacturer"]=> string(19) "PNA fashion details" ["manufacturer_size_table"]=> string(147) "<p><span style="font-family:&quot;Times New Roman&quot;; font-size:7pt">&nbsp;&nbsp;</span></p> " ["price"]=> string(9) "1700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-11-25" ["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-11-25 10:44:06" ["date_modified"]=> string(19) "2021-06-25 15:45:03" ["viewed"]=> string(3) "166" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } [11004]=> array(49) { ["product_id"]=> string(5) "11004" ["name"]=> string(23) "Шарф серый PNA" ["description"]=> string(1185) "<p>Шелк давно покорил сердца представительниц прекрасного пола. Добрался он и до сильных мира сего &ndash; мужчин. Шелковый шарф подчеркнет лаконичность выбранного стиля и некую строгость. А также подарит своему обладателю легкость, мягкость и прелесть прикосновения.</p> <p>Шарф &ndash; это еще и хорошая идея подарка мужчине: коллеге, другу или знакомому. Цены на шарфы мужские варьируются, поэтому выбрать наиболее подходящий вариант просто.</p> <ul> <li>Необработанный край;</li> <li>длина 176 см, ширина 29 см;</li> <li>двухсторонний: с одной стороны однотонный светло-серый, с другой &ndash; серый в серую клетку.</li> </ul> " ["characteristics"]=> string(479) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: серый, темно-серый;</li> <li>Рисунок: однотонный и клеточка;</li> <li>Материал: шелк 100%;</li> <li>Сезонность: осень, зима, весна;</li> <li>Бренд: PNA;</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(93) "шарф, шелковый, серый, с бахромой, клетка, клетчатый" ["model"]=> string(5) "11004" ["sku"]=> string(13) "991031069-583" ["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(68) "catalog/dn8/fotosessija/2020/nojabr/predmetka/img_6232-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "69" ["manufacturer"]=> string(19) "PNA fashion details" ["manufacturer_size_table"]=> string(147) "<p><span style="font-family:&quot;Times New Roman&quot;; font-size:7pt">&nbsp;&nbsp;</span></p> " ["price"]=> string(9) "1700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-11-25" ["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-11-25 10:44:06" ["date_modified"]=> string(19) "2021-06-25 15:49:26" ["viewed"]=> string(3) "137" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } [14134]=> array(49) { ["product_id"]=> string(5) "14134" ["name"]=> string(40) "Шарф серый Harmont & Blaine" ["description"]=> string(1042) "<p>Купить шарф серый Harmont &amp; Blaine &ndash; дополнительная возможность подчеркнуть свой стиль, индивидуальность и даже создать особое настроение.</p> <p>Представленный вариант хорошо подойдет для деловой встречи или свидания. Гармонично сочетается с одеждой в разных стилях. Преподносит согревающий эффект.</p> <p>Классический дизайн дополнен бахромой. Шарф придает завершающий штрих выбранному образу. Обратите внимание: для такого изделия рекомендована ручная стирка.</p> <ul> <li>край - бахрома</li> <li>длина 166 см, ширина 33 см</li> </ul> " ["characteristics"]=> string(446) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: серый:</li> <li>Рисунок: без рисунка;</li> <li>Материал: шерсть 100%;</li> <li>Сезонность: осень, зима;</li> <li>Бренд: Harmont &amp; Blaine;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(40) "Шарф серый Harmont & Blaine" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(104) "шарф, шерстяной, серый, с бахромой, однотонный, без принта" ["model"]=> string(5) "14134" ["sku"]=> string(18) "HBS0A017030516 921" ["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(68) "catalog/dn8/fotosessija/2020/nojabr/predmetka/img_6244-ds-1500px.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(9) "4500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-11-25" ["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-11-25 10:44:06" ["date_modified"]=> string(19) "2021-06-25 15:51:22" ["viewed"]=> string(3) "152" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } [16008]=> array(49) { ["product_id"]=> string(5) "16008" ["name"]=> string(48) "Шарф полосатый Harmont & Blaine" ["description"]=> string(820) "<p>Бескомпромиссная игра цветов и тканей. Именно так стоит охарактеризовать, а впоследствии и заказать шарф полосатый Harmont &amp; Blaine. Яркий, стильный, теплый, привлекающий внимание!</p> <p>Обратите внимание на декор: бахрома придает изделию расслабленности.</p> <p>Роскошный осенне-зимний вариант для любителей выглядеть модно и привлекательно.</p> <ul> <li>Необработанный край</li> <li>длина 173 см, ширина 41 см</li> </ul> " ["characteristics"]=> string(451) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: разноцветный;</li> <li>Узор: полосатый;</li> <li>Материал: шерсть 100%;</li> <li>Сезонность: осень, зима;</li> <li>Бренд: Harmont &amp; Blaine;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(48) "Шарф полосатый Harmont & Blaine" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(94) "шарф, шерстяной, полоска, коричневый, теплый, зимний" ["model"]=> string(5) "16008" ["sku"]=> string(14) "HBS0C053082679" ["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(68) "catalog/dn8/fotosessija/2020/nojabr/predmetka/img_6240-ds-1500px.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(9) "4600.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-11-25" ["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-11-25 10:44:06" ["date_modified"]=> string(19) "2021-06-25 15:47:52" ["viewed"]=> string(3) "153" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } [11012]=> array(49) { ["product_id"]=> string(5) "11012" ["name"]=> string(27) "Шарф мужской PNA" ["description"]=> string(1135) "<p>Черно-серый двусторонний шарф, изготовленный из натурального шелка. Осторожно: при первом соприкосновении может возникнуть масса приятных впечатлений от соприкосновения с изделием. Он чрезвычайно мягкий и внешне привлекательный.&nbsp;</p> <p>Для изготовления послужил натуральный материал, а это, в свою очередь, говорит о его хорошей воздухопроницаемости с одновременным обеспечением тепла и уюта.&nbsp;&nbsp;&nbsp;</p> <ul> <li>Необработанный край;</li> <li>длина 176 см, ширина 29 см;</li> <li>двухсторонний: с одной стороны угольно-серый в полоску, с другой светло-серый, в клетку.</li> </ul> " ["characteristics"]=> string(444) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: черный, серый;</li> <li>Узор: полоска, клеточка;</li> <li>Материал: шелк 100%;</li> <li>Сезонность: осень, зима;</li> <li>Бренд: PNA;</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(133) "шарф, серый, с бахромой, двусторонний, демисезонный, клетка, черный, серый" ["model"]=> string(5) "11012" ["sku"]=> string(13) "991031065-429" ["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(68) "catalog/dn8/fotosessija/2020/nojabr/predmetka/img_6234-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "69" ["manufacturer"]=> string(19) "PNA fashion details" ["manufacturer_size_table"]=> string(147) "<p><span style="font-family:&quot;Times New Roman&quot;; font-size:7pt">&nbsp;&nbsp;</span></p> " ["price"]=> string(9) "1700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-11-25" ["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-11-25 10:44:06" ["date_modified"]=> string(19) "2021-06-25 15:42:45" ["viewed"]=> string(3) "159" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } [16007]=> array(49) { ["product_id"]=> string(5) "16007" ["name"]=> string(48) "Шарф клетчатый Harmont & Blaine" ["description"]=> string(1071) "<p>Удивительно, сколько мягкий и симпатичный шарф может подарить тепла и уюта. Так и в случае с аксессуаром от итальянского бренда Harmont &amp; Blaine. Он однозначно достоин вашего внимания, ведь шерсть хорошо согревает в холодное время года.&nbsp;</p> <p>Купить шарф клетчатый Harmont &amp; Blaine означает обеспечить себе защиту от холодного ветра осенью или зимой, насладиться легкостью и приятностью на ощупь. С ним можно стильно завершить кэжуальный образ, сформировав&nbsp;элегантный узел.&nbsp;</p> <ul> <li>Необработанный край</li> <li>длина 165 см, ширина 32 см</li> </ul> " ["characteristics"]=> string(443) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: разные цвета;</li> <li>Узор: клетка</li> <li>Материал: шерсть 100%;</li> <li>Сезонность: осень, зима;</li> <li>Бренд: Harmont &amp; Blaine;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(48) "Шарф клетчатый Harmont & Blaine" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(72) "шарф, шерстяной, полоска, теплый, зимний" ["model"]=> string(5) "16007" ["sku"]=> string(14) "HBS0C050082665" ["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(68) "catalog/dn8/fotosessija/2020/nojabr/predmetka/img_6242-ds-1500px.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(9) "4980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-11-25" ["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-11-25 10:44:06" ["date_modified"]=> string(19) "2021-06-25 15:54:18" ["viewed"]=> string(3) "158" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } [11010]=> array(49) { ["product_id"]=> string(5) "11010" ["name"]=> string(37) "Шарф двусторонний PNA" ["description"]=> string(1442) "<p>Купить мужской брендовый шарф &ndash; запрос в Интернете, который в разы возрастает с наступлением прохладных дней. Такой аксессуар помогает уберечься от ветра и холода, хорошо смотрится с куртками и зимними пальто.</p> <p>Универсальное качество шарфа &ndash; он двухсторонний, поэтому как его ни надень, будет красиво.</p> <p>Шелк &ndash; натуральный и потрясающе приятный к телу материал. А знаете ли вы, что он имеет еще и пристойный согревающий эффект? Да, он теплый и готов дарить своему обладателю максимум уюта. А еще стильный шарф &ndash; хороший завершающий штрих в образе.</p> <ul> <li>Необработанный край;</li> <li>длина 176 см, ширина 29 см;</li> <li>двухсторонний: с одной стороны светло-серый в полоску, с другой &ndash; бежевый, в серую клетку.</li> </ul> " ["characteristics"]=> string(425) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: серый;</li> <li>Узор: клетка, полоска</li> <li>Материал: шелк 100%;</li> <li>Сезонность: осень, зима;</li> <li>Бренд: PNA;</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(93) "шарф, серый, с бахромой, двусторонний, демисезонный" ["model"]=> string(5) "11010" ["sku"]=> string(13) "991031065-483" ["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(68) "catalog/dn8/fotosessija/2020/nojabr/predmetka/img_6236-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "69" ["manufacturer"]=> string(19) "PNA fashion details" ["manufacturer_size_table"]=> string(147) "<p><span style="font-family:&quot;Times New Roman&quot;; font-size:7pt">&nbsp;&nbsp;</span></p> " ["price"]=> string(9) "1700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-11-25" ["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-11-25 10:44:06" ["date_modified"]=> string(19) "2021-06-25 15:55:41" ["viewed"]=> string(3) "138" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } [17355]=> array(49) { ["product_id"]=> string(5) "17355" ["name"]=> string(47) "Шарф в полоску Harmont & Blaine" ["description"]=> string(1005) "<p>Только посмотрите на эти удивительные цвета, мягкие и одновременно строгие. Как говорится &ndash; &laquo;расцветка, то, что любишь&raquo;.</p> <p>Как можно описать представленный вашему вниманию аксессуар? Яркий, стильный, привлекает внимание и, главное &ndash; теплый и уютный! И зима кажется уже и не такой холодной.</p> <ul> <li>Необработанный край</li> <li>длина 183 см, ширина 26 см</li> </ul> <p>А как можно купить шарф в полоску Harmont &amp; Blaine? Просто и быстро. Можно заказать обратный звонок или оставить заявку на сайте.</p> " ["characteristics"]=> string(478) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: разные цвета;</li> <li>Узор: полосы</li> <li>Материал: шерсть 43%, акрил 43%, вискоза 14%;</li> <li>Сезонность: осень, зима;</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(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(94) "шарф, шерстяной, полоска, коричневый, теплый, зимний" ["model"]=> string(5) "17355" ["sku"]=> string(12) "S0E078082708" ["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(68) "catalog/dn8/fotosessija/2020/nojabr/predmetka/img_6241-ds-1500px.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(9) "4980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-11-25" ["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-11-25 10:44:06" ["date_modified"]=> string(19) "2021-06-25 15:57:10" ["viewed"]=> string(3) "158" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } [12242]=> array(49) { ["product_id"]=> string(5) "12242" ["name"]=> string(48) "Шарф мужской серый Antony Morato" ["description"]=> string(1008) "<p>Шарф изготовлен из мягкой пряжи. Поэтому полюбить его будет просто. А в &laquo;благодарность&raquo; он согреет своего обладателя в холодное время года. Среди преимуществ: вязаный, &laquo;дышащий&raquo; материал, практичный цвет, удобство надевания, легкость в ношении и уходе.</p> <p>Шарф добавит выбранному образу оригинальности.</p> <p>При уходе желательна ручная стирка, чтобы изделие не растянулось и сохранило привлекательный вид.</p> <p>Купить шарф мужской серый Antony Morato можно в интернет-магазине dn8.ua по оптимальной цене.</p> " ["characteristics"]=> string(439) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: серый;</li> <li>Узор: милитари;</li> <li>Материал: акрил 70%, шерсть 30%;</li> <li>Сезонность: осень, зима;</li> <li>Бренд: Antony Morato;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "12242" ["sku"]=> string(19) "MMSC243AF04017053 D" ["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(62) "data/1c/utp008979_catalog_predmetka_3011_mmsc00243_9000_2_.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) "1600.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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:36:49" ["date_modified"]=> string(19) "2021-06-25 15:58:32" ["viewed"]=> string(3) "712" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } [12401]=> array(49) { ["product_id"]=> string(5) "12401" ["name"]=> string(38) "Шарф мужской Shine Original" ["description"]=> string(645) "<p>Секрет модного лука в деталях. Согласны? Вот и шарф от молодежного бренда Shine Original &ndash; эффектный завершающий штрих выбранного образа.</p> <p>Он имеет практичный неброский цвет, оптимальный размер, дарит тепло и дополнительный уют. И цена приятная.</p> <p>Купить шарф мужской Shine Original в интернет-магазине dn8.ua можно в удобное время.</p> " ["characteristics"]=> string(416) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: серый;</li> <li>Узор: без узора</li> <li>Материал: акрил;</li> <li>Сезонность: осень, зима;</li> <li>Бренд: Shine Original;</li> <li>Страна бренда: Дания.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "12401" ["sku"]=> string(17) "2-97063 black mel" ["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(53) "data/1c/utp009169_catalog_predmetka_3011_ao6b0091.jpg" ["manufacturer_id"]=> string(2) "51" ["manufacturer"]=> string(14) "Shine Original" ["manufacturer_size_table"]=> string(1999) "<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>Shine Original</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Shine Original (джинсы)</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Аксессуары&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>примечание</td> </tr> <tr> <td>Shine original (ремни)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(8) "600.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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:36:49" ["date_modified"]=> string(19) "2021-06-25 15:59:58" ["viewed"]=> string(3) "924" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } [12245]=> array(49) { ["product_id"]=> string(5) "12245" ["name"]=> string(37) "Шарф мужской Antony Morato" ["description"]=> string(1064) "<p>Двусторонний шарф для осенне-зимнего периода. Изготовлен из современного материала с рядом позитивных характеристик.</p> <p>Среди преимуществ акрила, из которого изготовлен шарф, следующие: хорошо сохраняет форму; не &laquo;кусается&raquo;; легко поддается уходу; имеет достаточно большой срок службы; мягкий и приятный к телу; практичный благодаря двустороннему &laquo;исполнению&raquo;.</p> <p>Купить шарф мужской Antony Morato в интернет-магазине DN8 легко: набирайте указанный на сайте телефон. Наш менеджер поможет оформить заказ и расскажет об условиях доставки.</p> " ["characteristics"]=> string(432) "<ul> <li>Модель: мужской шарф;</li> <li>Цвет: серый, синий;</li> <li>Узор: полоска;</li> <li>Материал: акрил 100%;</li> <li>Сезонность: осень, зима;</li> <li>Бренд: Antony Morato;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Шарф" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(161) "Шарф, мужской, Antony Morato, зимний, осенний, демисезонный, аксессуар, заказать, легкий, теплый" ["model"]=> string(5) "12245" ["sku"]=> string(13) "MMSC244AF0401" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(57) "data/1c/utp008921_catalog_predmetka_3011_mmsc00244_3_.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) "1700.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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:36:49" ["date_modified"]=> string(19) "2021-06-29 09:10:23" ["viewed"]=> string(3) "823" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "310" } [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 = '310' 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" } }