Брендовые женские трусики

Сортировать:

Показывать:

array(12) { [16808]=> array(49) { ["product_id"]=> string(5) "16808" ["name"]=> string(64) "Трусы синие Emporio Armani, набор из 2 штук" ["description"]=> string(405) "<p>Комплект трусов из 2 пар синего цвета. Изготовлены из хлопка, имеют эластичный широкий пояс с логотипом бренда.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> " ["characteristics"]=> string(497) "<ul> <li>Код товара: 16808</li> <li>Артикул: 163337 0Р317</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: синий</li> <li>Модель: трусы</li> <li>Материал: хлопок 95%, эластан 5%</li> <li>Стиль: белье</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(141) "Трусики, женские, синего цвета, синие, комплект, синие, Emporio Armani, набор из 2 штук" ["model"]=> string(5) "16808" ["sku"]=> string(12) "163337 0P317" ["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(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1389-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(9) "1300.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 14:49:12" ["viewed"]=> string(3) "455" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "232" [3]=> string(3) "234" [4]=> string(3) "237" } [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 = '234' 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" } [16801]=> array(49) { ["product_id"]=> string(5) "16801" ["name"]=> string(68) "Трусы женские Emporio Armani, набор из 2 штук" ["description"]=> string(450) "<ul> </ul> <p>Комплект трусов из 2 пар белого цвета. Изготовлены из хлопка, имеют эластичный пояс с логотипом бренда.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> <p> </p> " ["characteristics"]=> string(503) "<ul> <li>Код товара: 16801</li> <li>Артикул: 163334 0Р263 04710</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: белый</li> <li>Модель: трусы</li> <li>Материал: хлопок 95%, эластан 5%</li> <li>Стиль: белье</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(86) "Трусики, женские, Emporio Armani, набор, белье, женское" ["model"]=> string(5) "16801" ["sku"]=> string(18) "163334 0P263 04710" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1393-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(9) "1300.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 14:58:58" ["viewed"]=> string(3) "387" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "232" [3]=> string(3) "234" [4]=> string(3) "237" } [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 = '234' 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" } [16818]=> array(49) { ["product_id"]=> string(5) "16818" ["name"]=> string(38) "Трусы черные Emporio Armani" ["description"]=> string(411) "<ul> </ul> <p>Трусы-бразилиана из микрофибры в чёрном цвете. С эластичным поясом, отделка из люрекса с логотипом.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> " ["characteristics"]=> string(499) "<ul> <li>Код товара: 16818</li> <li>Артикул: 163179 0Р263</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: черный</li> <li>Модель: трусы</li> <li>Материал: хлопок 95%, эластан 5%</li> <li>Стиль: белье</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(124) "Трусики, женские, черные, эластичные, Emporio Armani, нижнее, белье, женское" ["model"]=> string(5) "16818" ["sku"]=> string(12) "163179 0P263" ["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(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1352-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 14:46:38" ["viewed"]=> string(3) "412" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "232" [3]=> string(3) "234" } [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 = '234' 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" } [16806]=> array(49) { ["product_id"]=> string(5) "16806" ["name"]=> string(38) "Трусы хлопок Emporio Armani" ["description"]=> string(375) "<ul> </ul> <p>Трусы-бразилиана из хлопка стрейч с контрастным эластичным поясом и логотипом.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> " ["characteristics"]=> string(548) "<p>ХАРАКТЕРИСТИКИ</p> <ul> <li>Код товара: 16806</li> <li>Артикул: 162948 0Р317</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: синий</li> <li>Модель: трусы</li> <li>Материал: хлопок 95%, эластан 5%</li> <li>Стиль: белье</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(107) "Трусики, женские, темно-синие, синие, хлопок, хлопковые, Armani" ["model"]=> string(5) "16806" ["sku"]=> string(12) "162948 0P317" ["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(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1339-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 14:47:30" ["viewed"]=> string(3) "434" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "232" [3]=> string(3) "234" [4]=> string(3) "237" } [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 = '234' 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" } [16803]=> array(49) { ["product_id"]=> string(5) "16803" ["name"]=> string(44) "Трусы хлопковые Emporio Armani" ["description"]=> string(407) "<ul> </ul> <p>Трусы-бразилиана в синем цвете с кружевными вставками сзади, эластичный пояс с логотипом бренда.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> " ["characteristics"]=> string(497) "<ul> <li>Код товара: 16803</li> <li>Артикул: 162525 0Р202</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: синий</li> <li>Модель: трусы</li> <li>Материал: хлопок 95%, эластан 5%</li> <li>Стиль: белье</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(111) "Трусы, женские, темно-синие, хлопковые, синий, хлопок, Emporio Armani" ["model"]=> string(5) "16803" ["sku"]=> string(12) "162525 0P202" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "6" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1347-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(9) "1300.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 14:48:24" ["viewed"]=> string(3) "407" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "232" [3]=> string(3) "234" } [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 = '234' 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" } [16807]=> array(49) { ["product_id"]=> string(5) "16807" ["name"]=> string(36) "Трусы синие Emporio Armani" ["description"]=> string(425) "<ul> </ul> <p>Трусы в синем цвете, выполнены из микрофибры. Модель имеет контрастный эластичный пояс с логотипом бренда.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> " ["characteristics"]=> string(497) "<ul> <li>Код товара: 16807</li> <li>Артикул: 163225 0Р317</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: синий</li> <li>Модель: трусы</li> <li>Материал: хлопок 95%, эластан 5%</li> <li>Стиль: белье</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(103) "Трусики, женские, синего цвета, хлопковые, синие, Emporio Armani" ["model"]=> string(5) "16807" ["sku"]=> string(12) "163225 0P317" ["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(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1389-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 14:49:47" ["viewed"]=> string(3) "403" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(3) "232" [2]=> string(3) "234" } [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 = '234' 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" } [16816]=> array(49) { ["product_id"]=> string(5) "16816" ["name"]=> string(43) "Трусы с принтом Emporio Armani" ["description"]=> string(489) "<p>Трусы-бразилиана в тёмно-синем цвете из кружева с неоромантическим цветочным принтом и кружевной вставкой сзади, с медальоном и логотипом, эластичный пояс.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> " ["characteristics"]=> string(513) "<ul> <li>Код товара: 16816</li> <li>Артикул: 162948 0Р212</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: темно-синий</li> <li>Модель: трусы</li> <li>Материал: полиамид 84%, эластан 16%</li> <li>Стиль: белье</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(118) "Трусики, женские, с флористическим принтом, принт, цветы, Emporio Armani" ["model"]=> string(5) "16816" ["sku"]=> string(12) "162948 0P212" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "6" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1344-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(9) "1200.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 14:50:41" ["viewed"]=> string(3) "440" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "232" [3]=> string(3) "234" } [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 = '234' 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" } [16810]=> array(49) { ["product_id"]=> string(5) "16810" ["name"]=> string(44) "Трусы кружевные Emporio Armani" ["description"]=> string(421) "<ul> </ul> <p>Трусы в чёрном цвете, выполнены из смесового кружева, декорированы медалью с логотипом, эластичный пояс.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> " ["characteristics"]=> string(579) "<p>ХАРАКТЕРИСТИКИ</p> <ul> <li>Код товара: 16810</li> <li>Артикул: 162525 0Р215</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: черный</li> <li>Модель: трусы</li> <li>Материал: полиамид 70%, полиэстер 18%, эластан 12%</li> <li>Стиль: белье</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(80) "Трусики, женские, черные, кружевные, Emporio Armani" ["model"]=> string(5) "16810" ["sku"]=> string(12) "162525 0P215" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "9" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1371-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(9) "1200.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 14:51:20" ["viewed"]=> string(3) "543" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "232" [3]=> string(3) "234" } [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 = '234' 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" } [16809]=> array(49) { ["product_id"]=> string(5) "16809" ["name"]=> string(46) "Трусы коралловые Emporio Armani" ["description"]=> string(415) "<ul> </ul> <p>Трусы-бразилиана из микрофибры в коралловом цвете. С эластичным поясом, отделанным логотипом бренда.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> " ["characteristics"]=> string(547) "<p> </p> <ul> <li>Код товара: 16809</li> <li>Артикул: 162948 0Р235</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: коралл</li> <li>Модель: трусы </li> <li>Материал: полиамид 84%, эластан 16%</li> <li>Стиль: белье</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(140) "Трусики, женские, кораллового цвета, коралловые, Emporio Armani, красные, оранжевые " ["model"]=> string(5) "16809" ["sku"]=> string(12) "162948 0P235" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "7" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1341-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 14:58:26" ["viewed"]=> string(3) "405" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "232" [3]=> string(3) "234" } [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 = '234' 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" } [16813]=> array(49) { ["product_id"]=> string(5) "16813" ["name"]=> string(44) "Трусы бирюзовые Emporio Armani" ["description"]=> string(423) "<ul> </ul> <p>Трусы из кружева в цветочный принт, с контрастным эластичным поясом и логотипом бренда.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> <p> </p> " ["characteristics"]=> string(510) "<ul> <li>Код товара: 16813</li> <li>Артикул: 164271 0Р216</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: бирюзовый</li> <li>Модель: трусы</li> <li>Материал: полиамид 87%, эластан 13%</li> <li>Стиль: белье</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(115) "Трусики, женские, бирюзового цвета, бирюзовые, ажурные, Emporio Armani" ["model"]=> string(5) "16813" ["sku"]=> string(12) "164271 0P216" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "7" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1355-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(9) "1300.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 14:59:38" ["viewed"]=> string(3) "428" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "232" [3]=> string(3) "234" } [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 = '234' 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" } [16805]=> array(49) { ["product_id"]=> string(5) "16805" ["name"]=> string(36) "Трусы белые Emporio Armani" ["description"]=> string(429) "<ul> </ul> <p>Трусы-бразилиана из кружева с цветочным узором в белом цвете, эластичный пояс, бант с медальоном с логотипом.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> " ["characteristics"]=> string(531) "<ul> <li>Код товара: 16805</li> <li>Артикул: 162948 0P215 00011</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: белый</li> <li>Модель: трусы</li> <li>Материал: полиамид 70%, полиэстер 18%, эластан 12%</li> <li>Стиль: белье</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(74) "Трусики, женские, белые, ажурные, Emporio Armani" ["model"]=> string(5) "16805" ["sku"]=> string(18) "162948 0P215 00011" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "7" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1349-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(9) "1200.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 15:00:28" ["viewed"]=> string(3) "413" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(3) "232" [2]=> string(3) "234" [3]=> string(3) "237" } [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 = '234' 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" } [16811]=> array(49) { ["product_id"]=> string(5) "16811" ["name"]=> string(40) "Трусы бежевые Emporio Armani" ["description"]=> string(400) "<ul> </ul> <p>Трусы-бразилиана в розовом цвете. Модель имеет эластичный пояс, отделанный логотипом бренда.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ «О защите прав потребителей»</p> " ["characteristics"]=> string(506) "<ul> <li>Код товара: 16811</li> <li>Артикул: 162525 0Р235</li> </ul> <ul> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: розовый</li> <li>Модель: трусы</li> <li>Материал: полиамид 84%, эластан 16%</li> <li>Стиль: белье</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(62) "Трусики, женские, бежевые, Emporio Armani" ["model"]=> string(5) "16811" ["sku"]=> string(12) "162525 0P235" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1359-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда </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> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td> </td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP A</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP B</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP C</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP D</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>BRA - CUP DD</td> <td> </td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </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> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>футболки, майки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td> </td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(8) "980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:56:09" ["date_modified"]=> string(19) "2021-01-14 15:01:06" ["viewed"]=> string(3) "283" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "232" [3]=> string(3) "234" } [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 = '234' 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" } }