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

array(7) { [13221]=> array(49) { ["product_id"]=> string(5) "13221" ["name"]=> string(68) "Лонгслив мужской с манжетами Pal Zileri LAB" ["description"]=> string(1092) "<p>Серый лонгслив Pal Zileri Lab с рукавом реглан и круглым вырезом.</p> <p>Без застежки, вырез, низ рукава и край для удобства довязаны &laquo;резинкой&raquo;.</p> <p>Тыльная сторона выреза и манжет украшена полосками в спортивном стиле.</p> <p>Мягкий, комфортный, натуральный&nbsp; трикотаж из 100% хлопка.</p> <p>Классического цвета светло серый меланж.</p> <p>Хорошо комбинируется с одеждой в стиле кэжуал, внося легкий спортивный акцент в образ.</p> <p>Лонгслив Pal Zileri Lab по лучшей цене можно купить в интернет магазине DN8 Shopping Space <a href="https://dn8.ua">https://dn8.ua</a>.</p> " ["characteristics"]=> string(600) "<ul> <li>Код товара: 13221</li> <li>Артикул: MPM0M560 38622</li> <li>Бренд: Pal Zileri Lab</li> <li>Страна: Италия</li> <li>Цвет: серый</li> <li>Сезон: вне сезона</li> <li>Материал: 100% хлопок</li> <li>Тип застёжки: без застежки</li> <li>Параметры модели: 102-84-99, рост 185 см</li> <li>На модели надет: 48</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(139) "Джемпер, мужской, с манжетами, кофта, Pal Zileri, облегающий, с круглой горловиной" ["model"]=> string(5) "13221" ["sku"]=> string(14) "MPM0M560 38622" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "8" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(57) "catalog/dn8/fotosessija/2020/oktjabr/2_etazh/img_2186.jpg" ["manufacturer_id"]=> string(3) "102" ["manufacturer"]=> string(15) "Pal Zileri LAB " ["manufacturer_size_table"]=> string(690) "<table class="men"> <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>Pal Zileri Lab</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>58</td> <td>60</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) "2020-10-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-30 16:59:20" ["date_modified"]=> string(19) "2021-07-12 11:29:16" ["viewed"]=> string(3) "233" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "453" [3]=> string(3) "513" } [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 = '453' 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" } [13773]=> array(49) { ["product_id"]=> string(5) "13773" ["name"]=> string(54) "Сливовый лонгслив Harmont & Blaine" ["description"]=> string(1200) "<p>Мужская футболка (лонгслив) <a href="https://dn8.ua/harmont-amp-blaine">HARMONT&amp;BLAINE</a> с длинным рукавом &nbsp;и&nbsp; классическим круглым вырезом.</p> <p>Материал 100% хлопок, джерси (трикотаж) сливового цвета. Украшена графическим принтом &laquo;viaggiare&raquo; и логотипом <a href="https://dn8.ua/harmont-amp-blaine">HARMONT&amp;BLAINE</a>.</p> <p>Универсальная модель, подходит для &nbsp;образов в кэжуал стилях, хорошо сочетается с трикотажем и денимом.</p> <p>Остались вопросы? Задавайте их нашим менеджерам в режиме онлайн или по номеру телефона +38(067)510-28-88. Заказывайте сливовый лонгслив Harmont &amp; Blaine прямо сейчас. DN8 - мы работаем с удовольствием для вас!</p> " ["characteristics"]=> string(618) "<ul> <li>Код товара: 13773</li> <li>Артикул: HBI00225020741 545</li> <li>Бренд: Harmont &amp; Blaine</li> <li>Страна: Италия</li> <li>Цвет: сливовый</li> <li>Сезон: вне сезона</li> <li>Материал: 100% хлопок</li> <li>Тип застёжки: без застежки</li> <li>Параметры модели: 102-84-99, рост 185 cм</li> <li>На модели надет: L</li> </ul> " ["color"]=> string(7) "#813a5c" ["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(139) "Футболка, мужская, с длинным рукавом, Harmont & Blaine, хлопок, бордовая, с принтом" ["model"]=> string(5) "13773" ["sku"]=> string(18) "HBI00225020741 545" ["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(57) "catalog/dn8/fotosessija/2020/oktjabr/2_etazh/img_2207.jpg" ["manufacturer_id"]=> string(2) "55" ["manufacturer"]=> string(18) "Harmont&Blaine" ["manufacturer_size_table"]=> string(1718) "<table class="men"> <tbody> <tr> <td>Верхняя одежда, костюм, пиджак, трикотаж, рубашки, брюки</td> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> </tr> </tbody> <tbody> <tr> </tr> <tr> <td>Рубашки</td> <td>Европа (EU)</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> <td>42</td> <td>43</td> <td>44</td> <td>45</td> <td>46</td> <td>47</td> <td>48</td> <td>49</td> <td>50</td> </tr> </tbody> <tbody> <tr> <td>Джинсы</td> <td>Европа (EU)</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> </tr> <tr> <td>Головные уборы</td> <td>one size</td> </tr> </tbody> <tbody> </tbody> </table> " ["price"]=> string(9) "2990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-10-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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-30 16:49:16" ["date_modified"]=> string(19) "2021-07-05 12:11:12" ["viewed"]=> string(3) "228" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "445" [3]=> string(3) "453" [4]=> string(3) "513" } [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 = '453' 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" } [13776]=> array(49) { ["product_id"]=> string(5) "13776" ["name"]=> string(48) "Синий лонгслив Harmont & Blaine" ["description"]=> string(1066) "<p>Мужская футболка (лонгслив) <a href="https://dn8.ua/harmont-amp-blaine">HARMONT&amp;BLAINE</a> с длинным рукавом &nbsp;и&nbsp; классическим круглым вырезом.</p> <p>Материал 100% хлопок, джерси (трикотаж) темно-синего цвета. Украшена графическим принтом &laquo;viaggiare&raquo; и логотипом <a href="https://dn8.ua/harmont-amp-blaine">HARMONT&amp;BLAINE</a>.</p> <p>Универсальная модель, подходит для &nbsp;образов в кэжуал стилях, хорошо сочетается с трикотажем и денимом.</p> <p>Купить синий лонгслив Harmont &amp; Blaine Вы можете в нашем магазине, оформив заказ по телефону +38(067)510-28-88 или через сайт.&nbsp;</p> " ["characteristics"]=> string(608) "<ul> <li>Код товара: 13776</li> <li>Артикул: HBI00225020741 801</li> <li>Бренд: Harmont &amp; Blaine</li> <li>Страна: Италия</li> <li>Цвет: синий</li> <li>Сезон: вне сезона</li> <li>Материал: 100% хлопок</li> <li>Тип застёжки: без застежки</li> <li>Параметры модели: 102-84-99, рост 185</li> <li>На модели надет: L</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(326) "футболка с коротким рукавом, футболка с фотопринтом, повседневная футболка, хлопковая футболка, футболка на каждый день, футболка с длинным рукавом, хлопковая футболка, лонгслив" ["model"]=> string(5) "13776" ["sku"]=> string(18) "HBI00225020741 801" ["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(57) "catalog/dn8/fotosessija/2020/oktjabr/2_etazh/img_2211.jpg" ["manufacturer_id"]=> string(2) "55" ["manufacturer"]=> string(18) "Harmont&Blaine" ["manufacturer_size_table"]=> string(1718) "<table class="men"> <tbody> <tr> <td>Верхняя одежда, костюм, пиджак, трикотаж, рубашки, брюки</td> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> </tr> </tbody> <tbody> <tr> </tr> <tr> <td>Рубашки</td> <td>Европа (EU)</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> <td>42</td> <td>43</td> <td>44</td> <td>45</td> <td>46</td> <td>47</td> <td>48</td> <td>49</td> <td>50</td> </tr> </tbody> <tbody> <tr> <td>Джинсы</td> <td>Европа (EU)</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> </tr> <tr> <td>Головные уборы</td> <td>one size</td> </tr> </tbody> <tbody> </tbody> </table> " ["price"]=> string(9) "2990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-10-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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-30 16:49:16" ["date_modified"]=> string(19) "2021-07-05 12:12:53" ["viewed"]=> string(3) "242" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(3) "445" [2]=> string(3) "453" [3]=> string(3) "513" } [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 = '453' 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" } [13775]=> array(49) { ["product_id"]=> string(5) "13775" ["name"]=> string(52) "Красный лонгслив Harmont & Blaine" ["description"]=> string(827) "<p>Мужская футболка (лонгслив) <a href="https://dn8.ua/harmont-amp-blaine">HARMONT&amp;BLAINE</a> с длинным рукавом &nbsp;и&nbsp; классическим круглым вырезом.</p> <p>Материал 100% хлопок, джерси (трикотаж) красного цвета. Украшена графическим принтом &laquo;viaggiare&raquo; и логотипом <a href="https://dn8.ua/harmont-amp-blaine">HARMONT&amp;BLAINE</a>.</p> <p>Универсальная модель, подходит для &nbsp;образов в кэжуал стилях, хорошо сочетается с &nbsp;трикотажем и денимом.</p> " ["characteristics"]=> string(617) "<ul> <li>Код товара: 13775</li> <li>Артикул: HBI00225020741 513</li> <li>Бренд: Harmont &amp; Blaine</li> <li>Страна: Италия</li> <li>Цвет: красный</li> <li>Сезон: вне сезона</li> <li>Материал: 100% хлопок</li> <li>Тип застёжки: без застежки</li> <li>Параметры модели: 102-84-99, рост 185 см</li> <li>На модели надет: L</li> </ul> " ["color"]=> string(7) "#70011c" ["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(263) "футболка с длинным рукавом, футболка с фотопринтом, повседневная футболка, хлопковая футболка, футболка на каждый день, лонгслив, длинный рукав" ["model"]=> string(5) "13775" ["sku"]=> string(18) "HBI00225020741 513" ["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(57) "catalog/dn8/fotosessija/2020/oktjabr/2_etazh/img_2219.jpg" ["manufacturer_id"]=> string(2) "55" ["manufacturer"]=> string(18) "Harmont&Blaine" ["manufacturer_size_table"]=> string(1718) "<table class="men"> <tbody> <tr> <td>Верхняя одежда, костюм, пиджак, трикотаж, рубашки, брюки</td> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> </tr> </tbody> <tbody> <tr> </tr> <tr> <td>Рубашки</td> <td>Европа (EU)</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> <td>42</td> <td>43</td> <td>44</td> <td>45</td> <td>46</td> <td>47</td> <td>48</td> <td>49</td> <td>50</td> </tr> </tbody> <tbody> <tr> <td>Джинсы</td> <td>Европа (EU)</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> </tr> <tr> <td>Головные уборы</td> <td>one size</td> </tr> </tbody> <tbody> </tbody> </table> " ["price"]=> string(9) "2990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-10-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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-30 16:49:16" ["date_modified"]=> string(19) "2021-07-05 12:08:59" ["viewed"]=> string(3) "237" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "445" [3]=> string(3) "453" [4]=> string(3) "513" } [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 = '453' 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" } [13774]=> array(49) { ["product_id"]=> string(5) "13774" ["name"]=> string(48) "Белый лонгслив Harmont & Blaine" ["description"]=> string(823) "<p>Мужская футболка (лонгслив) <a href="https://dn8.ua/harmont-amp-blaine">HARMONT&amp;BLAINE</a> с длинным рукавом &nbsp;и&nbsp; классическим круглым вырезом.</p> <p>Материал 100% хлопок, джерси (трикотаж) белого цвета. Украшена графическим принтом &laquo;viaggiare&raquo; и логотипом <a href="https://dn8.ua/harmont-amp-blaine">HARMONT&amp;BLAINE</a>.</p> <p>Универсальная модель, подходит для &nbsp;образов в кэжуал стилях, хорошо сочетается с &nbsp;трикотажем и денимом.</p> " ["characteristics"]=> string(608) "<ul> <li>Код товара: 13774</li> <li>Артикул: HBI00225020741 100</li> <li>Бренд: Harmont &amp; Blaine</li> <li>Страна: Италия</li> <li>Цвет: белый</li> <li>Сезон: вне сезона</li> <li>Материал: 100% хлопок</li> <li>Тип застёжки: без застежки</li> <li>Параметры модели: 102-84-99, рост 185</li> <li>На модели надет: L</li> </ul> " ["color"]=> string(7) "#d7d7e1" ["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(187) "Футболка, мужская, с длинным рукавом, белая, Harmont & Blaine, с принтом, хлопок, хлопковая, осенняя, весенняя" ["model"]=> string(5) "13774" ["sku"]=> string(18) "HBI00225020741 100" ["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(57) "catalog/dn8/fotosessija/2020/oktjabr/2_etazh/img_2198.jpg" ["manufacturer_id"]=> string(2) "55" ["manufacturer"]=> string(18) "Harmont&Blaine" ["manufacturer_size_table"]=> string(1718) "<table class="men"> <tbody> <tr> <td>Верхняя одежда, костюм, пиджак, трикотаж, рубашки, брюки</td> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> </tr> </tbody> <tbody> <tr> </tr> <tr> <td>Рубашки</td> <td>Европа (EU)</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> <td>42</td> <td>43</td> <td>44</td> <td>45</td> <td>46</td> <td>47</td> <td>48</td> <td>49</td> <td>50</td> </tr> </tbody> <tbody> <tr> <td>Джинсы</td> <td>Европа (EU)</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> </tr> <tr> <td>Головные уборы</td> <td>one size</td> </tr> </tbody> <tbody> </tbody> </table> " ["price"]=> string(9) "2990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-10-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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-30 16:49:16" ["date_modified"]=> string(19) "2021-07-05 12:14:32" ["viewed"]=> string(3) "251" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "445" [3]=> string(3) "453" [4]=> string(3) "513" } [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 = '453' 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" } [15813]=> array(49) { ["product_id"]=> string(5) "15813" ["name"]=> string(76) "Футболка мужская с длинным рукавом Craghoppers" ["description"]=> string(2272) "<p>Защита от укуса насекомых&nbsp;NosiLife.&nbsp;Превосходная защиту от большинства видов насекомых на весь срок эксплуатации. Подходит как для жаркого климата, так и для холодного времени года.&nbsp;</p> <p>Регулирование влажности&nbsp;Moisture control.&nbsp;Технология охлаждения в движении, которая помогает выводить влагу из кожи, позволяя коже дышать.&nbsp;</p> <p>Преимущества мужской футболки с длинным рукавом Craghoppers: контроль запаха; просто отстирать грязь; не нужно гладить; защита от насекомых; управление потоотделением.</p> <p>С чем носить и как комплектовать?&nbsp;Широкий ассортимент товаров для создания стильного спортивного образа или&nbsp;outdoor look-а представлен на сайте нашего магазина. Предлагаем вам дополнить образ стильной <a href="https://dn8.ua/muzhchinam/muzhskaya-odezhda/muzhskaya-verxnyaya-odezhda/muzhskie-kurtki/" target="_blank">курткой</a>, <a href="https://dn8.ua/muzhchinam/muzhskaya-odezhda/muzhskie-dzhinsy/" target="_blank">джинсами </a>или <a href="https://dn8.ua/muzhchinam/muzhskaya-odezhda/muzhskie-bryuki/" target="_blank">брюками</a>.</p> <p>Если вам понравилась модель, купить&nbsp;футболка мужская с длинным рукавом серого цвета с бордовыми вставками Craghoppers можно на сайте нашего магазина. Оформить доставку можно по Киеву и по областям Украины. Удачных покупок!</p> " ["characteristics"]=> string(720) "<ul style="list-style-type:disc"> <li>Модель: мужская одежда&nbsp;outdoor;</li> <li>Фасон: приталенный (slim fit);</li> <li>Цвет: серый, бордовый;</li> <li>Принт: символика Craghoppers;</li> <li>Материал: 61% полиэстер, 36% хлопок, 3% эластан;</li> <li>Вес: 165 гр;</li> <li>Сезонность: внесезонная;</li> <li>Бренд:&nbsp;Craghoppers (Крагхопперс);</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(108) "Craghoppers, Грегхопперс, outdoor, футболка, лонгслив, серый, мужская" ["model"]=> string(5) "15813" ["sku"]=> string(10) "CMT888 6C1" ["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(59) "catalog/dn8/fotosessija/2019/muzhskaja_oktjabr/ao6b0048.jpg" ["manufacturer_id"]=> string(3) "144" ["manufacturer"]=> string(11) "Craghoppers" ["manufacturer_size_table"]=> string(2063) "<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>5XL</td> <td>примечание</td> </tr> <tr> <td>Мужские куртка, пуловер, футболка</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Мужские брюки, шорты</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>22</td> <td>&nbsp;</td> </tr> <tr> <td>Женские куртка, пуловер, футболка</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Женские брюки, шорты</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-10-21" ["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-10-19 16:59:23" ["date_modified"]=> string(19) "2021-07-27 14:57:10" ["viewed"]=> string(3) "625" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "445" [3]=> string(3) "453" } [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 = '453' 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" } [15814]=> array(49) { ["product_id"]=> string(5) "15814" ["name"]=> string(55) "Мужская футболка серая Сraghoppers" ["description"]=> string(1727) "<ul style="list-style-type:disc"> </ul> <p>Практичная и удобная модель.&nbsp;Даже в жаркие дни помогает сохранить комфортную температуру тела. Круглый высокий вырез горловины. Рукава реглан длиной до косточки большого пальца. Овальная линия подола. Длина изделия до начала бедра. Нет карманов. Гладкий материал, приятный телу.</p> <p>Защита от укуса насекомых.&nbsp;Обеспечивает превосходную защиту от большинства укусов насекомых на протяжении всего срока эксплуатации. Материал легко отстирать от загрязнений.&nbsp;</p> <p>Контроль неприятного запаха пота.&nbsp;Материал сконструирован таким образом, что во время движения выводит влагу из кожи и позволяет коже дышать, не вызывая&nbsp;дискомфорта и неприятного запаха.</p> <p>Если вам понравилась модель, купить&nbsp;футболку мужскую серого цвета с длинным рукавом Сraghoppers в нашем магазине. Сервис доставки работает в Киеве и по областям Украины. Удачных покупок!&nbsp;</p> " ["characteristics"]=> string(742) "<ul> <li>Модель: мужская футболка&nbsp;outdoor;</li> <li>Фасон: приталенный (slim fit), лонгслив;</li> <li>Цвет: серый, темно-серый меланж;</li> <li>Принт: символика бренда Сraghoppers;</li> <li>Материал: 61% полиэстер, 36% хлопок, 3% эластан;</li> <li>Сезонность: внесезонная;</li> <li>Вес: 185 г;</li> <li>Бренд:&nbsp;Craghoppers (Крагхопперс);</li> <li>Країна бренду:&nbsp;Великобританія</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(137) "футболка, лонгслив, мужской, серый, длинный, Сraghoppers, outdoor, приталенный, спорт" ["model"]=> string(5) "15814" ["sku"]=> string(10) "CMT888 7UA" ["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(59) "catalog/dn8/fotosessija/2019/muzhskaja_oktjabr/ao6b0065.jpg" ["manufacturer_id"]=> string(3) "144" ["manufacturer"]=> string(11) "Craghoppers" ["manufacturer_size_table"]=> string(2063) "<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>5XL</td> <td>примечание</td> </tr> <tr> <td>Мужские куртка, пуловер, футболка</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Мужские брюки, шорты</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>22</td> <td>&nbsp;</td> </tr> <tr> <td>Женские куртка, пуловер, футболка</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Женские брюки, шорты</td> <td>6</td> <td>8</td> <td>10</td> <td>11</td> <td>12</td> <td>14</td> <td>16</td> <td>20</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-10-21" ["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-10-19 16:59:23" ["date_modified"]=> string(19) "2021-07-27 15:06:59" ["viewed"]=> string(3) "503" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "445" [3]=> string(3) "453" [4]=> string(3) "513" } [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 = '453' 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" } }