Мужские трусы

array(12) { [7816]=> array(49) { ["product_id"]=> string(4) "7816" ["name"]=> string(46) "Трусы боксеры белые Van Laack" ["description"]=> string(1185) "<p>Классические комфортные текстильные боксеры от van Laack средней длины.</p> <p>Модель с универсальной средней посадкой, потайным эластичным поясом и функциональной ширинкой с застежкой на 2 пуговицы.</p> <p>Сшиты запошивочным швом, обеспечивающим комфорт прочность и долговечность.</p> <p>Материал боксеров - хлопковый батист (100% мерсеризованный хлопок), классического белого цвета.</p> <p>Он не пиллингуется, приятен тактильно и обладает отличными гигроскопическими свойствами.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> <p style="margin-left:24px">&nbsp;</p> " ["characteristics"]=> string(494) "<ul> <li>Код товара: 7816</li> <li>Артикул: 160354 000</li> </ul> <ul> <li>Бренд: van Laack</li> <li>Страна: Германия</li> </ul> <ul> <li>Цвет: белый</li> <li>Рисунок: однотонный</li> <li>Материал: текстиль</li> <li>Состав: 100% хлопок</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Трусы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(116) "Трусы-боксеры, белые, мужские, белые, трусы, боксеры, белье, Van Laack" ["model"]=> string(4) "7816" ["sku"]=> string(10) "160354 000" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1052-ds.jpg" ["manufacturer_id"]=> string(3) "110" ["manufacturer"]=> string(9) "van Laack" ["manufacturer_size_table"]=> string(3523) "<div class="men"> <p>Мужские&nbsp;верхняя одежда, костюм, пиджак, трикотаж, брюки</p> <table class="men"> <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> </tr> <tr> <td>van Laack</td> <td>&nbsp;</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</td> </tr> </tbody> </table> <p>Мужские рубашки</p> <table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>van Laack</td> <td>38-39</td> <td>40-41</td> <td>42-43</td> <td>44-45</td> <td>46-47</td> <td>48-49</td> <td>50</td> </tr> </tbody> </table> <p>Мужское нижнее белье&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>боксеры</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> </div> <div class="women"> <p>Женские верхняя одежда, костюм, пиджак, трикотаж, блузы, брюки</p> <table class="women"> <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> </tr> <tr> <td>van Laack&nbsp;</td> <td>&nbsp;</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> </tr> </tbody> </table> </div> " ["price"]=> string(9) "1260.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["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-19 13:14:48" ["date_modified"]=> string(19) "2021-02-02 10:52:39" ["viewed"]=> string(3) "305" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11563]=> array(49) { ["product_id"]=> string(5) "11563" ["name"]=> string(60) "Трусы боксеры (набор 2 шт) Shine Original" ["description"]=> string(712) "<p>Трусы боксеры (набор 2 шт) Shine Original из мягкого эластичного трикотажа. Мужские трусы средней длины в классическом дизайне.&nbsp;Изделие в разных цветовых решениях - базовый черный и белый в растительный принт. Материал не пиллингиуется (не скатывается), не деформируется, не линяет.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(406) "<ul> <li>Код товара: 11563</li> <li>Артикул: 2-95100 palm</li> <li>Бренд: Shine Original</li> <li>Страна бренда: Дания</li> <li>Модель: трусы</li> <li>цвет синий</li> <li>Материал: хлопок 95%, эластан 5%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(11) "Трусы " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(112) "Трусы-боксеры, трусы, боксеры, плавки, упаковка Shine Original, набор" ["model"]=> string(5) "11563" ["sku"]=> string(12) "2-95100 palm" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1153-ds.jpg" ["manufacturer_id"]=> string(2) "51" ["manufacturer"]=> string(14) "Shine Original" ["manufacturer_size_table"]=> string(1999) "<p>Одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Shine Original</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Shine Original (джинсы)</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Аксессуары&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>примечание</td> </tr> <tr> <td>Shine original (ремни)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(8) "650.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:34:37" ["date_modified"]=> string(19) "2021-08-02 15:28:48" ["viewed"]=> string(3) "279" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" [4]=> string(3) "476" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16078]=> array(49) { ["product_id"]=> string(5) "16078" ["name"]=> string(56) "Трусы черные с принтом Emporio Armani" ["description"]=> string(1046) "<p>Стильные слипы от Emporio Armani.</p> <p>Универсальная&nbsp; средняя посадка, черный цвет и оригинальный принт.</p> <p>Слипы сшиты из джерси с оригинальным составом&nbsp; (95% хлопок, 5% эластан), который не пилингуется, приятен тактильно, обладает&nbsp; отличными гигроскопическими свойствами и&nbsp; обеспечивает комфортную посадку.</p> <p>Оригинальное дизайнерское решение &ndash; контрастный эластичный пояс с графическим принтом и логотипом Emporio Armani.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(509) "<ul> <li>Код товара: 16078</li> <li>Артикул: 110814 9А506</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: черный</li> <li>Рисунок: принт</li> <li>Материал: трикотаж</li> <li>Состав: 95% хлопок, 5% эластан</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(11) "Трусы " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(82) "Трусы, мужские, черные, синие, хлопок, Emporio Armani" ["model"]=> string(5) "16078" ["sku"]=> string(12) "110814 9A506" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1087-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Мужская одежда</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>боксеры, слипы</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1100.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 15:40:12" ["viewed"]=> string(3) "243" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [7782]=> array(49) { ["product_id"]=> string(4) "7782" ["name"]=> string(46) "Трусы черные полосатые Isa" ["description"]=> string(948) "<p>Комфортные трикотажные боксеры от ISA средней длины.</p> <p>Модель с универсальной средней посадкой, плоскими швами, и эластичным поясом.</p> <p>Классический черный цвет.</p> <p>Боксеры сшиты из трикотажа с плетением риб с естественным эластичным эффектом. Материал не пилингуется, приятен тактильно, обладает&nbsp; отличными гигроскопическими свойствами и обеспечивает комфортную посадку.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(500) "<ul> <li>Код товара: 7782</li> <li>Артикул: 1448 0013</li> </ul> <ul> <li>Бренд: ISA Bodywear</li> <li>Страна: Швейцария</li> </ul> <ul> <li>Цвет: черный</li> <li>Рисунок: однотонный</li> <li>Материал: трикотаж</li> <li>Состав: хлопок 100%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(107) "Трусы-боксеры, мужские, черные, в полоску, Isa, трусы, боксеры" ["model"]=> string(4) "7782" ["sku"]=> string(9) "1448 0013" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1124-ds.jpg" ["manufacturer_id"]=> string(2) "28" ["manufacturer"]=> string(12) "Isa Bodywear" ["manufacturer_size_table"]=> string(850) "<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>Isa Bodywear</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1090.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-02-02 12:12:56" ["viewed"]=> string(3) "316" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [7722]=> array(49) { ["product_id"]=> string(4) "7722" ["name"]=> string(60) "Трусы черные мужские в полоску Isa" ["description"]=> string(886) "<p>​​​​​​Комфортные трикотажные слипы от ISA.</p> <p>Универсальная средняя посадка, плоские швы, эластичный пояс, классический черный цвет.</p> <p>Слипы сшиты трикотажа с плетением риб с естественным эластичным эффектом.</p> <p>Материал не пилингуется, приятен тактильно, обладает отличными гигроскопическими свойствами и обеспечивает комфортную посадку.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(500) "<ul> <li>Код товара: 7722</li> <li>Артикул: 1450 0013</li> </ul> <ul> <li>Бренд: ISA Bodywear</li> <li>Страна: Швейцария</li> </ul> <ul> <li>Цвет: черный</li> <li>Рисунок: однотонный</li> <li>Материал: трикотаж</li> <li>Состав: хлопок 100%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(81) "Трусы, черные, мужские, в полоску, Isa, полоска " ["model"]=> string(4) "7722" ["sku"]=> string(9) "1450 0013" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1120-ds.jpg" ["manufacturer_id"]=> string(2) "28" ["manufacturer"]=> string(12) "Isa Bodywear" ["manufacturer_size_table"]=> string(850) "<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>Isa Bodywear</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(8) "750.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-02-02 12:13:21" ["viewed"]=> string(3) "269" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [7780]=> array(49) { ["product_id"]=> string(4) "7780" ["name"]=> string(45) "Трусы черные в полоску Isa" ["description"]=> string(902) "<p>Комфортные трикотажные боксеры от ISA средней длины.</p> <p>Модель с универсальной средней посадкой,&nbsp; плоскими швами, и эластичным поясом.</p> <p>Боксеры сшиты из гладкого трикотажа, эластичного за счет добавки эластана.</p> <p>Материал не пилингуется, приятен тактильно, обладает&nbsp; отличными гигроскопическими свойствами и обеспечивает комфортную посадку.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(514) "<ul> <li>Код товара: 7780</li> <li>Артикул: 315113 0013</li> </ul> <ul> <li>Бренд: ISA Bodywear</li> <li>Страна: Швейцария</li> </ul> <ul> <li>Цвет: черный</li> <li>Рисунок: полоска</li> <li>Материал: трикотаж</li> <li>Состав: хлопок 95%, эластан 5%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(11) "Трусы " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(107) "Трусы-боксеры, трусы, мужские, черные, боксеры, в полоску, Isa" ["model"]=> string(4) "7780" ["sku"]=> string(11) "315113 0013" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1107-ds.jpg" ["manufacturer_id"]=> string(2) "28" ["manufacturer"]=> string(12) "Isa Bodywear" ["manufacturer_size_table"]=> string(850) "<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>Isa Bodywear</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(8) "940.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 15:42:41" ["viewed"]=> string(3) "306" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16079]=> array(49) { ["product_id"]=> string(5) "16079" ["name"]=> string(38) "Трусы черные Emporio Armani" ["description"]=> string(1056) "<p>Стильные слипы от Emporio Armani.</p> <p>Универсальная&nbsp; средняя посадка, классический черный цвет и оригинальный принт.</p> <p>Слипы сшиты из джерси с оригинальным составом (95% хлопок, 5% эластан), который не пилингуется, приятен тактильно, обладает&nbsp; отличными гигроскопическими свойствами и&nbsp; обеспечивает комфортную посадку.</p> <p>Оригинальное дизайнерское решение &ndash; эластичный пояс тон в тон, с графическим принтом и логотипом Emporio Armani.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(515) "<ul> <li>Код товара: 16079</li> <li>Артикул: 110814 9А508 17520</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: черный</li> <li>Рисунок: принт</li> <li>Материал: трикотаж</li> <li>Состав: 95% хлопок, 5% эластан</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Трусы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(99) "Трусы, мужские, Emporio Armani, темно-серые, с надписью, серые " ["model"]=> string(5) "16079" ["sku"]=> string(18) "110814 9A508 17520" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1076-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Мужская одежда</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>боксеры, слипы</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1100.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-02-02 12:14:10" ["viewed"]=> string(3) "253" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16083]=> array(49) { ["product_id"]=> string(5) "16083" ["name"]=> string(49) "Трусы слипы черные Emporio Armani" ["description"]=> string(1098) "<p>Стильные слипы от Emporio Armani.</p> <p>Универсальная &nbsp;средняя посадка&nbsp; и классический серый меланж.</p> <p>Слипы сшиты из джерси с оригинальным составом &nbsp;(95% хлопок, 5% эластан), который не пилингуется, приятен тактильно, обладает&nbsp; отличными гигроскопическими свойствами и&nbsp; обеспечивает комфортную посадку.</p> <p>Оригинальное дизайнерское решение - эластичный пояс тон в тон &nbsp;с контрастными полосками, &nbsp;с графическим принтом и логотипом Emporio Armani.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(465) "<ul> <li>Код товара: 16083</li> <li>Артикул: 110814 9А510 00020</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: черный</li> <li>Материал: трикотаж</li> <li>Состав: 95% хлопок, 5% эластан</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Трусы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(143) "Трусы, мужские, с крупной надписью, на резинке, резинка, хлопок, Emporio Armani, Армани" ["model"]=> string(5) "16083" ["sku"]=> string(18) "110814 9A510 00020" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1074-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Мужская одежда</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>боксеры, слипы</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(8) "990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-02-02 12:14:36" ["viewed"]=> string(3) "242" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16081]=> array(49) { ["product_id"]=> string(5) "16081" ["name"]=> string(47) "Трусы слипы синие Emporio Armani" ["description"]=> string(1044) "<p>Стильные слипы от Emporio Armani.</p> <p>Универсальная &nbsp;средняя посадка, синий цвет и оригинальный принт.</p> <p>Слипы сшиты из джерси с оригинальным составом &nbsp;(95% хлопок, 5% эластан), который не пилингуется, приятен тактильно, обладает&nbsp; отличными гигроскопическими свойствами и&nbsp; обеспечивает комфортную посадку.</p> <p>Оригинальное дизайнерское решение &ndash; контрастный эластичный пояс с графическим принтом и логотипом Emporio Armani.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(513) "<ul> <li>Код товара: 16081</li> <li>Артикул: 110814 9А508 27133</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: синий</li> <li>Рисунок: принт</li> <li>Материал: трикотаж</li> <li>Состав: 95% хлопок, 5% эластан</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Трусы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(134) "Трусы, мужские, синие, с черными надписями, Emporio Armani, нижнее, мужское, белье" ["model"]=> string(5) "16081" ["sku"]=> string(18) "110814 9A508 27133" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1085-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Мужская одежда</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>боксеры, слипы</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1100.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 15:44:42" ["viewed"]=> string(3) "254" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16084]=> array(49) { ["product_id"]=> string(5) "16084" ["name"]=> string(47) "Трусы слипы серые Emporio Armani" ["description"]=> string(1036) "<p>Стильные слипы от Emporio Armani.</p> <p>Универсальная &nbsp;средняя посадка&nbsp; и классический серый меланж.</p> <p>Слипы сшиты из джерси с оригинальным составом &nbsp;(95% хлопок, 5% эластан), который не пилингуется, приятен тактильно, обладает&nbsp; отличными гигроскопическими свойствами и&nbsp; обеспечивает комфортную посадку.</p> <p>Оригинальное дизайнерское решение - контрастный эластичный пояс с графическим принтом и логотипом Emporio Armani.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(463) "<ul> <li>Код товара: 16084</li> <li>Артикул: 110814 9А510 06749</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: серый</li> <li>Материал: трикотаж</li> <li>Состав: 95% хлопок, 5% эластан</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Трусы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(116) "Трусы, мужские, серые, с резинкой Emporio Armani, нижнее, мужское, белье" ["model"]=> string(5) "16084" ["sku"]=> string(18) "110814 9A510 06749" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1080-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Мужская одежда</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>боксеры, слипы</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(8) "990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 15:53:47" ["viewed"]=> string(3) "287" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16082]=> array(49) { ["product_id"]=> string(5) "16082" ["name"]=> string(55) "Трусы слипы с принтом Emporio Armani" ["description"]=> string(1056) "<p>Стильные слипы от Emporio Armani.</p> <p>Универсальная &nbsp;средняя посадка, классический черный цвет и оригинальный принт.</p> <p>Слипы сшиты из джерси с оригинальным составом &nbsp;(95% хлопок, 5% эластан), который не пилингуется, приятен тактильно, обладает&nbsp; отличными гигроскопическими свойствами и&nbsp; обеспечивает комфортную посадку.</p> <p>Оригинальное дизайнерское решение - эластичный пояс тон в тон, с графическим принтом и логотипом Emporio Armani.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(509) "<ul> <li>Код товара: 16082</li> <li>Артикул: 110814 9А509</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: черный</li> <li>Рисунок: принт</li> <li>Материал: трикотаж</li> <li>Состав: 95% хлопок, 5% эластан</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Трусы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(114) "Трусы, мужские, хлопковые, абстракция, Emporio Armani, хлопок, удобные" ["model"]=> string(5) "16082" ["sku"]=> string(12) "110814 9A509" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1083-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Мужская одежда</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>боксеры, слипы</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1350.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 15:55:27" ["viewed"]=> string(3) "328" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16080]=> array(49) { ["product_id"]=> string(5) "16080" ["name"]=> string(57) "Трусы слипы коричневые Emporio Armani" ["description"]=> string(1071) "<p>Стильные слипы от Emporio Armani.</p> <p>Универсальная&nbsp; средняя посадка, классический коричневый цвет и оригинальный принт.</p> <p>Слипы сшиты из джерси с оригинальным составом&nbsp; (95% хлопок, 5% эластан), который не пилингуется, приятен тактильно, обладает&nbsp; отличными гигроскопическими свойствами и&nbsp; обеспечивает комфортную посадку.</p> <p>Оригинальное дизайнерское решение - эластичный пояс тон в тон,&nbsp; графическим принтом и логотипом Emporio Armani.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(523) "<ul> <li>Код товара: 16080</li> <li>Артикул: 110814 9А508 21144</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: коричневый</li> <li>Рисунок: принт</li> <li>Материал: трикотаж</li> <li>Состав: 95% хлопок, 5% эластан</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Трусы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(121) "Трусы, мужские, темно-коричневые, коричневые, с надписями, Emporio Armani" ["model"]=> string(5) "16080" ["sku"]=> string(18) "110814 9A508 21144" ["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(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1078-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Мужская одежда</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>боксеры, слипы</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1100.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 15:55:50" ["viewed"]=> string(3) "263" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "475" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '475' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }