Женские трикотажные рубашки и блузы

array(7) { [14875]=> array(49) { ["product_id"]=> string(5) "14875" ["name"]=> string(49) "Топ женский черный Rich&Royal" ["description"]=> string(745) "<p>Топ женский приталенный на бретелях черного цвета Rich&amp;Royal из тонкого материала. Круглый низкий вырез. Широкие фиксированные бретели. Логотип бренда на спинке. Однотонная модель. укороченная длина. Классический крой. Базовая модель в повседневном гардеробе.&nbsp;</p> <p>Купить топ женский приталенный на бретелях черного цвета Rich&amp;Royal вы сможете в магазине через сайт или по телефону.</p> " ["characteristics"]=> string(589) "<ul> <li>Модель: женская трикотажная<strong> майка;</strong></li> <li>Фасон: приталенный;</li> <li>Цвет: черный;</li> <li>Узор: нет;</li> <li>Материал: хлопок 95%, эластен 5%;</li> <li>Сезон: весна-лето;</li> <li>Бренд:&nbsp;Rich&amp;Royal (Рич энд Роял);</li> <li>Страна бренда: Германия.&nbsp;</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(6) "Топ" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14875" ["sku"]=> string(11) "19S Ath Top" ["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/campaignss2019/1etazh/woman/ao6b6805.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) "1400.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) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-09-03 12:31:37" ["viewed"]=> string(3) "722" ["categories"]=> array(7) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "188" [3]=> string(3) "199" [4]=> string(3) "365" [5]=> string(3) "511" [6]=> string(3) "524" } [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 = '524' 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" } [15940]=> array(49) { ["product_id"]=> string(5) "15940" ["name"]=> string(38) "Женский топ Rich & Royal" ["description"]=> string(2102) "<p>Модная трикотажная майка с люрексовыми нитками&nbsp;Rich &amp; Royal.&nbsp;Круглая горловина, широкие проймы. Ткань в тонкий рубчик - удобная модель, которая хорошо смотрится как в паре с <a href="https://dn8.ua/zhenskie-pidzhaki/">пиджаком</a> или <a href="https://dn8.ua/zhenskie-kardigany/">кардиганом</a>, так и самостоятельно.&nbsp;&nbsp;</p> <p>Модный женский&nbsp;топ&nbsp;с открытыми плечами в спортивном стиле;&nbsp;универсальная вещь в базовом гардеробе;&nbsp;длинная женская футболка;&nbsp;плотно облегает фигуру; майка изготовлена из мягкого трикотажа, приятного телу; яркое цветовое решение.</p> <p>Чтобы заказать женский топ с люрексом Rich &amp; Royal, воспользуйтесь стандартной формой заказа или &quot;купить в 1 клик&quot;. Предпочитаете личное общение, <a href="https://dn8.ua/contact-us/">наберите</a> нашего менеджера и уточните всю нужную вам информацию. Сервис Новая Почта доставит ваш товар в любое удобное для вас отделение как в Киеве, так и в любом другом регионе Украины. Подробнее о&nbsp;<a href="https://dn8.ua/booking-terms">Правила бронирования товаров</a>,&nbsp; а так же об&nbsp;<a href="https://dn8.ua/delivery">Оплате/доставке</a>.</p> <ul> </ul> " ["characteristics"]=> string(805) "<ul> <li>Модель: женский&nbsp;топ;</li> <li>Фасон: облегающая женская майка на широких бретелях;</li> <li>Цвет: темно-зеленый;</li> <li>Узор: нет;</li> <li>Состав:&nbsp;вискоза 66%, полиамид 16%, полиакрил 15%, эластан 3%;</li> <li>Сезон: демисезонный;</li> <li>Бренд:&nbsp;<a href="https://dn8.ua/rich-and-royal">Rich&amp;Roya</a><a href="https://dn8.ua/rich-and-royal">l</a>&nbsp;(Рич энд Роял);</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(6) "Топ" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(179) "Топ, майка, футболка без рукавов, женский, короткий, зеленый, с люрексом, Rich & Royal, бренд, брендовый" ["model"]=> string(5) "15940" ["sku"]=> string(13) "E19W LX S Top" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "5" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2019/zhenskaja_dekabr_1_etazh/img_4528.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) "1490.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-16" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-06-08 16:54:03" ["viewed"]=> string(3) "564" ["categories"]=> array(7) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "188" [3]=> string(3) "199" [4]=> string(3) "365" [5]=> string(3) "511" [6]=> string(3) "524" } [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 = '524' 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" } [4227]=> array(49) { ["product_id"]=> string(4) "4227" ["name"]=> string(51) "Топ женский металлик Maison Espin" ["description"]=> string(1076) "<p>Топ женский без рукавов пудра металлик Maison Espin приталенный. Вырез горловины круглый, проймы неширокие. Яркий акцент в образе - обработка проймы и горловины обтачкой из контрастного трикотажа. Застежка на пуговицы на спине. Переднее полотно укороченное, подол ровный. Ткань легкая, нежного пастельного оттенка хорошо сочетается однотонным низом. Лаконичный дизайн&nbsp; женственность и элегантный фасон подходят как для формальных встреч, так и для неформальных мероприятий.</p> <ul> </ul> <p>Блуза-топ - стильная вещь в базовом гардеробе уверенной, активной женщины.</p> " ["characteristics"]=> string(709) "<ul> <li>Фасон: блуза-топ без рукавов;</li> <li>Сезонность: весна-лето;</li> <li>Ткань: трикотаж;</li> <li>Состав:&nbsp;<span style="font-size:12px">&nbsp;<span style="color:black"><span style="font-family:Arial,sans-serif">вискоза 70%, полиамид 15%, полиэстер 15%</span></span></span></li> <li>Цвет: пудра металлик;</li> <li>Бренд: Maison Espin&nbsp;</li> <li>Страна бренда: Италия</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(19) "Топ Maison Espin" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(6) "Топ" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "4227" ["sku"]=> string(16) "MW16S12MT cipria" ["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(43) "data/1c/utp005821_catalog_news_img_6001.jpg" ["manufacturer_id"]=> string(2) "97" ["manufacturer"]=> string(12) "Maison Espin" ["manufacturer_size_table"]=> string(1353) "<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>&nbsp;</td> <td>примечание</td> </tr> <tr> <td>Maison Espin</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>Maison Espin (женские&nbsp;штаны, шорты)</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> </tr> </tbody> </table> " ["price"]=> string(9) "3990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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-12-20 16:59:20" ["date_modified"]=> string(19) "2021-06-09 10:19:13" ["viewed"]=> string(3) "869" ["categories"]=> array(7) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "188" [3]=> string(3) "199" [4]=> string(3) "365" [5]=> string(3) "511" [6]=> string(3) "524" } [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 = '524' 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" } [11096]=> array(49) { ["product_id"]=> string(5) "11096" ["name"]=> string(42) "Топ женский льняной Kocca" ["description"]=> string(1067) "<p>Топ женский кирпичный Kocca, силуэт приталенный, фасон удлиненный. Вырез горловины V-образный. Стильный акцент в образе - декорирование горловины и проем тонкой полосой кружева в цвет изделию. Подол овальный, подгиб средний. Лаконичный дизайн и насыщенный теплый цвет создают женственный, изысканный образ.&nbsp;</p> <ul> </ul> <p>Блуза-мастхэв для летнего гардероба. Легко комбинируется как с брюками, так и с юбками или шортами.&nbsp;</p> <p>Заказать&nbsp;топ женский кирпичный Kocca&nbsp;Вы можете в нашем магазине, оформив заказ по телефону или через сайт.&nbsp;</p> " ["characteristics"]=> string(405) "<ul> <li>Фасон: блуза без рукавов;</li> <li>Сезонность: весна-лето;</li> <li>Состав: лен 100%;</li> <li>Цвет: кирпичный;</li> <li>Бренд:&nbsp;Kocca (Кокка, Италия);</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(12) "Топ Kocca" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(6) "Топ" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(123) "Топ, женский, кирпичного, цвета, коричневый, Kocca, летний, лен, льняной" ["model"]=> string(5) "11096" ["sku"]=> string(29) "P17PCN440105UN0000 TUPA 10383" ["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(43) "data/1c/utp007820_catalog_news_img_5924.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) "2280.0000" ["special"]=> NULL ["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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-05-26 09:31:41" ["viewed"]=> string(3) "825" ["categories"]=> array(7) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "188" [3]=> string(3) "199" [4]=> string(3) "365" [5]=> string(3) "511" [6]=> string(3) "524" } [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 = '524' 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" } [8511]=> array(49) { ["product_id"]=> string(4) "8511" ["name"]=> string(51) "Топ женский в полоску Beatrice .b" ["description"]=> string(1173) "<p>Топ женский в разноцветную полоску на белом Beatrice .b приталенный, фасон укороченный. Вырез горловины высокий, круглый, аккуратно обработанный. Вырез на спине капля, застежка пуговица. Расцветка в полоску универсальная, можно комбинировать с любым однотонным низом. Можно надевать изделие как навыпуск, так и заправляя внутрь.&nbsp;</p> <ul> </ul> <p>Идеально подходит для создания летнего, изящного образа. Подходит для уверенных женщин, которые ценят комфорт и стиль.</p> <p>Купить&nbsp;топ женский в разноцветную полоску на белом Beatrice .b&nbsp;Вы можете в нашем магазине, оформив заказ по телефону или через сайт.&nbsp;</p> " ["characteristics"]=> string(465) "<ul> <li>Фасон: блуза без рукавов;</li> <li>Сезонность: весна-лето;</li> <li>Состав: полиэстер%;</li> <li>Цвет: белый в разноцветную полоску;</li> <li>Бренд:&nbsp;Beatrice .b (Беатриче би, Италия);</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(18) "Топ Beatrice .b" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(6) "Топ" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "8511" ["sku"]=> string(13) "16FE8055LINDA" ["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(57) "data/1c/utp006113_catalog_vesna_leto_jenskoe_img_6433.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(9) "5900.0000" ["special"]=> NULL ["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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-08-10 10:46:01" ["viewed"]=> string(3) "849" ["categories"]=> array(7) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "188" [3]=> string(3) "199" [4]=> string(3) "366" [5]=> string(3) "511" [6]=> string(3) "524" } [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 = '524' 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" } [7593]=> array(49) { ["product_id"]=> string(4) "7593" ["name"]=> string(34) "Топ женский Maison Espin" ["description"]=> string(1175) "<p>Топ женский без рукавов с надписью на белом Maison Espin прямого кроя, приталенный. Вырез горловины круглый, проймы неширокие. Перед укороченный, по бокам - небольшие треугольные разрезы. Хорошо подчеркивает широкие плечи и стройную фигуру. Отлично сочетается с однотонным низом. Рекомендуется носить навыпуск.&nbsp;</p> <ul> </ul> <p>Белая блуза-топ - базовая вещь в летнем гардеробе. Подходит для активных, молодых женщин, которые предпочитают стильные вещи в стиле casual.</p> <p>Заказать топ женский без рукавов с надписью на белом&nbsp;Maison Espin&nbsp;Вы можете в нашем магазине, оформив заказ по телефону или через сайт.&nbsp;</p> " ["characteristics"]=> string(418) "<ul> <li>Фасон: блуза-топ без рукавов с надписью на белом;</li> <li>Сезонность: весна-лето;</li> <li>Состав: хлопок 100 %;</li> <li>Цвет: белый;</li> <li>Бренд: Maison Espin;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "7593" ["sku"]=> string(17) "MW16S06TU bianco" ["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(61) "data/1c/utp005843_catalog_kocca_richroyal_mayson_img_2899.jpg" ["manufacturer_id"]=> string(2) "97" ["manufacturer"]=> string(12) "Maison Espin" ["manufacturer_size_table"]=> string(1353) "<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>&nbsp;</td> <td>примечание</td> </tr> <tr> <td>Maison Espin</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>Maison Espin (женские&nbsp;штаны, шорты)</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> </tr> </tbody> </table> " ["price"]=> string(9) "2200.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-06-09 10:31:19" ["viewed"]=> string(3) "826" ["categories"]=> array(7) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "188" [3]=> string(3) "199" [4]=> string(3) "366" [5]=> string(3) "511" [6]=> string(3) "524" } [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 = '524' 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" } [7594]=> array(49) { ["product_id"]=> string(4) "7594" ["name"]=> string(52) "Майка белая с принтом Maison Espin" ["description"]=> string(1020) "<p>Майка женская с принтом на белом Maison Espin,&nbsp;фасон приталенный и укороченный. Изделие подчеркивает красивые плечи владелицы и хорошо сидит по фигуре. Пройма широкая. Стильная деталь образа - модный принт контрастных цветов. Изделие в стиле casual, дизайн лаконичный.&nbsp;</p> <ul> </ul> <p>Универсальная модель легко комбинируется с однотонным низом. Базовый элемент летнего гардероба уверенной модницы.</p> <p>Купить майку женскую с принтом на белом Maison Espin Вы можете в нашем магазине, оформив заказ по телефону или через сайт.&nbsp;</p> " ["characteristics"]=> string(490) "<ul> <li>Фасон: майка;</li> <li>Сезонность: весна-лето;</li> <li>Состав: хлопок 100 %;</li> <li>Цвет: насыщенный зеленый;</li> <li>Бренд: Maison Espin&nbsp;(Мейсон Эспин, Италия);</li> <li>Страна бренда: Италия;</li> <li>Производство: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(19) "Топ Maison Espin" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "7594" ["sku"]=> string(16) "MW16S07TU bianco" ["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(43) "data/1c/utp005844_catalog_news_img_5968.jpg" ["manufacturer_id"]=> string(2) "97" ["manufacturer"]=> string(12) "Maison Espin" ["manufacturer_size_table"]=> string(1353) "<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>&nbsp;</td> <td>примечание</td> </tr> <tr> <td>Maison Espin</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>Maison Espin (женские&nbsp;штаны, шорты)</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> </tr> </tbody> </table> " ["price"]=> string(9) "1300.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-05-26 10:47:50" ["viewed"]=> string(3) "816" ["categories"]=> array(6) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "292" [3]=> string(3) "511" [4]=> string(3) "524" [5]=> string(3) "542" } [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 = '524' 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" } }