Fratelli Rossetti

array(12) { [14102]=> array(49) { ["product_id"]=> string(5) "14102" ["name"]=> string(56) "Черные дерби  броги  Fratelli Rossetti" ["description"]=> string(1260) "<p>В модели дерби&nbsp; открытая шнуровка, берцы нашиваются на союзку. Отличительная особенность брогов &ndash; декоративная перфорация вдоль всех швов и наличие перфорированного медальона на мыске, оформленном &laquo;крыльями&raquo;.</p> <p>Шнуровка на пять отверстий&nbsp; позволяет гибко регулировать объем обуви. Верх сшит из зерненной кожи&nbsp; теленка черного цвета.</p> <p>У модели дерби брогов&nbsp; Fratelli Rossetti подошва как у сникеров &ndash; плоская и устойчивая. Обувь произведена в Италии.</p> <p>Модель предназначенная для&nbsp; образов неформальном стиле. Самые выигрышные комбинации для бордовых дерби DN8 by Moreschi&nbsp; с неформальными пиджаками и джинсами.</p> " ["characteristics"]=> string(606) "<ul> <li>Код товара: 14102</li> <li>Артикул: 45722</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Сезон: зима</li> <li>Внешний материал: кожа теленка</li> <li>Внутренний материал: кожа</li> <li>Подошва: резина</li> <li>Стелька: кожа</li> <li>Стиль: casual</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(43) "Туфли мужские Fratelli Rossetti" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14102" ["sku"]=> string(5) "45722" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(39) "catalog/foto20-21predmetka/ao6b7103.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "12400.0000" ["special"]=> string(9) "6200.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-12" ["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(2) "90" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-01-14 14:11:18" ["viewed"]=> string(4) "1232" ["categories"]=> array(3) { [0]=> string(2) "71" [1]=> string(3) "155" [2]=> string(3) "307" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } [14106]=> array(49) { ["product_id"]=> string(5) "14106" ["name"]=> string(68) "Ботинки мужские утепленные Fratelli Rossetti" ["description"]=> string(1117) "<p>Утепленные ботинки чукка&nbsp; Fratelli Rossetti линии&nbsp;One. Особенность &nbsp;чукка &ndash; шнуровка на два или три отверстия, высота до щиколотки и отсутствие декоративных элементов.</p> <p>У модели чукка &nbsp;Fratelli Rossetti подошва как у сникеров &ndash; плоская и устойчивая. Верх сшит из зерненной кожи &nbsp;теленка синего цвета. Внутренняя часть утеплена натуральной овчиной.</p> <p>Обувь произведена в Италии. Модель предназначенная для&nbsp; образов неформальном стиле.</p> <p>Самые выигрышные комбинации для ботинок чукка&nbsp; Fratelli Rossetti &nbsp;&nbsp;с неформальными пиджаками и джинсами.</p> " ["characteristics"]=> string(612) "<ul> <li>Код товара: 14106</li> <li>Артикул: 45755</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: синий</li> <li>Сезон: зима</li> <li>Внешний материал: кожа теленка</li> <li>Внутренний материал: овчина</li> <li>Подошва: резина</li> <li>Стелька: овчина</li> <li>Стиль: casual</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(47) "Ботинки мужские Fratelli Rossetti" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14106" ["sku"]=> string(5) "45755" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(39) "catalog/foto20-21predmetka/ao6b7091.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "12750.0000" ["special"]=> string(9) "7650.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-12" ["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(2) "20" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2018-11-12 12:44:37" ["date_modified"]=> string(19) "2022-01-14 14:12:13" ["viewed"]=> string(4) "1468" ["categories"]=> array(3) { [0]=> string(2) "71" [1]=> string(3) "145" [2]=> string(3) "486" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } [14107]=> array(49) { ["product_id"]=> string(5) "14107" ["name"]=> string(80) "Утепленные мужские ботинки чукка Fratelli Rossetti" ["description"]=> string(892) "<p>Особенность чукка Fratelli Rossetti линии One&ndash; шнуровка на два или три отверстия, высота до щиколотки и отсутствие декоративных элементов.</p> <p>Верх сшит из зерненной кожи &nbsp;теленка черного цвета. Внутренняя часть утеплена натуральной овчиной.</p> <p>Обувь произведена в Италии. Модель предназначенная для&nbsp; образов неформальном стиле.</p> <p>Самые выигрышные комбинации для ботинок чукка&nbsp; Fratelli Rossetti &nbsp;&nbsp;с неформальными пиджаками и джинсами.</p> " ["characteristics"]=> string(614) "<ul> <li>Код товара: 14107</li> <li>Артикул: 45886</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Сезон: зима</li> <li>Внешний материал: кожа теленка</li> <li>Внутренний материал: овчина</li> <li>Подошва: резина</li> <li>Стелька: овчина</li> <li>Стиль: casual</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(47) "Ботинки мужские Fratelli Rossetti" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(15) "Ботинки " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14107" ["sku"]=> string(5) "45886" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "3" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(39) "catalog/foto20-21predmetka/ao6b6879.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "13590.0000" ["special"]=> string(9) "8154.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-12" ["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(2) "20" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2018-11-12 12:44:37" ["date_modified"]=> string(19) "2022-01-14 14:13:12" ["viewed"]=> string(4) "1557" ["categories"]=> array(3) { [0]=> string(2) "71" [1]=> string(3) "145" [2]=> string(3) "486" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } [8223]=> array(49) { ["product_id"]=> string(4) "8223" ["name"]=> string(81) "Черные оксфорды с отрезным носком Fratelli Rossetti " ["description"]=> string(839) "<p>Оксфорды с отрезным носком&nbsp;от Fratelli Rossetti - внесезонная классическая модель.</p> <p>Характерная особенность &ndash; отсутствие декоративных швов и перфорационных узоров.</p> <p>В модели использована кожа теленка классического черного цвета.</p> <p>Модель оптимальна для создания повседневных офисных луков.</p> <p>Оксфорды с отрезным носком&nbsp;черного цвета хорошо комбинируются с&nbsp;костюмами, блейзерами, слаксами.</p> " ["characteristics"]=> string(632) "<ul> <li>Код товара: 8223&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</li> <li>Артикул: 11240 black</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Сезон: вне сезона</li> <li>Внешний материал: кожа теленка</li> <li>Стелька: кожа</li> <li>Подошва: кожа/резина</li> <li>Стиль: business</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Оксфорды" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(158) "туфли, туфли для мужчин, оксфорды, классические туфли, туфли на шнуровке, базовые туфли" ["model"]=> string(4) "8223" ["sku"]=> string(11) "11240 black" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0158-ds.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "10900.0000" ["special"]=> string(9) "5450.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["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(2) "19" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-01-14 14:14:28" ["viewed"]=> string(3) "535" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "155" [3]=> string(3) "328" [4]=> string(3) "519" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } [8202]=> array(49) { ["product_id"]=> string(4) "8202" ["name"]=> string(64) "Дерби коричневые кожаные Fratelli Rossetti" ["description"]=> string(1025) "<p>Дерби с носком &laquo;крыльями&raquo; от Fratelli Rossetti -&nbsp; внесезонная классическая модель.</p> <p>В отличии от классических брогов, в этой модели перфорационный узор используется минимально.</p> <p>Шнуровка дерби позволяет регулировать объем обуви в большем диапазоне.</p> <p>В модели использована кожа теленка классического коньячного цвета с винтажным эффектом.</p> <p>Модель оптимальна для создания повседневных офисных луков.</p> <p>Дерби&nbsp; хорошо комбинируются с&nbsp; костюмами, блейзерами, чиносами и джинсами.</p> " ["characteristics"]=> string(633) "<ul> <li>Код товара: 8202</li> <li>Артикул: 11142</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: коричневый</li> <li>Сезон: вне сезона</li> <li>Внешний материал: кожа теленка</li> <li>Внутренний материал: кожа теленка</li> <li>Подошва: кожа теленка/профиалктика</li> <li>Стиль: smart casual</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(256) "туфли мужские, дерби, коричневые дерби, дерби на шнуровке, стильные туфли, базовые туфли, туфли на каждый день, офисные туфли, туфли на работу" ["model"]=> string(4) "8202" ["sku"]=> string(5) "11142" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "3" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0183-ds.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "10500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["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(2) "19" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:44:34" ["date_modified"]=> string(19) "2022-01-14 14:13:51" ["viewed"]=> string(3) "403" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "155" [3]=> string(3) "356" [4]=> string(3) "520" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } [8224]=> array(49) { ["product_id"]=> string(4) "8224" ["name"]=> string(49) "Коричневые дерби Fratelli Rossetti" ["description"]=> string(1104) "<p>Дерби броги с носком &laquo;крыльями&raquo; от Fratelli Rossetti&nbsp;-&nbsp;вне сезонная классическая модель.</p> <p>Характерная особенность брогов &ndash; швы, украшеные перфорированной декорацией и носок с медальоном.</p> <p>Шнуровка дерби позволяет регулировать объем обуви в большем диапазоне.</p> <p>В модели использована кожа теленка классического коньячного оттенка коричневого цвета.</p> <p>Модель оптимальна для создания повседневных офисных луков.</p> <p>Дерби броги&nbsp; коньячного цвета хорошо комбинируются с&nbsp; костюмами, блейзерами, чиносами и джинсами.</p> " ["characteristics"]=> string(633) "<ul> <li>Код товара: 8224</li> <li>Артикул: 11249</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: коричневый</li> <li>Сезон: вне сезона</li> <li>Внешний материал: кожа теленка</li> <li>Внутренний материал: кожа теленка</li> <li>Подошва: кожа теленка/профилактика</li> <li>Стиль: smart casual</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(256) "туфли мужские, дерби, коричневые дерби, дерби на шнуровке, стильные туфли, базовые туфли, туфли на каждый день, офисные туфли, туфли на работу" ["model"]=> string(4) "8224" ["sku"]=> string(5) "11249" ["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(73) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0156-ds-ds.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "10900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["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(2) "19" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:44:34" ["date_modified"]=> string(19) "2022-01-14 14:15:05" ["viewed"]=> string(3) "464" ["categories"]=> array(6) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "155" [3]=> string(3) "356" [4]=> string(3) "485" [5]=> string(3) "520" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } [8226]=> array(49) { ["product_id"]=> string(4) "8226" ["name"]=> string(82) "Черные оксфорды с отрезным носком Fratelli Rossetti " ["description"]=> string(925) "<p>Черные оксфорды&nbsp; с отрезным носком от Fratelli Rossetti &nbsp;&nbsp;- внесезонная модель.</p> <p>Перфорированная декорация шва на носке и наличие медальона делают эту модель менее формальной, чем оксфорды с отрезным носком.</p> <p>Для пошива&nbsp; использована кожа теленка черного цвета.</p> <p>Модель одинаково подходит для создания деловых и повседневных луков.</p> <p>Оксфорды Fratelli Rossetti черного цвета хорошо комбинируются с&nbsp; костюмами, блейзерами, слаксами и джинсами.</p> " ["characteristics"]=> string(621) "<ul> <li>Код товара: 8226</li> <li>Артикул: 11321</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Сезон: вне сезона</li> <li>Внешний материал: Кожа теленка</li> <li>Внутренний материал: Кожа теленка</li> <li>Подошва: Кожа теленка/профиалктика</li> <li>Стиль: business</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Оксфорды" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(319) "кожаные оксфорды, мужские оксфорды, туфли на шнуровке, туфли с перфорацией, оксфорды с перфрацией, оксфорды на каждый день, оксфорды удобные, офисные туфли, оксфорды для офиса" ["model"]=> string(4) "8226" ["sku"]=> string(5) "11321" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0201-ds.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "12500.0000" ["special"]=> string(9) "6250.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["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(2) "19" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-01-14 14:17:13" ["viewed"]=> string(3) "552" ["categories"]=> array(6) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "155" [3]=> string(3) "328" [4]=> string(3) "485" [5]=> string(3) "519" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } [8236]=> array(49) { ["product_id"]=> string(4) "8236" ["name"]=> string(53) "Оксфорды хоулкатс Fratelli Rossetti " ["description"]=> string(1180) "<p>Оксфорды &ndash;&nbsp; классическая модель мужских туфель, отличающаяся от других закрытой шнуровкой. Берцы вшиваются под союзку, а язычок под берцы.</p> <p>Данный вид оксфордов называется&nbsp; хоулкатс, он сшит из одного куска кожи.</p> <p>В модели использована&nbsp; матовая кожа теленка коричневого цвета с патинированием.</p> <p>Классическая шнуровка на пять отверстий.</p> <p>Кожаная подошва дополнительно защищена&nbsp; резиновой накладкой.</p> <p>Обувь произведена в Италии.</p> <p>Оксфорды&nbsp; хоулкатс Fratelli Rossetti используют для завершения образов повседневных деловых&nbsp; и офисных стилях.</p> " ["characteristics"]=> string(643) "<ul> <li>Код товара: 8236</li> <li>Артикул: 11751</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: коричневый</li> <li>Сезон: вне сезона</li> <li>Внешний материал: кожа теленка</li> <li>Внутренний материал: кожа</li> <li>Стелька: кожа</li> <li>Подошва: кожа/резина</li> <li>Стиль: business, casual</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(17) "Fratelli Rossetti" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Оксфорды" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "8236" ["sku"]=> string(5) "11751" ["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(43) "data/1c/utp005036_catalog_test_img_7647.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "15400.0000" ["special"]=> string(9) "9240.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-29" ["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(2) "18" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-01-14 14:17:59" ["viewed"]=> string(4) "1084" ["categories"]=> array(4) { [0]=> string(2) "71" [1]=> string(3) "155" [2]=> string(3) "328" [3]=> string(3) "519" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } [8234]=> array(49) { ["product_id"]=> string(4) "8234" ["name"]=> string(55) "Оксфорды фиолетовые Fratelli Rossetti" ["description"]=> string(1143) "<p>Оксфорды &ndash;&nbsp; классическая модель мужских туфель, отличающаяся от других закрытой шнуровкой. Берцы вшиваются под союзку, а язычок под берцы.</p> <p>Отличительная особенность модели &ndash; отрезной мысок и отсутствие декоративных элементов.</p> <p>В модели использована&nbsp; матовая кожа теленка фиолетового цвета.</p> <p>Классическая шнуровка на пять отверстий.</p> <p>Кожаная подошва дополнительно защищена&nbsp; резиновой накладкой.</p> <p>Обувь произведена в Италии.</p> <p>Оксфорды&nbsp;Fratelli Rossetti используют для завершения образов повседневных&nbsp; офисных стилях.</p> " ["characteristics"]=> string(643) "<ul> <li>Код товара: 8234</li> <li>Артикул: 11240</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: фиолетовый</li> <li>Сезон: вне сезона</li> <li>Внешний материал: кожа теленка</li> <li>Внутренний материал: кожа</li> <li>Стелька: кожа</li> <li>Подошва: кожа/резина</li> <li>Стиль: casual, business</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(15) "Туфли F.R." ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Оксфорды" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "8234" ["sku"]=> string(5) "11240" ["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(43) "data/1c/utp005034_catalog_test_img_7640.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "14900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-29" ["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(2) "18" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-01-14 14:20:05" ["viewed"]=> string(4) "1198" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "155" [3]=> string(3) "328" [4]=> string(3) "519" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } [8237]=> array(49) { ["product_id"]=> string(4) "8237" ["name"]=> string(59) "Оксфорды квотер броги Fratelli Rossetti" ["description"]=> string(1501) "<p>Оксфорды квотер броги&nbsp;с комбинированным верхом Fratelli Rossetti.</p> <p>Оксфорды &ndash;&nbsp; классическая модель мужских туфель, отличающаяся от других закрытой шнуровкой. Берцы вшиваются под союзку, а язычок под берцы.</p> <p>Отличительная особенность квотер &ndash; брогов в наличие декоративной перфорации&nbsp; вдоль всех швов, но отсутствие перфорированного медальона на мыске.</p> <p>Комбинированный верх сшит из&nbsp; матовой кожи теленка коричневого цвета и коричневого нубука.</p> <p>Классическая шнуровка на пять отверстий.</p> <p>Кожаная подошва дополнительно защищена&nbsp; резиновой накладкой.</p> <p>Обувь произведена в Италии.</p> <p>Оксфорды&nbsp; квотер броги&nbsp; Fratelli Rossetti используют для завершения образов повседневных деловых и неформальных стилях.</p> " ["characteristics"]=> string(671) "<ul> <li>Код товара: 8237</li> <li>Артикул: 11753</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: коричневый</li> <li>Сезон: вне сезона</li> <li>Внешний материал: нубук, кожа теленка</li> <li>Внутренний материал: кожа теленка</li> <li>Стелька: кожа</li> <li>Подошва: кожа /резина</li> <li>Стиль: casual, business</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(43) "Туфли мужские Fratelli Rossetti" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Оксфорды" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "8237" ["sku"]=> string(5) "11753" ["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(43) "data/1c/utp005037_catalog_test_img_7651.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "14900.0000" ["special"]=> string(9) "8940.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-29" ["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(2) "18" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2022-01-14 14:21:04" ["viewed"]=> string(3) "963" ["categories"]=> array(4) { [0]=> string(2) "71" [1]=> string(3) "155" [2]=> string(3) "328" [3]=> string(3) "519" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } [8227]=> array(49) { ["product_id"]=> string(4) "8227" ["name"]=> string(62) "Дерби с отрезным носком Fratelli Rossetti " ["description"]=> string(1133) "<p>Коричневые дерби с отрезным носком от&nbsp;Fratelli Rossetti&nbsp;- летняя деловая классика.</p> <p>Особенность модели в сочетании формального отрезного носка с комфортной шнуровкой.</p> <p>В модели использована кожа теленка коньячного оттенка коричневого &nbsp;цвета.</p> <p>Модель предназначена для луков в деловом и офисных стилях.</p> <p>Самые выиграшные комбинации для коричневых дерби с отрезным носком&nbsp; - с деловыми&nbsp; костюмами и&nbsp;блейзерами.</p> <p>Оформить заявку на покупку дерби с отрезным носком Fratelli Rossetti на нашем сайте можно прямо сейчас. dn8.ua: мы работаем для вас!</p> " ["characteristics"]=> string(618) "<ul> <li>Код товара: 8227</li> <li>Артикул: 11498</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: коричневый</li> <li>Сезон: лето</li> <li>Внешний материал: кожа теленка</li> <li>Внутренний материал: кожа теленка</li> <li>Подошва: кожа теленка/профиалктика</li> <li>Стиль: business</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(256) "туфли мужские, дерби, коричневые дерби, дерби на шнуровке, стильные туфли, базовые туфли, туфли на каждый день, офисные туфли, туфли на работу" ["model"]=> string(4) "8227" ["sku"]=> string(5) "11498" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(73) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0163-ds-ds.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "10900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["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-07 10:44:34" ["date_modified"]=> string(19) "2022-01-14 14:23:22" ["viewed"]=> string(3) "352" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "155" [3]=> string(3) "356" [4]=> string(3) "520" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } [13549]=> array(49) { ["product_id"]=> string(5) "13549" ["name"]=> string(49) "Лоферы бордовые Fratelli Rossetti " ["description"]=> string(1262) "<p>Бордовые пенни - лоферы с контрастной подошвой Fratelli Rossetti &ndash; спортивная интерпретация классической модели.</p> <p>Отличительная особенность пенни лоферов &ndash; кожаный ремешок, пришитый над овальной вставкой.</p> <p>По легенде студенты перед экзаменами прятали за него монетку пенни&nbsp;на удачу.</p> <p>В модели использована мягкая зерненая кожа теленка бордового цвета, оптимальная для ношения без носков.</p> <p>Мягкий верх и гибкая резиновая подошва делают обувь максимально комфортной для теплого сезона.</p> <p>Лоферы предназначены для создания повседневных луков и комбинируются с летними рубашками, поло, шортами , чиносами и джинсами.</p> " ["characteristics"]=> string(491) "<ul> <li>Код товара: 13549</li> <li>Артикул: 13305</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: бордовый</li> <li>Сезон: лето</li> <li>Внешний материал: кожа теленка</li> <li>Подошва: резина</li> <li>Стиль: casual</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(165) "лоферы, лоферы в офис, лоферы на каждый день, лоферы удобные, лоферы с пряжкой, пенни лоферы" ["model"]=> string(5) "13549" ["sku"]=> string(5) "13305" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0139-ds.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>Fratelli Rossetti</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "11800.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["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-07 10:44:34" ["date_modified"]=> string(19) "2021-06-22 15:14:38" ["viewed"]=> string(3) "518" ["categories"]=> array(4) { [0]=> string(2) "71" [1]=> string(3) "150" [2]=> string(3) "155" [3]=> string(3) "483" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41'ORDER BY p.sort_order DESC LIMIT 0,12" } }