Женские носки

Сортировать:

Показывать:

array(11) { [15794]=> array(49) { ["product_id"]=> string(5) "15794" ["name"]=> string(74) "Носки женские темно-синие длинные Craghoppers" ["description"]=> string(929) "Носки женские темно-синие длинные Craghoppers эластичные, плотные, универсальные. Выполнены из приятных на ощупь материалов. Подходят для повседневной носки и занятий спортом.  Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей» " ["characteristics"]=> string(3809) "<ul> <li>Модель: носки спортивные;</li> <li>Цвет: темно-синий;</li> <li>Узор: нет;</li> <li>Состав: шерсть 72%, полиамид 28%;</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(239) "женские носки, носки длинные, высокие женские носки, носки женские модные, носки, высокие, длинные, женские, женские носки с принтом" ["model"]=> string(5) "15794" ["sku"]=> string(6) "CWH020" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(65) "catalog/dn8/fotosessija/2019/predmetka_1etazh/img_3988-kopija.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> </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>22</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> </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> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "630.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-16" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-12-16 13:28:41" ["date_modified"]=> string(19) "2021-01-22 15:42:24" ["viewed"]=> string(3) "487" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "339" [3]=> string(3) "348" } [0]=> string(2135) "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 = '339' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15796]=> array(49) { ["product_id"]=> string(5) "15796" ["name"]=> string(59) "Носки женские с полосками Craghoppers" ["description"]=> string(592) "Носки женские с полосками Craghoppers это спортивные носки для активных и целеустремленных. Принт логотипа Craghoppers на носке  изделия. Стильный дизайн и крой защищают ступню и помогают свободно двигаться.  Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей» " ["characteristics"]=> string(538) "<ul> <li>Модель: носки спортивные;</li> <li>Цвет: серый, голубой;</li> <li>Узор: полоска;</li> <li>Склад: кулмакс 42%, шерсть 28%, полиамид 19%, эластан 1%;</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(97) "высокие носки, длинные носки, женские носки, носочки, " ["model"]=> string(5) "15796" ["sku"]=> string(10) "CWH123 8M9" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(58) "catalog/dn8/fotosessija/2019/predmetka_1etazh/img_3998.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> </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>22</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> </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> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "630.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-16" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-12-16 13:28:41" ["date_modified"]=> string(19) "2021-02-01 16:39:46" ["viewed"]=> string(3) "479" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "339" [3]=> string(3) "348" } [0]=> string(2135) "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 = '339' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15795]=> array(49) { ["product_id"]=> string(5) "15795" ["name"]=> string(67) "Носки женские длинные розовые Craghoppers" ["description"]=> string(633) "Носки женские длинные розовые Craghoppers это спортивные носки для активных и целеустремленных. Принт логотипа Craghoppers на носке  изделия. Стильный дизайн и крой защищают ступню и помогают свободно двигаться.  Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»   " ["characteristics"]=> string(541) "<ul> <li>Модель: носки спортивные;</li> <li>Цвет: серый, розовый;</li> <li>Узор: полоска;</li> <li>Состав: кулмакс 42%, шерсть 28%, полиамид 19%, эластан 1%;</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(0) "" ["model"]=> string(5) "15795" ["sku"]=> string(10) "CWH123 2FH" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(58) "catalog/dn8/fotosessija/2019/predmetka_1etazh/img_3996.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> </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>22</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> </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> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "630.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-16" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-12-16 13:28:41" ["date_modified"]=> string(19) "2021-02-01 16:41:25" ["viewed"]=> string(3) "576" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "339" [3]=> string(3) "348" } [0]=> string(2135) "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 = '339' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16632]=> array(49) { ["product_id"]=> string(5) "16632" ["name"]=> string(44) "Черные носки (унисекс) RH+" ["description"]=> string(547) "Спортивные черные носки (унисекс) RH+.  Изготовлены из качественного нейлона, эластичные. Декорированные логотипами компании. Носки формостабильные, можно стирать в стиральной машине. Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей» " ["characteristics"]=> string(2288) "<ul> <li>Модель: носки спортивные;</li> <li>Цвет: черный, красный;</li> <li>Узор: логотип;</li> <li>Состав: нейлон 95%, эластан 5%;</li> <li>Сезон: осень-зима-весна;</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(128) "Носки, велоноски, носки высокие, носки спортивные, носки под кроссовки" ["model"]=> string(5) "16632" ["sku"]=> string(11) "ECX9164 987" ["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(61) "catalog/dn8/fotosessija/2020/ijul/predmetka/noski/0748-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "Мужская одежда  <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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> </tbody> </table> Женская одежда  <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> </td> <td> </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> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "770.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-10" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-10 11:22:53" ["date_modified"]=> string(19) "2021-02-12 10:43:14" ["viewed"]=> string(3) "431" ["categories"]=> array(6) { [0]=> string(2) "18" [1]=> string(2) "20" [2]=> string(2) "85" [3]=> string(3) "338" [4]=> string(3) "339" [5]=> string(3) "348" } [0]=> string(2135) "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 = '339' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16630]=> array(49) { ["product_id"]=> string(5) "16630" ["name"]=> string(53) "Спортивные носки (унисекс) RH+" ["description"]=> string(865) "Спортивные носки (унисекс) RH+ эластичные черного цвета. Оптимально подойдут для занятий спортом. Декорированные фирменными логотипами сбоку. Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей» " ["characteristics"]=> string(3441) "<ul> <li>Модель: носки спортивные;</li> <li>Цвет: черный, серый;</li> <li>Узор: логотип;</li> <li>Состав: нейлон 95%, эластан 5%;</li> <li>Сезон: осень-зима-весна;</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(153) "Носки, мужские носки, носки для велоспорта, велосипедные носки, носки на каждый день" ["model"]=> string(5) "16630" ["sku"]=> string(11) "ECX9164 906" ["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(61) "catalog/dn8/fotosessija/2020/ijul/predmetka/noski/0750-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "Мужская одежда  <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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> </tbody> </table> Женская одежда  <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> </td> <td> </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> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "770.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-10" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-10 11:22:53" ["date_modified"]=> string(19) "2021-02-12 13:59:30" ["viewed"]=> string(3) "398" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "85" [2]=> string(3) "338" [3]=> string(3) "339" [4]=> string(3) "348" } [0]=> string(2135) "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 = '339' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16631]=> array(49) { ["product_id"]=> string(5) "16631" ["name"]=> string(44) "Носки черные (унисекс) RH+" ["description"]=> string(1206) "Носки черные (унисекс) RH+ максимально эластичные носки, хорошо держатся на ноге. Оптимально подойдут для занятий спортом. Декорированные фирменными логотипами сбоку. Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»   " ["characteristics"]=> string(3431) "<ul> <li>Модель: носки спортивные;</li> <li>Цвет: черный, салатовый;</li> <li>Узор: логотип;</li> <li>Состав: нейлон 95%, эластан 5%;</li> <li>Сезон: осень-зима-весна;</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(128) "Носки, велоноски, носки высокие, носки спортивные, носки под кроссовки" ["model"]=> string(5) "16631" ["sku"]=> string(11) "ECX9164 94G" ["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(61) "catalog/dn8/fotosessija/2020/ijul/predmetka/noski/0751-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "Мужская одежда  <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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> </tbody> </table> Женская одежда  <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> </td> <td> </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> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "770.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-10" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-10 11:22:53" ["date_modified"]=> string(19) "2021-02-12 11:00:52" ["viewed"]=> string(3) "412" ["categories"]=> array(6) { [0]=> string(2) "18" [1]=> string(2) "20" [2]=> string(2) "85" [3]=> string(3) "338" [4]=> string(3) "339" [5]=> string(3) "348" } [0]=> string(2135) "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 = '339' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16628]=> array(49) { ["product_id"]=> string(5) "16628" ["name"]=> string(57) "Носки черного цвета (унисекс) RH+" ["description"]=> string(1072) "Носки черного цвета (унисекс) RH+  cозданы для максимального комфорта во время езды на велосипеде. Специальная ткань оптимально защищает и поддерживает ноги в велосипедной обуви. Носки произведены с учетом анатомических особенностей ступни. Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей» " ["characteristics"]=> string(812) "<ul> <li>Код товара: 16628</li> <li>Артикул: ECX</li> <li>Бренд: RH+</li> <li>Страна: Италия</li> <li>Цвет: черный, салатовый</li> <li>Модель: велоноски</li> <li>Материал: 95% нейлон, 5% эластан</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(11) "Носки " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(130) "носки черные, носки для спорта, носки для с узором, носки на каждый день" ["model"]=> string(5) "16628" ["sku"]=> string(11) "ECX9163 917" ["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(61) "catalog/dn8/fotosessija/2020/ijul/predmetka/noski/0746-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "Мужская одежда  <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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> </tbody> </table> Женская одежда  <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> </td> <td> </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> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "590.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-10" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-10 11:22:53" ["date_modified"]=> string(19) "2021-02-12 12:30:22" ["viewed"]=> string(3) "426" ["categories"]=> array(6) { [0]=> string(2) "18" [1]=> string(2) "20" [2]=> string(2) "69" [3]=> string(3) "338" [4]=> string(3) "339" [5]=> string(3) "348" } [0]=> string(2135) "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 = '339' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16627]=> array(49) { ["product_id"]=> string(5) "16627" ["name"]=> string(37) "Носки спортивные RH+ " ["description"]=> string(657) "<ul> </ul> Носки спортивные RH+  cозданы для максимального комфорта во время езды на велосипеде. Специальная ткань оптимально защищает и поддерживает ноги в велосипедной обуви. Носки произведены с учетом анатомических особенностей ступни. Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей» " ["characteristics"]=> string(420) "<ul> <li>Код товара: 16627</li> <li>Артикул: ECX9163 916</li> <li>Бренд: RH+ </li> <li>Страна: Италия</li> <li>Цвет: черный, красный</li> <li>Модель: велоноски</li> <li>Материал: 95% нейлон, 5% эластан</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(130) "носки черные, носки для спорта, носки для с узором, носки на каждый день" ["model"]=> string(5) "16627" ["sku"]=> string(11) "ECX9163 916" ["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(61) "catalog/dn8/fotosessija/2020/ijul/predmetka/noski/0747-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "Мужская одежда  <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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> </tbody> </table> Женская одежда  <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> </td> <td> </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> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "590.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-10" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-10 11:22:53" ["date_modified"]=> string(19) "2021-03-05 16:46:45" ["viewed"]=> string(3) "457" ["categories"]=> array(7) { [0]=> string(2) "18" [1]=> string(2) "20" [2]=> string(2) "85" [3]=> string(3) "329" [4]=> string(3) "338" [5]=> string(3) "339" [6]=> string(3) "465" } [0]=> string(2135) "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 = '339' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16626]=> array(49) { ["product_id"]=> string(5) "16626" ["name"]=> string(35) "Носки спортивные RH+" ["description"]=> string(1041) "Носки спортивные RH+ cозданы для максимального комфорта во время езды на велосипеде. Специальная ткань оптимально защищает и поддерживает ноги в велосипедной обуви. Носки произведены с учетом анатомических особенностей ступни. Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей» " ["characteristics"]=> string(821) "<ul> <li>Код товара: 16626</li> <li>Артикул: ECX9163 910</li> <li>Бренд: RH+ </li> <li>Страна: Италия</li> <li>Цвет: черный/белый</li> <li>Модель: велоноски</li> <li>Материал: 95% нейлон, 5% эластан</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(130) "носки черные, носки для спорта, носки для с узором, носки на каждый день" ["model"]=> string(5) "16626" ["sku"]=> string(11) "ECX9163 910" ["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(61) "catalog/dn8/fotosessija/2020/ijul/predmetka/noski/0744-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "Мужская одежда  <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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> </tbody> </table> Женская одежда  <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> </td> <td> </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> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "590.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-10" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-10 11:22:53" ["date_modified"]=> string(19) "2021-02-12 14:08:06" ["viewed"]=> string(3) "443" ["categories"]=> array(7) { [0]=> string(2) "18" [1]=> string(2) "20" [2]=> string(2) "73" [3]=> string(2) "85" [4]=> string(3) "338" [5]=> string(3) "339" [6]=> string(3) "465" } [0]=> string(2135) "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 = '339' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16629]=> array(49) { ["product_id"]=> string(5) "16629" ["name"]=> string(42) "Носки белые (унисекс) RH+" ["description"]=> string(994) "Носки белые (унисекс) RH+ спортивные носки для активных и целеустремленных. Принт логотипа RH+ по бокам изделия. Стильный дизайн и крой защищают ступню и помогают свободно двигаться.  Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»   " ["characteristics"]=> string(3439) "<ul> <li>Модель: носки спортивные;</li> <li>Цвет: белый, черный;</li> <li>Узор: логотип;</li> <li>Состав: нейлон 95%, эластан 5%;</li> <li>Сезон: осень-зима-весна;</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(163) "Носки, белые, с контрастными вставками, с символикой, для велоспорта, на каждый день, Zero rh+" ["model"]=> string(5) "16629" ["sku"]=> string(11) "ECX9164 09G" ["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(61) "catalog/dn8/fotosessija/2020/ijul/predmetka/noski/0749-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "Мужская одежда  <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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> </tbody> </table> Женская одежда  <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> </td> <td> </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> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "770.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-10" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-10 11:22:53" ["date_modified"]=> string(19) "2021-02-12 12:53:04" ["viewed"]=> string(3) "406" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "85" [2]=> string(3) "338" [3]=> string(3) "339" [4]=> string(3) "348" } [0]=> string(2135) "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 = '339' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16625]=> array(49) { ["product_id"]=> string(5) "16625" ["name"]=> string(46) "Белые спортивные носки RH+" ["description"]=> string(1053) "Белые спортивные носки RH+ cозданы для максимального комфорта во время езды на велосипеде. Специальная ткань оптимально защищает и поддерживает ноги в велосипедной обуви. Носки произведены с учетом анатомических особенностей ступни. Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей» " ["characteristics"]=> string(808) "<ul> <li>Код товара: 16625</li> <li>Артикул: ECX9163 009</li> <li>Бренд: RH+ </li> <li>Страна: Италия</li> <li>Цвет: белый</li> <li>Модель: велоноски</li> <li>Материал: 95% нейлон, 5% эластан</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(122) "носки белые, белые носки для спорта, носки для с узором, белые носки" ["model"]=> string(5) "16625" ["sku"]=> string(11) "ECX9163 009" ["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(61) "catalog/dn8/fotosessija/2020/ijul/predmetka/noski/0749-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(8) "ZERO RH+" ["manufacturer_size_table"]=> string(2203) "Мужская одежда  <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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> </tbody> </table> Женская одежда  <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> </td> <td> </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> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "590.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-10" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-10 11:22:53" ["date_modified"]=> string(19) "2021-02-12 14:10:24" ["viewed"]=> string(3) "471" ["categories"]=> array(7) { [0]=> string(2) "18" [1]=> string(2) "20" [2]=> string(2) "73" [3]=> string(2) "85" [4]=> string(3) "338" [5]=> string(3) "339" [6]=> string(3) "465" } [0]=> string(2135) "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 = '339' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }