Цільні купальники

array(10) { [16783]=> array(49) { ["product_id"]=> string(5) "16783" ["name"]=> string(63) "Купальник жіночий цільний Emporio Armani" ["description"]=> string(520) "<p>Цільний купальник червоного кольору із золотою люрексовою ниткою. Виконаний з еластичного матеріалу, м&#39;яка чашка, має контрастні еластичні бретелі з логотипом бренду.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</p> " ["characteristics"]=> string(516) "<ul> <li>Код товару: 16783</li> <li>Артикул: 262631 0H342 00174</li> <li>Бренд: Emporio Armani</li> <li>Країна: Італія</li> <li>Колір: червоно-золотистий</li> <li>Модель: купальник</li> <li>Матеріал: поліамід 65%, еластан 21%, поліестер 14%</li> <li>Стиль: пляжний</li> </ul> " ["color"]=> string(8) "#ff0000 " ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Купальник" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(134) "Купальник, жіночий, суцільний, червоний, з контрастними шлейками, Emporio Armani" ["model"]=> string(5) "16783" ["sku"]=> string(18) "262631 0P342 00174" ["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/1421-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4910) "<p>Жіночий одяг&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Чоловічий одяг</p> <table class="size-table"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примітки</td> </tr> <tr> <td>боксери, сліпи</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4360.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-08-16 15:41:08" ["viewed"]=> string(3) "567" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "209" [3]=> string(3) "214" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '214' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16776]=> array(49) { ["product_id"]=> string(5) "16776" ["name"]=> string(78) "Купальник жіночий чорного кольору Emporio Armani" ["description"]=> string(490) "<p>Злитий купальник чорного кольору з еластичної тканини. Модель має ущільнений верх, глибокий виріз і зав&#39;язки на спині. Декоративні ґудзики з логотипом.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</p> " ["characteristics"]=> string(476) "<ul> <li>Код товару: 16776</li> <li>Артикул: 262632 0Р310</li> <li>Бренд: Emporio Armani</li> <li>Країна: Італія</li> <li>Колір: чорний</li> <li>Модель: купальник</li> <li>Матеріал: поліестер 87%, еластан 13%</li> <li>Стиль: пляжний&nbsp;</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Купальник" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(115) "Купальник, жіночий, суцільний, чорного кольору, чорний, Emporio Armani" ["model"]=> string(5) "16776" ["sku"]=> string(18) "262642 0P307 00020" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(81) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskoe_bele_kupalniki/1431-ds-2.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4910) "<p>Жіночий одяг&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Чоловічий одяг</p> <table class="size-table"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примітки</td> </tr> <tr> <td>боксери, сліпи</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4700.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:38:23" ["date_modified"]=> string(19) "2021-08-12 11:22:43" ["viewed"]=> string(3) "548" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "209" [3]=> string(3) "214" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '214' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16777]=> array(49) { ["product_id"]=> string(5) "16777" ["name"]=> string(65) "Купальник жіночий червоний Emporio Armani" ["description"]=> string(496) "<p>Цільний купальник червоного кольору з еластичної тканини. Модель має ущільнений верх, глибокий виріз і зав&#39;язки на спині. Декоративні ґудзики з логотипом.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</p> " ["characteristics"]=> string(475) "<ul> <li>Код товару: 16777</li> <li>Артикул: 262642 0P307 00074</li> <li>Бренд: Emporio Armani</li> <li>Країна: Італія</li> <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(18) "Купальник" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(137) "Купальник, жіночий, червоного кольору, суцільний, червоний, Армані, Emporio Armani" ["model"]=> string(5) "16777" ["sku"]=> string(18) "262642 0P307 00074" ["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/1428-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4910) "<p>Жіночий одяг&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Чоловічий одяг</p> <table class="size-table"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примітки</td> </tr> <tr> <td>боксери, сліпи</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4700.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:38:23" ["date_modified"]=> string(19) "2021-08-16 15:42:02" ["viewed"]=> string(3) "640" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "209" [3]=> string(3) "214" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '214' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16779]=> array(49) { ["product_id"]=> string(5) "16779" ["name"]=> string(87) "Купальник жіночий суцільний з написами Emporio Armani" ["description"]=> string(544) "<p>Злитий купальник синього кольору з малюнком написи логотип бренду білим кольором, виконаний з еластичного матеріалу, тонкі бретелі переплітаються на спині і зав&#39;язуються на вузол.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</p> " ["characteristics"]=> string(462) "<ul> <li>Код товару: 16779</li> <li>Артикул: 262632 0Р310</li> <li>Бренд: Emporio Armani</li> <li>Країна: Італія</li> <li>Колір: синій</li> <li>Модель: купальник</li> <li>Матеріал: поліамід 80%, еластан 20%</li> <li>Стиль: пляжний</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Купальник" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(109) "Купальник, жіночий, суцільний, з написами, Emporio Armani, цілісний" ["model"]=> string(5) "16779" ["sku"]=> string(12) "262632 0P310" ["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/1426-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4910) "<p>Жіночий одяг&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Чоловічий одяг</p> <table class="size-table"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примітки</td> </tr> <tr> <td>боксери, сліпи</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4400.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:38:23" ["date_modified"]=> string(19) "2021-08-16 15:41:35" ["viewed"]=> string(3) "746" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "209" [3]=> string(3) "214" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '214' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14894]=> array(49) { ["product_id"]=> string(5) "14894" ["name"]=> string(75) "Купальник жіночий в квітковий принт Seafolly" ["description"]=> string(812) "<p>Купальник жіночий в квітковий принт Seafolly без шлеек. Виріб має низку особливостей: приховані кісточки, кулиска з боків, без шлеек. Стильна пляжна модель з конрастним принтом приверне увагу оточуючих і вигідно підкреслить достоїнства фігури. Купити купальник жіночий в квітковий принт Seafolly можна на сайті нашого магаазіна https://dn8.ua/uk.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</p> " ["characteristics"]=> string(507) "<ul> <li>Код товару: 14894</li> <li>Артикул: 10813DD419</li> </ul> <ul> <li>Бренд: Seafolly</li> <li>Країна: Австралія</li> </ul> <ul> <li>Колір: чорний</li> <li>Малюнок: принт</li> <li>Матеріал: трикотаж</li> <li>Склад: нейлон 74%, еластан 26%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Купальник" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(327) "купальник цельнокройный, купальник без бретелей, купальник черный монокини, купальник с открытыми плечами, купальник с открытой спиной, купальник с завязкам по бокам, купальни с " ["model"]=> string(5) "14894" ["sku"]=> string(10) "10813DD419" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(65) "catalog/dn8/fotosessija/2019/zhenskaja_beleikupalniki/ds-1314.jpg" ["manufacturer_id"]=> string(2) "26" ["manufacturer"]=> string(8) "Seafolly" ["manufacturer_size_table"]=> string(1684) "<p>Cпідня&nbsp;білизна і купальники</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> <p>Пляжне взуття</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> " ["price"]=> string(9) "4990.0000" ["special"]=> string(9) "2994.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-17" ["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) "2019-12-17 12:48:51" ["date_modified"]=> string(19) "2021-02-02 14:28:55" ["viewed"]=> string(3) "711" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "209" [3]=> string(3) "214" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '214' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15162]=> array(49) { ["product_id"]=> string(5) "15162" ["name"]=> string(55) "Купальник жіночий чорний Seafolly" ["description"]=> string(750) "<p>Купальник жіночий чорний Seafolly на тонких бретелях виконаний з чорного трикотажу. Класичний дизайн в новому стилі підходить для жінок різної статури. V-подібний виріз, м&#39;які чашки на кісточках. Рекомендуємо звертати увагу на ярлик по догляду, щоб вироби не втратило привабливий зовнішній вигляд.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</p> " ["characteristics"]=> string(482) "<ul> <li>Код товару: 15162</li> <li>Артикул: 10807-058</li> <br /> <li>Бренд: Seafolly</li> <li>Країна: Австралія</li> <br /> <li>Колір чорний</li> <li>Малюнок: не має</li> <li>Матеріал: трикотаж</li> <li>Склад: нейлон 87%, еластан 13%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Купальник" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(250) "купальник черный цельный, купальник с открытой спиной, купальник утягивающий, купальник с глубоким декольте, купальник с низким вырезом" ["model"]=> string(5) "15162" ["sku"]=> string(9) "10807-058" ["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(65) "catalog/dn8/fotosessija/2019/zhenskaja_beleikupalniki/ds-1304.jpg" ["manufacturer_id"]=> string(2) "26" ["manufacturer"]=> string(8) "Seafolly" ["manufacturer_size_table"]=> string(1684) "<p>Cпідня&nbsp;білизна і купальники</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> <p>Пляжне взуття</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> " ["price"]=> string(9) "3990.0000" ["special"]=> string(9) "2394.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-17" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-12-17 12:48:51" ["date_modified"]=> string(19) "2021-02-02 15:25:26" ["viewed"]=> string(3) "819" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "209" [3]=> string(3) "214" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '214' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15160]=> array(49) { ["product_id"]=> string(5) "15160" ["name"]=> string(53) "Купальник жіночий синій Seafolly" ["description"]=> string(733) "<p>Купальник жіночий синій Seafolly на одне плече в ретро стилі. Монохромна модель виглядає стильно і сучасно&nbsp; - бічний виріз, відкрита спина і асиметричний верх. Для догляду а виробом рекомендується делікатна машинне прання окремо або ручне прання в теплій воді з м&#39;яким миючим засобом.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</p> " ["characteristics"]=> string(479) "<ul> <li>Код товару: 15160</li> <li>Артикул: 10795-058</li> <br /> <li>Бренд: Seafolly</li> <li>Країна: Австралія</li> <br /> <li>Колір синій</li> <li>Малюнок: принт</li> <li>Матеріал: трикотаж</li> <li>Склад: нейлон 87%, еластан 13%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Купальник" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(137) "купальник, женский, слитный, монокини, вырезы, купальник на оно плечо, синий" ["model"]=> string(5) "15160" ["sku"]=> string(9) "10795-058" ["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(65) "catalog/dn8/fotosessija/2019/zhenskaja_beleikupalniki/ds-1310.jpg" ["manufacturer_id"]=> string(2) "26" ["manufacturer"]=> string(8) "Seafolly" ["manufacturer_size_table"]=> string(1684) "<p>Cпідня&nbsp;білизна і купальники</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> <p>Пляжне взуття</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> " ["price"]=> string(9) "2990.0000" ["special"]=> string(9) "1794.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-17" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-12-17 12:48:51" ["date_modified"]=> string(19) "2021-02-02 15:11:13" ["viewed"]=> string(3) "743" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "209" [3]=> string(3) "214" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '214' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15165]=> array(49) { ["product_id"]=> string(5) "15165" ["name"]=> string(77) "Купальник жіночий на тонких бретелях Seafolly" ["description"]=> string(665) "<p>Купальник жіночий на тонких бретелях Seafolly бірюзового кольору з яскравим квітковим принтом. Бретельки регульованої довжини. Спереду шнурівка, спина відкрита. Чашки на кісточках. Щоб забезпечити правильний догляд, звертайте увагу на етикетки на товар.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</p> " ["characteristics"]=> string(541) "<ul> <li>Код товару: 15165</li> <li>Артикул: 10826-489 Evergreen</li> </ul> <ul> <li>Бренд: Seafolly</li> <li>Країна: Австралія</li> </ul> <ul> <li>Колір: бірюзовий</li> <li>Малюнок: рослинний принт</li> <li>Матеріал: трикотаж</li> <li>Склад: нейлон 68%, еластан 32%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Купальник" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(170) "купальники цельный, купальник на бретелях, купальник на шнуровке, купальник с низким вырезом" ["model"]=> string(5) "15165" ["sku"]=> string(19) "10826-489 Evergreen" ["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(65) "catalog/dn8/fotosessija/2019/zhenskaja_beleikupalniki/ds-1306.jpg" ["manufacturer_id"]=> string(2) "26" ["manufacturer"]=> string(8) "Seafolly" ["manufacturer_size_table"]=> string(1684) "<p>Cпідня&nbsp;білизна і купальники</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> <p>Пляжне взуття</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> " ["price"]=> string(9) "4990.0000" ["special"]=> string(9) "2994.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-17" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-12-17 12:48:51" ["date_modified"]=> string(19) "2021-02-02 14:54:23" ["viewed"]=> string(3) "758" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "209" [3]=> string(3) "214" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '214' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15164]=> array(49) { ["product_id"]=> string(5) "15164" ["name"]=> string(75) "Купальник жіночий в квітковий принт Seafolly" ["description"]=> string(736) "<p>Купальник жіночий в квітковий принт Seafolly декорований широкою оборкою. Без шлеєк, tube style, виріб&nbsp;щільно прилягає і не зісковзує. Рекомендуємо звертати увагу на ярлик по догляду. Делікатне&nbsp;машинне прання окремо або ручне прання в теплій воді з м&#39;яким миючим засобом. Сушити в тіні.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</p> " ["characteristics"]=> string(524) "<ul> <li>Код товару: 15164</li> <li>Артикул: 10824CD489</li> </ul> <ul> <li>Бренд: Seafolly</li> <li>Країна: Австралія</li> </ul> <ul> <li>Колір: синій</li> <li>Малюнок: рослинний принт</li> <li>Матеріал: трикотаж</li> <li>Склад: нейлон 68%, еластан 32%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Купальник" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(226) "купальник цельнокроный, цельный купальник, купальник с открытыми плечами, купальник с оборкой, купальник с открытой спиной" ["model"]=> string(5) "15164" ["sku"]=> string(10) "10824CD489" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(65) "catalog/dn8/fotosessija/2019/zhenskaja_beleikupalniki/ds-1312.jpg" ["manufacturer_id"]=> string(2) "26" ["manufacturer"]=> string(8) "Seafolly" ["manufacturer_size_table"]=> string(1684) "<p>Cпідня&nbsp;білизна і купальники</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> <p>Пляжне взуття</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> " ["price"]=> string(9) "4990.0000" ["special"]=> string(9) "2994.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-17" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-12-17 12:48:51" ["date_modified"]=> string(19) "2021-02-02 15:12:09" ["viewed"]=> string(3) "780" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "209" [3]=> string(3) "214" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '214' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15163]=> array(49) { ["product_id"]=> string(5) "15163" ["name"]=> string(120) " Купальник жіночий суцільний монокіні білий в дрібний принт Seafolly" ["description"]=> string(740) "<p>Купальник жіночий суцільний монокіні &nbsp;білий в дрібний принт Seafolly білого&nbsp;кольору з яскравим квітковим принтом. Бретельки регульованої довжини. Спереду декоративна шнурівка, спина відкрита. Чашки на кісточках. Щоб забезпечити правильний догляд, звертайте увагу на етикетки на товар.</p> <p>Товар обміну та поверненню не підлягає згідно ЗУ &laquo;Про захист прав споживачів&raquo;</p> " ["characteristics"]=> string(523) "<ul> <li>Код товару: 15163</li> <li>Артикул: 10818-410</li> </ul> <ul> <li>Бренд: Seafolly</li> <li>Країна: Австралія</li> </ul> <ul> <li>Колір: білий</li> <li>Малюнок: рослинний принт</li> <li>Матеріал: трикотаж</li> <li>Склад: нейлон 78%, еластан 22%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(161) "слитный купальник, монокини, купальник на шнуровке, цельный купальник, модный купальник" ["model"]=> string(5) "15163" ["sku"]=> string(9) "10818-410" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(68) "catalog/dn8/fotosessija/2019/zhenskaja_beleikupalniki/ds-1291(1).jpg" ["manufacturer_id"]=> string(2) "26" ["manufacturer"]=> string(8) "Seafolly" ["manufacturer_size_table"]=> string(1684) "<p>Cпідня&nbsp;білизна і купальники</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> <p>Пляжне взуття</p> <table class="men"> <tbody> <tr> <td>Міжнародний (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примітки</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>відповідать</td> </tr> </tbody> </table> " ["price"]=> string(9) "4400.0000" ["special"]=> string(9) "2640.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-17" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-12-17 12:48:51" ["date_modified"]=> string(19) "2021-05-18 13:10:44" ["viewed"]=> string(3) "625" ["categories"]=> array(1) { [0]=> string(3) "214" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '214' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }