UNQ

array(12) { [16294]=> array(49) { ["product_id"]=> string(5) "16294" ["name"]=> string(48) "Штаны женские зауженные UNQ" ["description"]=> string(804) "<p>Штаны женские зауженные UNQ серого цвета. Прямой крой, средняя посадка по талии, карманы в боковых швах. Прорезные карманы в листочку на заднем полотне. Пояс с пряжкой регулируемой ширины. Длина выше щиколотки.&nbsp;</p> <p>Практичная вещь для повседневного образа.&nbsp;Универсальный фасон хорошо смотрится на девушках разного телосложения. Благодаря базовому цветовому решению брюки легко комбинировать в стильный образ.</p> " ["characteristics"]=> string(430) "<ul> <li>Код товара: 16294</li> <li>Артикул: 90114210065</li> <li>Бренд: UNQ</li> <li>Страна: Германия</li> <li>Модель: брюки</li> <li>Цвет: серый</li> <li>Принт: нет</li> <li>Материал: хлопок 97%, эластан 3%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Штаны" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(208) "Штаны женские, женские хлопковые брюки, серые штаны, летние серые штаны, женские штаны на лето, демисезонные штаны" ["model"]=> string(5) "16294" ["sku"]=> string(11) "90114210065" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(68) "catalog/dn8/fotosessija/2020/avgust_zhenskaja_1_etazh/img_7429-3.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "3980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-28" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-28 14:44:37" ["date_modified"]=> string(19) "2021-08-30 10:09:23" ["viewed"]=> string(3) "635" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } [16291]=> array(49) { ["product_id"]=> string(5) "16291" ["name"]=> string(51) "Джинсы женские с бахромой UNQ" ["description"]=> string(897) "<p>Джинсы женские с бахромой UNQ узкого кроя. КМодель skinny с 5 карманами, средняя посадка по талии, застежка молния.&nbsp;Фурнитура металлическая, без зазубрин, прочно закреплена.&nbsp;</p> <p>Модель идеально подходит для сезона весна-лето. Базовое цветовое решение позволяет легко комбинировать с футболками, блузами, куртками.</p> <p>В составе хлопок и небольшой процент синтетических волокон. Ткань с саржевым переплетением&nbsp;прочная, износостойкая и эластичная.&nbsp;</p> " ["characteristics"]=> string(432) "<ul> <li>Код товара: 16291</li> <li>Артикул: 90116710072</li> <li>Бренд: UNQ</li> <li>Страна: Германия</li> <li>Модель: джинсы</li> <li>Цвет: белый</li> <li>Принт: нет</li> <li>Материал: хлопок 98%, эластан 2%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Джинсы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(170) "Джинсы женские белые, женские штаны, летние штаны, джинсы на каждый день, штаны на каждый день" ["model"]=> string(5) "16291" ["sku"]=> string(11) "90116710072" ["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(66) "catalog/dn8/fotosessija/2020/avgust_zhenskaja_1_etazh/img_7388.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "3800.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-28" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-28 14:44:37" ["date_modified"]=> string(19) "2021-03-16 10:15:20" ["viewed"]=> string(3) "642" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(2) "74" [3]=> string(3) "166" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } [17086]=> array(49) { ["product_id"]=> string(5) "17086" ["name"]=> string(67) "Брюки женские голубые вельветовые UNQ" ["description"]=> string(862) "<p>Брюки женские голубые вельветовые UNQ зауженные. Пояс регулируемой ширины, средняя посадка по талии.&nbsp;Карманы по бокам, длина до щиколотки.&nbsp;</p> <p>Изделие из натурального хлопка с небольшим добавлением синтетики.&nbsp;Добавление синтетики многократно повышает износостойкость и сохраняет внешний вид.&nbsp;</p> <p>Практичная вещь для повседневного образа.&nbsp;Универсальный фасон хорошо смотрится на девушках разного телосложения.&nbsp;</p> " ["characteristics"]=> string(438) "<ul> <li>Код товара: 17086</li> <li>Артикул: 90241110128 636</li> <li>Бренд: UNQ</li> <li>Страна: Германия</li> <li>Модель: брюки</li> <li>Цвет: голубой</li> <li>Принт: нет</li> <li>Материал: хлопок 97%, эластан 3%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Брюки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(268) "штаны бананы, широкие штаны, штаны вельветовые, штаны со средней посадкой, штаны на каждый день, штаны однотонные, штаны укороченные, штаны баллоны" ["model"]=> string(5) "17086" ["sku"]=> string(15) "90241110128 636" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(64) "catalog/dn8/fotosessija/2020/oktjabr/1etazhzhenskoe/img_1661.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </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-10-20" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-20 13:25:06" ["date_modified"]=> string(19) "2021-11-29 11:27:43" ["viewed"]=> string(3) "532" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } [17081]=> array(49) { ["product_id"]=> string(5) "17081" ["name"]=> string(42) "Брюки-кюлоты женские UNQ" ["description"]=> string(816) "<p>Брюки-кюлоты женские UNQ серого цвета. Широкие укороченные брюки с высокой посадкой по талии в спортивном стиле. Принт &quot;елочка&quot; - фактурный рисунок, состоящий из мелких диагональных полосок. Получается за счет переплетения нитей разного цвета. Средняя посадка по талии, пояс на шнурке, боковые карманы.&nbsp;</p> <p>Базовое цветовое решение позволяет легко комбинировать с футболками, блузами, куртками прямого кроя.&nbsp;</p> " ["characteristics"]=> string(442) "<ul> <li>Код товара: 17081</li> <li>Артикул:&nbsp;90216420002</li> <li>Бренд: UNQ</li> <li>Страна: Германия</li> <li>Модель: брюки</li> <li>Цвет: серый</li> <li>Принт: елочка</li> <li>Материал: 50% шерсть, 50% акрил</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Брюки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(356) "штаны кюлоты, брюки, укороченные, широкие штаны, расклешенные штаны, штаны в елочку, штаны со средней посадкой, штаны на каждый день, штаны укороченные, штаны шерстяные, штаны со вставной резинкой" ["model"]=> string(5) "17081" ["sku"]=> string(11) "90216420002" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(64) "catalog/dn8/fotosessija/2020/oktjabr/1etazhzhenskoe/img_1687.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </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) "2020-10-20" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-20 13:25:06" ["date_modified"]=> string(19) "2021-11-29 11:28:41" ["viewed"]=> string(3) "391" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" [4]=> string(3) "511" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } [17083]=> array(49) { ["product_id"]=> string(5) "17083" ["name"]=> string(56) "Брюки женские в мелкий принт UNQ" ["description"]=> string(801) "<p>Брюки женские в мелкий принт UNQ в спортивном стиле. Штаны прямого кроя, снизу на эластичных манжетах. Средняя посадка по талии, эластичный притачной пояс.&nbsp;На задней части накладной карман.</p> <p>Универсальный фасон хорошо смотрится на девушках разного телосложения.&nbsp;Практичная вещь для повседневного образа.</p> <p>Купить&nbsp;брюки женские в мелкий принт UNQ можно на сайте нашего магазина&nbsp;DN8 SHOPPING SPACE.</p> " ["characteristics"]=> string(462) "<ul> <li>Код товара: 17083</li> <li>Артикул: 90227920002</li> <li>Бренд: UNQ</li> <li>Страна: Германия</li> <li>Модель: брюки</li> <li>Цвет: черный</li> <li>Принт: клетка</li> <li>Материал: шерсть 50%,&nbsp;полиакрил 50%&nbsp;</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Брюки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(230) "штаны шерстяные, черно-белые, штаны с вязаными манжетами, штаны на резинке, свободные штаны, удобные штаны, повседневные штаны" ["model"]=> string(5) "17083" ["sku"]=> string(11) "90227920002" ["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(64) "catalog/dn8/fotosessija/2020/oktjabr/1etazhzhenskoe/img_1655.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </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) "2020-10-20" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-20 13:25:06" ["date_modified"]=> string(19) "2021-11-29 11:27:24" ["viewed"]=> string(3) "542" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" [4]=> string(3) "511" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } [17085]=> array(49) { ["product_id"]=> string(5) "17085" ["name"]=> string(52) "Брюки женские вельветовые UNQ" ["description"]=> string(997) "<p>Брюки женские вельветовые UNQ фиолетового цвета. По бокам карманы, на задней части нет карманов и доп элементов декора. Штаны широкие, зауженные книзу.&nbsp;</p> <p>Изделие из натурального хлопка с небольшим добавлением синтетики.&nbsp;Добавление синтетики многократно повышает износостойкость и сохраняет внешний вид.&nbsp;</p> <p>Практичная вещь для повседневного образа.&nbsp;Универсальный фасон хорошо смотрится на девушках разного телосложения.&nbsp;Комбинируя одежду и аксессуары, можно получить интересные образы.</p> " ["characteristics"]=> string(462) "<ul> <li>Код товара: 17085</li> <li>Артикул: 90241110128 427</li> <li>Бренд: UNQ</li> <li>Страна: Германия</li> <li>Модель: брюки</li> <li>Цвет: фиолетовый</li> <li>Принт: нет</li> <li>Материал:&nbsp;хлопок&nbsp;97%, эластан 3%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Брюки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(328) "штаны бананы, широкие штаны, штаны вельветовые, штаны со средней посадкой, штаны на каждый день, штаны однотонные, штаны укороченные, штаны баллоны, штаны для офиса, штаны для учебы" ["model"]=> string(5) "17085" ["sku"]=> string(15) "90241110128 427" ["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(64) "catalog/dn8/fotosessija/2020/oktjabr/1etazhzhenskoe/img_1640.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </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-10-20" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-20 13:25:06" ["date_modified"]=> string(19) "2021-11-29 11:28:02" ["viewed"]=> string(3) "914" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } [17084]=> array(49) { ["product_id"]=> string(5) "17084" ["name"]=> string(43) "Брюки-кюлоты в клетку UNQ" ["description"]=> string(660) "<p>Брюки-кюлоты в клетку UNQ черного цвета. Широкие укороченные брюки с высокой посадкой по талии. Пояс-кулиска, шнурок позволяет регулировать ширину талии. Боковые карманы на переднем полотне.&nbsp;Практичная вещь для повседневного образа.&nbsp;Базовое цветовое решение позволяет легко комбинировать с футболками, блузами, куртками прямого кроя.&nbsp;</p> " ["characteristics"]=> string(445) "<ul> <li>Код товара: 17084</li> <li>Артикул: 90229120041</li> <li>Бренд: UNQ</li> <li>Страна: Германия</li> <li>Модель: брюки</li> <li>Цвет: черный</li> <li>Принт: клетка</li> <li>Материал: вискоза 75%, полиэстер 25%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Брюки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(312) "штаны кюлоты, брюки, укороченные, широкие штаны, расклешенные штаны, штаны клетчатые, штаны со средней посадкой, штаны на каждый день, штаны однотонные, штаны укороченные, " ["model"]=> string(5) "17084" ["sku"]=> string(11) "90229120041" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(64) "catalog/dn8/fotosessija/2020/oktjabr/1etazhzhenskoe/img_1724.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </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-10-20" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-20 13:25:06" ["date_modified"]=> string(19) "2021-11-29 11:28:21" ["viewed"]=> string(3) "466" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" [4]=> string(3) "511" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } [16298]=> array(49) { ["product_id"]=> string(5) "16298" ["name"]=> string(36) "Штаны-кюлоты хаки UNQ" ["description"]=> string(1473) "<p>Штаны-кюлоты женские цвета хаки UNQ. Широкие женские брюки фасона кюлоты; аккуратная и очень стильная модель; подойдут женщинам разного роста, визуально корректируя его; хороший вариант для лета &ndash; в них не жарко; простые и функциональные.&nbsp; Широкие брюки. Длина &ndash; миди. С глубокими складками. Узкий пояс. Застегиваются на крючок и молнию (спрятанные). Цвет &ndash; хаки.</p> <p>Кюлоты &ndash; весьма простая, но одновременно функциональная вещь в женском гардеробе. Во-первых, она хорошо сочетается с одеждой в разных стилях. Во-вторых, за ней легко ухаживать. В-третьих, она очень комфорта. Подбирайте необходимый размер!</p> <p>Заказывайте брюки нужного вам размера уже сейчас. Для вас работают консультанты онлайн. Одевайтесь удобно, быстро и со вкусом в DN8! Ждем ваших звонков.</p> " ["characteristics"]=> string(466) "<ul> <li>Код товара: 16298</li> <li>Артикул: 90133810043</li> <li>Бренд: UNQ</li> <li>Страна: Германия</li> <li>Модель: брюки</li> <li>Цвет: оливковый</li> <li>Принт: нет</li> <li>Материал: вискоза 52%, тенсел 22%, модал 20%, лен 6%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Штаны" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(55) "Брюки, кюлоты. женские, хаки, UNQ" ["model"]=> string(5) "16298" ["sku"]=> string(11) "90133810043" ["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(66) "catalog/dn8/fotosessija/2020/avgust_zhenskaja_1_etazh/img_5056.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4300.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-03-18" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-06-15 16:44:22" ["viewed"]=> string(4) "1146" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } [16293]=> array(49) { ["product_id"]=> string(5) "16293" ["name"]=> string(57) "Брюки с накладными карманами UNQ" ["description"]=> string(1464) "<p>Брюки из хлопка. Завышенная талия. &laquo;Французские&raquo; карманы по бокам. На штанинах карманы с клапанами. Широкая талия. На поясе шлевки для пояса. Несколько укороченная длина. Скрытые застежки. Сзади два прорезных кармана.</p> <p>Натуральный хлопок &ndash; материал, который наверняка придется вам по душе. Все дело в его позитивных особенностях: он не парит, так что брюки смело можно носить даже в жару; приятен к телу и на ощупь; за ним легко ухаживать: стирка, сушка &ndash; главное придерживаться рекомендаций на этикетке; он хорошо пропускает воздух.</p> <p>Надумали покупать брюки женские зауженные с накладными карманами горчичного цвета UNQ? Хорошее решение. Скорей звоните нашим менеджерам или оформите заказ онлайн. Будьте всегда стильными и модными с DN8.</p> <ul> </ul> " ["characteristics"]=> string(481) "<ul> <li>Модель: женские брюки;</li> <li>Фасон: зауженные;</li> <li>Цвет: желтый;</li> <li>Узор: без узора;</li> <li>Материал: хлопок 100%;</li> <li>Сезон: весна-лето;</li> <li>Бренд: UNQ;</li> <li>Страна-производитель: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Брюки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(128) "Брюки, женские, зауженные, с накладными карманами, горчичного цвета, UNQ" ["model"]=> string(5) "16293" ["sku"]=> string(11) "90112310082" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(56) "catalog/dn8/fotosessija/2020/mart/muzhskaja/img_4579.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "3980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-03-18" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-03-18 10:05:17" ["date_modified"]=> string(19) "2021-09-08 16:31:19" ["viewed"]=> string(3) "601" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } [16299]=> array(49) { ["product_id"]=> string(5) "16299" ["name"]=> string(48) "Штаны женские оранжевые UNQ" ["description"]=> string(1525) "<p>Штанины с отворотами. Подходят как для жаркой погоды, так и для весеннего солнышка. Удобные застежки. Есть шлевки для продевания ремешка. Два неглубоких боковых кармана. Достаточно высокая посадка.</p> <p>Для изготовления брюк, производитель использовал натуральные материалы &ndash; хлопок и лен. Учитывая их особенности, брюки характеризуются следующими особенностями: хорошей воздухопроницаемостью; успешным комбинированием с другими материалами; достаточной износоустойчивостью; легкостью в уходе.</p> <p>Убедились, что эти брючки &ndash; настоящая находка для весенне-летнего сезона? Скорее звоните нашим менеджерам и оформляйте заказ. Еще больше стильных, красочных и модных вещей ищите в разделе &laquo;<a href="https://dn8.ua/ua/zhenskaya-odezhda/"><span style="color:#3984c6">Одежда</span></a>&raquo;.</p> <ul> </ul> " ["characteristics"]=> string(538) "<ul> <li>Модель: женские брюки;</li> <li>Фасон: зауженные, с отворотами;</li> <li>Цвет:светло-оранжевые;</li> <li>Узор: однотонные;</li> <li>Материал: хлопок 57%, лен 43%;</li> <li>Сезон: весна-лето;</li> <li>Бренд: UNQ;</li> <li>Страна-производитель: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Штаны" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(247) "женские брюки, летние женские штаны, женские светлые брюки, женские персиковые брюки, светлые легкие брюки, летние штаны на каждый день" ["model"]=> string(5) "16299" ["sku"]=> string(11) "90147310073" ["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(58) "catalog/dn8/fotosessija/2020/mart/zhenskaja_3/img_5005.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4300.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-03-18" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-03-18 10:05:17" ["date_modified"]=> string(19) "2021-09-08 15:27:19" ["viewed"]=> string(3) "655" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } [17082]=> array(49) { ["product_id"]=> string(5) "17082" ["name"]=> string(49) "Брюки женские из экокожи UNQ" ["description"]=> string(660) "<p>Брюки укороченной длины, с поясом, прямой крой со слегка расклешенными штанинами, есть шлевки для ремня, застежка, интересный дизайн, завышенная талия.</p> <p>Экокожа &ndash; современный материал: прочный, эластичный, устойчивый к истиранию, формоустойчивый.</p> <p>Купить брюки женские из экокожи UNQ в интернет-магазине dn8.ua по хорошей цене.</p> " ["characteristics"]=> string(404) "<ul> <li>Модель: женские брюки;</li> <li>Цвет: голубой;</li> <li>Узор: нет;</li> <li>Состав: полиэстер 100%;</li> <li>Сезон: весна-лето;</li> <li>Бренд:UNQ;</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Брюки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(295) " штаны кожаные, штаны из эко-кожи, штаны серые, штаны серо-голубые, штаны с завышенной талией, свободные штаны, удобные штаны, повседневные штаны, однотонные штаны" ["model"]=> string(5) "17082" ["sku"]=> string(11) "90219110126" ["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(64) "catalog/dn8/fotosessija/2020/oktjabr/1etazhzhenskoe/img_1633.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </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-10-20" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-20 13:25:06" ["date_modified"]=> string(19) "2021-09-09 12:39:04" ["viewed"]=> string(3) "481" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } [16290]=> array(49) { ["product_id"]=> string(5) "16290" ["name"]=> string(50) "Джинсы женские зауженные UNQ" ["description"]=> string(902) "<p>Джинсы женские зауженные UNQ черного цвета. Модель skinny с 5 карманами, средняя посадка по талии, застежка молния,&nbsp;V-образная кокетка. Фурнитура металлическая, без зазубрин, прочно закреплена. Длина укорочена.&nbsp;</p> <p>В составе хлопок и небольшой процент синтетических волокон. Ткань с саржевым переплетением&nbsp;прочная, износостойкая и эластичная.&nbsp;</p> <p>Благодаря базовому цветовому решению джинсы&nbsp;легко комбинировать с футболками, блузами, куртками.</p> " ["characteristics"]=> string(434) "<ul> <li>Код товара: 17084</li> <li>Артикул: 90229120041</li> <li>Бренд: UNQ</li> <li>Страна: Германия</li> <li>Модель: джинсы</li> <li>Цвет: черный</li> <li>Принт: нет</li> <li>Материал: хлопок 98%, эластан 2%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Джинсы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(125) "Брюки джинсовые, джинсы, женские, зауженные, черного цвета, черные, UNQ" ["model"]=> string(5) "16290" ["sku"]=> string(11) "90116410072" ["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(56) "catalog/dn8/fotosessija/2020/mart/muzhskaja/img_4184.jpg" ["manufacturer_id"]=> string(3) "145" ["manufacturer"]=> string(3) "UNQ" ["manufacturer_size_table"]=> string(1188) "<h2>&nbsp;</h2> <table class="size-table" style="font-size:13px"> <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 rowspan="2">UNQ</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> <tr> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4260.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-03-18" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-03-18 10:05:17" ["date_modified"]=> string(19) "2021-09-08 15:47:03" ["viewed"]=> string(3) "623" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(2) "74" [3]=> string(3) "166" [4]=> string(3) "521" } [0]=> string(1921) "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 = '145'ORDER BY p.sort_order DESC LIMIT 36,12" } }