Трусики

Сортувати:

На сторінці:

array(12) { [16808]=> array(49) { ["product_id"]=> string(5) "16808" ["name"]=> string(98) "Трусики жіночі синього кольору Emporio Armani, набір з 2 штук" ["description"]=> string(438) "<ul> </ul> <p>Комплект трусів з 2 пар синього кольору. Виготовлені з бавовни, мають еластичний широкий пояс з логотипом бренду.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> " ["characteristics"]=> string(515) "<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(139) "Трусики, жіночі, синього кольору, сині, комплект, сині, 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) "3" ["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(4910) "<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) "432" ["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 = '3' 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(64) "Труси жіночі Emporio Armani, набір з 2 штук" ["description"]=> string(421) "<ul> </ul> <p>Комплект трусів з 2 пар білого кольору. Виготовлені з бавовни, мають еластичний пояс з логотипом бренду.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> " ["characteristics"]=> string(511) "<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(4910) "<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) "362" ["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 = '3' 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" } [16802]=> array(49) { ["product_id"]=> string(5) "16802" ["name"]=> string(82) "Трусики жіночі Emporio Armani, чорні, набір із 2 штук" ["description"]=> string(444) "<ul> </ul> <p>Комплект трусів з 2 пар чорного кольору. Виготовлені з бавовни, мають еластичний пояс з сріблястим логотипом бренду.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> " ["characteristics"]=> string(513) "<ul> <li>Код товару: 16802</li> <li>Артикул: 163334 0Р263 17020</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(110) "Трусики, жіночі, жіноче, білизна, нижня, Emporio Armani, чорні, набір" ["model"]=> string(5) "16802" ["sku"]=> string(18) "163334 0P263 17020" ["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/1382-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4910) "<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:30:16" ["viewed"]=> string(3) "374" ["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 = '3' 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(36) "Труси чорні Emporio Armani" ["description"]=> string(415) "<ul> </ul> <p>Труси-бразиліана з мікрофібри в чорному кольорі. З еластичним поясом, обробка з люрексу з логотипом.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> " ["characteristics"]=> string(558) "<p>ХАРАКТЕРИСТИКИ</p> <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(118) "Трусики, жіночі, чорні, еластичні, 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(4910) "<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) "386" ["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 = '3' 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(34) "Труси сині Emporio Armani" ["description"]=> string(427) "<ul> </ul> <p>Труси в синьому кольорі, виконані з мікрофібри. Модель має контрастний еластичний пояс з логотипом бренду.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> " ["characteristics"]=> string(505) "<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(105) "Трусики, жіночі, синього кольору, бавовняні, сині, 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(4910) "<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) "378" ["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 = '3' 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(398) "<p>Труси в чорному кольорі, виконані зі змішаного мережива, декоровані медаллю з логотипом, еластичний пояс.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> " ["characteristics"]=> string(534) "<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(76) "Трусики, жіночі, чорні, мереживні, 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(4910) "<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) "516" ["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 = '3' 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(42) "Труси коралові Emporio Armani" ["description"]=> string(419) "<ul> </ul> <p>Труси-бразиліана з мікрофібри в кораловому кольорі. З еластичним поясом, обробленим логотипом бренду.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> " ["characteristics"]=> string(518) "<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(139) "Трусики, жіночі, коралового кольору, коралові, 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(4910) "<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) "388" ["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 = '3' 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(526) "<ul> </ul> <p>Труси-бразиліана в темно-синьому кольорі з мережива з неоромантичним квітковим принтом і мереживною вставкою ззаду, з медальйоном і логотипом, еластичний пояс.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> " ["characteristics"]=> string(519) "<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(112) "Трусики, жіночі, з флористичним принтом, принт, квіти, 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(4910) "<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) "415" ["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 = '3' 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(38) "Труси бежеві Emporio Armani" ["description"]=> string(404) "<ul> </ul> <p>Труси-бразиліана в рожевому кольорі. Модель має еластичний пояс, оздоблений логотипом бренду.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> " ["characteristics"]=> string(512) "<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(58) "Трусики, жіночі, бежеві, 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(4910) "<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) "257" ["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 = '3' 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(419) "<ul> </ul> <p>Труси-бразиліана в синьому кольорі з мереживними вставками ззаду, еластичний пояс з логотипом бренду.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> " ["characteristics"]=> string(505) "<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(109) "Труси, жіночі, темно-сині, бавовняні, синій, бавовна, 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(4910) "<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) "389" ["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 = '3' 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(40) "Труси бавовна Emporio Armani" ["description"]=> string(410) "<ul> </ul> <p>Труси-бразиліана з бавовни стрейч з контрастним еластичним поясом і логотипом.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> <p> </p> " ["characteristics"]=> string(515) "<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(103) "Трусики, жіночі, темно-сині, сині, бавовна, бавовняні, 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(4910) "<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) "409" ["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 = '3' 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(42) "Труси бірюзові Emporio Armani" ["description"]=> string(392) "<ul> </ul> <p>Труси з мережива в квітковий принт, з контрастним еластичним поясом і логотипом бренду.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ «Про захист прав споживачів»</p> " ["characteristics"]=> string(516) "<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(113) "Трусики, жіночі, бірюзового кольору, бірюзові, ажурні, 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(4910) "<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) "410" ["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 = '3' 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" } }