Чоловічі светри

array(8) { [12154]=> array(49) { ["product_id"]=> string(5) "12154" ["name"]=> string(57) "Светр оливкового кольору Blauer.USA" ["description"]=> string(1080) "<p>Оливковий меланжевий светр Blauer.USA з коміром мок.</p> <p>На відміну від пуловерів, деталі зв&#39;язані з фактурної і товстої нитки.</p> <p>Светр зшитий по напіврегулярній технології: кожна деталь в&#39;яжеться окремо, а потім зшивається в готовий виріб.</p> <p>Без застібки, низ рукава і край для зручності дов&#39;язані&nbsp;&laquo;резинкою&raquo;.</p> <p>М&#39;який, комфортний трикотаж, в складі 50% вовна, 50% акрил.</p> <p>Основний колір оливковий меланж.</p> <p>Светр Blauer.USA добре комбінуються з одягом в стилі кежуал, вносячи спортивний акцент в образ.</p> " ["characteristics"]=> string(491) "<ul> <li>Код товару: 12154</li> <li>Артикул: 17WBLUМ01184</li> <li>Бренд: Blauer.USA</li> <li>Країна: Італія</li> <li>Колір: оливковий меланж</li> <li>Сезон: осінь, зима</li> <li>Матеріал: 50% вовна, 50% акрил</li> <li>Тип застібки: без застібки</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(40) "Светр чоловічий Blauer USA" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(11) "Светр " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(153) "Светр, оливкового кольору, зелений, чоловічий, кофта, Blauer USA, теплий, зимовий, осінній" ["model"]=> string(5) "12154" ["sku"]=> string(13) "17WBLUМ01184" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "6" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(30) "catalog/foto20-21/ao6b2892.jpg" ["manufacturer_id"]=> string(2) "61" ["manufacturer"]=> string(10) "Blauer.USA" ["manufacturer_size_table"]=> string(2641) "<p>Одяг</p> <table class="size-table"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>примечание</td> </tr> <tr> <td>Жіночий верхній одяг, костюм, піджак, трикотаж, блузи, брюки&nbsp;Blauer. USA</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>маломерят</td> </tr> <tr> <td>Чоловічий верхній одяг, костюм, піджак, трикотаж, брюки&nbsp;Blauer. USA</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>маломерят</td> </tr> </tbody> </table> <p>Взуття</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Жіноче взуття Blauer.USA</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>35</td> <td>&nbsp;</td> <td>36</td> <td>&nbsp;</td> <td>37</td> <td>&nbsp;</td> <td>38</td> <td>&nbsp;</td> <td>39</td> <td>&nbsp;</td> <td>40</td> <td>&nbsp;</td> <td>41</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>&nbsp; &nbsp;</p> " ["price"]=> string(9) "6700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-09-27" ["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(4) "1600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2021-08-04 15:01:59" ["viewed"]=> string(4) "1315" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "454" [3]=> string(3) "457" [4]=> string(3) "513" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '457' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [12445]=> array(49) { ["product_id"]=> string(5) "12445" ["name"]=> string(73) "Пуловер чоловічий темно-зелений Wool & Co" ["description"]=> string(602) "<p>Пуловер чоловічий темно-зелений Wool &amp; Co прямого крою. Круглий виріз горловини, фактурна в&#39;язка, широка гумка на рукавах і по подолу. Щільний трикотаж, м&#39;який на дотик, добре тримає форму, не мнеться, володіє антистатичним ефектом. Дотримуйтесь рекомендації по догляду, щоб модель збереглася в хорошому стані.</p> " ["characteristics"]=> string(524) "<ul> <li>Код товару: 12445</li> <li>Артикул: 8225</li> <li>Бренд: Wool &amp; Co</li> <li>Країна: Італія</li> <li>Колір зелений</li> <li>Принт: немає</li> <li>Сезон: осінь, зима</li> <li>Склад: верх - 100% поліестер; підкл. - поліестер 100%</li> <li>Стиль: casual</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(41) "Пуловер мужской Wool&Co" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Пуловер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "12445" ["sku"]=> string(4) "8225" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "7" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(30) "catalog/foto20-21/ao6b2209.jpg" ["manufacturer_id"]=> string(2) "14" ["manufacturer"]=> string(11) "Wool&Co" ["manufacturer_size_table"]=> string(643) "<table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> <td>4XL</td> </tr> <tr> <td>Wool&amp;Co</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> <td>4XL</td> </tr> </tbody> </table> " ["price"]=> string(9) "3300.0000" ["special"]=> string(9) "2310.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-10-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(4) "1600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-16 16:59:20" ["date_modified"]=> string(19) "2021-09-01 11:54:21" ["viewed"]=> string(4) "1050" ["categories"]=> array(5) { [0]=> string(2) "85" [1]=> string(3) "296" [2]=> string(3) "454" [3]=> string(3) "457" [4]=> string(3) "513" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '457' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [12232]=> array(49) { ["product_id"]=> string(5) "12232" ["name"]=> string(90) "Пуловер чоловічий з контрастною вставкою Antony Morato" ["description"]=> string(937) "<p>Пуловер чоловічий з контрастною вставкою Antony Morato сезон осінь-зима. Фактурна в&#39;язка, круглий виріз, рукави реглан. Виріз горловини оброблений подвійною резинкою, що перешкоджає зношуванню. Низ вироби і рукавів на резинці. Прекрасно поєднується як з джинсами і повсякденними брюками в стилі casual, так і з класичними брюками. Вовна у складі зігріває і утримує тепло, синтетичні добавки надають м&#39;якості та легкості. Купити пуловер з контрастною вставкою Antony Morato можна в нашому магазині DN8 SHOPPING SPACE.</p> " ["characteristics"]=> string(471) "<ul> <li>Код товару: 12232</li> <li>Артикул: MMSW724YA0887051</li> <li>Бренд: Antony Morato</li> <li>Країна: Італія</li> <li>Колір синій</li> <li>Малюнок: смуга</li> <li>Матеріал: трикотаж</li> <li>Склад: вовна 50%, поліамід 30%, акрил 20%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(43) "Пуловер мужской Antony Morato" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Пуловер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "12232" ["sku"]=> string(16) "MMSW724YA0887051" ["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(30) "catalog/foto20-21/ao6b2054.jpg" ["manufacturer_id"]=> string(2) "44" ["manufacturer"]=> string(13) "Antony Morato" ["manufacturer_size_table"]=> string(768) "<table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>&nbsp;XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> <td>4XL</td> <td>5XL</td> </tr> <tr> <td>Antony Morato</td> <td>28-29</td> <td>30-31</td> <td>32-33</td> <td>34-35</td> <td>36-37</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> </tr> </tbody> </table> " ["price"]=> string(9) "5100.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-09-25" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-16 16:59:20" ["date_modified"]=> string(19) "2021-11-25 15:32:38" ["viewed"]=> string(3) "918" ["categories"]=> array(6) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "296" [3]=> string(3) "454" [4]=> string(3) "457" [5]=> string(3) "513" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '457' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [12447]=> array(49) { ["product_id"]=> string(5) "12447" ["name"]=> string(76) "Пуловер чоловічий в дрібний принт Wool & Co" ["description"]=> string(788) "<p>Пуловер чоловічий в дрібний принт Wool &amp; Co 8230/52 підходить для створення стильного кеуажльного образу. Фасон вільний, виріз горловини круглий. Широка еластична резинка по подолу і рукавах. Виріб зручний у використанні. До складу пряжі входить вовна і альпака, тому матеріал м&#39;який, легкий і надовго зберігає тепло. Крме того, пуловер стійкий до забруднення, не пілінгується і не деформується в процесі використання.</p> " ["characteristics"]=> string(479) "<ul> <li>Код товару: 12447</li> <li>Артикул: 8230/52</li> <li>Бренд: Wool &amp; Co</li> <li>Країна: Італія</li> <li>Колір: бордовий</li> <li>Малюнок: символіка</li> <li>Матеріал: трикотаж</li> <li>Склад: акрил 50%, вовна 30%, альпака 20%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Пуловер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "12447" ["sku"]=> string(7) "8230/52" ["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/utp009093_catalog_foto_modeli_1412_ao6b4148.jpg" ["manufacturer_id"]=> string(2) "14" ["manufacturer"]=> string(11) "Wool&Co" ["manufacturer_size_table"]=> string(643) "<table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> <td>4XL</td> </tr> <tr> <td>Wool&amp;Co</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> <td>4XL</td> </tr> </tbody> </table> " ["price"]=> string(9) "3300.0000" ["special"]=> string(9) "1650.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-30" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-16 16:59:20" ["date_modified"]=> string(19) "2021-09-01 11:56:42" ["viewed"]=> string(4) "1048" ["categories"]=> array(6) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "296" [3]=> string(3) "454" [4]=> string(3) "457" [5]=> string(3) "513" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '457' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [12450]=> array(49) { ["product_id"]=> string(5) "12450" ["name"]=> string(68) "Пуловер чоловічий бавовняний Wool & Co" ["description"]=> string(736) "<p>Пуловер чоловічий бавовняний Wool &amp; Co фактурної в&#39;язки.</p> <p>Круглий виріз горловини, прямий силует, низ виробу і рукавів на гумці.</p> <p>Прекрасно поєднується з джинсами і брюками вільного стилю.</p> <p>Пуловер з бавовни добре зберігає тепло, вбирає вологу і приємний на дотик.</p> <p>Дотримуйтесь рекомендації по догляду, тому що тканину схильна давати усадку.</p> " ["characteristics"]=> string(428) "<ul> <li>Код товару: 12450</li> <li>Артикул: 8280</li> <li>Бренд: Wool &amp; Co</li> <li>Країна: Італія</li> <li>Модель: пуловер</li> <li>Колір синій</li> <li>Матеріал: бавовна 100%</li> <li>Стиль: кежуал</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(41) "Пуловер мужской Wool&Co" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Пуловер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "12450" ["sku"]=> string(4) "8280" ["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(30) "catalog/foto20-21/ao6b2091.jpg" ["manufacturer_id"]=> string(2) "14" ["manufacturer"]=> string(11) "Wool&Co" ["manufacturer_size_table"]=> string(643) "<table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> <td>4XL</td> </tr> <tr> <td>Wool&amp;Co</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> <td>4XL</td> </tr> </tbody> </table> " ["price"]=> string(9) "3100.0000" ["special"]=> string(9) "1550.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-10-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(4) "1600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-16 16:59:20" ["date_modified"]=> string(19) "2021-09-01 11:57:57" ["viewed"]=> string(4) "1080" ["categories"]=> array(6) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "296" [3]=> string(3) "454" [4]=> string(3) "457" [5]=> string(3) "513" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '457' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [10703]=> array(49) { ["product_id"]=> string(5) "10703" ["name"]=> string(35) "Светр чоловічий Maerz" ["description"]=> string(1292) "<p>Бежевий светр Maerz з круглим вирізом.</p> <p>На відміну від пуловерів, деталі светру&nbsp;зв&#39;язані з фактурної і товстої нитки.</p> <p>Зшитий по напіврегулярній технології: кожна деталь в&#39;яжеться окремо, а потім зшивається в готовий виріб.</p> <p>Комір, низ рукава і край для зручності дов&#39;язані&nbsp;&laquo;резинкою&raquo;.</p> <p>М&#39;який, комфортний, натуральний трикотаж 100% вовна.</p> <p>Светр однотонного бежевого кольору з об&#39;ємними декоративними деталями.</p> <p>Добре комбінується з одягом в стилі кежуал, вносячи спортивний акцент в образ.</p> <p>Бежевий светр Maerz, за найкращою ціною, можна купити в інтернет магазині DN8 Shopping Space https://dn8.ua.</p> " ["characteristics"]=> string(445) "<ul> <li>Код товару: 10703</li> <li>Артикул: 429000 137</li> <li>Бренд: Maerz</li> <li>Країна: Німеччина</li> <li>Колір: бежевий</li> <li>Сезон: зима</li> <li>Матеріал: 100% вовна</li> <li>Тип застібки: без застібки</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(11) "Светр " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(115) "пуловер чоловічий, светр, кофта, зимовий, осінній, демісезонний" ["model"]=> string(5) "10703" ["sku"]=> string(10) "429000 137" ["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(32) "catalog/aproduct/ao6b2431(1).jpg" ["manufacturer_id"]=> string(2) "53" ["manufacturer"]=> string(6) "Maerz " ["manufacturer_size_table"]=> string(687) "<table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Maerz</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(9) "8900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-04-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(4) "1600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-04-28 11:19:44" ["date_modified"]=> string(19) "2021-11-30 11:35:53" ["viewed"]=> string(3) "903" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "454" [3]=> string(3) "457" [4]=> string(3) "513" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '457' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14015]=> array(49) { ["product_id"]=> string(5) "14015" ["name"]=> string(68) "Пуловер чоловічий білий з принтом Blend" ["description"]=> string(1116) "<p>Пуловер чоловічий тройер білий з принтом Blend з однотонного еластичного трикотажу урізноманітнює ваш повсякденний гардероб в холодну пору року. Комірець стійка. Довжина рукава до зап&#39;ястя. Виріз горловини, поділ і рукави оброблені широкою резинкою&nbsp;в рубчик. Центральна застібка - блискавка в рамку з контрастним пуллером. Яскравий акцент в стриманому образі - геометричний принт і логотип бренду. Довжина до початку стегна.</p> <ul> </ul> <p>Якщо вам сподобалася модель, ви зможете замовити пуловер чоловічий тройер білий з принтом Blend в нашому магазині по телефону або через сайт.</p> " ["characteristics"]=> string(642) "<ul> <li>Код товара: 14015</li> <li>Артикул: 20707375 70810</li> <li>Модель: чоловічий тройер;</li> <li>Фасон: приталений;</li> <li>Колір: білий, синій, бордовий;</li> <li>Візерунок: геометричний;</li> <li>Склад: акрил 90%, вовна 10%;</li> <li>Сезон: осінь-зима;</li> <li>Бренд: Blend (Бленд);</li> <li>Країна бренду: Данія.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Пуловер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14015" ["sku"]=> string(14) "20707375 70810" ["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(35) "catalog/novinki/1etazh/ao6b1296.jpg" ["manufacturer_id"]=> string(3) "121" ["manufacturer"]=> string(5) "Blend" ["manufacturer_size_table"]=> string(2415) "<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>Blend&nbsp;he,&nbsp;Blend she</td> <td>XXS</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> <td>&nbsp;</td> </tr> </tbody> </table> <p>Штани, шорти</p> <table class="size-table"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</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> </tr> <tr> <td>Blend he</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>27</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> </tr> <tr> <td>Blend she</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "2940.0000" ["special"]=> string(9) "1176.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-13" ["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(4) "1600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-03-13 12:31:30" ["date_modified"]=> string(19) "2021-09-08 12:56:14" ["viewed"]=> string(4) "2065" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "454" [3]=> string(3) "457" [4]=> string(3) "513" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '457' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14554]=> array(49) { ["product_id"]=> string(5) "14554" ["name"]=> string(58) "Пуловер чоловічий білий Wool & Co" ["description"]=> string(934) "<p>Пуловер білий Wool &amp; Co з однотонної пряжі виконаний різними варіантами в&#39;язки. Виріз горловини круглий. Комір напівстійкого. М&#39;яка резинка в рубчик на рукавах, по подолу, на комірі. Спущена лінія плечей. Рукава широкі, довгі. Фактурна модель прикрасить повсякденний гардероб. Виріб легко комбінується з різними варіантами низу.</p> <ul> </ul> <p>Якщо вам сподобалася модель, ви можете замовити пуловер білий Wool &amp; Co в нашому магазині, оформивши заявку по телефону або через сайт.</p> " ["characteristics"]=> string(494) "<ul> <li>Модель: пуловер чоловічий;</li> <li>Фасон: приталений;</li> <li>Забарвлення: білий;</li> <li>Візерунок: різні варіанти в&#39;язки;</li> <li>Верх: нейлон 88%, еластан 12%;</li> <li>Бренд: Wool &amp; Co;</li> <li>Країна бренду: Італія.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Пуловер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14554" ["sku"]=> string(8) "4150 100" ["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(35) "catalog/novinki/1etazh/ao6b1589.jpg" ["manufacturer_id"]=> string(2) "14" ["manufacturer"]=> string(11) "Wool&Co" ["manufacturer_size_table"]=> string(643) "<table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> <td>4XL</td> </tr> <tr> <td>Wool&amp;Co</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> <td>4XL</td> </tr> </tbody> </table> " ["price"]=> string(9) "3990.0000" ["special"]=> string(9) "2793.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-06" ["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(4) "1600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-03-06 13:18:36" ["date_modified"]=> string(19) "2021-09-01 12:05:45" ["viewed"]=> string(3) "578" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "454" [3]=> string(3) "457" [4]=> string(3) "513" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '457' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }