RH+

array(12) { [16610]=> array(49) { ["product_id"]=> string(5) "16610" ["name"]=> string(58) "Куртка вітрозахисна (унісекс) RH+" ["description"]=> string(3573) "<ul> </ul> <p>Особливості:</p> <p>&bull; Силует SLIM Fit</p> <p>&bull; Рефлективні смужки на спині</p> <p>&bull; Компактна в складеному вигляді</p> <p>Легка велокуртка для їзди на веловипеді, що компактно упаковується, із захистом від вітру і слабкого дощу.</p> <div class="br-table"> <div class="br-table__left"> <div class="br-table__element">аеродинаміка</div> <div class="br-table__element">повітропроникність</div> <div class="br-table__element">захист від вітру</div> <div class="br-table__element">захист від дощу</div> <div class="br-table__element">захист від ультрафіолету</div> <div class="br-table__element">легкість</div> </div> <div class="br-table__right"> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> </div> </div> " ["characteristics"]=> string(503) "<ul> <li>Код товару: 16610</li> <li>Артикул: SSCX563&nbsp;83Р</li> </ul> <ul> <li>Бренд: RH+</li> <li>Країна: Італія</li> </ul> <ul> <li>Модель: велокуртка</li> <li>Колір: чорний/салатовий</li> <li>Матеріал: тканина&nbsp;Air Dry (100% поліестер)</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(117) "Куртка, вітрозахисний, полегшена, чорна, зелена, Zero rh +, спортивна" ["model"]=> string(5) "16610" ["sku"]=> string(11) "SSCX563 83P" ["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(65) "catalog/dn8/fotosessija/2020/ijul/1etazh_muzhskoe/img_4336-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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) "2990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-14" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "6" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-31 16:59:20" ["date_modified"]=> string(19) "2021-07-13 14:36:06" ["viewed"]=> string(3) "389" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "397" [3]=> string(3) "465" } [0]=> string(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16612]=> array(49) { ["product_id"]=> string(5) "16612" ["name"]=> string(61) "Куртка унісекс вітрозахисна ZERO RH+" ["description"]=> string(3606) "<ul> </ul> <p>Легка велокуртка для їзди на велосипеді, що компактно упаковується, із захистом від вітру і слабкого дощу.</p> <p>&nbsp;</p> <p>Особливості:</p> <p>&bull; Силует SLIM Fit</p> <p>&bull; Рефлективні смужки на спині</p> <p>&bull; Компактна в складеному вигляді</p> <div class="br-table"> <div class="br-table__left"> <div class="br-table__element">аеродинаміка</div> <div class="br-table__element">повітропроникність</div> <div class="br-table__element">захист від вітру</div> <div class="br-table__element">захист від дощу</div> <div class="br-table__element">захист від ультрафіолету</div> <div class="br-table__element">легкість</div> </div> <div class="br-table__right"> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> </div> </div> " ["characteristics"]=> string(490) "<ul> <li>Код товару: 16612</li> <li>Артикул: SSCX563 R10</li> </ul> <ul> <li>Бренд: RH+</li> <li>Країна: Італія</li> </ul> <ul> <li>Модель: велокуртка</li> <li>Колір: салатовий&nbsp;</li> <li>Матеріал: тканина&nbsp;Air Dry (100% поліестер)</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(131) "Куртка, чоловіча, вітрозахисна, салатова, зелена, легка, спортивна, Zero rh +" ["model"]=> string(5) "16612" ["sku"]=> string(11) "SSCX563 R10" ["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(65) "catalog/dn8/fotosessija/2020/ijul/1etazh_muzhskoe/img_4328-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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) "2500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-14" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-13 12:57:47" ["viewed"]=> string(3) "470" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "397" [3]=> string(3) "465" } [0]=> string(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16611]=> array(49) { ["product_id"]=> string(5) "16611" ["name"]=> string(65) "Куртка унісекс біла вітрозахисна RH+" ["description"]=> string(3378) "<ul> </ul> <p>Особливості:</p> <p>&bull; Силует SLIM Fit</p> <p>&bull; Рефлективні смужки на спині</p> <p>&bull; Компактна в складеному вигляді</p> <p>Легка велокуртка для їзди на веловипеді, що компактно упаковується, із захистом від вітру і слабкого дощу.</p> <div class="br-table"> <div class="br-table__left"> <div class="br-table__element">аеродинаміка</div> <div class="br-table__element">повітропроникність</div> <div class="br-table__element">захист від вітру</div> <div class="br-table__element">захист від дощу</div> <div class="br-table__element">захист від ультрафіолету</div> <div class="br-table__element">легкість</div> </div> <div class="br-table__right"> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> </div> </div> " ["characteristics"]=> string(481) "<ul> <li>Код товару: 16611</li> <li>Артикул: SSCX563&nbsp;R09</li> </ul> <ul> <li>Бренд: RH+</li> <li>Країна: Італія</li> </ul> <ul> <li>Модель: велокуртка</li> <li>Колір: білий</li> <li>Матеріал: тканина&nbsp;Air Dry (100% поліестер)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(13) "Куртка " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(97) "Куртка, чоловіча, біла, вітрозахисна, Zero rh +, спортивна" ["model"]=> string(5) "16611" ["sku"]=> string(11) "SSCX563 R09" ["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(65) "catalog/dn8/fotosessija/2020/ijul/1etazh_muzhskoe/img_4343-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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) "2500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-14" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2020-12-30 16:59:20" ["viewed"]=> string(3) "344" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "397" [3]=> string(3) "465" } [0]=> string(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16608]=> array(49) { ["product_id"]=> string(5) "16608" ["name"]=> string(74) "Жилет чоловічий чорний для велоспорту RH+" ["description"]=> string(3506) "<p>Легкий веложилет, що компактно упаковуються, із захистом від вітру і слабкого дощу.</p> <p>Особливості:</p> <p>&bull; Силует SLIM Fit</p> <p>&bull; Рефлективні смужки на спині</p> <p>&bull; Компактний в складеному вигляді</p> <div class="br-table"> <div class="br-table__left"> <div class="br-table__element">аеродинаміка</div> <div class="br-table__element">повітропроникність</div> <div class="br-table__element">захист від вітру</div> <div class="br-table__element">захист від дощу</div> <div class="br-table__element">захист від ультрафіолету</div> <div class="br-table__element">легкість</div> </div> <div class="br-table__right"> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> </div> </div> " ["characteristics"]=> string(472) "<ul> <li>Код товару: 16608</li> <li>Артикул: SSCX564 R90</li> </ul> <ul> <li>Бренд: RH+</li> <li>Країна: Італія</li> </ul> <ul> <li>Модель: веложилет</li> <li>Колір: чорний</li> <li>Матеріал: тканина&nbsp;Air Dry (100% поліестер)</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(77) "Жилет, чоловічий, чорний, Zero rh +, спортивний" ["model"]=> string(5) "16608" ["sku"]=> string(11) "SSCX564 R90" ["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(65) "catalog/dn8/fotosessija/2020/ijul/1etazh_muzhskoe/img_4312-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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) "1990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-14" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2020-12-30 16:59:20" ["viewed"]=> string(3) "381" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "397" [3]=> string(3) "465" } [0]=> string(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16607]=> array(49) { ["product_id"]=> string(5) "16607" ["name"]=> string(61) "Жилет чоловічий для велоспорту RH+" ["description"]=> string(3463) "<p>Ідеально підходить для теплих днів, дійсно повітропроникний матеріал і володіє високим комфортом завдяки новій тканині Morphic Dry Tech 4Way Stretch: вона легка і дозволяє досить швидко випаровувати вологу, ідеально підходить для теплішого клімату. Центральна задня вставка Morphic Aero Mesh виводить вологу і тепло тіла назовні, усуваючи відчуття вологи на шкірі.</p> <p>&nbsp;</p> <p>Особливості:</p> <p>&bull; Силует SLIM Fit</p> <p>&bull; 3 кишені на спині</p> <p>&bull; Міні-кишеня на блискавці</p> <p>&bull; Еластична смужка з силікону на нижній кромці</p> <p>&bull; Рефлективні смужки на спині</p> <div class="br-table"> <div class="br-table__left"> <div class="br-table__element"><span style="font-size:16px">аеродинаміка</span></div> <div class="br-table__element"><span style="font-size:16px">повітропроникність</span></div> <div class="br-table__element"><span style="font-size:16px">захист від ультрафіолету</span></div> <div class="br-table__element"><span style="font-size:16px">легкість</span></div> </div> <div class="br-table__right"> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> </div> </div> " ["characteristics"]=> string(690) "<ul> <li>Код товару: 16607</li> <li>Артикул: ECU0704 03R</li> </ul> <ul> <li>Бренд: RH+</li> <li>Країна: Італія</li> </ul> <ul> <li>Модель: веложилет</li> <li>Колір: білий</li> <li>Матеріал: тканина&nbsp;Morphic Dry Tech 4Way Stretch (92% поліестер, 8% еластан)</li> <li>Параметри&nbsp;моделі:&nbsp;102-84-99, ріст 185 см&nbsp;</li> <li>На моделі&nbsp;надіто: 50</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(114) "Жилет, чоловічий, для велоспорту, Zero rh +, спортивний, безрукавка" ["model"]=> string(5) "16607" ["sku"]=> string(11) "ECU0704 03R" ["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(65) "catalog/dn8/fotosessija/2020/ijul/1etazh_muzhskoe/img_4352-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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) "2900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-14" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2020-12-30 16:59:20" ["viewed"]=> string(3) "376" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "465" [3]=> string(3) "467" } [0]=> string(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16613]=> array(49) { ["product_id"]=> string(5) "16613" ["name"]=> string(63) "Велокуртка унісекс на блискавці RH+" ["description"]=> string(3603) "<ul> </ul> <p>Легка велокуртка для їзди на веловипеді, що компактно упаковується, із захистом від вітру і слабкого дощу.</p> <p>&nbsp;</p> <p>Особливості:</p> <ul> <li>Силует SLIM Fit</li> <li>Рефлективні смужки на спині</li> <li>Компактна в складеному вигляді</li> </ul> <div class="br-table"> <div class="br-table__left"> <div class="br-table__element">аеродинаміка</div> <div class="br-table__element">повітропроникність</div> <div class="br-table__element">захист від вітру</div> <div class="br-table__element">захист від дощу</div> <div class="br-table__element">захист від ультрафіолету</div> <div class="br-table__element">легкість</div> </div> <div class="br-table__right"> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> <div class="br-empty">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> <div class="br-table__element"> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> <div class="br-filled">&nbsp;</div> </div> </div> </div> " ["characteristics"]=> string(483) "<ul> <li>Код товару: 16613</li> <li>Артикул: SSCX563&nbsp;R90</li> </ul> <ul> <li>Бренд: RH+</li> <li>Країна: Італія</li> </ul> <ul> <li>Модель: велокуртка</li> <li>Колір: чорний</li> <li>Матеріал: тканина&nbsp;Air Dry (100% поліестер)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(20) "Велокуртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(88) "Жилетка, чоловіча, чорна, на блискавці, rh+, куртка" ["model"]=> string(5) "16613" ["sku"]=> string(11) "SSCX563 R90" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "8" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(65) "catalog/dn8/fotosessija/2020/ijul/1etazh_muzhskoe/img_4368-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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) "2500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-14" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2020-12-30 16:59:20" ["viewed"]=> string(3) "630" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "397" [3]=> string(3) "465" } [0]=> string(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16636]=> array(49) { ["product_id"]=> string(5) "16636" ["name"]=> string(91) "Шолом велосипедний чорний з зеленими вставками RH+" ["description"]=> string(1286) "<p>Шолом велосипедний чорний з зеленими вставками RH+ - один з найлегших шоломів, а також один з найбільш добре вентильованих і зручних. Ідеально підходить як для швидкісної їзди по шосе без козирка, так і для їзди по бездоріжжю з козирком. Система кріплення Power FIT 2 утримує шолом стійко, навіть коли ви знаходитесь в русі.</p> <p>Особливості:</p> <ul> <li>Технологія Power FIT 2 з поліпшеним кріпленням на потиличній частині</li> <li>Чудові легка вага і міцність</li> <li>Світловідбиваючі наклейки, нанесені на поверхню шолома</li> <li>Знімна й така, що миється, антиалергічна прокладка з тканини 3D open mesh rh + Fire Dry, що забезпечує максимальний комфорт і швидко відводить піт.</li> </ul> " ["characteristics"]=> string(418) "<ul> <li>Код товару: 16636</li> <li>Артикул: EHX6058 28</li> <li>Бренд: RH+&nbsp;</li> <li>Країна: Італія</li> <li>Колір: чорний/салатовий</li> <li>Модель: велошолом</li> <li>Матеріал: полікарбонат 100%</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(183) "велошлем, шолом для велосипеда, велосипедний шолом, захист велосипедний, велозахист, захисний шолом" ["model"]=> string(5) "16636" ["sku"]=> string(10) "EHX6058 28" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "2" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(73) "catalog/dn8/fotosessija/2020/ijul/predmetka/veloshlemy/retush/0726-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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) "3600.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-22 17:00:52" ["viewed"]=> string(3) "455" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "20" [2]=> string(3) "428" [3]=> string(3) "465" [4]=> string(3) "470" } [0]=> string(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16637]=> array(49) { ["product_id"]=> string(5) "16637" ["name"]=> string(61) "Шолом велосипедний з вставками RH+" ["description"]=> string(1219) "<ul> </ul> <p>Особливості:</p> <ul> <li>Технологія Power FIT 2 з поліпшеним кріпленням на потиличній частині</li> <li>Чудові легка вага і міцність</li> <li>Світловідбиваючі наклейки, нанесені на поверхню шолома</li> <li>Знімна й така, що миється, антиалергічна прокладка з тканини 3D open mesh rh + Fire Dry, що забезпечує максимальний комфорт і швидко відводить піт.</li> </ul> <p>Один з найлегших шоломів, а також один з найбільш добре вентильованих і зручних. Ідеально підходить як для швидкісної їзди по шосе без козирка, так і для їзди по бездоріжжю з козирком. Система кріплення Power FIT 2 утримує шолом стійко, навіть коли ви знаходитесь в русі.</p> " ["characteristics"]=> string(470) "<ul> <li>Код товару: 16637</li> <li>Артикул: EHX6058 53</li> </ul> <ul> <li>Бренд: RH+&nbsp;</li> <li>Країна: Італія</li> </ul> <ul> <li>Колір: чорный/червоний</li> <li>Модель: велошолом</li> <li>Матеріал: полікарбонат 100%</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(183) "велошлем, шолом для велосипеда, велосипедний шолом, захист велосипедний, велозащіта, захисний шолом" ["model"]=> string(5) "16637" ["sku"]=> string(10) "EHX6058 53" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "2" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(73) "catalog/dn8/fotosessija/2020/ijul/predmetka/veloshlemy/retush/0713-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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) "3600.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:05:20" ["viewed"]=> string(3) "486" ["categories"]=> array(6) { [0]=> string(2) "18" [1]=> string(2) "20" [2]=> string(3) "329" [3]=> string(3) "428" [4]=> string(3) "465" [5]=> string(3) "470" } [0]=> string(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16638]=> array(49) { ["product_id"]=> string(5) "16638" ["name"]=> string(39) "Шолом велосипедний RH+" ["description"]=> string(1252) "<ul> </ul> <p>Один з найлегших шоломів, а також один з найбільш добре вентильованих і зручних. Ідеально підходить як для швидкісної їзди по шосе без козирка, так і для їзди по бездоріжжю з козирком. Система кріплення Power FIT 2 утримує шолом стійко, навіть коли ви знаходитесь в русі.</p> <p>Особливості:</p> <ul> <li>Технологія Power FIT 2 з поліпшеним кріпленням на потиличній частині</li> <li>Чудові легка вага і міцність</li> <li>Світловідбиваючі наклейки, нанесені на поверхню шолома</li> <li>Знімна й така, що миється, антиалергічна прокладка з тканини 3D open mesh rh + Fire Dry, що забезпечує максимальний комфорт і швидко відводить піт.</li> </ul> <p>&nbsp;</p> " ["characteristics"]=> string(453) "<ul> <li>Код товару: 16638</li> <li>Артикул: EHX6075 01</li> </ul> <ul> <li>Бренд: RH+&nbsp;</li> <li>Країна: Італія</li> </ul> <ul> <li>Колір: чорний</li> <li>Модель: велошолом</li> <li>Матеріал: полікарбонат 100%</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(185) "велошолом, шолом для велосипеда, велосипедний шолом, захист велосипедний, велозахист, захисний шолом" ["model"]=> string(5) "16638" ["sku"]=> string(10) "EHX6075 01" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "2" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/predmetka/veloshlemy/0708-ds.jpg" ["manufacturer_id"]=> string(3) "112" ["manufacturer"]=> string(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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) "2960.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-11 16:50:05" ["viewed"]=> string(3) "470" ["categories"]=> array(6) { [0]=> string(2) "18" [1]=> string(2) "20" [2]=> string(3) "329" [3]=> string(3) "428" [4]=> string(3) "465" [5]=> string(3) "470" } [0]=> string(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY 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(69) "Шкарпетки чорного кольору (унісекс) RH+" ["description"]=> string(1089) "<p><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Шкарпетки чорного кольору (унісекс) </span></span>RH+<span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif"> створені для максимального комфорту під час їзди на велосипеді. Спеціальна тканина оптимально захищає і підтримує ноги у велосипедному взутті. Шкарпетки виготовлені з урахуванням анатомічних особливостей ступні.</span></span></p> <p><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</span></span></p> " ["characteristics"]=> string(890) "<ul> <li><span style="font-size:14px">Код товару: 16628</span></li> <li><span style="font-size:14px">Артикул: ECX</span></li> <li><span style="font-size:14px">Бренд: </span>RH+<span style="font-size:14px">&nbsp;</span></li> <li><span style="font-size:14px">Країна: Італія</span></li> <li><span style="font-size:14px">Колір: чорний, салатовий</span></li> <li><span style="font-size:14px">Модель: велошкарпетки</span></li> <li><span style="font-size:14px">Матеріал: 95% нейлон, 5% еластан</span></li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(19) "Шкарпетки " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(165) "шкарпетки чорні, шкарпетки для спорту, шкарпетки для з візерунком, шкарпетки на кожен день" ["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(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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(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) "433" ["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(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY 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(50) "Шкарпетки чорні (унісекс) RH+" ["description"]=> string(640) "<pre> <span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Шкарпетки чорні (унісекс) RH+ максимально еластичні шкарпетки, добре тримаються на нозі. Оптимально підійдуть для занять спортом. Декоровані фірмовими логотипами збоку. Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</span></span></pre> " ["characteristics"]=> string(1453) "<ul> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Модель: шкарпетки спортивні;</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Колір: чорний, салатовий;</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Візерунок: логотип;</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Склад: нейлон 95%, еластан 5%;</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Сезон: осінь-зима-весна;</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Бренд: RH +;</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Країна бренду: Італія.</span></span></li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Шкарпетки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(154) "Шкарпетки, велоноскі, шкарпетки високі, шкарпетки спортивні, шкарпетки під кросівки" ["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(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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(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) "418" ["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(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY 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(43) "Шкарпетки спортивні RH+ " ["description"]=> string(657) "<ul> </ul> <p>Шкарпетки спортивні RH+&nbsp;cтворені для максимального комфорту під час їзди на велосипеді. Спеціальна тканина оптимально захищає і підтримує ноги в велосипедному взуті. Шкарпетки виготовлені з урахуванням анатомічних особливостей ступні. Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</pre> " ["characteristics"]=> string(432) "<ul> <li>Код товару: 16627</li> <li>Артикул: ECX9163 916</li> <li>Бренд: RH+&nbsp;</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(18) "Шкарпетки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(165) "шкарпетки чорні, шкарпетки для спорту, шкарпетки для з візерунком, шкарпетки на кожен день" ["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(3) "RH+" ["manufacturer_size_table"]=> string(2285) "<p>Чоловічий одяг&nbsp;</p> <table class="size-table" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&nbsp;</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" style="width:1118.67px"> <tbody> <tr> <td>Міжнародний&nbsp; (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>нотатки&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> <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(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) "464" ["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(1983) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '112' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }