Riani

array(12) { [16709]=> array(49) { ["product_id"]=> string(5) "16709" ["name"]=> string(47) "Жакет женский с поясом Riani" ["description"]=> string(1197) "<p>Укороченный пиджак из смеси хлопка и льна в миндальном цвете, стиль сафари*. Модель с короткими лацканами, широким ремнём на талии, рукавами длиной 3/4. Спортивные рукава реглан и накладные нагрудные карманы дополняют повседневный изысканный шик пиджака, со скрытой планкой на пуговицах.</p> <p>*Сафари &ndash; стиль одежды, который сформировался на основе экипировки охотников и прочно вошел в ранг летней классики одежды. Мягкая и комфортная униформа стала предметом целого модного культа путешественников и it-girls в реалиях городских джунглей. Одежда в стиле сафари &ndash; это идеальное сочетание городской моды и африканского колорита.</p> " ["characteristics"]=> string(655) "<ul> <li>Код товара: 16709</li> <li>Артикул: 401990-3617</li> </ul> <ul> <li>Бренд: Riani</li> <li>Страна: Германия</li> </ul> <ul> <li>Модель: пиджак</li> <li>Цвет: миндальный</li> <li>Материал: хлопок 86%, лен 13%, эластан 1%</li> <li>Стиль: сафари</li> <li>Рост модели 172 см</li> <li>На модели размер 36&nbsp;(немецкий)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Пиджак" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(227) "Жакет, женский, с поясом, рукава 3/4, Riani, четвертной рукав, бежевый, молочный, летний, осенний, весенний, костюмный, праздничный" ["model"]=> string(5) "16709" ["sku"]=> string(11) "401990-3617" ["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(65) "catalog/dn8/fotosessija/2020/ijul/pravki_zhenskoe/img_5208-ds.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(10) "12400.0000" ["special"]=> string(9) "8680.0000" ["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(2) "14" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 14:42:55" ["viewed"]=> string(3) "728" ["categories"]=> array(6) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "318" [3]=> string(3) "360" [4]=> string(3) "363" [5]=> string(3) "364" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16716]=> array(49) { ["product_id"]=> string(5) "16716" ["name"]=> string(46) "Штаны женские широкие Riani" ["description"]=> string(355) "<p>Женские укороченные брюки кораллового цвета.</p> <p>Модель выполнена из натурального льна, имеет прямые брючины с простроченной стрелкой, боковые и декоративные сзади карманы.</p> " ["characteristics"]=> string(637) "<ul> <li>Код товара: 16716</li> <li>Артикул: 403585-3656</li> </ul> <ul> <li>Бренд: Riani</li> <li>Страна: Германия</li> </ul> <ul> <li>Модель: брюки&nbsp;</li> <li>Цвет: коралловый</li> <li>Материал: лен 100%&nbsp;</li> <li>Стиль: кэжуал</li> <li>Рост модели 172 см</li> <li>На модели размер 36&nbsp;(немецкий)</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(139) "Штаны, брюки, женские коралловые, широкие, укороченные, Riani, модные, стильные " ["model"]=> string(5) "16716" ["sku"]=> string(11) "403585-3656" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/1_etazh_zhenskoe/img_5182-ds.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(9) "7980.0000" ["special"]=> string(9) "5586.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-16" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(2) "12" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-16 11:23:36" ["date_modified"]=> string(19) "2021-07-14 12:33:34" ["viewed"]=> string(3) "403" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16403]=> array(49) { ["product_id"]=> string(5) "16403" ["name"]=> string(70) "Пуловер женский с коротким рукавом Riani" ["description"]=> string(563) "<p>Тонкий трикотажный пуловер с короткими рукавами в форме реглана огненно-красного цвета. Модель с перекрещенной водолазной горловиной и широким вязаным манжетом по низу изделия.</p> <p>Якщо вас зацікавила модель, придбати пуловер жіночий з коротким рукавом Riani ви зможете в нашому магазині.</p> " ["characteristics"]=> string(646) "<ul> <li>Код товара: 16403</li> <li>Артикул: 307150 7673</li> </ul> <ul> <li>Бренд: Riani</li> <li>Страна: Германия</li> </ul> <ul> <li>Модель: пуловер</li> <li>Цвет: красный</li> <li>Материал: вискоза 70%, полиэстер 30%</li> <li>Стиль: кэжуал</li> <li>Рост модели 172 см</li> <li>На модели размер 36&nbsp;(немецкий)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Пуловер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(147) "Пуловер, кофта, женский, летний, с коротким рукавом, асимметричная, горловина, Riani" ["model"]=> string(5) "16403" ["sku"]=> string(11) "307150 7673" ["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(65) "catalog/dn8/fotosessija/2020/ijul/pravki_zhenskoe/img_5426-ds.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(9) "6250.0000" ["special"]=> string(9) "4375.0000" ["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(2) "10" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 14:08:37" ["viewed"]=> string(3) "336" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "218" [3]=> string(3) "375" [4]=> string(3) "511" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [17233]=> array(49) { ["product_id"]=> string(5) "17233" ["name"]=> string(33) "Бежевая куртка Riani" ["description"]=> string(1439) "<p>Бежевая куртка Riani - весенняя куртка - кардиган выполнена из натуральной&nbsp;ткани в трендовом бежевом цвете. По бокам куртки функциональные накладные карманы. По переду застежка на молнию. Рукав спущенный, широкий сверху и заужен к низу.&nbsp;Рукава и спинка выполнены из трикотажа в тон куртки. Ворот круглый по краю декоративная трикотажная резинка в тон. Модель оверсайз, укороченная, низ стягиваеться на кулиску.&nbsp;&nbsp;Куртка выглядит красиво и стильно, можно носитьь как кардиган.&nbsp;&nbsp;Она отлично впишется в весенне-летний гардероб.</p> <p>Если вас заинтересовала модель, приобрести бежевую&nbsp;куртку&nbsp;Riani можно в нашем магазине. Оформить заявку можно через сайт. Есть возможность оформить доставку по Киеву и по всей Украине. Удачных покупок!&nbsp;</p> " ["characteristics"]=> string(432) "<ul> <li>Код товара: 17233</li> <li>Артикул: 707230</li> <li>Бренд: Riani</li> <li>Страна: Германия</li> <li>Модель: куртка</li> <li>Цвет: бежевый</li> <li>Материал: шерсть 100%;</li> <li>Стиль: кэжуал&nbsp;</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(203) "куртка легкая, ветровка, куртка на молнии, с трикотажными вставками, куртка в спортивном стиле, свободный фасон" ["model"]=> string(5) "17233" ["sku"]=> string(6) "707230" ["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(57) "catalog/dn8/fotosessija/2020/oktjabr/4_etazh/img_0941.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(10) "11800.0000" ["special"]=> string(9) "8260.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-10-21" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(2) "10" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-21 10:01:17" ["date_modified"]=> string(19) "2021-07-13 15:13:57" ["viewed"]=> string(3) "296" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "399" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15120]=> array(49) { ["product_id"]=> string(5) "15120" ["name"]=> string(74) "Пуловер женский с рисунком-шахматкой Riani" ["description"]=> string(1091) "<p>Пуловер женский с коротким рукавом и рисунком-шахматкой Riani из гладкого трикотажа. Высококачесвенный материал хорошо пропускает воздух. Вырез &quot;лодочка&quot;. слегка спущенная линия плеч. Разрезы по бокам. Оригинальный декор - металлические шайбы.&nbsp; Трикотажная стяжка по подолу на рукавах.</p> <ul style="list-style-type:disc"> </ul> <p>Чтобы всегда выглядеть на высоте, соблюдайте рекомендации по уходу, указанные на ярлыке. Если вас заинтересовала модель, купить&nbsp;пуловер женский с коротким рукавом и рисунком-шахматкой Riani вы сможете в нашем магазине. Удачных покупок!</p> " ["characteristics"]=> string(619) "<ul style="list-style-type:disc"> <li>Модель: женский трикотажный пуловер;</li> <li>Фасон: свободный;</li> <li>Цвет: зеленый, белый;</li> <li>Узор: клетка (шахматка);</li> <li>Состав: вискоза 75%, акрил 25%;</li> <li>Сезонность: весна-лето-осень;</li> <li>Бренд:&nbsp;Riani (Риани);</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Пуловер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15120" ["sku"]=> string(11) "947620 7845" ["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(76) "catalog/dn8/2019-2-fotosessiya-modelyami-zhenskaya/19ijunja2019/ao6b7793.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(9) "4960.0000" ["special"]=> string(9) "2480.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-01" ["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) "9" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 14:09:09" ["viewed"]=> string(3) "450" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "218" [3]=> string(3) "375" [4]=> string(3) "511" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15124]=> array(49) { ["product_id"]=> string(5) "15124" ["name"]=> string(53) "Рубашка женская с принтом Riani" ["description"]=> string(1330) "<p>Рубашка женская белого цвета в полоску и цветочный принт с длинным рукавом Riani - оригинальная модель, которая украсит ваш повседневный гардероб. Отложной воротник с концами прямоугольной формы. Спереди кулиска с завязками, что позволяет регулировать ширину пояса. Укороченная супатная планка. Застегивается на пуговицы. Прямая линия плеч. Рукава до косточки большого пальца. Фигурная линия подола. Оригинальный акцент - вставка на спине из ткани другой расцветки.&nbsp;</p> <ul style="list-style-type:disc"> </ul> <p>Если вас заинтересовала модель, купить&nbsp;рубашку женскую белого цвета в полоску и цветочный принт с длинным рукавом Riani вы сможете в нашем магазине, сделав заказ через сайт или по телефону.&nbsp;</p> " ["characteristics"]=> string(721) "<ul style="list-style-type:disc"> <li>Модель: женская рубашка свободного кроя;</li> <li>Фасон: рубашка с длинным рукавом;</li> <li>Цвет: белый, бежевый, коралловый, зеленый;</li> <li>Узор: полосы, цветочный принт;</li> <li>Состав:&nbsp;вискоза 80%, шелк 20%;</li> <li>Сезонность:&nbsp;весна-лето-осень;</li> <li>Бренд:&nbsp;Riani (Риани);</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Рубашка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15124" ["sku"]=> string(11) "945800 3461" ["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(76) "catalog/dn8/2019-2-fotosessiya-modelyami-zhenskaya/19ijunja2019/ao6b7862.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(9) "8900.0000" ["special"]=> string(9) "6230.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-01" ["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) "9" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-07-13 12:37:42" ["viewed"]=> string(3) "971" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "182" [3]=> string(3) "199" [4]=> string(3) "366" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [17239]=> array(49) { ["product_id"]=> string(5) "17239" ["name"]=> string(54) "Пуловер c коротким рукавом Riani" ["description"]=> string(822) "<p>Пуловер c коротким рукавом Riani бежевого цвета. Круглый вырез, короткие рукава, овальный подол. Горизонтальные полоски из пайеток. Пуловер из натурального хлопка обладает своей воздухопроницаемостью; он легко стирается, прочен и износостоек. Хлопковый пуловер не согревает, но хорошо держит тепло. Поэтому пуловер из хлопка не подходит для холодного периода года. Купить&nbsp;пуловер c коротким рукавом Riani можно в магазине&nbsp;DN8 SHOPPING SPACE.</p> " ["characteristics"]=> string(441) "<ul> <li>Код товара:&nbsp;17239</li> <li>Артикул:&nbsp;708085</li> <li>Бренд: Riani</li> <li>Страна: Германия</li> <li>Модель: пуловер</li> <li>Цвет: бежевый</li> <li>Материал: хлопок 100%</li> <li>Стиль: кэжуал</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Пуловер" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(271) "пуловер, укороченный рукав, свободный пуловер, свободный свитер, свитер на каждый день, трикотаж полосатый, свитер для офиса, для учебы, для прогулки" ["model"]=> string(5) "17239" ["sku"]=> string(6) "708085" ["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(57) "catalog/dn8/fotosessija/2020/oktjabr/4_etazh/img_0934.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(9) "5900.0000" ["special"]=> string(9) "4130.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-10-21" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "7" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-21 10:01:17" ["date_modified"]=> string(19) "2021-07-12 14:10:39" ["viewed"]=> string(3) "147" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "218" [3]=> string(3) "375" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16713]=> array(49) { ["product_id"]=> string(5) "16713" ["name"]=> string(62) "Платье женское белое из хлопка Riani" ["description"]=> string(923) "<p>Платье без рукавов в белом цвете. Изделие выполнено в модной длине 7/8. Летнее платье соблазняет женственной утонченностью, подчеркивая фигуру, с широкими лямками и глубоким V-образным вырезом спереди и сзади. Романтические вставки с вышивкой и выгодная драпировка на талии завершают повседневный элегантный образ в стиле бохо.</p> <p>*Бохо &ndash; стиль одежды, который ассоциируется с пышными платьями и юбками, украшенные цветочным принтом, вышивкой, с добавлением бахромы и орнаментов.</p> " ["characteristics"]=> string(612) "<ul> <li>Код товара: 16713</li> <li>Артикул: 406840-3477</li> </ul> <ul> <li>Бренд: Riani</li> <li>Страна: Германия</li> </ul> <ul> <li>Модель: платье</li> <li>Цвет: белый</li> <li>Материал: хлопок 100%</li> <li>Стиль: бохо*</li> <li>Рост модели 172 см</li> <li>На модели размер 36&nbsp;(немецкий)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(120) "Платье, женское, длинное, летнее, белое, хлопок, легкое, Riani, на лето" ["model"]=> string(5) "16713" ["sku"]=> string(11) "406840-3477" ["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(66) "catalog/dn8/fotosessija/2020/ijul/4_etazh_zhenskoe/img_5525-ds.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(10) "10980.0000" ["special"]=> string(9) "7686.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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) "7" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 12:47:44" ["date_modified"]=> string(19) "2021-07-14 12:21:40" ["viewed"]=> string(3) "793" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14855]=> array(49) { ["product_id"]=> string(5) "14855" ["name"]=> string(48) "Брюки женские пудровые Riani" ["description"]=> string(862) "<p>Брюки женские зауженные пудрового цвета Riani в элегантном стиле. Прямые стрелки визуально удлиняют ноги. Модель с поясом, что позволяет регулировать ширину талии. Изделие с высокой талией. Застежка потайная молния. Длина до щиколотки. Не сковывает движений. Подходит для деловых встреч, офисного дресс-кода и вечерних выходов.</p> <ul> </ul> <p>Заказать брюки женские зауженные пудрового цвета Riani вы можете через сайт или по телефону в нашем магазине.</p> " ["characteristics"]=> string(531) "<ul> <li>Модель: брюки со средней талией;</li> <li>Фасон: зауженные;</li> <li>Цвет: пудровый;</li> <li>Узор: однотонные;</li> <li>Материал: полиэстер 96%, эластен 4%;</li> <li>Сезон: весна-лето;</li> <li>Бренд: Riani (Риани);</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14855" ["sku"]=> string(11) "933340 3178" ["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(42) "catalog/campaignss2019/4etazh/ao6b6154.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(9) "7600.0000" ["special"]=> string(9) "5320.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-04-01" ["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) "7" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-07-14 12:39:45" ["viewed"]=> string(3) "590" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "166" [3]=> string(3) "170" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14846]=> array(49) { ["product_id"]=> string(5) "14846" ["name"]=> string(43) "Блуза в мелкий принт Riani" ["description"]=> string(1084) "<p>Блуза женская с длинным рукавом белая в мелкий принт Riani из тонкой. ниспадающей ткани. Воротник рубашечный с острыми концами. Сзади двойная кокетка, декорированная контрастным кантом. Спущенная линия плеч. Длинные рукава на широких манжетах с окантовкой. Накладная планка. Разрезы по бокам. Асимметричный подол. Линия подола ровная. Модель подходит как для формальных, так и для неформальных мероприятий.&nbsp;</p> <ul> </ul> <p>Чтобы приобрести понравившуюся модель, достаточно заказать блузу женскую с длинным рукавом белую в мелкий принт Riani по телефону или через сайт.</p> " ["characteristics"]=> string(563) "<ul> <li>Модель: женская блуза с длинным рукавом;</li> <li>Фасон: свободный;</li> <li>Цвет: белый, голубой;</li> <li>Узор: мелкий принт;</li> <li>Состав: вискоза 100%;</li> <li>Сезон: весна-осень-зима;</li> <li>Бренд:&nbsp;Riani (Риани);</li> <li>Страна бренда: Германия.&nbsp;</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Блуза" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14846" ["sku"]=> string(11) "935170 3424" ["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(42) "catalog/campaignss2019/4etazh/ao6b6714.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(9) "6600.0000" ["special"]=> string(9) "4620.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-04-01" ["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) "4" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-07-13 12:40:46" ["viewed"]=> string(3) "647" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "182" [3]=> string(3) "199" [4]=> string(3) "366" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [17240]=> array(49) { ["product_id"]=> string(5) "17240" ["name"]=> string(46) "Бежевый женский гольф Riani" ["description"]=> string(958) "<p>Бежевый женский гольф Riani - базовая модель в гардеробе. Издлие хорошо сочетается с джинсам и более элегантным брюками, юбками. Основой соства пряжи яляется вискоза.&nbsp;Вискозу получают из&nbsp;природной целлюлозы, поэтому она относится к искуссвенным матариалам, но не явялется синтетикой. Ткани из&nbsp;вискозных волокон отлично впитывают и&nbsp;отводят влагу, пропускают воздух и&nbsp;гипоаллергенны. Но, как и&nbsp;другие ткани с&nbsp;натуральной основой, она требует бережного ухода.&nbsp;</p> <p>&nbsp;</p> " ["characteristics"]=> string(411) "<ul> <li>Код товара:&nbsp;17240</li> <li>Артикул: 807620</li> <li>Бренд: Riani</li> <li>Страна: Германия</li> <li>Модель: гольф</li> <li>Цвет: коричневый</li> <li>Материал: вискоза 70%, полиэстер 30%</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(210) "гольф, пуловер с высоким горлом, тонкий пуловер, шерстяной гольф, фиолетовый гольф, однотонный гольф, базовый гольф" ["model"]=> string(5) "17240" ["sku"]=> string(6) "807620" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(57) "catalog/dn8/fotosessija/2020/oktjabr/4_etazh/img_0580.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(9) "7800.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-10-21" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "3" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-21 10:01:17" ["date_modified"]=> string(19) "2021-07-12 14:20:15" ["viewed"]=> string(3) "176" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "218" [3]=> string(3) "378" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16405]=> array(49) { ["product_id"]=> string(5) "16405" ["name"]=> string(56) "Юбка женская асимметричная Riani" ["description"]=> string(352) "<p>Юбка из вискозы в тёмно-синем цвете. Изделие имеет яркий рисунок, металлическую пряжку и складки на поясе. Юбку украшает ассиметричный угловой подол.</p> <p>Длина изделия миди.</p> " ["characteristics"]=> string(637) "<ul> <li>Код товара: 16405</li> <li>Артикул: 304220 3624</li> </ul> <ul> <li>Бренд: Riani</li> <li>Страна: Германия</li> </ul> <ul> <li>Модель: юбка</li> <li>Цвет: темно-синий с принтом</li> <li>Материал: вискоза</li> <li>Стиль: кэжуал</li> <li>Рост модели 172 см</li> <li>На модели размер 36&nbsp;(немецкий)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(8) "Юбка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(139) "Юбка, женская, с контрастным принтом, длинная, асимметрия, асимметричная, Riani" ["model"]=> string(5) "16405" ["sku"]=> string(11) "304220 3624" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/4_etazh_zhenskoe/img_5430-ds.jpg" ["manufacturer_id"]=> string(3) "129" ["manufacturer"]=> string(5) "Riani" ["manufacturer_size_table"]=> string(843) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Riani</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(10) "12980.0000" ["special"]=> string(9) "9086.0000" ["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) "3" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-14 16:34:28" ["date_modified"]=> string(19) "2021-07-13 11:45:44" ["viewed"]=> string(3) "383" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "179" [3]=> string(3) "194" } [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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '129' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }