Pal Zileri LAB

array(12) { [16672]=> array(49) { ["product_id"]=> string(5) "16672" ["name"]=> string(40) "Бежевые чинос Pal Zileri LAB" ["description"]=> string(1266) "<p>Брюки слаксы Pal Zileri Lab бежевого цвета.</p> <p>Подходят для большинства типов фигур, благодаря средней посадке и чуть зауженному крою. Брючины без защипов и&nbsp; подкладки, ширина по низу 18 см. Четыре врезных кармана: два боковых и два задних. Застежка на молнию и&nbsp; пуговицы.</p> <p>Смесовый состав хлопок 70%, полиэстер 30%. Брюки комфортны в теплое время года, хорошо сохраняют цвет и форму благодаря полиэстеру низкую теплопроводность, воздухопроницаемость благодаря хлопку.</p> <p>Бежевые слаксы Pal Zileri Lab входят в базовый летний гардероб, они легко комбинируются с блейзерами, рубашками, поло и т.п. Модель подходит для образов в смарт кэжуал&nbsp; и кэжуал стилях.</p> " ["characteristics"]=> string(760) "<ul> <li>Код товара:16672</li> <li>Артикул: QP130 E C8170 35</li> <li>Бренд: Pal Zileri Lab</li> <li>Страна: Италия</li> <li>Цвет: бежевый</li> <li>Рисунок: без рисунка</li> <li>Сезон: лето</li> <li>Материал: хлопок 70%, полиэстер 30%</li> <li>Количество карманов: четыре</li> <li>Тип застежки: молния, пуговицы</li> <li>Параметры модели: 102-84-99, рост 185 см</li> <li>На модели надет: 48</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(230) "Штаны мужские, брюки мужские, легкие штаны, летние штаны, бежевые штаны, мужские штаны на лето, светлые брюки, коричневые штаны" ["model"]=> string(5) "16672" ["sku"]=> string(16) "QP130 E C8170 35" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/2_etazh_muzhskoe/img_4695-ds.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(9) "6980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-16" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(2) "15" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-16 11:23:36" ["date_modified"]=> string(19) "2021-07-29 10:23:53" ["viewed"]=> string(3) "713" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "272" [3]=> string(3) "525" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13721]=> array(49) { ["product_id"]=> string(5) "13721" ["name"]=> string(58) "Костюм мужской в клетку Pal Zileri Lab" ["description"]=> string(838) "<p>Стильный мужской костюм серого цвета в клеточку от итальянского бренда Pal Zileri Lab. Состоит из брюк и пиджака. Подойдет для деловых встреч и совещаний, также можно носить его каждый день.<br /> Пиджак однобортный, застегивается на 2 пуговицы, современная посадка, карманы с клапанами, на рукавах по 4 пуговицы в ряд, брюки со стрелками.<br /> Купить костюм мужской в клетку Pal Zileri Lab&nbsp;можно прямо сейчас в интернет-магазине dn8.ua. Удачных покупок в DN8!</p> " ["characteristics"]=> string(607) "<ul> <li>Код товара:&nbsp;13721</li> <li>Артикул:&nbsp;MP3906092 38226 08 7R&nbsp;</li> <li>Цвет: серый</li> <li>Рисунок: клетка</li> <li>Сезон: весна-лето</li> <li>Материал:&nbsp;шерсть 98%, эластан 2%</li> <li>Бренд:&nbsp;Pal Zileri Lab</li> <li>Страна бренда: Италия</li> <li>Стиль: повседневный&nbsp;(кэжуал)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(58) "Костюм мужской в клетку Pal Zileri Lab" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Костюм" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "13721" ["sku"]=> string(21) "MP3906092 38226 08 7R" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(30) "catalog/foto15-16/ao6b5730.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(10) "27990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-29" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(2) "14" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 10:10:29" ["viewed"]=> string(4) "1243" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "288" [3]=> string(3) "440" [4]=> string(3) "444" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13216]=> array(49) { ["product_id"]=> string(5) "13216" ["name"]=> string(66) "Костюм (двойка) однобортный Pal Zileri LAB" ["description"]=> string(894) "<p>Стильный однотонный мужской костюм синего цвета, состоящий из брюк и пиджака. Подойдет для деловых встреч и совещаний.</p> <p>Пиджак однобортный, современная посадка, застегивается на 2 круглые пуговицы черного цвета, карманы с клапанами, на рукавах по 4 пуговицы в ряд, брюки со стрелками.</p> <p>Купить костюм&nbsp;(двойка) однобортный Pal Zileri LAB&nbsp; можно незамедлительно в интернет-магазине dn8.ua.&nbsp;DN8: с нами покупки делать просто и приятно!&nbsp;</p> <p>&nbsp;</p> " ["characteristics"]=> string(533) "<ul> <li>Код товара:&nbsp;13216</li> <li>Артикул:&nbsp;MP3906092 38223 0707L</li> <li>Цвет: синий</li> <li>Рисунок: нет</li> <li>Сезон: осень-зима</li> <li>Материал: верх - шерсть 100%, подкладка - 100% вискоза</li> <li>Бренд:&nbsp;Pal Zileri LAB</li> <li>Страна бренда: Италия</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Костюм" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "13216" ["sku"]=> string(21) "MP3906092 38223 0707L" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(58) "data/1c/utp010300_catalog_foto_modeli_15_1605_ao6b5691.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(10) "21780.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-10-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(2) "13" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 10:14:03" ["viewed"]=> string(4) "2039" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "288" [3]=> string(3) "439" [4]=> string(3) "440" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16655]=> array(49) { ["product_id"]=> string(5) "16655" ["name"]=> string(58) "Пиджак в крупную клетку Pal Zileri LAB" ["description"]=> string(1151) "<p>Неформальный блейзер Lab Pal Zileri для летнего сезона.&nbsp;Однобортный пиджак с застежкой на две пуговицы и двумя шлицами выполнен на полной подкладке.</p> <p>Боковые карманы врезные, нагрудный - с листочкой.&nbsp;Модель в комфортном полуприталенном силуэте.</p> <p>Сшит из смесовой ткани. Благодаря шерсти и льну и в составе, в блейзере комфортно при повышенных температурах, а синтетические волокна делают его немнущимся и более износостойким.</p> <p>Застежка на роговые пуговицы.Сочетание синего меланжа с коричневой клеткой позволяют комбинировать блейзер как в повседневном так и спортивном стилях.</p> " ["characteristics"]=> string(918) "<ul> <li>Код товара: 16655</li> <li>Артикул: QP29060 2 C8311</li> </ul> <ul> <li>Бренд: Lab Pal Zileri</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: синий</li> <li>Рисунок: клетка</li> <li>Сезон: весна-лето</li> <li>Материал лицевой стороны: 52% шерсть, полиэстер 40%, лен 8%</li> <li>Материал подкладки: вискоза 100%</li> <li>Застежка пиджака: на 2 пуговицы</li> <li>Модель:&nbsp;tailor fit</li> <li>Параметры модели:&nbsp;102-77-96, рост 185</li> <li>На модели:&nbsp;50</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(88) "Пиджак, мужской, в крупную клеточку, Pal Zileri, синий" ["model"]=> string(5) "16655" ["sku"]=> string(15) "QP29060 2 C8311" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/2_etazh_muzhskoe/img_4704-ds.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(10) "15980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-14" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(2) "12" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-19 15:52:28" ["viewed"]=> string(3) "760" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "316" [3]=> string(3) "437" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15327]=> array(49) { ["product_id"]=> string(5) "15327" ["name"]=> string(44) "Бордовый пиджак Pal Zileri Lab" ["description"]=> string(1109) "<p>Бордовый пиджак Pal Zileri Lab из фактурной жатой ткани в мелкую клетку. Отложной воротник и длинные лацканы прямоугольной формы. Декоративная петля, нагрудный карман с листочкой. Рукав начинается точно по плечу, декорирован 4 пуговицами. Длина до косточки большого пальца. Застегивается на 2 пуговицы. Сзади 2 шлицы. Выточки по фигуре, полу приталенный фасон. Широкие карманы на уровне талии.&nbsp;</p> <ul style="list-style-type:disc"> </ul> <p>Если вам понравилась модель, приобрести пиджак мужской однобортный бордового цвета Pal Zileri Lab вы сможете в нашем магазине. Удачных покупок!</p> <p>&nbsp;</p> " ["characteristics"]=> string(643) "<ul style="list-style-type:disc"> <li>Модель: непарный мужской пиджак;</li> <li>Фасон: однобортный мужской пиджак на 2 пуговицы;</li> <li>Цвет: бордовый;</li> <li>Узор: мелкая клетка;</li> <li>Состав: шерсть 54%, полиэстер 45%, эластан 1%;</li> <li>Сезонность: весна-лето;</li> <li>Бренд:Pal Zileri;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Пиджак" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15327" ["sku"]=> string(15) "OP2I03S-2 58353" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(51) "catalog/fotosessijasmodeljami_ijun2019/ao6b1167.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(10) "15800.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-08" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(2) "10" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 10:32:54" ["viewed"]=> string(3) "632" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "437" [3]=> string(3) "438" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15326]=> array(49) { ["product_id"]=> string(5) "15326" ["name"]=> string(42) "Сиреневый пиджак Pal Zileri" ["description"]=> string(1818) "<p>Традиционная одежда для любителей классики.&nbsp;Модель прямого кроя. Однобортный пиджак. Застегивается на две пуговицы. Принт &ndash; мелкая клеточка. Сзади две шлицы для большего удобства. Наличие нагрудного и боковых карманов.&nbsp;</p> <p>Классическая мужская одежда.&nbsp;Мужской классический пиджак, в зависимости от создаваемого образа, может выполнять как главную роль, так и вспомогательную. В любом случае &ndash; это функциональная, привлекательная и весьма элегантная вещь, поэтому купить пиджак &ndash; верное решение.&nbsp;</p> <p>Пиджак для мужчины на каждый день.&nbsp;Модель хорошо держит форму; придает своему обладателю дополнительного комфорта; приятный на ощупь; легкий по весу; подходит мужчинам с разным типом фигуры.&nbsp;В теплое время года попробуйте такое сочетание: брюки, рубашка и пиджак. В более прохладную &ndash; добавьте классическое пальто. Все это и еще больший ассортимент ожидает вас в нашем интернет-магазине. Звоните и заказывайте!&nbsp;</p> " ["characteristics"]=> string(428) "<ul> <li>Модель: мужской;</li> <li>Фасон: классический;</li> <li>Цвет: серый;</li> <li>Принт: в клетку;</li> <li>Материал: полиамид 98%, шелк 2%;</li> <li>Сезонность: внесезонный;</li> <li>Бренд: Pal Zileri.</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(165) "пиджак, однобортный, мужской пиджак, непарный мужской пиджак, демисезонный мужской пиджак" ["model"]=> string(5) "15326" ["sku"]=> string(15) "OP2I03S-2 58313" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(58) "catalog/dn8/fotosessija/2020/mart/muzhskaja_3/img_7923.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(10) "12900.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(1) "8" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-19 16:23:12" ["viewed"]=> string(3) "852" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "316" [3]=> string(3) "437" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16674]=> array(49) { ["product_id"]=> string(5) "16674" ["name"]=> string(55) "Брюки бежевые льняные Pal Zileri LAB" ["description"]=> string(1073) "<p>Брюки на кулиске Pal Zileri Lab цвета неокрашенного льна.</p> <p>Подходят для большинства типов фигур, благодаря средней посадке, чуть зауженному крою. Брючины без защипов и&nbsp; подкладки, ширина по низу 18 см. Три врезных кармана: два боковых и один задний. Пояс подрезинен, застежка на кулиску.</p> <p>Состав 100% лен, максимально комфортный в теплое время года.</p> <p>Брюки на кулиске &nbsp;Pal Zileri Lab &nbsp;комбинируются с рубашками, поло и т.п. Модель подходит для летних образов в кэжуал&nbsp; и &nbsp;спорт кэжуал стилях.</p> <p>Желаем удачного шопинга вместе с DN8!</p> " ["characteristics"]=> string(710) "<ul> <li>Код товара:16674</li> <li>Артикул: QP1NH236 C2542 37</li> <li>Бренд: Pal Zileri Lab</li> <li>Страна: Италия</li> <li>Цвет: бежевый</li> <li>Рисунок: без рисунка</li> <li>Сезон: лето</li> <li>Материал: лен 100%</li> <li>Количество карманов: три</li> <li>Тип застежки: кулиска</li> <li>Параметры модели: 102-84-99, рост 185 см</li> <li>На модели надет: 48</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(219) "штаны, брюки, мужские штаны, мужские брюки, светлые мужские брюки, светлые штаны для мужчин, летние брюки, лльняные брюки" ["model"]=> string(5) "16674" ["sku"]=> string(17) "QP1NH236 C2542 37" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/2_etazh_muzhskoe/img_4522-ds.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(9) "6980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-16" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "8" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-16 11:23:36" ["date_modified"]=> string(19) "2021-07-13 11:33:16" ["viewed"]=> string(3) "901" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "272" [3]=> string(3) "275" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14843]=> array(49) { ["product_id"]=> string(5) "14843" ["name"]=> string(68) "Голубые джинсы широкого кроя Pal Zileri LAB" ["description"]=> string(1459) "<p>Голубые джинсы Pal Zileri Lab, стилизованные под &laquo;брюки с кулиской&raquo;.</p> <p>Подходят для большинства типов фигур, благодаря средней посадке и свободному крою. Ширина брючины по низу 21 см. Пояс подрезинен. Комбинированная застежка на молнию YKK , брендированный &laquo;болт&raquo; (пуговицу заклепку), кулиску. Пять карманов: два боковых, два задних и карман для монет.</p> <p>Сшиты из санфоризированного&nbsp; денима, состав хлопок 100%, светло голубого цвета. Джинсы максимально комфортны в теплое время года.</p> <p>Голубые джинсы с кулиской Pal Zileri Lab хорошо сочетаются с летней одеждой в стиле&nbsp;кэжуал: футболками, рубашками, поло и т.п.</p> <ul> </ul> <p>Купить&nbsp;голубые джинсы широкого кроя Pal Zileri LAB можно через сайт или сделать заказ по телефону +38 (067) 510-28-88.</p> " ["characteristics"]=> string(651) "<ul> <li>Код товара: 14843</li> <li>Артикул: OP1DH238 54553</li> <li>Бренд: Pal Zileri Lab</li> <li>Страна: Италия</li> <li>Цвет: голубой</li> <li>Рисунок: без рисунка</li> <li>Сезон: вне сезона</li> <li>Материал: хлопок 100%</li> <li>Количество карманов: пять</li> <li>Тип застежки: кулиска, молния, пуговицы</li> </ul> <p>&nbsp;</p> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(13) " Джинсы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14843" ["sku"]=> string(14) "OP1DH238 54553" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(42) "catalog/campaignss2019/2etazh/ao6b5119.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(9) "5900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-04-08" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "8" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-04-08 13:27:21" ["date_modified"]=> string(19) "2021-08-25 16:39:31" ["viewed"]=> string(3) "726" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "272" [3]=> string(3) "522" [4]=> string(3) "530" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16673]=> array(49) { ["product_id"]=> string(5) "16673" ["name"]=> string(53) "Черные льняные брюки Pal Zileri LAB" ["description"]=> string(1108) "<p>Льняные брюки на кулиске Pal Zileri Lab черного цвета.</p> <p>Подходят для большинства типов фигур, благодаря средней посадке и прямому крою. Брючины без защипов и&nbsp; подкладки, ширина по низу 18 см. Три врезных кармана: два боковых и один задний. Пояс подрезинен, застежка на кулиску.</p> <p>Состав 100% лен, максимально комфортный в теплое время года.</p> <p>Брюки на кулиске &nbsp;Pal Zileri Lab &nbsp;комбинируются с рубашками, поло и т.п. Модель подходит для летних образов в кэжуал&nbsp; и &nbsp;спорт кэжуал стилях.</p> <p>Преобрести эту модель вы можете прямо сейчас у нас на сайте.&nbsp;</p> " ["characteristics"]=> string(704) "<ul> <li>Код товара: 16673</li> <li>Артикул: QP1NH236 C2542 01</li> <li>Бренд: Pal Zileri Lab</li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Рисунок: без рисунка</li> <li>Сезон: лето</li> <li>Материал: лен 100%</li> <li>Количество карманов: три</li> <li>Тип застежки: кулиска</li> <li>Параметры модели: 102-84-99, рост 185</li> <li>На модели надет: 48</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(170) "Брюки мужские, брюки мужские, легкие штаны, летние штаны, льняные штаны, мужские штаны на лето" ["model"]=> string(5) "16673" ["sku"]=> string(17) "QP1NH236 C2542 01" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/2_etazh_muzhskoe/img_4557-ds.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(9) "6980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-16" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "5" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-16 11:23:36" ["date_modified"]=> string(19) "2021-07-29 14:20:29" ["viewed"]=> string(3) "782" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "272" [3]=> string(3) "275" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14839]=> array(49) { ["product_id"]=> string(5) "14839" ["name"]=> string(72) "Футболка мужская черного цвета Pal Zileri LAB" ["description"]=> string(1754) "<p>Стильная и строгая модель мужской летней футболки в сдержанном цвете из потрясающе мягкого материала.&nbsp;</p> <p>Мужская футболка <a href="https://dn8.ua/pal-zileri-lab">PAL ZILERI LAB</a> c коротким рукавом и классическим круглым вырезом. Низ футболки сделан с довязом (резинкой), который улучшает посадку.</p> <p>Футболка сшита из трикотажа в составе 70% шелк, 30% хлопок обладающего улучшенными тепло- и пароотводящими свойствами. Классический черный цвет.</p> <p>Универсальная базовая модель, подходит для летних образов в кэжуал стилях, хорошо сочетается с трикотажем и денимом.</p> <p>Если вы ищете подходящий вариант на каждый день &ndash; для прогулок, на работу или на встречу с друзьями &ndash; обратите внимание на это удобное, стильное и практичное изделие. Заполучив его в свой гардероб, мужчине не будет необходимости терять время на подбор вещей.</p> <p>Купить футболку мужскую черного цвета Pal Zileri LAB в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(539) "<ul> <li>Код товара: 14839</li> <li>Артикул: OPM0M550 58622</li> <li>Бренд: <a href="https://dn8.ua/pal-zileri-lab">PAL ZILERI LAB</a></li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Рисунок: без рисунка</li> <li>Материал: 70% шелк, 30% хлопок</li> <li>Длина рукава: короткий</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14839" ["sku"]=> string(17) "OPM0M550 58622 16" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2021/mart/muzhskaja/img_9314-ds-1500px.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(9) "4900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:30:11" ["date_modified"]=> string(19) "2021-07-01 11:43:58" ["viewed"]=> string(3) "313" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14838]=> array(49) { ["product_id"]=> string(5) "14838" ["name"]=> string(75) "Футболка мужская синяя из хлопка Pal Zileri LAB" ["description"]=> string(1498) "<p>Строгая, неброская и очень стильная модель мужской летней футболки.&nbsp;</p> <p>Мужская футболка <a href="https://dn8.ua/pal-zileri-lab">PAL ZILERI LAB</a> c коротким рукавом и классическим круглым вырезом. Низ футболки сделан с довязом (резинкой), который улучшает посадку.</p> <p>Футболка сшита из трикотажа, 100% &nbsp;хлопок темно синего цвета. Особенность модели контрастные полоски по краю выреза воротника и краям рукавов.</p> <p>Модель, подходит для летних образов в кэжуал стилях, хорошо сочетается с трикотажем и денимом.</p> <p>Если вы ищете подходящий вариант на каждый день &ndash; для прогулок, на работу или на встречу с&nbsp;друзьями &ndash; обратите внимание на это удобное, стильное и практичное изделие.</p> <p>Купить футболку мужскую синюю из хлопка Pal Zileri LAB в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(675) "<ul> <li>Код товара: 14838</li> <li>Артикул: OPM0M550 58620</li> <li>Бренд: <a href="https://dn8.ua/pal-zileri-lab">PAL ZILERI LAB</a></li> <li>Страна: Италия</li> <li>Цвет: темно синий</li> <li>Рисунок: без рисунка</li> <li>Материал: 100% хлопок</li> <li>Длина рукава: короткий</li> <li>Параметры модели: 102-84-99, рост 185 см</li> <li>На модели надет: M</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14838" ["sku"]=> string(14) "OPM0M550 58620" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2021/mart/muzhskaja/img_9351-ds-1500px.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(9) "3500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:30:11" ["date_modified"]=> string(19) "2021-07-01 11:46:15" ["viewed"]=> string(3) "295" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13228]=> array(49) { ["product_id"]=> string(5) "13228" ["name"]=> string(86) "Футболка мужская белая с серым принтом Pal Zileri LAB" ["description"]=> string(1462) "<p>Мужская футболка <a href="https://dn8.ua/pal-zileri-lab">PAL ZILERI LAB</a> c коротким рукавом и классическим круглым вырезом.</p> <p>Футболка сшита из трикотажа, 100%&nbsp; хлопок. Верхняя половина передней части модели, украшена абстрактным геометрическим принтом серого цвета.</p> <p>Модель, подходит для летних образов в кэжуал стилях, хорошо сочетается с трикотажем и денимом.</p> <p>Базовая футболка из натурального хлопка &ndash; легкая и &laquo;дышащая&raquo;. Прекрасное решение для сезона весна-лето.&nbsp;</p> <p>Стирать при минимальной температуре 30&deg;С, не отбеливать, не сушить в стиральной машине, максимальная температура глажки 110&deg;С &ndash; без пара, не поддавать химчистке.</p> <p>Купить футболку мужскую белую с серым принтом Pal Zileri LAB в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(652) "<ul> <li>Код товара: 13228</li> <li>Артикул: MPMJF557 38604</li> <li>Бренд: <a href="https://dn8.ua/pal-zileri-lab">PAL ZILERI LAB</a></li> <li>Страна: Италия</li> <li>Цвет: белый</li> <li>Рисунок: принт</li> <li>Материал:100% хлопок</li> <li>Длина рукава: короткий</li> <li>Параметры модели: 102-84-99, рост 185 см</li> <li>На модели надет: M</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "13228" ["sku"]=> string(14) "MPMJF557 38604" ["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(66) "catalog/dn8/fotosessija/2021/mart/muzhskaja/img_9172-ds-1500px.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(9) "3500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:23:27" ["date_modified"]=> string(19) "2021-07-01 11:56:53" ["viewed"]=> string(3) "283" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1983) "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 = '102' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }