Женские трендовые платья

array(12) { [16644]=> array(49) { ["product_id"]=> string(5) "16644" ["name"]=> string(75) "Платье женское с цветочным принтом Miss Sixty" ["description"]=> string(496) "<p>Романтическое летнее платье с цветочным принтом из мягкой и легкой вискозной ткани в голубом цвете. С глубоким вырезом, отделанным перекрещенными кружевами и рукавами три четверти, украшенными элегантными манжетами с бантами.</p> <p>Длина изделия миди.</p> " ["characteristics"]=> string(724) "<ul> <li>Код товара: 16644</li> <li>Артикул: DJ356VI901000000</li> </ul> <ul> <li>Бренд: Miss Sixty&nbsp;</li> <li>Страна: Италия</li> </ul> <ul> <li>Модель: платье</li> <li>Цвет: голубой</li> <li>Материал: верх &ndash; вискоза 100%, подкладка &ndash; полиэстер 100%</li> <li>Стиль: романтический</li> <li>Рост модели 172 см</li> <li>На модели размер S (итальянский)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(137) "Платье, женское, из легкой ткани, летнее, голубое, с принтом, Miss Sixty, заказать" ["model"]=> string(5) "16644" ["sku"]=> string(18) "DJ3560VI9010000000" ["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(66) "catalog/dn8/fotosessija/2020/ijul/4_etazh_zhenskoe/img_5529-ds.jpg" ["manufacturer_id"]=> string(3) "115" ["manufacturer"]=> string(10) "Miss Sixty" ["manufacturer_size_table"]=> string(1844) "<p>Верхняя одежда, костюм, пиджак, трикотаж, блузы, брюки</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>примечание</td> </tr> <tr> <td>Miss Sixty</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>соответствует</td> </tr> </tbody> </table> <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> <td>примечание</td> </tr> <tr> <td>Riani</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> <td>соответствует</td> </tr> </tbody> </table> " ["price"]=> string(10) "10500.0000" ["special"]=> string(9) "6300.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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(2) "15" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 12:47:44" ["date_modified"]=> string(19) "2021-07-14 12:16:09" ["viewed"]=> string(3) "943" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } [16206]=> array(49) { ["product_id"]=> string(5) "16206" ["name"]=> string(70) "Платье женское в ярко-жёлтом цвете Sfizio" ["description"]=> string(505) "<p>Платье женское с поясом в ярко-жёлтом цвете. Модель имеет круглый вырез, на спине застёжка-капелька на пуговицу, короткий рукав с манжетой. Платье украшено яркой вышивкой в тропическом стиле. Подходит для повседневного образа.</p> <p>Длина изделия &ndash; миди.</p> " ["characteristics"]=> string(644) "<ul> <li>Код товара: 16206</li> <li>Артикул: 20FE6234POP44</li> </ul> <ul> <li>Бренд: Sfizio</li> <li>Страна: Италия</li> </ul> <ul> <li>Модель: платье</li> <li>Цвет: желтый</li> <li>Материал: хлопок 96%, другие волокна 4%</li> <li>Стиль: кэжуал</li> <li>Рост модели 172 см</li> <li>На модели размер 42 (итальянский)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(112) "Платье, женское, с поясом, яркое, жёлтое, ниже колена, Sfizio, миди" ["model"]=> string(5) "16206" ["sku"]=> string(13) "20FE6234POP44" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/1_etazh_zhenskoe/img_5571-ds.jpg" ["manufacturer_id"]=> string(2) "54" ["manufacturer"]=> string(6) "Sfizio" ["manufacturer_size_table"]=> string(1568) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Sfizio (одежда)</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> </tr> </tbody> </table> <table class="women"> <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> <td>Sfizio (джинсы)</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> </tbody> </table> " ["price"]=> string(9) "8200.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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(2) "13" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 12:47:44" ["date_modified"]=> string(19) "2021-07-14 12:18:28" ["viewed"]=> string(3) "947" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } [16527]=> array(49) { ["product_id"]=> string(5) "16527" ["name"]=> string(48) "Платье ярко-желтое Liviana Conti" ["description"]=> string(483) "<p>Платье жёлтого цвета из поплина. Модель имеет А-силуэт, затягивающийся шнурок из корсажной ленты на талии, круглый ворот со складками, объёмные короткие рукава кимоно со спущенными плечами и складками. Посадка свободная.</p> <p>Длина изделия миди.</p> " ["characteristics"]=> string(599) "<ul> <li>Код товара: 16527</li> <li>Артикул: L0SK33</li> <li>Бренд: Liviana Conti</li> <li>Страна: Италия</li> <li>Модель: платье</li> <li>Цвет: желтый</li> <li>Материал: хлопок 68%, полиамид 28%, эластан 4%</li> <li>Стиль: кэжуал</li> <li>Рост модели 172 см</li> <li>На модели размер 42 (итальянский)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(127) "Платье, женское, ярко-желтое, желтое, сборки, Liviana Conti, лето, ниже колена" ["model"]=> string(5) "16527" ["sku"]=> string(6) "L0SK33" ["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(66) "catalog/dn8/fotosessija/2020/ijul/4_etazh_zhenskoe/img_5497-ds.jpg" ["manufacturer_id"]=> string(3) "130" ["manufacturer"]=> string(13) "Liviana Conti" ["manufacturer_size_table"]=> string(859) "<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>Liviana Conti</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "9980.0000" ["special"]=> string(9) "5988.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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(2) "11" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 12:47:44" ["date_modified"]=> string(19) "2021-08-17 16:35:07" ["viewed"]=> string(3) "444" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } [16901]=> array(49) { ["product_id"]=> string(5) "16901" ["name"]=> string(40) "Платье полосатое Le Coeur" ["description"]=> string(707) "<ul> </ul> <p>Особенности:</p> <ul> <li>Пояс</li> <li>Оборки</li> </ul> <p>Женственное платье из поплина в полоску с V-образным вырезом, пушистыми двойными оборками, которые переходят к кокетке, съемным поясом, подчеркивающим талию, боковыми карманами, застежкой на молнию. Выбирайте непринужденный образ, носите его с кроссовками &nbsp;и сумкой через плечо.</p> " ["characteristics"]=> string(300) "<ul> <li>Бренд: le coeur</li> <li>Страна: Италия</li> <li>Модель: платье</li> <li>Цвет: розовый</li> <li>Материал : 73% хлопок, 27% полиэстер</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(135) "Платье, женское, длина ниже колена, в полоску, с поясом, Le Coeur, полоска, миди " ["model"]=> string(5) "16901" ["sku"]=> string(9) "201ST202J" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/1_etazh_zhenskoe/img_4993-ds.jpg" ["manufacturer_id"]=> string(3) "132" ["manufacturer"]=> string(19) "Le Coeur by Twinset" ["manufacturer_size_table"]=> string(1281) "<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>Le Coeur by Twinset</td> <td>XXS</td> <td>XS</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>Le Coeur by Twinset(женские&nbsp;штаны, шорты)</td> <td>XXS</td> <td>XS</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) "7440.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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(2) "10" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 12:47:44" ["date_modified"]=> string(19) "2021-07-14 12:20:04" ["viewed"]=> string(3) "487" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } [16902]=> array(49) { ["product_id"]=> string(5) "16902" ["name"]=> string(79) "Платье женское в геометрический принт Le Coeur" ["description"]=> string(617) "<p>Выразите свою женственность платьем с геометрическим принтом, рюшами и каплевидным вырезом спереди. Асимметричный подол делает эту модель платья особенной, дополните ее босоножками или кроссовками.</p> <p>Особенности:</p> <ul> <li>Рюши</li> <li>Ассиметричный подол</li> <li>Геометрический принт</li> </ul> " ["characteristics"]=> string(398) "<ul> <li>Код:&nbsp;16902</li> <li>Артикул: 201ST2185</li> <li>Бренд: le coeur</li> <li>Страна: Италия</li> <li>Модель: платье</li> <li>Цвет: бирюзовый</li> <li>Материал: 73% хлопок, 27% полиэстер</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(115) "Платье, женское, геометрический принт, Le Coeur, абстракция, летнее" ["model"]=> string(5) "16902" ["sku"]=> string(9) "201ST2185" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/1_etazh_zhenskoe/img_4999-ds.jpg" ["manufacturer_id"]=> string(3) "132" ["manufacturer"]=> string(19) "Le Coeur by Twinset" ["manufacturer_size_table"]=> string(1281) "<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>Le Coeur by Twinset</td> <td>XXS</td> <td>XS</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>Le Coeur by Twinset(женские&nbsp;штаны, шорты)</td> <td>XXS</td> <td>XS</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) "8160.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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) "9" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 12:47:44" ["date_modified"]=> string(19) "2021-07-14 12:20:38" ["viewed"]=> string(3) "405" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } [16903]=> array(49) { ["product_id"]=> string(5) "16903" ["name"]=> string(53) "Платье женское бордовое Le Coeur" ["description"]=> string(569) "<p>Изысканный дизайн приталенного длинного платья из стрейч-вискозы с V-образным вырезом и контрастными полосками на поясе и вороте. Легко сочетается с кроссовками или босоножками.</p> <p>Особенности:</p> <ul> <li>Трикотажный пояс</li> <li>Контрастные полоски на поясе и вороте</li> </ul> " ["characteristics"]=> string(312) "<ul> <li>Бренд: le coeur</li> <li>Страна: Италия</li> <li>Модель: платье</li> <li>Цвет: бордовый/розовый</li> <li>Материал: 57% вискоза, 43% нейлон</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(100) "Платье, женское, бордовое, ниже колена, с разрезом, Le Coeur" ["model"]=> string(5) "16903" ["sku"]=> string(9) "201ST3030" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/1_etazh_zhenskoe/img_4987-ds.jpg" ["manufacturer_id"]=> string(3) "132" ["manufacturer"]=> string(19) "Le Coeur by Twinset" ["manufacturer_size_table"]=> string(1281) "<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>Le Coeur by Twinset</td> <td>XXS</td> <td>XS</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>Le Coeur by Twinset(женские&nbsp;штаны, шорты)</td> <td>XXS</td> <td>XS</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) "6360.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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) "8" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 12:47:44" ["date_modified"]=> string(19) "2021-08-16 16:38:47" ["viewed"]=> string(3) "480" ["categories"]=> array(7) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" [5]=> string(3) "508" [6]=> string(3) "511" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } [16518]=> array(49) { ["product_id"]=> string(5) "16518" ["name"]=> string(82) "Платье женское c цветочной расцветкой Luisa Cerano" ["description"]=> string(448) "<p>Платье прямого кроя в яркий цветочный принт с коротким рукавом. Модель выполнена из вискозы, имеет круглый вырез, пояс кулиску на талии, застёжку в виде капли спереди. Подходит для повседневного образа.</p> <p>Длина изделия миди.</p> " ["characteristics"]=> string(662) "<ul> <li>Код товара: 16518</li> <li>Артикул: 7181572457</li> <li>Бренд: Luisa Cerano</li> <li>Страна: Германия</li> <li>Модель: платье</li> <li>Цвет: разноцветное</li> <li>Материал: верх &ndash; вискоза 100%, подкладка &ndash; полиэстер 100%</li> <li>Стиль: кэжуал</li> <li>Рост модели: 172 см</li> <li>На модели: размер 36&nbsp;(немецкий)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(138) "Платье, женское, летнее, с цветочной расцветкой, цветы, Luisa Cerano, легкое, заказ" ["model"]=> string(5) "16518" ["sku"]=> string(11) "718157/2457" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/4_etazh_zhenskoe/img_5479-ds.jpg" ["manufacturer_id"]=> string(2) "32" ["manufacturer"]=> string(12) "Luisa Cerano" ["manufacturer_size_table"]=> string(690) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Luisa Cerano</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> </tbody> </table> " ["price"]=> string(10) "15500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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) "6" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 12:47:44" ["date_modified"]=> string(19) "2021-08-19 09:55:44" ["viewed"]=> string(3) "598" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } [16959]=> array(49) { ["product_id"]=> string(5) "16959" ["name"]=> string(41) "Платье темно-синее Repeat" ["description"]=> string(937) "<p>Симпатичное женское платье на каждый день. Что важно для одежды в летний период? Легкость, воздухопроницаемость, простота в уходе? Все это, плюс потрясающую мягкость, воплощает в себе представленная одежда.</p> <p>Планка с пуговицей, рубашечный воротник, закругленный подол, длинный рукав со сборенным манжетом, имитация пояса.</p> <p>Приятный темно-синий цвет хорошо комбинируется с другой одеждой в разной цветовой гамме.</p> <p>Купить платье темно-синее Repeat в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(394) "<ul> <li>Код товара: 16959</li> <li>Бренд: Repeat;</li> <li>Страна: Швейцария;</li> <li>Модель: платье;</li> <li>Цвет: темно-синий;</li> <li>Принт: однотонное;</li> <li>Материал: тенсел.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(343) "платье до колен, платье свободное, платье на каждый день, платье удобное, платье с длинным рукавом, платье средней длины, синее платье, платье на лето, платье для прогулки, платье для театра" ["model"]=> string(5) "16959" ["sku"]=> string(6) "600329" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(60) "catalog/dn8/fotosessija/2020/avgust_zhenskaya_4/img_8345.jpg" ["manufacturer_id"]=> string(3) "136" ["manufacturer"]=> string(6) "Repeat" ["manufacturer_size_table"]=> string(881) "<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> <td>Repeat</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "7500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-09-14" ["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-09-14 09:54:31" ["date_modified"]=> string(19) "2021-05-27 15:04:09" ["viewed"]=> string(3) "253" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } [16958]=> array(49) { ["product_id"]=> string(5) "16958" ["name"]=> string(47) "Платье-блуза шелковое Repeat" ["description"]=> string(497) "<p>Платье женское этностиль с узором принт пейсли. Модель прямого кроя с поясом, длинными рукавами с манжетами, круглый вырез с V-образной планкой и пуговицами, боковые разрезы.</p> <p>Изделие можно носить с поясом и без.</p> <p>Длина изделия ниже колена.</p> " ["characteristics"]=> string(656) "<ul> <li>Код товара: 16958</li> <li>Артикул: 600347</li> </ul> <ul> <li>Бренд: Repeat</li> <li>Страна: Швейцария</li> </ul> <ul> <li>Модель: блуза</li> <li>Цвет: этно-принт узор пейсли</li> <li>Материал: шелк 95%, эластан 5%</li> <li>Стиль: кэжуал</li> <li>Рост модели 172 см</li> <li>На модели размер 36&nbsp;(немецкий)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(144) "Платье, женское, с длинным рукавом, с поясом, легкое, летнее, Repeat, шелк, шелковое" ["model"]=> string(5) "16958" ["sku"]=> string(6) "600347" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/4_etazh_zhenskoe/img_5515-ds.jpg" ["manufacturer_id"]=> string(3) "136" ["manufacturer"]=> string(6) "Repeat" ["manufacturer_size_table"]=> string(881) "<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> <td>Repeat</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "13600.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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-07-15 12:47:44" ["date_modified"]=> string(19) "2021-05-31 16:38:56" ["viewed"]=> string(3) "520" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } [16528]=> array(49) { ["product_id"]=> string(5) "16528" ["name"]=> string(54) "Платье женское желтое Liviana Conti" ["description"]=> string(439) "<p>Ассиметричное платье жёлтого цвета. Модель выполнена из поплина, прямого кроя, имеет пояс из корсажной ленты сбоку, мягкий ассиметричный ворот, длинные рукава с разрезами внизу. Посадка свободная.</p> <p>Длина изделия миди.</p> " ["characteristics"]=> string(599) "<ul> <li>Код товара: 16528</li> <li>Артикул: L0SK30</li> <li>Бренд: Liviana Conti</li> <li>Страна: Италия</li> <li>Модель: платье</li> <li>Цвет: желтый</li> <li>Материал: хлопок 68%, полиамид 28%, эластан 4%</li> <li>Стиль: кэжуал</li> <li>Рост модели 172 см</li> <li>На модели размер 42 (итальянский)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(108) "Платье, женское, асимметричное, желтое, Liviana Conti, ниже колена" ["model"]=> string(5) "16528" ["sku"]=> string(6) "L0SK30" ["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(66) "catalog/dn8/fotosessija/2020/ijul/4_etazh_zhenskoe/img_5488-ds.jpg" ["manufacturer_id"]=> string(3) "130" ["manufacturer"]=> string(13) "Liviana Conti" ["manufacturer_size_table"]=> string(859) "<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>Liviana Conti</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "8800.0000" ["special"]=> string(9) "5280.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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-07-15 12:47:44" ["date_modified"]=> string(19) "2021-08-18 10:04:14" ["viewed"]=> string(3) "522" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } [16542]=> array(49) { ["product_id"]=> string(5) "16542" ["name"]=> string(80) "Платье женское голубого цвета в полоску Sfizio" ["description"]=> string(634) "<p>Платье женское голубого цвета в белую полоску. Модель платья комбинирована&nbsp;цветовыми блоками бежевого цвета. Имеет два бежевых накладных кармана на кнопках в стиле карго спереди, на спине кокетка бежевого цвета с вышитым цветочным узором. Шнурок на талии.&nbsp; Подходит для повседневного образа.</p> <p>Длина изделия макси.</p> " ["characteristics"]=> string(614) "<ul> <li>Код товара: 16542</li> <li>Артикул: 20FE61842696</li> </ul> <ul> <li>Бренд: Sfizio</li> <li>Страна: Италия</li> </ul> <ul> <li>Модель: платье</li> <li>Цвет: голубой</li> <li>Материал: хлопок 100%</li> <li>Стиль: кэжуал</li> <li>Рост модели 172 см</li> <li>На модели размер 42 (итальянский)</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(106) "Платье, женское, голубое, в полоску, Sfizio, макси, с карманами" ["model"]=> string(5) "16542" ["sku"]=> string(12) "20FE61842696" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/ijul/1_etazh_zhenskoe/img_5505-ds.jpg" ["manufacturer_id"]=> string(2) "54" ["manufacturer"]=> string(6) "Sfizio" ["manufacturer_size_table"]=> string(1568) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> </tr> <tr> <td>Sfizio (одежда)</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> </tr> </tbody> </table> <table class="women"> <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> <td>Sfizio (джинсы)</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> </tbody> </table> " ["price"]=> string(9) "9500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-07-15" ["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-07-15 12:47:44" ["date_modified"]=> string(19) "2021-05-31 16:54:50" ["viewed"]=> string(3) "488" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } [14772]=> array(49) { ["product_id"]=> string(5) "14772" ["name"]=> string(65) "Платье женское белое с оборкой Le Coeur" ["description"]=> string(660) "<p>Платье свободное с открытыми плечами и оборкой белое Le Coeur из легкой ткани. Оборка на вырезе. Свободный крой. Спущенные плечи. Модель на подкладке. Классический крой. Длина до колена.&nbsp;</p> <ul> </ul> <p>Купить&nbsp;платье свободное с открытыми плечами белое Le Coeur вы сможете в нашем магазине, оформив заказ через сайт или по телефону.&nbsp;</p> " ["characteristics"]=> string(448) "<ul> <li>Модель: платье с открытыми плечами;</li> <li>Фасон: свободный;</li> <li>Цвет: белый;</li> <li>Состав: полиэстер 100%;</li> <li>Сезон: лето;</li> <li>Бренд:&nbsp;Le Coeur;</li> <li>Страна бренда: Италия.&nbsp;</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14772" ["sku"]=> string(9) "191ST2142" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(48) "catalog/aproduct/folder-2/ao6b6958-1000x1500.jpg" ["manufacturer_id"]=> string(3) "132" ["manufacturer"]=> string(19) "Le Coeur by Twinset" ["manufacturer_size_table"]=> string(1281) "<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>Le Coeur by Twinset</td> <td>XXS</td> <td>XS</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>Le Coeur by Twinset(женские&nbsp;штаны, шорты)</td> <td>XXS</td> <td>XS</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) "5600.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-04-03" ["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-04-03 12:29:00" ["date_modified"]=> string(19) "2021-08-17 10:50:18" ["viewed"]=> string(4) "1015" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "205" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '205' 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" } }