Hamaki-Ho

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

Показывать:

array(12) { [10634]=> array(49) { ["product_id"]=> string(5) "10634" ["name"]=> string(82) "Бушлат мужской двубортный синего цвета Hamaki-Ho" ["description"]=> string(1022) "<p>Если вы отдаете предпочтение неброским сдержанным вещам, но при этом, отвечающим осенне-весенним &laquo;запросам&raquo;, как то обеспечение тепла, тогда пальто от Hamaki-ho прекрасно пополнит гардероб.</p> <p>Шерстяное пальто для мужчин, модель бушлат, двубортная, воротник с лацканами, сзади шлица, застежка на пуговицы, удобные карманы, которые помогут при необходимости согреть руки в прохладную погоду. Симпатичная цветовая гамма.</p> <p>Заказать бушлат мужской двубортный синего цвета Hamaki-Ho по хорошей цене можно в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(500) "<ul> <li>Модель: мужской бушлат;</li> <li>Цвет: черный, синий;</li> <li>Узор: клетка;</li> <li>Состав: 38% вискоза, 30% акрил, 16% полиэстер, 14% шерсть, 2% эластан;</li> <li>Сезон: осень, весна;</li> <li>Бренд: Hamaki-Ho;</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) "10634" ["sku"]=> string(6) "GB947H" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "3" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(55) "data/1c/utp007648_catalog_foto_modeli_1412_ao6b4835.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(10) "14200.0000" ["special"]=> string(9) "5680.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(2) "51" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-09-18 13:36:49" ["date_modified"]=> string(19) "2021-11-30 15:03:58" ["viewed"]=> string(4) "1564" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "278" [3]=> string(3) "280" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } [3332]=> array(49) { ["product_id"]=> string(4) "3332" ["name"]=> string(22) "Куртка Hamaki-Ho" ["description"]=> string(785) "<p>Мужская куртка из кожи. Да не простой, а перфорированной. Интересно? В таком случае, купить куртку Hamaki-Ho можно в нашем оффлайн-магазине в Киеве на Дорогожицкой ул., 8.</p> <p>Куртка кожаная, силуэт свободный, перфорированная кожа, застежка &ndash; &nbsp;молния, классический черный цвет, длинный рукав, воротник, характерный для бомбера, по низу куртки и на рукавах резинка для большего комфорта. Звоните и заказывайте!</p> " ["characteristics"]=> string(491) "<ul> <li>Модель: мужская куртка;</li> <li>Цвет: черный;</li> <li>Узор: перфорация;</li> <li>Состав: верх &ndash; кожа 100%; подкладка - полиэстер 100%;</li> <li>Сезон: осень, весна, лето;</li> <li>Бренд: Hamaki-Ho;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(22) "Куртка Hamaki-Ho" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(13) "Куртка " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "3332" ["sku"]=> string(6) "GB894H" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "3" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(38) "data/1c/utp005762_catalog_820f1454.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(10) "14900.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(2) "50" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-20 16:59:20" ["date_modified"]=> string(19) "2021-11-30 15:02:17" ["viewed"]=> string(3) "721" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "282" [3]=> string(3) "433" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } [3334]=> array(49) { ["product_id"]=> string(4) "3334" ["name"]=> string(26) "Ветровка Hamaki-Ho" ["description"]=> string(925) "<p>Представленная вашему вниманию ветровка от итальянского бренда Hamaki-Ho отличается минималистичным дизайном и линейным вкусом. Силуэт прямой, ворот-стойка, застежка &ndash; молния, актуальный темно-синий цвет.</p> <p>Полиэстер &ndash; весьма практичный в ношении материал &ndash; достаточно прочен и долговечен. Кроме того, за ним легко ухаживать.</p> <p>Купить ветровку можно в нашем интернет-магазине по привлекательной цене. Менеджеры-консультанты подскажут, как быстро сделать заказ.</p> " ["characteristics"]=> string(486) "<ul> <li>Модель: мужская куртка;</li> <li>Цвет: темно-синий;</li> <li>Узор: нет;</li> <li>Состав: верх - полиэстер 100%, подкладка - полиэстер 100%;</li> <li>Сезон: осень, весна, лето;</li> <li>Бренд: Hamaki-Ho;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(22) "Куртка Hamaki-Ho" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Ветровка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "3334" ["sku"]=> string(11) "GB864H nero" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "2" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(38) "data/1c/utp005764_catalog_820f1497.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(9) "5500.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(2) "49" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-20 16:59:20" ["date_modified"]=> string(19) "2021-11-30 15:02:30" ["viewed"]=> string(3) "645" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "433" [3]=> string(3) "434" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } [3335]=> array(49) { ["product_id"]=> string(4) "3335" ["name"]=> string(22) "Бомбер Hamaki-Ho" ["description"]=> string(980) "<p>Привлекательная модель куртки на каждый день. Она почти невесомая, а при передвижении способствует обеспечению максимального комфорта.</p> <p>Куртка с капюшоном, на вороте, подкладке и капюшоне есть графические элементы, двухцветная однобортная модель, застежка-молния, ворот (можно делать стоечку), карманы, длинные рукава, внутри на подкладке, актуальный темно-синий цвет.</p> <p>Заказать одежду в интернет-магазине dn8.ua очень просто: звоните на указанные на сайте номера телефонов и менеджеры оформят доставку.</p> " ["characteristics"]=> string(508) "<ul> <li>Модель: мужская куртка;</li> <li>Цвет: темно-синий;</li> <li>Узор: полоска;</li> <li>Состав: верх &ndash; хлопок 100%; подкладка &ndash; полиэстер 100%;</li> <li>Сезон: осень, весна, лето;</li> <li>Бренд: Hamaki-Ho;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(22) "Куртка Hamaki-Ho" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Бомбер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "3335" ["sku"]=> string(6) "GB863H" ["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(38) "data/1c/utp005765_catalog_820f1536.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(9) "6400.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(2) "48" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-20 16:59:20" ["date_modified"]=> string(19) "2021-11-30 15:02:47" ["viewed"]=> string(3) "483" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "285" [3]=> string(3) "433" [4]=> string(3) "434" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } [3881]=> array(49) { ["product_id"]=> string(4) "3881" ["name"]=> string(45) "Однобортный пиджак Hamaki-Ho" ["description"]=> string(1100) "<p>Мужской приталенный пиждак от молодого итальянского&nbsp;бренда Hamaki-Ho. Однобортный, светло-синего&nbsp;цвета, с застежкой на две круглые пуговицы черного цвета, с отложным воротником.</p> <p>Модель имеет боковые и нагрудный карманы. Пиджак&nbsp;выполнен&nbsp;из натуральной хлопковой ткани, благодаря чему вам будет комфортно в нем даже при высоких температурах. Можно комбинировать&nbsp;как с легкими брюками, так и джинсами.</p> <p>Желаете купить этот стильный однобортный пиджак Hamaki-Ho на нашем сайте? Вы можете воплотить задуманное прямо сейчас.&nbsp;Удачных покупок в&nbsp;DN8!</p> " ["characteristics"]=> string(549) "<ul> <li>Код товара:&nbsp;3881</li> <li>Артикул:&nbsp;GA871H</li> <li>Цвет: синий</li> <li>Сезон: весна-лето</li> <li>Материал:&nbsp;хлопок 100%</li> <li>Бренд:&nbsp;Hamaki-Ho</li> <li>Страна бренда: Италия</li> <li>Стиль: смарт-кэжуал</li> <li>На модели: 177 см, размер 50</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(22) "Пиджак Hamaki-Ho" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "3881" ["sku"]=> string(6) "GA871H" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "3" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(38) "data/1c/utp005767_catalog_820f1564.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(9) "8800.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(2) "47" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-11-30 15:03:06" ["viewed"]=> string(4) "1194" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(3) "316" [2]=> string(3) "437" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } [10566]=> array(49) { ["product_id"]=> string(5) "10566" ["name"]=> string(57) "Кроссовки мужские черные Hamaki-Ho" ["description"]=> string(895) "<p>Замечательные мужские кроссовки от относительно молодого итальянского бренда&nbsp;Hamaki-Ho, который возник в 2000 году. Лицевая часть выполнена в черном цвете с широкой полоской тон в тон. На пятках черно-белые контрастные вставки. Подошва имеет рельефную поверхность черно-белого цвета. Модель на шнурках.&nbsp;</p> <p>Хотите купить кроссовки мужские черные &nbsp;Hamaki-Ho на нашем сайте? Вы можете оформить заказ прямо сейчас.&nbsp;DN8: для нас важен каждый, кто заходит на наш сайт!</p> " ["characteristics"]=> string(543) "<ul> <li>Код товара:&nbsp;10566</li> <li>Артикул:&nbsp;SCA100H</li> <li>Бренд:&nbsp;Hamaki-Ho</li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Сезон: осень-зима</li> <li>Внешний материал: кожа&nbsp;</li> <li>Внутренний материал: кожа</li> <li>Подошва: резина</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(43) "Кроссовки мужские Hamaki-Ho" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Кроссовки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "10566" ["sku"]=> string(7) "SCA100H" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "3" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(52) "catalog/dn8/fotosessija/2021/september/10566_new.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(9) "5500.0000" ["special"]=> string(9) "2200.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(2) "46" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2018-08-31 09:32:37" ["date_modified"]=> string(19) "2021-12-02 16:50:45" ["viewed"]=> string(4) "1083" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "149" [3]=> string(3) "482" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } [10962]=> array(49) { ["product_id"]=> string(5) "10962" ["name"]=> string(33) "Штаны черные Hamaki-Ho" ["description"]=> string(1132) "<p>Штаны черные Hamaki-Ho - подходят как для занятий спортом, так и для повседневной носки.&nbsp;Модель на шнурке, что позволяет регулировать ширину на свое усмотрение. Внизу манжета из эластичного трикотажа.&nbsp;Сзади карман на молнии.&nbsp;Посадка низкая.</p> <div>Высокое качество материалов гарантирует, штаны не растянутся и не потеряют привлекательности.&nbsp;</div> <div>&nbsp;</div> <div>Вас заинтересовала модель? Купить штаны черные Hamaki-Ho можно на сайте нашего магазина. Доставка Новая Почта привозит заказ на удобное для вас отделение в Киеве и по всем другим городам Украины. Удачных покупок!</div> " ["characteristics"]=> string(420) "<ul> <li>Код товара: 10962</li> <li>Артикул: PS944H</li> <li>Бренд: Hamaki-Ho</li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Материал: синтетические ткани</li> <li>Состав: полиэстер 94%, эластан 6%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(20) "Брюки Hamaki-Ho" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Штаны" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "10962" ["sku"]=> string(6) "PS944H" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(55) "catalog/dn8/fotosessija/2021/december/22-12-2/10962.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(9) "3900.0000" ["special"]=> string(9) "1560.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2022-01-18 14:10:57" ["viewed"]=> string(3) "970" ["categories"]=> array(8) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "272" [3]=> string(3) "465" [4]=> string(3) "468" [5]=> string(3) "513" [6]=> string(3) "528" [7]=> string(3) "529" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } [8768]=> array(49) { ["product_id"]=> string(4) "8768" ["name"]=> string(52) "Синяя футболка мужская Hamaki-Ho" ["description"]=> string(1022) "<p>Креативность, вкус, искусство и изысканность &ndash; вот суть Hamaki-Ho. Обратите внимание на дизайнерское решение с игрой цветов и полосок. Силуэт &ndash; slim fit, особенности модели &ndash; полоски на спине, цвет &ndash; синий. Футболка изготовлена из натурального 100% хлопка.</p> <p>Чем хорош хлопок? Хорошо пропускает воздух, поэтому тело &laquo;дышит&raquo; и не парится; имеет отличную износостойкость и прочность; не прилипает к телу даже в сильную жару; за ним легко ухаживать.</p> <p>Заказать синюю футболку мужскую Hamaki-Ho в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(434) "<ul> <li>Модель: мужская футболка;</li> <li>Цвет: синий;</li> <li>Узор: принт;</li> <li>Материал: хлопок 100%;</li> <li>Сезонность: лето, весна, осень;</li> <li>Бренд: Hamaki-Ho;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(26) "Футболка Hamaki-Ho" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(17) "Футболка " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "8768" ["sku"]=> string(7) "ME1773H" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(38) "data/1c/utp005793_catalog_820f1660.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(9) "2100.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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2018-08-31 09:32:37" ["date_modified"]=> string(19) "2021-07-06 09:45:48" ["viewed"]=> string(3) "425" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } [5392]=> array(49) { ["product_id"]=> string(4) "5392" ["name"]=> string(73) "Рубашка мужская фиолетового цвета Hamaki-Ho" ["description"]=> string(951) "<p>Стильная и комфортная мужская рубашка от модного итальянского бренда&nbsp;Hamaki-Ho. Выполнена из натуральной хлопковой ткани светло-фиолетового цвета. Застегивается на&nbsp;пуговицы голубого цвета круглой формы. Акцент модели - контрастные манжеты, с внутренней стороны с бело-красным узором,&nbsp;фиксируются пуговицей. Рубашка кроя&nbsp;slim fit. В ней вы будете выглядеть непревзойденно!</p> <p>Купить рубашку&nbsp;светло-фиолетового цвета Hamaki-Ho можно на нашем сайте прямо сейчас и по доступной цене.&nbsp;</p> " ["characteristics"]=> string(586) "<ul> <li>Код товара:&nbsp;5392</li> <li>Артикул:&nbsp;CA658H</li> <li>Бренд:&nbsp;Hamaki-Ho</li> <li>Страна: Италия</li> <li>Цвет: светло-фиолетовый</li> <li>Рисунок: узор на манжетах</li> <li>Материал: 100% хлопок</li> <li>Параметры&nbsp;модели: рост&nbsp;177 см</li> <li>На модели надет: М</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(24) "Рубашка Hamaki-Ho" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Рубашка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "5392" ["sku"]=> string(6) "CA658H" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "2" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(38) "data/1c/utp005774_catalog_820f1633.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(9) "3400.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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-11 16:59:20" ["date_modified"]=> string(19) "2021-07-21 09:47:39" ["viewed"]=> string(3) "539" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "277" [3]=> string(3) "446" [4]=> string(3) "449" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } [10038]=> array(49) { ["product_id"]=> string(5) "10038" ["name"]=> string(42) "Темно-серые чинос Hamaki-Ho" ["description"]=> string(761) "<p>В изделиях бренда Hamaki-Ho соблюдается гармония сочетания традиционных элементов и модных тенденций. Создатели по-новому посмотрели на повседневные вещи.</p> <p>Представленные вашему вниманию брюки имеют 4 кармана: задние прорезные карманы с клапаном, боковые косые карманы, низкую посадку, актуальный темно-серый цвет, модель чинос.</p> <p>Купить темно-серые чинос Hamaki-Ho в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(457) "<ul> <li>Модель: мужские чинос;</li> <li>Цвет: темно-серый;</li> <li>Узор: однотонные;</li> <li>Материал: хлопок 97%, эластан 3%;</li> <li>Сезонность: внесезонные;</li> <li>Бренд: Hamaki-Ho;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(20) "Брюки Hamaki-Ho" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(11) "Чинос " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "10038" ["sku"]=> string(6) "PS858H" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "3" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(53) "catalog/dn8/fotosessija/2021/december/22-12/10038.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(9) "3900.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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-12-22 12:16:55" ["viewed"]=> string(3) "981" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "272" [3]=> string(3) "525" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } [5390]=> array(49) { ["product_id"]=> string(4) "5390" ["name"]=> string(74) "Рубашка мужская с белым воротником Hamaki-Ho" ["description"]=> string(919) "<p>Модная рубашка от итальянского бренда&nbsp;Hamaki-Ho. В ней вы непременно будете чувствовать себя на все 100%. Акцент модели в контрастных манжетах белого цвета. Выполнена рубашка из смесового состава: хлопок 97%, эластан 3%, темно-синего цвета, в белую продольную полоску, с длинным рукавом. Застегивается на белые пуговицы круглой формы. Силует рубашки приталенный.</p> <p>Оформить заказ и приобрести мужскую&nbsp;рубашку&nbsp;с белым воротником Hamaki-Ho вы можете немедленно на нашем сайте.&nbsp;</p> " ["characteristics"]=> string(447) "<ul> <li>Код товара:&nbsp;5390</li> <li>Артикул:&nbsp;CA652H&nbsp;</li> <li>Бренд:&nbsp;Hamaki-Ho</li> <li>Страна: Италия</li> <li>Цвет: темно-синий</li> <li>Рисунок: полоска</li> <li>Материал: 97% хлопок,&nbsp;3% эластан</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(24) "Рубашка Hamaki-Ho" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Рубашка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "5390" ["sku"]=> string(6) "CA652H" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(38) "data/1c/utp005772_catalog_820f1589.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(9) "3400.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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-11 16:59:20" ["date_modified"]=> string(19) "2022-01-18 14:08:43" ["viewed"]=> string(3) "540" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "277" [3]=> string(3) "446" [4]=> string(3) "449" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } [10034]=> array(49) { ["product_id"]=> string(5) "10034" ["name"]=> string(31) "Брюки синие Hamaki-Ho" ["description"]=> string(899) "<p>Брюки чинос из высококачественного эластичного хлопка имеют сдержанный внешний вид. Модель выполнена в классическом стиле.</p> <p>Два прорезных карман сзади на пуговицах, 2 косых кармана по бокам, застежка на пуговицу и молнию, шлевки для ремня.</p> <p>Обратите внимание на цвет &ndash; не маркий и хорошо сочетается с одеждой в другой цветовой гамме.</p> <p>Хотите заказать брюки синие Hamaki-Ho? Тогда звоните нашим менеджерам. Они подскажут, как быстро оформить заказ.</p> " ["characteristics"]=> string(454) "<ul> <li>Модель: мужские брюки;</li> <li>Цвет: темно-синий;</li> <li>Узор: однотонные;</li> <li>Материал: хлопок 97%, эластан 3%;</li> <li>Сезонность: весна-лето;</li> <li>Бренд: Hamaki-Ho;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(20) "Штаны Hamaki-Ho" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Брюки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "10034" ["sku"]=> string(14) "PS853H bluette" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(55) "catalog/dn8/fotosessija/2021/december/22-12-2/10034.jpg" ["manufacturer_id"]=> string(2) "93" ["manufacturer"]=> string(9) "Hamaki-Ho" ["manufacturer_size_table"]=> string(1278) "<p>Мужская одежда таблица</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>Hamaki-Ho</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>Hamaki-Ho (джинсы)</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> " ["price"]=> string(9) "3900.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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-12-22 12:06:42" ["viewed"]=> string(4) "1064" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "272" [3]=> string(3) "525" } [0]=> string(1919) "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 p 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 p.manufacturer_id = '93'ORDER BY p.sort_order DESC LIMIT 0,12" } }
-60%
Бушлат мужской двубортный синего цвета Hamaki-Ho

Бушлат мужской двубортный синего цвета Hamaki-Ho

14 200 грн.

5 680 грн.

Если вы отдаете предпочтение неброским сдержанным вещам, но при этом, отвечающим осенне-весенним &la..

Куртка Hamaki-Ho

14 900 грн.
Мужская куртка из кожи. Да не простой, а перфорированной. Интересно? В таком случае, купить куртку H..

Ветровка Hamaki-Ho

5 500 грн.
Представленная вашему вниманию ветровка от итальянского бренда Hamaki-Ho отличается минималистичным ..

Бомбер Hamaki-Ho

6 400 грн.
Привлекательная модель куртки на каждый день. Она почти невесомая, а при передвижении способствует о..

Однобортный пиджак Hamaki-Ho

8 800 грн.
Мужской приталенный пиждак от молодого итальянского бренда Hamaki-Ho. Однобортный, светло-синег..
-60%
Кроссовки мужские черные  Hamaki-Ho

Кроссовки мужские черные Hamaki-Ho

5 500 грн.

2 200 грн.

Замечательные мужские кроссовки от относительно молодого итальянского бренда Hamaki-Ho, который..
-60%
Штаны черные Hamaki-Ho

Штаны черные Hamaki-Ho

3 900 грн.

1 560 грн.

Штаны черные Hamaki-Ho - подходят как для занятий спортом, так и для повседневной носки. Модель..

Синяя футболка мужская Hamaki-Ho

2 100 грн.
Креативность, вкус, искусство и изысканность – вот суть Hamaki-Ho. Обратите внимание на дизайн..

Рубашка мужская фиолетового цвета Hamaki-Ho

3 400 грн.
Стильная и комфортная мужская рубашка от модного итальянского бренда Hamaki-Ho. Выполнена из на..

Темно-серые чинос Hamaki-Ho

3 900 грн.
В изделиях бренда Hamaki-Ho соблюдается гармония сочетания традиционных элементов и модных тенденций..

Рубашка мужская с белым воротником Hamaki-Ho

3 400 грн.
Модная рубашка от итальянского бренда Hamaki-Ho. В ней вы непременно будете чувствовать себя на..

Брюки синие Hamaki-Ho

3 900 грн.
Брюки чинос из высококачественного эластичного хлопка имеют сдержанный внешний вид. Модель выполнена..
Показано с 1 по 12 из 22 (всего 2 страниц)

Hamaki-Ho, Италия

Hamaki-Ho – молодой итальянский бренд, появившийся в 2000 году на fasion-рынке. Основная целевая аудитория – мужская, для которой дважды в год выпускаются две сезонных коллекции. Стилевое направление компании – деловая, классическая и повседневная одежда для мужчин: футболки, рубашки, джемперы, кардиганы, пуловеры, пальто, брюки, а также стильные аксессуары – сумки, ремни, браслеты.

Хорошие ткани (материалы) и точный крой, интересные узоры и принты, оригинальные расцветки и фасоны – все это мужчины найдут в продукции бренда Hamaki-Ho. В целом, с его помощью можно сформировать личный образ в стиле smart-look.