Горнолыжная одежда

array(10) { [14435]=> array(49) { ["product_id"]=> string(5) "14435" ["name"]=> string(45) "Мужская лыжная куртка RH+" ["description"]=> string(940) "<p>Куртка мужская лыжная RH+ из прочной гладкой ткани. Материал эластичный, с высоким показателем водозащиты и воздухопроницаемости. Фасон приталенный. Специальный крой ткани предотвращает от разрыва во время натяжения. Водонипроницаемые проклеенные плоские швы. Линия плеч прямая, рукава втачные. Манжеты с отверстием для больших пальцев. Линия подола асимметричная.&nbsp;</p> <ul> </ul> <p>Купить куртку мужскую лыжную RH+ можете в нашем магазине, оформив заказ по телефону или через сайт.&nbsp;</p> " ["characteristics"]=> string(521) "<ul> <li>Модель: куртка мужская лыжная;</li> <li>Фасон: приталенный;</li> <li>Цвет: белый, синий;</li> <li>Узор: однотонные;</li> <li>Верх: нейлон 82%; эластен 18%;</li> <li>Подкладка: нейлон 100%;</li> <li>Бренд:&nbsp;RH+;</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) "14435" ["sku"]=> string(11) "INU2679 89C" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(35) "catalog/novinki/1etazh/ao6b1671.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "<p>Мужская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>RH+ (женские штаны, шорты)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "22900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-06" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-05-02 18:14:45" ["viewed"]=> string(3) "932" ["categories"]=> array(11) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "279" [3]=> string(3) "397" [4]=> string(3) "465" [5]=> string(3) "548" [6]=> string(3) "557" [7]=> string(3) "591" [8]=> string(3) "592" [9]=> string(3) "593" [10]=> string(3) "600" } [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 = '600' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3397]=> array(49) { ["product_id"]=> string(4) "3397" ["name"]=> string(39) "Куртка двухцветная RH+" ["description"]=> string(970) "<p>Куртка двухцветная RH+ из прочной гладкой ткани в черного и белого цвета.. Материал эластичный, с высоким показателем водозащиты и воздухопроницаемости. Фасон прямой. Застежка-на молнии. Специальный крой ткани предотвращает от разрыва во время натяжения. Водонипроницаемые проклеенные плоские швы. Линия плеч прямая, рукава втачные. Манжеты с отверстием для больших пальцев. Линия подола ровная.</p> <ul> </ul> <p>Купить куртку мужскую RH+ можете в нашем магазине, оформив заказ по телефону или через сайт.&nbsp;</p> " ["characteristics"]=> string(521) "<ul> <li>Модель: куртка мужская лыжная;</li> <li>Фасон: прямой;</li> <li>Цвет: белый, черный;</li> <li>Узор: однотонные;</li> <li>Верх: полиакрил 88%; спандекс 12%;</li> <li>Подкладка: нейлон 100%;</li> <li>Бренд:&nbsp;RH+;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(20) "Куртка Zero rh" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(13) "Куртка " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "3397" ["sku"]=> string(11) "INU2180-000" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(46) "catalog/dn8/fotosessija/2021/november/3397.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "<p>Мужская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>RH+ (женские штаны, шорты)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "9900.0000" ["special"]=> string(9) "3960.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-30" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-16 16:59:23" ["date_modified"]=> string(19) "2022-05-02 18:04:29" ["viewed"]=> string(4) "1267" ["categories"]=> array(11) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "279" [3]=> string(3) "397" [4]=> string(3) "465" [5]=> string(3) "548" [6]=> string(3) "557" [7]=> string(3) "591" [8]=> string(3) "592" [9]=> string(3) "593" [10]=> string(3) "600" } [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 = '600' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14433]=> array(49) { ["product_id"]=> string(5) "14433" ["name"]=> string(44) "Лыжный синий кардиган RH+" ["description"]=> string(931) "<p>Кардиган мужской лыжный синий&nbsp; RH+ выполнен из тонкой эластичной ткани, фасон прилегающий. Воротник-стойка. Центральная застежка черная молния. Яркий акцент - логотип бренда на левой полочке, на рукаве, на пуллере. Линия плеча прямая. Втачные рукава длиной до запястья с тонкими эластичными манжетами.&nbsp;</p> <ul> </ul> <p>Если вам понравилась модель, вы сможете приобрести кардиган мужской лыжный синий&nbsp; RH+ можете в нашем магазине, оформив заказ по телефону или через сайт.&nbsp;</p> " ["characteristics"]=> string(427) "<ul> <li>Модель: кардиган мужской лыжный;</li> <li>Фасон:&nbsp;tailored fit;</li> <li>Цвет: синий;</li> <li>Узор: нет;</li> <li>Состав: полиэстер 100%;</li> <li>Бренд:&nbsp;RH+;</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) "14433" ["sku"]=> string(11) "INU2734 89G" ["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(35) "catalog/novinki/1etazh/ao6b1684.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "<p>Мужская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>RH+ (женские штаны, шорты)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "3350.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-06" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2200" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-05-02 18:14:00" ["viewed"]=> string(3) "539" ["categories"]=> array(10) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "465" [3]=> string(3) "472" [4]=> string(3) "513" [5]=> string(3) "557" [6]=> string(3) "591" [7]=> string(3) "592" [8]=> string(3) "594" [9]=> string(3) "600" } [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 = '600' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14439]=> array(49) { ["product_id"]=> string(5) "14439" ["name"]=> string(43) "Лыжный белый пуловер RH+" ["description"]=> string(1076) "<p>Пуловер мужской лыжный белый с черными вставками RH+ из гладкого материала обладает высокими свойствами водозащиты и воздухопроницаемости. Стиль спортивный, фасон приталенный, крой прямой. Расцветка классическая. Швы плоские, водонепроницаемые. Центральная черная молния до середины груди. Воротник-стойка утепленный высокий. Рукава укороченные. Акцент - стильные черные полоски, подчеркивающие фигуру.</p> <ul> </ul> <p>Если вам понравилась модель, вы можете заказать пуловер мужской лыжный белый с черными вставками RH+ по телефону или через сайт в нашем магазине.</p> " ["characteristics"]=> string(453) "<ul> <li>Модель: спортивный лыжный пуловер;</li> <li>Фасон: приталенный;</li> <li>Цвет: белый,черный;</li> <li>Узор: черные вставки;</li> <li>Верх: полиэстер 100%;</li> <li>Бренд: RH+;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Пуловер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14439" ["sku"]=> string(11) "INU2730 09D" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(35) "catalog/novinki/1etazh/ao6b1642.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "<p>Мужская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>RH+ (женские штаны, шорты)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "3500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-06" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2200" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-05-02 18:12:56" ["viewed"]=> string(3) "535" ["categories"]=> array(10) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "465" [3]=> string(3) "472" [4]=> string(3) "513" [5]=> string(3) "557" [6]=> string(3) "591" [7]=> string(3) "592" [8]=> string(3) "594" [9]=> string(3) "600" } [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 = '600' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14432]=> array(49) { ["product_id"]=> string(5) "14432" ["name"]=> string(67) "Кардиган мужской лыжный оранжевый RH+" ["description"]=> string(980) "<p>Кардиган мужской лыжный оранжевый RH+ из&nbsp; прочного эластичного материала. Ткань дышащяя, непродуваемая ткань. Плоские, термически сваренные швы. Водонепроницаемые швы. Воротник-сойка. Центральная застежка контрастная молния. Специальный крой ткани исключает разрыв ткани во время натяжения. Рукав втачной на тонком черном манжете.&nbsp;</p> <ul> </ul> <p>Если вас заинтересовала модель, вы можете приобрести кардиган мужской лыжный оранжевый RH+ в нашем магазине, оформив заказ по телефону или через сайт.&nbsp;</p> " ["characteristics"]=> string(450) "<ul> <li>Модель: кардиган мужской лыжный;</li> <li>Фасон: приталенный;</li> <li>Цвет: оранжевый;</li> <li>Узор: однотонный;</li> <li>Состав: полиэстер 100%;</li> <li>Бренд:&nbsp;RH+;</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) "14432" ["sku"]=> string(11) "INU2734 335" ["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(35) "catalog/novinki/1etazh/ao6b1663.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "<p>Мужская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>RH+ (женские штаны, шорты)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "3350.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-06" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2200" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-05-02 18:08:42" ["viewed"]=> string(3) "544" ["categories"]=> array(10) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "465" [3]=> string(3) "472" [4]=> string(3) "513" [5]=> string(3) "557" [6]=> string(3) "591" [7]=> string(3) "592" [8]=> string(3) "594" [9]=> string(3) "600" } [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 = '600' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14442]=> array(49) { ["product_id"]=> string(5) "14442" ["name"]=> string(40) "Черные лыжные штаны RH+" ["description"]=> string(1293) "<p>Черные лыжные штаны RH+ из гладкой однотонной ткани с высокими показателями водозащиты и воздухопроницаемости. Эргономичный крой, спортивный сдержанный стиль. Материал плотный, эластичный. область коленей артикулированная, что гарантирует удобство при движениях. На морозе материал сохраняет эластичность. Широкие подтяжки с регулируемой длиной. Пояс с регулируемой шириной, застежка молния и кнопки. Внизу штанины усилены износостойкой тканью, устойчивой к порезам. Молнии гарантируют удобство надевания и снятии ботинок.&nbsp;</p> <ul> </ul> <p>Если вам понравилась модель, вы можете заказать черные лыжные штаны RH+&nbsp;в нашем магазине, оформив заявку по телефону или через сайт.</p> " ["characteristics"]=> string(438) "<ul> <li>Модель: спортивные мужские штаны;</li> <li>Фасон: свободный;</li> <li>Расцветка: черный;</li> <li>Узор: нет;</li> <li>Верх: нейлон 88%, эластан 12%;</li> <li>Бренд: RH+;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Штаны" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14442" ["sku"]=> string(11) "INU2699 900" ["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(35) "catalog/novinki/1etazh/ao6b1660.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "<p>Мужская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>RH+ (женские штаны, шорты)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "10900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-06" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1200" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-05-02 18:10:08" ["viewed"]=> string(3) "632" ["categories"]=> array(11) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "272" [3]=> string(3) "465" [4]=> string(3) "468" [5]=> string(3) "528" [6]=> string(3) "557" [7]=> string(3) "591" [8]=> string(3) "592" [9]=> string(3) "595" [10]=> string(3) "600" } [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 = '600' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15824]=> array(49) { ["product_id"]=> string(5) "15824" ["name"]=> string(71) "Серые штаны для спорта и туризма Craghoppers" ["description"]=> string(1478) "<p>Серые штаны для спорта и туризма Craghoppers&nbsp;- притачной пояс, чтоб регулировать ширину талии.&nbsp;Сложноскроенная модель. Удобные карманы: 2 прорезных кармана на молнии.&nbsp;Молния с фиксацией. Вышитый логотип и надписи Craghoppers, подчеркивающие статусность вещи.&nbsp;&nbsp;В боковых карманах вшита салфетка для очков.Вышитый логотип и надписи Craghoppers, подчеркивающие статусность вещи.&nbsp;</p> <h3><strong>ПРЕИМУЩЕСТВА&nbsp;</strong></h3> <ol> <li>легкий вес;</li> <li>стильный дизайн;</li> <li>легко комбинируется с разными видами одежды;</li> <li>водонепроницаемый-материал;</li> </ol> <p>Если вас заинтересовала модель, приобрести серые штаны для спорта и туризма Craghoppers можно на сайте нашего магазина. Доставка работает по Киеву и всей Украины. Удачных покупок!&nbsp;</p> " ["characteristics"]=> string(649) "<ul> <li>Модель: мужская одежда&nbsp;outdoor;</li> <li>Фасон: мужские спортивные брюки средней посадки;</li> <li>Цвет: серый;</li> <li>Принт: символика бренда Craghoppers;</li> <li>Материал: 92% полиамид, 8% эластан;</li> <li>Сезонность: внесезонная;</li> <li>Бренд: Craghoppers (Крагхопперс).</li> <li>Страна бренда: Великобритания</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Штаны" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(260) "Темно-синие мужские брюки из тонкой ткани Craghoppers, штаны мужские, брюки мужские, легкие штаны, летние штаны, для походов штаны, брюки для пикника" ["model"]=> string(5) "15824" ["sku"]=> string(7) "CMJ494R" ["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(59) "catalog/dn8/fotosessija/2019/muzhskaja_oktjabr/ao6b0353.jpg" ["manufacturer_id"]=> string(3) "144" ["manufacturer"]=> string(11) "Craghoppers" ["manufacturer_size_table"]=> string(2063) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>5XL</td> <td>примечание</td> </tr> <tr> <td>Мужские куртка, пуловер, футболка</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Мужские брюки, шорты</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>22</td> <td>&nbsp;</td> </tr> <tr> <td>Женские куртка, пуловер, футболка</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Женские брюки, шорты</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "2400.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-10-21" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1200" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-05-02 18:29:14" ["viewed"]=> string(3) "901" ["categories"]=> array(12) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "272" [3]=> string(3) "465" [4]=> string(3) "468" [5]=> string(3) "528" [6]=> string(3) "558" [7]=> string(3) "591" [8]=> string(3) "595" [9]=> string(3) "600" [10]=> string(3) "601" [11]=> string(3) "602" } [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 = '600' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14441]=> array(49) { ["product_id"]=> string(5) "14441" ["name"]=> string(27) "Лыжные штаны RH+" ["description"]=> string(1676) "<p>Штаны мужские лыжные оранжевые <span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">RH+</span></span> из однотонной гладкой ткани выполнены из плотного современного материала, обладающего высокими водозащитными и воздухонипроницаемыми свойствами. Модель с широкими эластичными подтяжками. Широкий притачной пояс регулируемой ширины. Застежка потайная молния и пуговицы. Высокая спинка защищает от холода и ветра. Карманы по бокам на молниях. Эластичные вставки в области колен обеспечивают свободу движений. Молнии по бокам обеспечивают простое снятие и надевание ботинок. Низ штанин усилен износостойкой тканью, устойчивой к порезам.</p> <ul> </ul> <p>Если вам понравилась модель, вы можете заказать пуловер мужской лыжный белый с черными вставками <span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">RH+</span></span> в нашем магазине, оформив заявку по телефону или через сайт.</p> " ["characteristics"]=> string(611) "<ul> <li>Модель: спортивные мужские штаны;</li> <li>Фасон: свободный;</li> <li>Расцветка: оранжевый, черный;</li> <li>Узор: черные вставки;</li> <li>Верх: нейлон 88%, эластен 12%;</li> <li>Бренд: <span style="font-size:11pt"><span style="font-family:Calibri,sans-serif">RH+</span></span>;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Штаны" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14441" ["sku"]=> string(11) "INU2699 327" ["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(35) "catalog/novinki/1etazh/ao6b1636.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "<p>Мужская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>RH+ (женские штаны, шорты)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "10900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-06" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1200" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-05-02 18:06:48" ["viewed"]=> string(3) "616" ["categories"]=> array(11) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "272" [3]=> string(3) "465" [4]=> string(3) "468" [5]=> string(3) "528" [6]=> string(3) "557" [7]=> string(3) "591" [8]=> string(3) "592" [9]=> string(3) "595" [10]=> string(3) "600" } [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 = '600' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14436]=> array(49) { ["product_id"]=> string(5) "14436" ["name"]=> string(57) "Куртка лыжная трехцветная ZERO RH+" ["description"]=> string(1208) "<p>Куртка мужская лыжная RH + из прочной ткани с плоскими швами. Материал прочный, эластичный, водо- и воздухозащита. Специальный крой ткани предотвращает разрыв во время физических нагрузок. Капюшон с резинкой, что позволяет регулировать ширину. Линия плеч прямая. Притачные манжеты из эластичного материала с отверстиями для больших пальцев. Удобные боковые карманы застегиваются на молнию, фасон прорезные вертикальные. Подол асимметричный. Модель сочетает в себе функциональность и оригинальный дизайн.</p> <ul> </ul> <p>Если вам понравилась модель, вы можете заказать куртку мужскую лыжную&nbsp;RH + вы в телефонном режиме или через сайт.</p> " ["characteristics"]=> string(512) "<ul> <li>Модель: мужская горнолыжная куртка;</li> <li>Фасон: slim fit;</li> <li>Расцветка: черный, синий, оранжевый;</li> <li>Узор: нет;</li> <li>Ткань верха: нейлон 88%, эластан 12%;</li> <li>Ткань подкладки: нейлон 100%;</li> <li>Производитель: RH +&nbsp;</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) "14436" ["sku"]=> string(11) "INU2683 89A" ["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(35) "catalog/novinki/1etazh/ao6b1629.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "<p>Мужская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>RH+ (женские штаны, шорты)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "22900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-06" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "100" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-05-02 18:07:33" ["viewed"]=> string(3) "921" ["categories"]=> array(12) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "279" [3]=> string(3) "397" [4]=> string(3) "433" [5]=> string(3) "465" [6]=> string(3) "548" [7]=> string(3) "557" [8]=> string(3) "591" [9]=> string(3) "592" [10]=> string(3) "593" [11]=> string(3) "600" } [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 = '600' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14437]=> array(49) { ["product_id"]=> string(5) "14437" ["name"]=> string(44) "Куртка лыжная зеленая RH+" ["description"]=> string(1240) "<p>Куртка лыжная зеленая RH+ из однотонной гладкой ткани. Материал дышащий, не продуваемый и не промокаемый. На морозе ткань сохраняет эластичность. Специальный крой исключает разрыв во время физических нагрузок. Швы плоские, термически сварены. Линия плеч прямая, рукава длинные на эластичных контрастного цвета манжетах с прорезями для большого пальца. Удобный вертикальный карман на рукаве застежка молния. Карманы с листочкой на молнии по бокам. Подол асимметричный. Модель сочетает в себе стиль и функциональность.</p> <ul> </ul> <p>Если вам понравилась модель, вы можете заказать куртку&nbsp;лыжную зеленую RH+ в нашем магазине по телефону или через сайт.</p> " ["characteristics"]=> string(520) "<ul> <li>Модель: спортивная лыжная куртка;</li> <li>Фасон: приталенная;</li> <li>Цвет: зеленый;</li> <li>Узор: однотонный;</li> <li>Верх: нейлон 88%, эластен 12%;</li> <li>Подкладка: нейлон 100%;</li> <li>Бренд: &nbsp;RH+;</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) "14437" ["sku"]=> string(11) "INU2687 275" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(35) "catalog/novinki/1etazh/ao6b1649.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "<p>Мужская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>RH+</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>RH+ (женские штаны, шорты)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "18500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-06" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(3) "100" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-05-02 18:09:26" ["viewed"]=> string(3) "734" ["categories"]=> array(12) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "279" [3]=> string(3) "397" [4]=> string(3) "433" [5]=> string(3) "465" [6]=> string(3) "548" [7]=> string(3) "557" [8]=> string(3) "591" [9]=> string(3) "592" [10]=> string(3) "593" [11]=> string(3) "600" } [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 = '600' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }