Женские футболки с длинным рукавом

array(4) { [17338]=> array(49) { ["product_id"]=> string(5) "17338" ["name"]=> string(51) "Футболка коричневая Liviana Conti" ["description"]=> string(639) "<p>Футболка коричневая Liviana Conti с длинным рукавом - базовая модель для стильного образа. Круглый вырез, длинные рукава, полуприлегающий фасон. Материал хорошо держит тепло, не деформируется и не скатывается в процессе использования.</p> <p>Купить стильную&nbsp;футболку коричневую Liviana Conti можно на сайте нашего магазина&nbsp;DN8 SHOPPING SPACE.</p> " ["characteristics"]=> string(458) "<ul> <li>Код товара: 17338</li> <li>Артикул: W0L L0WH16</li> <li>Бренд: Liviana Conti</li> <li>Страна: Италия</li> <li>Цвет: коричневый</li> <li>Рисунок: нет</li> <li>Материал: трикотаж</li> <li>Состав: шерсть 75%, полиамид 25%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(172) "Футболка, женская, с длинным рукавом, Liviana Conti, шерсть, шерстяная, осенняя, весенняя, коричневая " ["model"]=> string(5) "17338" ["sku"]=> string(10) "W0L L0WH16" ["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(68) "catalog/dn8/fotosessija/2020/nojabr/zhenskaja/img_4413-ds-1500px.jpg" ["manufacturer_id"]=> string(3) "130" ["manufacturer"]=> string(13) "Liviana Conti" ["manufacturer_size_table"]=> string(859) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>Liviana Conti</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "6400.0000" ["special"]=> string(9) "3840.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-11-18" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(2) "44" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-11-18 16:50:36" ["date_modified"]=> string(19) "2021-11-30 11:44:29" ["viewed"]=> string(3) "465" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "292" [3]=> string(3) "372" } [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 = '372' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11138]=> array(49) { ["product_id"]=> string(5) "11138" ["name"]=> string(47) "Футболка полосатая River Woods" ["description"]=> string(913) "<p>Футболка женская с надписью &quot;Beach days&quot; свободного кроя River Woods в стиле casual. Круглый вырез горловины. Рукава реглан. Эластичная резинка на манжетах и по подолу. Модель подходит для стильного неформального образа и повседневной носки. Трендовая вещь укрсит ваш повседневный гардероб.</p> <ul> </ul> <p>Если вам понравилась модель, приобрести футболку женскую с надписью &quot;Beach days&quot; свободного кроя River Woods вы сможете в нашем магазине.</p> <ul style="list-style-type:disc"> </ul> " ["characteristics"]=> string(609) "<ul> <li>Модель: лонгслив;</li> <li>Фасон: свободный;</li> <li>Расцветка: белый, синий, красный;</li> <li>Узор: горизонтальная полоска;</li> <li>Ткань: вискоза 69%, акрил 23%, др. волокна 8%;</li> <li>Сезонность: весна-лето;</li> <li>Производитель: River Woods (Ривер Вудс);</li> <li>Производство: Бельгия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(26) "Пуловер River Woods" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11138" ["sku"]=> string(11) "RL17S-C3004" ["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(63) "data/1c/utp007737_catalog_vl_st_emile_creenston_my_img_8063.jpg" ["manufacturer_id"]=> string(3) "104" ["manufacturer"]=> string(11) "River Woods" ["manufacturer_size_table"]=> string(1687) "<p>Верхняя одежда, костюм, пиджак, трикотаж, блузы</p> <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>River Woods&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> </tbody> </table> <p>Джинсы</p> <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>River Woods&nbsp;</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) "3500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-30" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(2) "27" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-20 16:59:20" ["date_modified"]=> string(19) "2021-11-30 09:23:25" ["viewed"]=> string(3) "926" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "292" [3]=> string(3) "372" [4]=> string(3) "511" } [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 = '372' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11536]=> array(49) { ["product_id"]=> string(5) "11536" ["name"]=> string(63) "Футболка женская с оборками River Woods" ["description"]=> string(896) "<p>Футболка женская с длинным рукавом и оборками по подолу River Woods подходит для создания стильного, неформального образа. Высокий вырез горловины. Прямая линия плеч. Длинные рукава. Оригинальный акцент - принт на морскую тематику (якорь и канат), дополненный надписью &quot;Je tadore&quot;. Застегивается на пуговицу, застежка на спине.&nbsp;</p> <p>Если вас заинтересовала модель, купить футболку женскую с длинным рукавом и оборками по подолу River Woods в сможете в нашем магазине.&nbsp;</p> " ["characteristics"]=> string(739) "<ul style="list-style-type:disc"> <li>Модель: женская футболка с длинным рукавом (женский лонгслив);</li> <li>Фасон: свободный;</li> <li>Цвет: белый, синий, золотистый;</li> <li>Узор: полоска, фотопринт якорь и канат;</li> <li>Состав: вискоза 47%, хлопок 47%, эластен 6%;</li> <li>Сезонность: демисезонная;</li> <li>Бренд:&nbsp;River Woods (Ривер Вудс);</li> <li>Страна бренда: Бельгия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(28) "Футболка River Woods" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11536" ["sku"]=> string(11) "RL17S-C5068" ["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(63) "data/1c/utp008487_catalog_vl_st_emile_creenston_my_img_8045.jpg" ["manufacturer_id"]=> string(3) "104" ["manufacturer"]=> string(11) "River Woods" ["manufacturer_size_table"]=> string(1687) "<p>Верхняя одежда, костюм, пиджак, трикотаж, блузы</p> <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>River Woods&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> </tr> </tbody> </table> <p>Джинсы</p> <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>River Woods&nbsp;</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) "2850.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-30" ["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-05-26 10:33:36" ["viewed"]=> string(3) "862" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "292" [3]=> string(3) "372" [4]=> string(3) "511" } [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 = '372' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11102]=> array(49) { ["product_id"]=> string(5) "11102" ["name"]=> string(42) "Футболка oversize белая Kocca" ["description"]=> string(971) "<p>Футболка женская oversize белого цвета с надписью &quot;You make my day&quot; Kocca из гладкого высококачественного трикотажа. Круглый вырез горловины с широким кантом. Рукава реглан длина 7/8. Прямой подол. Длина изделия до начала бедра. Изделие сидит хорошо на разных типах фигуры. Подходит тем, кто ценит свободу движений и sport style.&nbsp;</p> <ul style="list-style-type:disc"> </ul> <p>В нашем магазине вы можете заказать понравившуюся вам футболку женскую oversize белого цвета с надписью &quot;You make my day&quot; Kocca. Желаем удачных покупок!</p> " ["characteristics"]=> string(635) "<ul style="list-style-type:disc"> <li>Модель: женская футболка с длинным рукавом (лонгслив);</li> <li>Фасон: свободный (oversize);</li> <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(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11102" ["sku"]=> string(24) "P17PTS448805UN0000 CHUTO" ["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(43) "data/1c/utp007826_catalog_news_img_5754.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) "2500.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) "2018-08-28 15:17:09" ["date_modified"]=> string(19) "2021-05-26 10:45:26" ["viewed"]=> string(3) "871" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "292" [3]=> string(3) "372" } [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 = '372' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }