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

array(12) { [6994]=> array(49) { ["product_id"]=> string(4) "6994" ["name"]=> string(64) "Платье-футляр женское черное Rena Lange" ["description"]=> string(904) "<p>Красота, изысканность, вкус&hellip; Одежда может о многом рассказать. Платье от RENA LANGE &ndash; воплощение стиля и элегантности. Изделие подчеркивает тонкие линии фигуры своей обладательницы, черный цвет помогает сбалансировать объем, нежная ткань в районе груди придает чувственности, сборки являются изюминкой дизайна.</p> <p>Платье из шелка хорошо подходит для светского вечера, встреч и свидания.</p> <p>Купить платье-футляр женское черное Rena Lange в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(474) "<ul> <li>Модель: платье-футляр;</li> <li>Цвет: черный;</li> <li>Узор: нет;</li> <li>Состав: верх-шелк 90% эластан 10%; подкладка - ацетат 96%, эластан 4%;</li> <li>Сезон: лето;</li> <li>Бренд: RENA LANGE;</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(0) "" ["model"]=> string(4) "6994" ["sku"]=> string(21) "RL-21-03-009-0-21-090" ["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/2021/mart/zhenskaya/img_9748-ds-1500px.jpg" ["manufacturer_id"]=> string(3) "161" ["manufacturer"]=> string(10) "Rena Lange" ["manufacturer_size_table"]=> string(848) "<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>Rena Lange</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>48</td> <td>соответствует</td> </tr> </tbody> </table> " ["price"]=> string(10) "23000.0000" ["special"]=> string(9) "4600.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:30:11" ["date_modified"]=> string(19) "2021-05-18 10:18:01" ["viewed"]=> string(3) "589" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "206" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11123]=> array(49) { ["product_id"]=> string(5) "11123" ["name"]=> string(64) "Платье женское темно-синее Rich&Royal" ["description"]=> string(909) "<p>С помощью платья от немецкого бренда Rich&amp;Royal вы сможете выразить уверенность и чувство стиля. Модный цвет и современный дизайн подчеркнут вашу женственность и вызовут восхищение.</p> <p>Рукава-крылышки, сзади молния, средняя длина, круглая горловина, приятный к телу материал.</p> <p>Такая модель хорошо походит для ежедневного ношения и так же уместна для работы и посиделок с подругами.</p> <p>Заказать платье женское темно-синее Rich&amp;Royal в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(464) "<ul> <li>Модель: платье женское;</li> <li>Цвет: темно-синий;</li> <li>Узор: без узора;</li> <li>Состав: полиамид 47%, хлопок 43%, эластан 10%;</li> <li>Сезон: лето;</li> <li>Бренд: Rich&amp;Royal;</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(0) "" ["model"]=> string(5) "11123" ["sku"]=> string(6) "65q600" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "6" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2021/mart/zhenskaya/img_0203-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "13" ["manufacturer"]=> string(14) "Rich&Royal" ["manufacturer_size_table"]=> string(2334) "<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>Rich&amp;Royal</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>&nbsp;</td> <td>&nbsp;</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> </tr> <tr> <td>Rich&amp;Royal</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> <td>&nbsp;</td> </tr> <tr> <td>Rich&amp;Royal (джинсы)</td> <td>&nbsp;</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>36 - 38</td> <td>31</td> <td>32</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "5500.0000" ["special"]=> string(9) "2750.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:30:11" ["date_modified"]=> string(19) "2021-11-10 11:57:13" ["viewed"]=> string(3) "435" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "206" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [6766]=> array(49) { ["product_id"]=> string(4) "6766" ["name"]=> string(48) "Платье женское серое Strenesse" ["description"]=> string(921) "<p>Классика для уверенных в себе женщин.</p> <p>Строгое стильное платье обладает некой свободой и легкостью благодаря спокойствию цвета, его отличает оригинальность кроя и интересный материал.</p> <p>Высокое качество пошива, уникальные материалы и идеальный крой &ndash; вот те черты, которые отличают коллекции Strenesse.</p> <p>Его оценят бизнес-вумен и женщины, знающие толк в модных тенденциях.</p> <p>Звоните и заказывайте платье женское серое Strenesse в интернет-магазине dn8.ua</p> " ["characteristics"]=> string(495) "<ul> <li>Модель: платье женское;</li> <li>Цвет: серый;</li> <li>Узор: без узора;</li> <li>Состав: верх - вискоза 79%, полиамид 21%; подкладка - хлопок 96%, эластан 4%;</li> <li>Сезон: лето;</li> <li>Бренд: Strenesse;</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(0) "" ["model"]=> string(4) "6766" ["sku"]=> string(6) "325036" ["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/2021/mart/zhenskaya/img_9759-ds-1500px.jpg" ["manufacturer_id"]=> string(3) "107" ["manufacturer"]=> string(9) "Strenesse" ["manufacturer_size_table"]=> string(687) "<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>Strenesse</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(9) "6300.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:30:11" ["date_modified"]=> string(19) "2021-05-18 11:42:58" ["viewed"]=> string(3) "546" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "206" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [6805]=> array(49) { ["product_id"]=> string(4) "6805" ["name"]=> string(53) "Платье женское красное Rena Lange" ["description"]=> string(941) "<p>Смелый цвет, правда? Красный всегда считался страстным, эмоциональным и очень женственным. А теперь представьте, какой потрясающий эффект оно воспроизведет на окружающих. Можно сказать, что это стильный джекпот.</p> <p>В платье воплощены чувственность на пару с шиком и в целом оно придает образу властности и шика.</p> <p>Облегающая модель, глубокий вырез горловины, длина миди, короткие рукава с тесьмой, сзади молния.</p> <p>Купить платье женское красное Rena Lange в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(512) "<ul> <li>Модель: облегающее платье;</li> <li>Цвет: красный;</li> <li>Узор: нет;</li> <li>Состав: верх - ацетат 75%, полиамид 22%, эластан 3%; подкладка - ацетат 96%, эластан 4%;</li> <li>Сезон: лето;</li> <li>Бренд: RENA LANGE;</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(0) "" ["model"]=> string(4) "6805" ["sku"]=> string(19) "RL-02-03-088-02-047" ["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/2021/mart/zhenskaya/img_9771-ds-1500px.jpg" ["manufacturer_id"]=> string(3) "161" ["manufacturer"]=> string(10) "Rena Lange" ["manufacturer_size_table"]=> string(848) "<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>Rena Lange</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>48</td> <td>соответствует</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) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:30:11" ["date_modified"]=> string(19) "2021-05-18 12:32:30" ["viewed"]=> string(3) "431" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "206" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [6983]=> array(49) { ["product_id"]=> string(4) "6983" ["name"]=> string(49) "Платье женское черное Mattiolo" ["description"]=> string(822) "<p>Амбициозное платье для любительниц шика и непревзойденного стиля. Потрясающе элегантная облегающая модель для обладательниц красивых форм.</p> <p>Интересный дизайн, без рукавов, длина ниже колена, строгий черный цвет придает загадочности и уверенности в своей привлекательности, наличие подкладки.</p> <p>Такая модель однозначно привлекает внимание.</p> <p>Заказать платье женское черное Mattiolo в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(481) "<ul> <li>Модель: облегающее платье;</li> <li>Цвет: черный;</li> <li>Узор: сеточка;</li> <li>Состав: верх - вискоза 55%, ацетат 45%; подкладка - полиамид 100%;</li> <li>Сезон: лето;</li> <li>Бренд: Gai Mattiolo;</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(0) "" ["model"]=> string(4) "6983" ["sku"]=> string(11) "P71224-1600" ["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(66) "catalog/dn8/fotosessija/2021/mart/zhenskaya/img_9764-ds-1500px.jpg" ["manufacturer_id"]=> string(3) "163" ["manufacturer"]=> string(12) "Gai Mattiolo" ["manufacturer_size_table"]=> string(679) "<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>примечание</td> </tr> <tr> <td>Gai Mattiolo</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>соответствует</td> </tr> </tbody> </table> " ["price"]=> string(9) "7400.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:23:27" ["date_modified"]=> string(19) "2022-01-14 15:01:08" ["viewed"]=> string(3) "586" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "206" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16378]=> array(49) { ["product_id"]=> string(5) "16378" ["name"]=> string(51) "Платье женское синее Luisa Cerano" ["description"]=> string(887) "<p>Почувствуйте себя женственной и элегантной в платье от немецкого бренда Luisa Cerano.</p> <p>Несколько завышенная линия талии, прилегающий А-образный силуэт, без рукавов, длина миди, сзади застегивается на молнию, с подкладкой.</p> <p>Такая модель хорошо подчеркивает прелести фигуры.</p> <p>Обратите внимание на привлекательный немаркий цвет, который чудесно сочетается с другими цветами.</p> <p>Купить платье женское синее Luisa Cerano в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(488) "<ul> <li>Модель: облегающее платье;</li> <li>Цвет: синий;</li> <li>Узор: с узором;</li> <li>Состав: верх - полиэстер 100%; подкладка - модал 62%, полиэстер 38%;</li> <li>Сезон: лето;</li> <li>Бренд: Luisa Cerano;</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(0) "" ["model"]=> string(5) "16378" ["sku"]=> string(11) "718142/2433" ["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/2021/mart/zhenskaya/img_9776-ds-1500px.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"]=> string(9) "7750.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:23:27" ["date_modified"]=> string(19) "2021-08-19 10:00:10" ["viewed"]=> string(3) "544" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "206" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11906]=> array(49) { ["product_id"]=> string(5) "11906" ["name"]=> string(73) "Платье женское в цветочный принт Luisa Cerano" ["description"]=> string(734) "<p>Потрясающе привлекательное платье однозначно обращает на себя внимание.</p> <p>Длина до колена, без рукавов, сзади молния, закругленная горловина, фактурный материал, модель прямого кроя, визуально красивое изделие, особенно при разном освещении.</p> <p>В таком платье вы готовы покорять мир!</p> <p>Заказать платье женское в цветочный принт Luisa Cerano в интернет-магазине dn8.ua.</p> " ["characteristics"]=> string(462) "<ul> <li>Модель: женское платье;</li> <li>Цвет: разноцветное;</li> <li>Узор: принт;</li> <li>Состав: полиэстер 53%, акрил 28%, хлопок 13%, РЕ2 6%;</li> <li>Сезон: лето;</li> <li>Бренд: Luisa Cerano;</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(0) "" ["model"]=> string(5) "11906" ["sku"]=> string(11) "758068/2094" ["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(66) "catalog/dn8/fotosessija/2021/mart/zhenskaya/img_9728-ds-1500px.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) "10900.0000" ["special"]=> string(9) "7630.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:23:27" ["date_modified"]=> string(19) "2021-08-19 10:03:20" ["viewed"]=> string(3) "570" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "206" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [6895]=> array(49) { ["product_id"]=> string(4) "6895" ["name"]=> string(36) "Платье женское Elegance" ["description"]=> string(838) "<p>Потрясающий наряд для особого случая в вашей жизни. Это платье воплощает элегантность и шик, красоту и обаяние. Модель черного цвета, длина в пол, с коротким рукавом, оригинальный дизайн.</p> <p>Если вы являетесь поклонницей качественных, красивых и не выходящих из моды вещей, тогда вам однозначно придется по душе это платье.</p> <p>И помните &ndash; вы восхитительны.</p> <p>Купить платье женское Elegance в интернет-магазине dn8.ua.&nbsp;</p> " ["characteristics"]=> string(490) "<ul> <li>Модель: женское платье;</li> <li>Цвет: черное;</li> <li>Узор: есть;</li> <li>Состав: верх - ацетат 76%, полиамид 18%, эластан 6%; подкладка - полиамид 100%;</li> <li>Сезон: лето;</li> <li>Бренд: Elegance;</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(118) "Платье, женское, Elegance, черное, длинное, вечернее, летнее, нарядное" ["model"]=> string(4) "6895" ["sku"]=> string(7) "2325099" ["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/2021/mart/zhenskaya/img_9723-ds-1500px.jpg" ["manufacturer_id"]=> string(3) "162" ["manufacturer"]=> string(8) "Elegance" ["manufacturer_size_table"]=> string(789) "<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>4XL</td> <td>примечание</td> </tr> <tr> <td>Elegance</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>соответствует</td> </tr> </tbody> </table> " ["price"]=> string(9) "9000.0000" ["special"]=> string(9) "4500.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:12:45" ["date_modified"]=> string(19) "2021-12-29 14:45:18" ["viewed"]=> string(3) "743" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "206" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [6837]=> array(49) { ["product_id"]=> string(4) "6837" ["name"]=> string(46) "Платье женское черное Axara" ["description"]=> string(906) "<p>Женственная, чувственная, роскошная&hellip; Именно такая женщина выбирает платье от бренда Axara. В нем столько скрытой страсти! А все дело в сдержанности и загадочности цвета, несколько укороченной длине и великолепно продуманному дизайну с ноткой кокетливости.</p> <p>Такая модель хорошо смотрится на женщинах с разным типом фигуры, подчеркивая женственные изгибы и придавая образу изящества.</p> <p>Купить платье женское черное Axara в интернет-магазине dn8.ua по хорошей цене.</p> " ["characteristics"]=> string(438) "<ul> <li>Модель: женское платье;</li> <li>Цвет: черное;</li> <li>Узор: сеточка;</li> <li>Состав: вискоза 81%, полиамид 16%, эластан 3%;</li> <li>Сезон: лето;</li> <li>Бренд: Axara;</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(137) "Платье, женское, черное, Axara, до колена, вечернее, на каждый день, без рукавов" ["model"]=> string(4) "6837" ["sku"]=> string(11) "Н15 191624" ["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(66) "catalog/dn8/fotosessija/2021/mart/zhenskaya/img_9753-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "73" ["manufacturer"]=> string(5) "Axara" ["manufacturer_size_table"]=> string(628) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> </tr> <tr> <td>Axara</td> <td>38 (M)</td> <td>40 (L)</td> <td>42 (XL)</td> <td>44 (XXL)</td> <td>46 (3XL)</td> <td>48</td> </tr> </tbody> </table> <table> </table> " ["price"]=> string(9) "7800.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-19 15:44:31" ["date_modified"]=> string(19) "2021-09-07 12:32:10" ["viewed"]=> string(3) "715" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "206" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11818]=> array(49) { ["product_id"]=> string(5) "11818" ["name"]=> string(54) "Длинное женское платье Beatrice .b" ["description"]=> string(880) "<p>Это платье завораживает и вдохновляет! Нежная голубизна сливается с &laquo;темной материей&raquo; и завораживает.</p> <p>Длина макси, плиссированная юбка, кружевные оборки, завышенная линия талии, великолепный дизайн, нестандартное оформление горловины с эффектом &laquo;на запах&raquo;, модель без рукавов.</p> <p>В таком платье женщина не останется незамеченной.</p> <p>Купить длинное женское платье Beatrice .b в интернет-магазине dn8.ua с доставкой по Украине.</p> " ["characteristics"]=> string(430) "<ul> <li>Модель: женское платье;</li> <li>Цвет: голубой с черным;</li> <li>Узор: принт цветы;</li> <li>Состав: полиэстер100%;</li> <li>Сезон: лето;</li> <li>Бренд: Beatrice .b;</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(140) "Длинное, женское, платье, Beatrice .b, плиссированное, выходное, без рукавов, цветы" ["model"]=> string(5) "11818" ["sku"]=> string(14) "17FE6548ORE234" ["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(66) "catalog/dn8/fotosessija/2021/mart/zhenskaya/img_9739-ds-1500px.jpg" ["manufacturer_id"]=> string(2) "58" ["manufacturer"]=> string(11) "Beatrice .b" ["manufacturer_size_table"]=> string(2539) "<table class="women"> <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>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>Примечание</td> </tr> <tr> <td>Верхняя одежда</td> <td>&nbsp;</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> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>соответствуют</td> </tr> <tr> <td>Женские штаны</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>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Обувь</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "15700.0000" ["special"]=> string(10) "10990.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-19 15:44:31" ["date_modified"]=> string(19) "2021-08-09 14:24:04" ["viewed"]=> string(3) "499" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "206" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16925]=> array(49) { ["product_id"]=> string(5) "16925" ["name"]=> string(42) "Платье шелковое Luisa Cerano" ["description"]=> string(944) "<p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Платье без рукавов зелёное в пудрово-розовый принт листья. Модель выполнена в А-силуэте <strong>из натурального шёлка</strong>, имеет два боковых кармана, круглый вырез, застёжку капля на пуговицу. </span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Длина изделия миди.</span></span></span></p> " ["characteristics"]=> string(595) "<ul> <li>Код товара: 16925</li> <li>Артикул: 7181442428</li> <li>Бренд: Luisa Cerano</li> <li>Страна: Германия</li> <li>Модель: платье</li> <li>Цвет: зеленое в принт</li> <li>Материал: шелк 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(164) "Платье, женское, летнее, легкое, с цветами, принт, цветы, без рукавов, Luisa Cerano, шелк, шелковое" ["model"]=> string(5) "16925" ["sku"]=> string(11) "718144/2428" ["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_5535-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) "16800.0000" ["special"]=> string(9) "8400.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(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-07-15 12:47:44" ["date_modified"]=> string(19) "2021-11-10 12:00:06" ["viewed"]=> string(4) "1439" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "206" [4]=> string(3) "207" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13073]=> array(49) { ["product_id"]=> string(5) "13073" ["name"]=> string(80) "Платье ярко-красное с завязками на спине Kocca" ["description"]=> string(631) "<p>Платье женское без рукавов с завязками на спине Kocca из гладкой однотонной ткани. Завышенная талия. Приталенный лиф. Широкая юбка полу-солнце с мягкими складками. Длина до колена.&nbsp;</p> <p>Если вам понравилась модель, заказать платье женское без рукавов с завязками на спине красного цвета Kocca вы сможете в нашем магазине.&nbsp;</p> " ["characteristics"]=> string(507) "<ul> <li>Модель: платье беби-долл;</li> <li>Фасон: приталенный;</li> <li>Цвет: красный;</li> <li>Узор: нет;</li> <li>Материал ткани: вискоза 95%, эластен 5;</li> <li>Сезонность: лето;</li> <li>Бренд: Kocca (Кокка);</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(17) "ПлатьеKocca" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Платье" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "13073" ["sku"]=> string(25) "P18PAB684003UN0000 IMABEL" ["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(58) "data/1c/utp010624_catalog_foto_modeli_17_1807_ao6b1778.jpg" ["manufacturer_id"]=> string(2) "48" ["manufacturer"]=> string(5) "Kocca" ["manufacturer_size_table"]=> string(1606) "<p>Одежда</p> <table class="women"> <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> </tr> <tr> <td>Kocca</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>50</td> </tr> </tbody> </table> <p>Джинсы</p> <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>Kocca</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) "3950.0000" ["special"]=> string(9) "1975.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-28" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1400" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-11-10 11:55:15" ["viewed"]=> string(3) "973" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "200" [3]=> string(3) "202" [4]=> string(3) "206" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '206' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }