Мужские классические костюмы

array(12) { [15324]=> array(49) { ["product_id"]=> string(5) "15324" ["name"]=> string(81) "Костюм мужской однобортный в клетку Pal Zileri LAB" ["description"]=> string(843) "<p>Стильный мужской костюм серого цвета в клетку от итальянского бренда Pal Zileri LAB. Состоит из брюк и пиджака. Подойдет для деловых встреч и совещаний.<br /> Пиджак однобортный, застегивается на 2 черные пуговицы круглой формы, современная посадка, карманы с клапанами, на рукавах по 4 пуговицы в ряд, брюки со стрелками.</p> <p>Купить костюм мужской однобортный в клетку Pal Zileri LAB можно прямо сейчас в интернет-магазине dn8.ua. DN8: мы любим наших клиентов!</p> " ["characteristics"]=> string(518) "<ul> <li>Код товара:&nbsp;15324</li> <li>Артикул:&nbsp;OP3906092 58257</li> <li>Цвет: серый</li> <li>Рисунок: клетка</li> <li>Сезон: весна-лето</li> <li>Материал: верх - лен 100%, подкладка - вискоза 100%</li> <li>Бренд: 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) "15324" ["sku"]=> string(15) "OP3906092 58257" ["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/2021/mart/muzhskaja/img_9517-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(10) "19900.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(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:23:27" ["date_modified"]=> string(19) "2022-02-15 15:44:27" ["viewed"]=> string(3) "529" ["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(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [2586]=> array(49) { ["product_id"]=> string(4) "2586" ["name"]=> string(38) "Мужской костюм Carl Gross" ["description"]=> string(825) "<p>Бескомпромиссный стиль и неповторимое качество &ndash; это лишь часть преимуществ, которые вы получаете, решив купить мужской костюм Carl Gross. Костюм состоит из пиджака и брюк, стандартная посадка, хорошее качество материала, приятный глазу цвет. Летне-весенний вариант. Деловые встречи, собрание акционеров вполне могут стать причиной для приобретения хорошего костюма.</p> <p>Купить мужской костюм Carl Gross в интернет-магазине dn8.ua.&nbsp;</p> " ["characteristics"]=> string(543) "<ul> <li>Код товара: 2586</li> <li>Артикул: 31-008N0/61</li> <li>Бренд: Carl Gross</li> <li>Страна: Германия</li> <li>Цвет: серый</li> <li>Рисунок: однотонный</li> <li>Материал: верх - хлопок 100%; подкладка - ацетат 52%, вискоза 48%</li> <li>Параметры модели: 102-84-99, рост 185 см</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(136) "Мужской, костюм, Carl Gross, классический, классика, голубой, синий, праздничный" ["model"]=> string(4) "2586" ["sku"]=> string(11) "31-008N0/61" ["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(66) "catalog/dn8/fotosessija/2021/mart/muzhskaja/img_9547-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "60" ["manufacturer"]=> string(10) "Carl Gross" ["manufacturer_size_table"]=> string(759) "<p>Внимание! Линия CG маломерит</p> <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>Carl Gross</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> " ["price"]=> string(9) "8900.0000" ["special"]=> string(9) "2670.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-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(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-19 15:44:31" ["date_modified"]=> string(19) "2021-11-02 09:58:12" ["viewed"]=> string(3) "626" ["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(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [2610]=> array(49) { ["product_id"]=> string(4) "2610" ["name"]=> string(49) "Костюм мужской серый Carl Gross" ["description"]=> string(960) "<p>Современная посадка, великолепное сочетание материалов, актуальный и немаркий цвет. Базовый набор &ndash; брюки и пиджак. Хороший вариант для сезона осень-зима, так как в составе есть шерсть и мохер</p> <p>Классический серый цвет &ndash; внесезонная и вневременная классика. Модель в комфортном полуприталенном силуэте. &nbsp;Однобортный пиджак с застежкой на две пуговицы и с двумя шлицами. Брюки со средней посадкой, без защипов.</p> <p>Костюм оптимально подходит для образов в деловом и офисных стилях.</p> " ["characteristics"]=> string(591) "<ul> <li>Цвет: серый;</li> <li>Рисунок: однотонный;</li> <li>Сезон: осень-зима;</li> <li>Верх - шерсть 48%, мохер 37%, шелк 15%; подкладка - вискоза 60%, полиэстер 40%;</li> <li>Параметры модели: 102-84-99, рост 185 см;</li> <li>На модели надет: 50</li> <li>Бренд: Carl Gross;</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(122) "Костюм, мужской, серый, Carl Gross, классика, классический, брюки, пиджак" ["model"]=> string(4) "2610" ["sku"]=> string(11) "61-077NO 81" ["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_9532-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "60" ["manufacturer"]=> string(10) "Carl Gross" ["manufacturer_size_table"]=> string(759) "<p>Внимание! Линия CG маломерит</p> <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>Carl Gross</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) "19900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-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(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-19 15:44:31" ["date_modified"]=> string(19) "2021-12-02 10:12:15" ["viewed"]=> string(3) "492" ["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(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [2565]=> array(49) { ["product_id"]=> string(4) "2565" ["name"]=> string(51) "Костюм-двойка мужской Carl Gross" ["description"]=> string(942) "<p>Стильный однотонный мужской костюм синего цвета от немецкого бренда Carl Gross. Состоит из брюк и пиджака. Подойдет для деловых встреч и совещаний.<br /> Пиджак однобортный, застегивается на 2 пуговицы, отложной воротник, силуэт приталенный, современная посадка, карманы с клапанами, есть нагрудный карман.&nbsp;Брюки без защипа,&nbsp;со стрелками, посадка&nbsp;&nbsp;средняя, классического кроя.</p> <p>Купить костюм-двойка мужской Carl Gross можно прямо сейчас в интернет-магазине dn8.ua. Удачных покупок в DN8!</p> " ["characteristics"]=> string(611) "<ul> <li>Код товара:&nbsp;2565</li> <li>Артикул:&nbsp;61-045S1 61</li> <li>Цвет: синий</li> <li>Рисунок: нет</li> <li>Сезон: осень-зима</li> <li>Материал:&nbsp;верх-шерсть 100%, подкл.- вискоза 60%, полиэстер 40%</li> <li>Бренд:&nbsp;Carl Gross</li> <li>Страна бренда: Германия</li> <li>На модели:&nbsp;размер 50</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(38) "Костюм мужской Carl Gross" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Костюм" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(135) "костюм, мужской, двойка, синего цвета, однобортный, на две пуговицы, синий " ["model"]=> string(4) "2565" ["sku"]=> string(11) "61-045S1 61" ["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(38) "data/1c/utp005424_catalog_820f9055.JPG" ["manufacturer_id"]=> string(2) "60" ["manufacturer"]=> string(10) "Carl Gross" ["manufacturer_size_table"]=> string(759) "<p>Внимание! Линия CG маломерит</p> <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>Carl Gross</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) "16500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2017-08-31" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-19 15:11:10" ["viewed"]=> string(4) "1479" ["categories"]=> array(4) { [0]=> string(2) "85" [1]=> string(3) "288" [2]=> string(3) "439" [3]=> string(3) "440" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11702]=> array(49) { ["product_id"]=> string(5) "11702" ["name"]=> string(39) "Костюм серого цвета CG" ["description"]=> string(1010) "<p>Стильный однотонный мужской костюм светло-серого цвета от немецкого&nbsp;бренда Carl Gross. Состоит из брюк и пиджака. Подойдет для деловых встреч и совещаний.<br /> Пиджак однобортный, застегивается на 2 круглые пуговицы, силуэт приталенный, боковые карманы с клапанами, есть нагрудный карманчик, на рукавах по 4 пуговицы в ряд. Брюки без защипа,&nbsp;со стрелками, посадка&nbsp;&nbsp;средняя, классического кроя.</p> <p>Купить костюм серого цвета CG можно прямо сейчас в интернет-магазине dn8.ua. DN8: для нас важен каждый, кто заходит на наш сайт!</p> " ["characteristics"]=> string(657) "<ul> <li>Код товара:&nbsp;11702</li> <li>Артикул:&nbsp;60-105N1</li> <li>Цвет: серый</li> <li>Рисунок: нет</li> <li>Сезон: весна-лето</li> <li>Материал:&nbsp;верх - шерсть&nbsp;100%; подкл. - ацетат 52%, вискоза 48%</li> <li>Бренд:&nbsp;CG</li> <li>Страна бренда: Германия</li> <li>Стиль: деловой</li> <li>На модели:&nbsp;размер 50</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(17) "Костюм C.G." ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Костюм" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11702" ["sku"]=> string(8) "60-105N1" ["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(51) "data/1c/utp008679_catalog_myjskoe_june_dsc09662.JPG" ["manufacturer_id"]=> string(2) "60" ["manufacturer"]=> string(10) "Carl Gross" ["manufacturer_size_table"]=> string(759) "<p>Внимание! Линия CG маломерит</p> <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>Carl Gross</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) "15990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-19 15:08:16" ["viewed"]=> string(4) "2195" ["categories"]=> array(4) { [0]=> string(2) "85" [1]=> string(3) "288" [2]=> string(3) "439" [3]=> string(3) "440" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13527]=> array(49) { ["product_id"]=> string(5) "13527" ["name"]=> string(43) "Костюм однобортный Cadini " ["description"]=> string(721) "<p>Костюм в клетку, который станет основой для создания образа в деловом стиле.</p> <p>Присмотритесь ближе и вам удастся рассмотреть ненавязчивый принт-клетка. Строго и со вкусом. Состоит из пиджака и брюк.</p> <p>Карман для платка, застежка на пуговицы, карманы с клапанами, классический крой, полуприталенный силуэт с четкими линиями, пиджак однобортный, брюки со стрелками.</p> " ["characteristics"]=> string(397) "<ul> <li>Цвет: синий;</li> <li>Рисунок: клетка;</li> <li>Сезон: осень-зима;</li> <li>Материал: верх - шерсть 100%, подкладка - ацетат 100%;</li> <li>Бренд: Cadini;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(61) "Костюм классический в клетку Cadini " ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Костюм" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(161) "Костюм, однобортный, на две пуговицы, синий, в крупную клетку, в клетку, Cadini, классический" ["model"]=> string(5) "13527" ["sku"]=> string(12) "487 972 2 6R" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "6" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(30) "catalog/foto15-16/ao6b5951.jpg" ["manufacturer_id"]=> string(2) "75" ["manufacturer"]=> string(7) "Cadini " ["manufacturer_size_table"]=> string(682) "<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>Cadini</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) "22200.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(5) ["reviews"]=> string(1) "1" ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-12-10 10:34:16" ["viewed"]=> string(4) "1463" ["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(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14707]=> array(49) { ["product_id"]=> string(5) "14707" ["name"]=> string(62) "Костюм мужской серый в клетку Cadini " ["description"]=> string(1294) "<p>Костюм мужской однобортный серого цвета в фиолетовую клетку Cadini, полу приталенный силуэт. Подходит для деловых встреч, официальных мероприятий и формальных событий с нестрогим дресс-кодом.&nbsp;</p> <p>Пиджак однобортный на 2 пуговицы. Отложной воротник с длинными лацканами прямоугольной формы. Декоративная петля, косой нагрудный карман с листочкой. На уровне талии карманы с клапаном. 2 шлицы. На рукавах по 4 пуговицы.</p> <p>Брюки в классическом стиле с заутюженными стрелками, боковые карманы.</p> <p>Приобрести костюм мужской однобортный&nbsp; серого цвета в фиолетовую клетку Cadini вы можете в нашем магазине, оформив заказ через сайт или по телефону. Желаем удачных покупок!</p> " ["characteristics"]=> string(684) "<ul> <li>Модель: мужской однобортный костюм (двойка);</li> <li>Фасон: полуприталенный костюм с чехлом;</li> <li>Цвет: серый, фиолетовый;</li> <li>Узор: крупная клетка;</li> <li>Состав верха: шерсть 100%;</li> <li>Подкладка: вискоза 100%;</li> <li>Сезонность: весна-лето-осень;</li> <li>Бренд: Cadini (Кадини);</li> <li>Страна бренда: Италия.</li> </ul> " ["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(107) "Костюм, мужской, однобортный, серого цвета, в клеточку, Cadini " ["model"]=> string(5) "14707" ["sku"]=> string(13) "K1006 C222121" ["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(51) "catalog/fotosessijasmodeljami_ijun2019/ao6b0741.jpg" ["manufacturer_id"]=> string(2) "75" ["manufacturer"]=> string(7) "Cadini " ["manufacturer_size_table"]=> string(682) "<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>Cadini</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) "23900.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(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-12-01 16:48:19" ["viewed"]=> string(4) "1241" ["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(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14705]=> array(49) { ["product_id"]=> string(5) "14705" ["name"]=> string(45) "Костюм мужской серый Cadini" ["description"]=> string(1095) "<p>Костюм мужской однобортный серый в мелкую клетку Cadini подходит для офиса, деловых встреч и формальных мероприятий. Пиджак однобортный с отложным воротником и прямоугольными лацканами. На левом лацкане петля. Нагрудный карман с листочкой. Прорезные карманы с клапаном на уровне талии. Приталенная модель. Две шлицы. Брюки классического кроя с заутюженными стрелками. Карманы в боковых швах. Ткань костюмная, хорошо держит форму.</p> <ul> </ul> <p>Купить костюм мужской однобортный серый в мелкую клетку Cadini можете в нашем магазине, оформив заказ по телефону или через сайт.&nbsp;</p> " ["characteristics"]=> string(523) "<ul> <li>Модель: мужской однобортный костюм;</li> <li>Силуэт: приталенный;</li> <li>Цвет: серый;</li> <li>Узор: клетка;</li> <li>Материал верха: шерсть 100%;</li> <li>Подкладка: вискоза 100%;</li> <li>Бренд: Cadini (Кадини);</li> <li>Производство: Италия.</li> </ul> " ["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(102) "Костюм, мужской, однобортный, серый, в мелкую клетку, Cadini" ["model"]=> string(5) "14705" ["sku"]=> string(13) "K1015 C222121" ["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(48) "catalog/aproduct/folder-2/ao6b5351-1000x1500.jpg" ["manufacturer_id"]=> string(2) "75" ["manufacturer"]=> string(7) "Cadini " ["manufacturer_size_table"]=> string(682) "<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>Cadini</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) "22900.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(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-12-01 16:47:34" ["viewed"]=> string(4) "1709" ["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(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16834]=> array(49) { ["product_id"]=> string(5) "16834" ["name"]=> string(85) "Костюм мужской классический темно-синий Carl Gross" ["description"]=> string(3428) "<p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Легкий</span> <span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">летний костюм-двойка Carl</span> <span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Gross для теплого сезона.</span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Сшит <strong>из облегченной шерстяной ткани</strong> Filli</span> <span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Cerruti 1881.</span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Застежка на роговые пуговицы.</span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Классический синий цвет &ndash; <strong>внесезонная и вневременная классика</strong>.</span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Модель в комфортном полуприталенном силуэте.</span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Однобортный пиджак с застежкой на две пуговицы и двумя шлицами сшит на полной подкладке.</span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Брюки со средней посадкой, без защипов.</span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Костюм оптимально подходит для образов в деловом и офисных стилях.</span></span></span></p> " ["characteristics"]=> string(947) "<ul> <li>Код товара: 16834</li> <li>Артикул: 70-061S0-63</li> </ul> <ul> <li>Бренд: Carl Gross</li> <li>Страна: Германия</li> </ul> <ul> <li>Цвет: синий</li> <li>Рисунок: однотонный</li> <li>Сезон: весна-лето</li> <li>Материал лицевой стороны: шерсть 100%&nbsp;</li> <li>Материал подкладки: вискоза 51%, ацетат&nbsp;49%</li> <li>Застежка пиджака: на две пуговицы</li> <li>Модель: Tailor Fit&nbsp;</li> <li>Параметры модели:&nbsp;102-84-99, рост 185 см&nbsp;</li> <li>На модели надет: 50</li> </ul> " ["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(115) "Костюм, мужской, классический, темно-синий, синий, купить, Carl Gross" ["model"]=> string(5) "16834" ["sku"]=> string(11) "70-061S0-63" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(2) "10" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/2_etazh_muzhskoe/img_4750-ds.jpg" ["manufacturer_id"]=> string(2) "60" ["manufacturer"]=> string(10) "Carl Gross" ["manufacturer_size_table"]=> string(759) "<p>Внимание! Линия CG маломерит</p> <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>Carl Gross</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) "20500.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(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-12-14 15:26:30" ["viewed"]=> string(4) "2185" ["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(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16837]=> array(49) { ["product_id"]=> string(5) "16837" ["name"]=> string(63) "Костюм мужской классический Carl Gross" ["description"]=> string(3645) "<p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Легкий, летний костюм-двойка Carl</span></span> <span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Gross для теплого сезона.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Сшит из облегченной шерстяной ткани производства REDA 1865.</span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><strong><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Пуговицы из натурального рога.</span></strong></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Классический синий цвет и неформальная коричневая клетка идеально подходят для летнего образа <strong>в современном европейском стиле</strong>.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Модель в комфортном полуприталенном силуэте.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Однобортный пиджак с застежкой на две пуговицы и двумя шлицами сшит на полной подкладке.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Брюки со средней посадкой, без защипов.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Костюм актуален для комбинирования повседневных офисных образов.</span></span></span></p> " ["characteristics"]=> string(896) "<ul> <li>Код товара: 16837</li> <li>Артикул: 01.146N3-62</li> </ul> <ul> <li>Бренд: Carl Gross</li> <li>Страна: Гемания</li> </ul> <ul> <li>Цвет: синий</li> <li>Рисунок: клетка</li> <li>Сезон: весна-лето</li> <li>Материал лицевой стороны: 100% шерсть&nbsp;</li> <li>Материал подкладки: 100% вискоза</li> <li>Застежка пиджака: две пуговицы</li> <li>Модель: Tailor Fit</li> <li>Параметры модели:&nbsp;102-84-99, рост 185 см&nbsp;</li> <li>На модели надет: 50</li> </ul> " ["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(199) "Пиджак, мужской, однобортный, пуговицы, стильный, классический, брендовый, Carl Gross, костюм, брюки, классический " ["model"]=> string(5) "16837" ["sku"]=> string(11) "01.146N3-62" ["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/2020/ijul/2_etazh_muzhskoe/img_4744-ds.jpg" ["manufacturer_id"]=> string(2) "60" ["manufacturer"]=> string(10) "Carl Gross" ["manufacturer_size_table"]=> string(759) "<p>Внимание! Линия CG маломерит</p> <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>Carl Gross</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) "20900.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(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-12-01 16:48:46" ["viewed"]=> string(4) "2309" ["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(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16836]=> array(49) { ["product_id"]=> string(5) "16836" ["name"]=> string(66) "Костюм мужской голубого цвета Carl Gross" ["description"]=> string(5091) "<p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Легкий</span></span> <span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">летний костюм-двойка Carl</span></span> <span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Gross для теплого сезона.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Сшит из смесовой ткани, в составе которой 70% шерсти и 30%</span></span> <span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">льна.</span></span> </span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Благодаря льну в составе, <strong>материал обладает повышенной комфортностью</strong> летом, а шерсть меньше мнется.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Пуговицы из натурального рога.</span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Голубой меланж идеально сочетается с большинством летних оттенков. </span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Модель в комфортном полуприталенном силуэте.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Однобортный пиджак с застежкой на две пуговицы и двумя шлицами сшит на полной подкладке.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Брюки со средней посадкой, без защипов.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">Костюм идеально <strong>подход</strong></span></span><strong><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">и</span></span></strong><strong><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">т для неформального летнего образа</span></span></strong><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;"><span style="color:black">.</span></span></span></span></p> " ["characteristics"]=> string(920) "<ul> <li>Код товара: 16836</li> <li>Артикул: 01.105N0-61</li> </ul> <ul> <li>Бренд: Carl Gross</li> <li>Страна: Германия</li> </ul> <ul> <li>Цвет: голубой</li> <li>Рисунок: меланж</li> <li>Сезон: весна-лето</li> <li>Материал лицевой стороны: шерсть 70%, лен 30%</li> <li>Материал подкладки: вискоза 51%, ацетат 49%</li> <li>Застежка пиджака: две пуговицы</li> <li>Модель: Tailor fit</li> <li>Параметры модели:&nbsp;102-84-99, рост 185 см&nbsp;</li> <li>На модели надет: 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(130) "Костюм, мужской, пиджак, брюки, голубой, Carl Gross, бренд, стильный, выходной" ["model"]=> string(5) "16836" ["sku"]=> string(11) "01.105N0-61" ["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_9561-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "60" ["manufacturer"]=> string(10) "Carl Gross" ["manufacturer_size_table"]=> string(759) "<p>Внимание! Линия CG маломерит</p> <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>Carl Gross</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) "16500.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(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2022-02-15 15:30:27" ["viewed"]=> string(4) "1218" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "288" [3]=> string(3) "439" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16833]=> array(49) { ["product_id"]=> string(5) "16833" ["name"]=> string(69) "Костюм мужской в крупную клетку Carl Gross" ["description"]=> string(1087) "<p>Легкий, летний костюм-двойка Club of Gents (линия Carl Gross) для теплого сезона.</p> <p>Сшит из облегченной шерстяной ткани производства Lanificio T.G. di Fabio.</p> <p>Пуговицы из натурального рога.</p> <p>Светло-серый цвет и элегантная синяя клетка идеально подходят для летнего образа.</p> <p>Модель сшита в актуальном приталенном&nbsp;силуэте.</p> <p>Однобортный пиджак с застежкой на две пуговицы и двумя шлицами выполнен на полной подкладке.</p> <p>Брюки со средней посадкой, без защипов.</p> <p>Костюм актуален для комбинирования неформальных офисных образов.</p> " ["characteristics"]=> string(771) "<ul> <li>Код товара: 16833</li> <li>Артикул: 01.036S3-81</li> <li>Бренд: Club of Gents</li> <li>Страна: Германия</li> <li>Цвет: серый</li> <li>Сезон: весна-лето</li> <li>Материал лицевой стороны: 100% шерсть</li> <li>Материал подкладки: 100% ацетат</li> <li>Застежка пиджака: две&nbsp;пуговицы</li> <li>Модель: Slim Fit</li> <li>Параметры модели: 102-84-99, рост 185 см</li> <li>На модели надет: 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(188) "Костюм, мужской, серый, в крупную клеточку, клеточка, классический, модный, праздничный, выходной, Carl Gross" ["model"]=> string(5) "16833" ["sku"]=> string(11) "01.036S3-81" ["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/2021/mart/muzhskaja/img_9582-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "60" ["manufacturer"]=> string(10) "Carl Gross" ["manufacturer_size_table"]=> string(759) "<p>Внимание! Линия CG маломерит</p> <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>Carl Gross</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) "17980.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(3) "500" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2022-02-15 15:31:21" ["viewed"]=> string(4) "1605" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "288" [3]=> string(3) "439" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '439' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }