Мужские наборы нижнего белья

array(4) { [16093]=> array(49) { ["product_id"]=> string(5) "16093" ["name"]=> string(78) "Футболка мужская Emporio Armani, набор из 2-х штук " ["description"]=> string(541) "<p>Класична футболка Emporio Armani з короткими рукавами і круглим вирізом.</p> <p>Призначена для створення образу в спортивному стилі.</p> <p>Зшита з джерсі синего и бордового цвета, склад 100% бавовна.</p> <p>Прикрашена логотипом лінії Emporio Armani.</p> <p>В комплекті 2 одиниці.</p> " ["characteristics"]=> string(529) "<ul> <li>Код товара: 16093</li> <li>Артикул: 111267 9А722 61735</li> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> <li>Цвет: синий и бордовый</li> <li>Рисунок: однотонная</li> <li>Материал: трикотаж</li> <li>Состав: 100%&nbsp;хлопок</li> <li>Комплект: 2 шт.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(126) "Футболка, бордовая, мужская, Emporio, Armani, набор, хлопок, хлопковая , синяя" ["model"]=> string(5) "16093" ["sku"]=> string(18) "111267 9A722 61735" ["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/1030-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) "1600.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(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 16:44:05" ["viewed"]=> string(3) "408" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "476" [4]=> string(3) "478" } [0]=> string(2053) "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 = '476' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16092]=> array(49) { ["product_id"]=> string(5) "16092" ["name"]=> string(67) "Футболка мужская (набор 2 шт) Emporio Armani " ["description"]=> string(545) "<p>Классическая футболка Emporio Armani с короткими рукавами и круглым вырезом.</p> <p>Предназначена для создания образа в спортивном стиле.</p> <p>Сшита из джерси серого и черного цвета, состав 100% хлопок.</p> <p>Украшена логотипом линии Emporio Armani.</p> <p>В комплекте 2 единицы.</p> " ["characteristics"]=> string(522) "<ul> <li>Код товара: 16092</li> <li>Артикул: 111267 9А722 70120</li> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> <li>Цвет: черный, серый</li> <li>Рисунок: однотонная</li> <li>Материал: трикотаж</li> <li>Состав: 100% хлопок</li> <li>Комлект из 2-х штук</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(147) "Футболка, мужская, Emporio Armani, черная, набор из 2 штук, футболки, нижнее, белье, серая " ["model"]=> string(5) "16092" ["sku"]=> string(18) "111267 9A722 70120" ["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/1025-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) "1600.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(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 16:44:54" ["viewed"]=> string(3) "583" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "476" [4]=> string(3) "478" } [0]=> string(2053) "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 = '476' GROUP BY p.product_id ORDER BY 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) "3" ["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(4) "3800" ["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) "409" ["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(2053) "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 = '476' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [12370]=> array(49) { ["product_id"]=> string(5) "12370" ["name"]=> string(64) "Боксеры мужские (набор 2 шт) Shine Original" ["description"]=> string(623) "<p>Боксеры мужские (набор 2 шт) Shine Original из хлопка. Изделие удобное в повседневной носке, средняя посадка, притачной эластичный пояс с символикой бренда. Ткань не застирывается&nbsp;и не скатывается, надолго сохраняя внешнйи вид.&nbsp;</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(446) "<ul> <li>Код товара: 12370</li> <li>Артикул: 2-91001N dark navy</li> </ul> <ul> <li>Бренд: Shine Original&nbsp;</li> <li>Страна: Дания</li> </ul> <ul> <li>Модель: трусы</li> <li>Цвет: синий</li> <li>Материал: хлопок 100%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Трусы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(141) "Трусы-боксеры, трусы, боксеры, белье, нижнее, мужские, набор, комплект, Shine Original" ["model"]=> string(5) "12370" ["sku"]=> string(18) "2-91001N dark navy" ["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/1140-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) "690.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(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-01-29 15:23:58" ["viewed"]=> string(3) "360" ["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(2053) "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 = '476' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }