Pal Zileri LAB

array(12) { [16669]=> array(49) { ["product_id"]=> string(5) "16669" ["name"]=> string(38) "Шорты черные Pal Zileri LAB" ["description"]=> string(783) "<p>Комфортная средняя посадка, классический силуэт. Брючины с 1 защипом, длина до колена.</p> <p>Шорты сшиты из смесовой ткани: хлопок 70%, полиэстер 30%. Хлопок придает ткани комфорт в теплое время, а синтетические волокна снижают изминаемость и упрощают уход.</p> <p>Цвет &ndash; черный.&nbsp;Хорошо комбинируются с одеждой в стиле кэжуал.</p> <p>Купить шорты черные Pal Zileri LAB на нашем сайте можно прямо сейчас.</p> " ["characteristics"]=> string(622) "<ul> <li>Код товара: 16669</li> <li>Артикул:&nbsp;QP130 M C8170</li> <li>Бренд: Lab Pal Zileri</li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Сезон: весна-лето</li> <li>Материал: хлопок 70%, полиэстер 30%</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(148) "шорты повседневные шорты для офиса, шорты для города, базовые шорты, черные шорты" ["model"]=> string(5) "16669" ["sku"]=> string(13) "QP130 M C8170" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "8" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/2_etazh_muzhskoe/img_4437-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) "6400.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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3000" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-16 11:23:36" ["date_modified"]=> string(19) "2022-02-17 14:02:05" ["viewed"]=> string(3) "793" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "289" [3]=> string(3) "461" } [0]=> string(1920) "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'ORDER BY p.sort_order 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) "7" ["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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2500" ["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) "775" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1920) "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'ORDER BY p.sort_order DESC LIMIT 0,12" } [16666]=> array(49) { ["product_id"]=> string(5) "16666" ["name"]=> string(69) "Футболка мужская трехцветная Pal Zileri Lab" ["description"]=> string(1123) "<p>Футболка Lab Pal Zileri с короткими рукавами и круглым вырезом.&nbsp;Предназначена не для занятий спортом, а для создания образа в спортивном стиле.</p> <p>Уникальный состав ткани - шелк 70% и хлопок 30% - делают футболку максимально комфортной для летнего сезона.</p> <p>Для улучшенной посадки низ футболки выполнен с довязом (резинкой).&nbsp;В дизайне футболки использован колор блок&nbsp; темно-синего, бирюзового и&nbsp;серого цветов.</p> <p>Ворот и рукава украшены бирюзовой и серой полоской.&nbsp;Футболка комбинируются с одеждой в стиле кэжуал и смарт кэжуал, внося спортивный акцент в образ.</p> " ["characteristics"]=> string(616) "<ul> <li>Код товара: 16666</li> <li>Артикул:&nbsp;QPM0M550 C8708</li> </ul> <ul> <li>Бренд: Pal Zileri Lab</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: мультицвет</li> <li>Сезон: весна-лето</li> <li>Материал: шелк 30%, хлопок&nbsp;70%</li> <li>Параметры модели:&nbsp;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(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(156) "Футболка, мужская, трехцветная, из натурального материала, Pal Zileri, летняя, хлопок, шелк" ["model"]=> string(5) "16666" ["sku"]=> string(14) "QPM0M550 C8708" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "9" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/2_etazh_muzhskoe/img_4613-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) "6600.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 15:24:28" ["date_modified"]=> string(19) "2021-12-02 15:34:07" ["viewed"]=> string(3) "880" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1920) "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'ORDER BY p.sort_order DESC LIMIT 0,12" } [16667]=> array(49) { ["product_id"]=> string(5) "16667" ["name"]=> string(73) "Мужская футболка с фотопринтом Pal Zileri LAB" ["description"]=> string(709) "<p>Футболка Lab Pal Zileri с короткими рукавами и круглым вырезом. Предназначена не для занятий спортом, а для создания образа в спортивном стиле.</p> <p>Состав ткани - 100% хлопок. Основной цвет футболки &ndash; белый, украшена мультицветным принтом &laquo;велосипедисты&raquo;.</p> <p>Хорошо комбинируются с одеждой в стиле кэжуал и смарт кэжуал, внося спортивный акцент в образ.</p> " ["characteristics"]=> string(629) "<ul> <li>Код товара: 16667</li> <li>Артикул:&nbsp;QPMJF559 C8731</li> <li>Бренд: Lab Pal Zileri</li> <li>Страна: Италия</li> <li>Цвет: белый</li> <li>Декор: принт</li> <li>Сезон: весна-лето</li> <li>Материал: 100% хлопок</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(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(251) "Футболка на лето, хлопковая футболка, футболка из хлопка, тенниска, облегающая футболка, футболка под костюм, футболка с коротким рукавом" ["model"]=> string(5) "16667" ["sku"]=> string(14) "QPMJF559 C8731" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "9" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/2_etazh_muzhskoe/img_4711-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) "4980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 15:24:28" ["date_modified"]=> string(19) "2021-07-01 12:36:20" ["viewed"]=> string(3) "801" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1920) "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'ORDER BY p.sort_order DESC LIMIT 0,12" } [16668]=> array(49) { ["product_id"]=> string(5) "16668" ["name"]=> string(66) "Футболка мужская хлопковая Pal Zileri Lab " ["description"]=> string(678) "<p>Футболка Lab Pal Zileri с короткими рукавами и круглым вырезом. Предназначена не для занятий спортом, а для создания образа в спортивном стиле.</p> <p>Состав ткани - 100% хлопок. Основной цвет футболки &ndash; белый, украшена черно-белым текстовым принтом &laquo;LAB&raquo;. Хорошо комбинируются с одеждой в стиле кэжуал и смарт кэжуал, внося спортивный акцент в образ.</p> " ["characteristics"]=> string(528) "<ul> <li>Код товара: 16668</li> <li>Артикул: QPMJF569 C8734</li> <li>Бренд: Lab Pal Zileri</li> <li>Страна: Италия</li> <li>Цвет: белый</li> <li>Сезон: весна-лето</li> <li>Материал: хлопок 100%</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(17) "Футболка " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(245) "Футболка на лето, хлопковая футболка, футболка из хлопка, тенниска, облегающая футболка, футболка на пляж, футболка с коротким рукавом" ["model"]=> string(5) "16668" ["sku"]=> string(14) "QPMJF569 C8734" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "9" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/2_etazh_muzhskoe/img_4724-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) "4500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 15:24:28" ["date_modified"]=> string(19) "2021-07-01 14:48:54" ["viewed"]=> string(3) "670" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1920) "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'ORDER BY p.sort_order DESC LIMIT 0,12" } [14840]=> array(49) { ["product_id"]=> string(5) "14840" ["name"]=> string(83) "Футболка мужская с цветочным принтом Pal Zileri Lab" ["description"]=> string(958) "<p>Мужская футболка <a href="https://dn8.ua/pal-zileri-lab">PAL ZILERI LAB</a> c коротким рукавом и классическим круглым вырезом и контрастным нагрудным карманом.</p> <p>Материал 100% хлопок, трикотаж бирюзового цвета в эксклюзивный темно фиолетовый цветочный принт.</p> <p>Модель подходит для летних образов в кэжуал стилях, хорошо сочетается с трикотажем и денимом.</p> <ul> </ul> <p>Купить&nbsp;футболку мужскую серую с&nbsp; цветочным принтом Pal Zileri Lab&nbsp; в нашем магазине можно через сайт или по телефону.</p> " ["characteristics"]=> string(521) "<ul> <li>Код товара: 14840</li> <li>Артикул: OPMJF564 58612</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> </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) "14840" ["sku"]=> string(14) "OPMJF564 58612" ["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(42) "catalog/campaignss2019/2etazh/ao6b5222.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) "4600.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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-04-08 13:27:21" ["date_modified"]=> string(19) "2021-07-02 12:21:31" ["viewed"]=> string(3) "726" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1920) "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'ORDER BY p.sort_order DESC LIMIT 0,12" } [14841]=> array(49) { ["product_id"]=> string(5) "14841" ["name"]=> string(83) "Футболка мужская белая с фотопринтом Pal Zileri Lab" ["description"]=> string(959) "<p>Мужская футболка <a href="https://dn8.ua/pal-zileri-lab">PAL ZILERI LAB</a> c коротким рукавом и классическим круглым вырезом.</p> <p>Материал 100% хлопок, джерси (трикотаж) белого цвета. Особенность модели эксклюзивный принт, состоящий из колор-блока голубого цвета и стилизованного рисунка цветка лилии.</p> <p>Модель подходит для летних образов в кэжуал стилях, хорошо сочетается с трикотажем и денимом.</p> <p>Заказать футболку&nbsp;мужскую&nbsp;белую&nbsp;с фотопринтом Pal Zileri Lab в интернет-магазине dn8.ua.&nbsp;</p> " ["characteristics"]=> string(513) "<ul> <li>Код товара: 14841</li> <li>Артикул: OPMJF565 58615</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> </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) "14841" ["sku"]=> string(14) "OPMJF565 58615" ["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(42) "catalog/campaignss2019/2etazh/ao6b5103.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) "2900.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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-04-08 13:27:21" ["date_modified"]=> string(19) "2021-07-02 12:24:59" ["viewed"]=> string(3) "756" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1920) "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'ORDER BY p.sort_order 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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2500" ["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) "510" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1920) "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'ORDER BY p.sort_order DESC LIMIT 0,12" } [14842]=> array(49) { ["product_id"]=> string(5) "14842" ["name"]=> string(64) "Футболка с принтом мужская Lab Pal Zileri" ["description"]=> string(764) "<p>Мужская футболка <a href="https://dn8.ua/pal-zileri-lab">PAL ZILERI LAB</a> c коротким рукавом и классическим круглым вырезом.</p> <p>Материал 100% хлопок, джерси (трикотаж) белого цвета. Особенность модели эксклюзивный принт, состоящий из колор-блока бирюзового цвета и стилизованного рисунка пальмовой ветви.</p> <p>Модель подходит для летних образов в кэжуал стилях, хорошо сочетается с трикотажем и денимом.</p> " ["characteristics"]=> string(513) "<ul> <li>Код товара: 14842</li> <li>Артикул: OPMJF565 58616</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> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(17) "Футболка " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14842" ["sku"]=> string(14) "OPMJF565 58616" ["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(51) "catalog/fotosessijasmodeljami_ijun2019/ao6b1247.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) "2900.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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-07-08 13:21:45" ["date_modified"]=> string(19) "2021-07-02 11:48:57" ["viewed"]=> string(3) "661" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1920) "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'ORDER BY p.sort_order 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) "6" ["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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:30:11" ["date_modified"]=> string(19) "2022-02-17 16:43:04" ["viewed"]=> string(3) "820" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" [4]=> string(3) "562" } [0]=> string(1920) "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'ORDER BY p.sort_order DESC LIMIT 0,12" } [13230]=> array(49) { ["product_id"]=> string(5) "13230" ["name"]=> string(98) "Футболка мужская белая с абстрактным принтом Pal Zileri LAB" ["description"]=> string(1360) "<p>Мужская футболка с абстрактным принтом &ndash; практичная и удобная модель на каждый день. Хорошо садится по фигуре и сохраняет форму после многократной стирки, способствует сохранению свободы движений.</p> <p>Мужская футболка <a href="https://dn8.ua/pal-zileri-lab">PAL ZILERI LAB</a> c коротким рукавом и классическим круглым вырезом.</p> <p>Футболка сшита из трикотажа, 100%&nbsp; хлопок. Модель &nbsp;украшена комбинацией абстрактного и буквенного принтов черного цвета.</p> <p>Модель&nbsp;подходит для летних образов в кэжуал стилях, хорошо сочетается с трикотажем и денимом.</p> <p>Удачное решение для теплого времени года.</p> <p>Купить футболку мужскую белую с абстрактным принтом Pal Zileri LAB в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(653) "<ul> <li>Код товара: 13230</li> <li>Артикул: MPMJF558 38605</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(17) "Футболка " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "13230" ["sku"]=> string(14) "MPMJF558 38605" ["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(66) "catalog/dn8/fotosessija/2021/mart/muzhskaja/img_9177-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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:23:27" ["date_modified"]=> string(19) "2021-07-01 12:01:10" ["viewed"]=> string(3) "573" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1920) "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'ORDER BY p.sort_order DESC LIMIT 0,12" } [13229]=> array(49) { ["product_id"]=> string(5) "13229" ["name"]=> string(69) "Футболка мужская двухцветная Pal Zileri Lab" ["description"]=> string(768) "<p>Мужская футболка <a href="https://dn8.ua/pal-zileri-lab">PAL ZILERI LAB</a> c коротким рукавом и классическим круглым вырезом.</p> <p>Футболка сшита из трикотажа в составе 70% шелк, 30% хлопок обладающего улучшенными тепло и паро отводящими свойствами. Передняя часть футболки белого цвета, а спинка &ndash; серого.</p> <p>Модель, подходит для летних образов в кэжуал стилях, хорошо сочетается с трикотажем и денимом.</p> " ["characteristics"]=> string(548) "<ul> <li>Код товара: 13229</li> <li>Артикул: MPM0M550 38627</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(231) "футболка мужская, демисезонная, футболка с коротким рукавом, красивая футболка, футболка белая, футболка с контрастной спиной" ["model"]=> string(5) "13229" ["sku"]=> string(14) "MPM0M550 38627" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "5" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(58) "catalog/dn8/fotosessija/2020/mart/muzhskaja_2/img_8327.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) "5950.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"]=> int(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-03-18 09:54:50" ["date_modified"]=> string(19) "2021-07-01 14:58:53" ["viewed"]=> string(3) "653" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "291" [3]=> string(3) "445" } [0]=> string(1920) "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'ORDER BY p.sort_order DESC LIMIT 0,12" } }