Мужские туфли монки

array(4) { [8353]=> array(49) { ["product_id"]=> string(4) "8353" ["name"]=> string(66) "Монки с перфорацией коричневые Magnanni" ["description"]=> string(884) "<p>Сингл монки от Magnanni с медальоном одна из самых экстравагантных моделей. Характерная особенность модели&nbsp; &ndash; застежка на ремешок с пряжкой, которая позволяет гибко регулировать объем обуви.&nbsp;</p> <p>В модели использована кожа теленка классического коньячного цвета.&nbsp;Туфли украшены выборочным патинированием и&nbsp;&nbsp;перфорационным медальоном на носке.&nbsp;Монки коньячного цвета хорошо комбинируются с костюмами, блейзерами, чинос и джинсами.</p> " ["characteristics"]=> string(675) "<ul> <li>Код товара: 8353</li> <li>Артикул: 16028</li> <li>Бренд: Magnanni</li> <li>Страна: Испания</li> <li>Цвет: коньячный</li> <li>Сезон: вне сезона</li> <li>Внешний материал: кожа теленка</li> <li>Внутренний материал: кожа теленка &nbsp;</li> <li>Подошва: кожа/профилактика резина</li> <li>Стелька: кожа</li> <li>Стиль: casual</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Монки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(488) "модные мужские туфли, туфли мужские классические, стильная мужская обувь, кожаные туфли мужские, мужские туфли монки, мужская кожаная обувь, классические мужские туфли, мужские туфли классика, мужская обувь из натуральной кожи, туфли монки мужские, коричневые туфли," ["model"]=> string(4) "8353" ["sku"]=> string(5) "16028" ["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(55) "catalog/dn8/fotosessija/2020/maj/obuv_2_etazh/16028.jpg" ["manufacturer_id"]=> string(3) "113" ["manufacturer"]=> string(8) "Magnanni" ["manufacturer_size_table"]=> string(1137) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>39</td> <td>39.5</td> <td>40</td> <td>40.5</td> <td>41</td> <td>41.5</td> <td>42</td> <td>42.5</td> <td>43</td> <td>43.5</td> <td>44</td> <td>44.5</td> <td>45</td> <td>45,5</td> <td>примечание</td> </tr> <tr> <td>Magnanni</td> <td>39</td> <td>39.5</td> <td>40</td> <td>40.5</td> <td>41</td> <td>41.5</td> <td>42</td> <td>42.5</td> <td>43</td> <td>43.5</td> <td>44</td> <td>44.5</td> <td>45</td> <td>45,5</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "6500.0000" ["special"]=> string(9) "2600.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2021-06-22 12:38:04" ["viewed"]=> string(3) "798" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "155" [3]=> string(3) "306" [4]=> string(3) "519" } [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 = '306' 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" } [8235]=> array(49) { ["product_id"]=> string(4) "8235" ["name"]=> string(70) "Дабл монки с отрезным носком Fratelli Rossetti" ["description"]=> string(1032) "<p>Дабл монки с отрезным носком от Fratelli Rossetti&nbsp;- одна из самых экстравагантных моделей.</p> <p>Характерная особенность модели&nbsp; &ndash; застежка на парные ремешки с пряжками, которая позволяет гибко регулировать объем обуви.</p> <p>В модели использована мягкая зерненная кожа теленка синего цвета, окрашенная вручную.</p> <p>Модель предназначена для создания повседневных луков и оптимальна для ношения без носков.</p> <p>Дабл монки синего цвета хорошо комбинируются с&nbsp; укороченными моделями брюк или с брюками с манжетом.</p> " ["characteristics"]=> string(612) "<ul> <li>Код товара: 8235</li> <li>Артикул: 11541</li> <li>Бренд: Fratelli Rossetti</li> <li>Страна: Италия</li> <li>Цвет: синий</li> <li>Сезон: лето</li> <li>Внешний материал: кожа теленка</li> <li>Внутренний материал: кожа теленка</li> <li>Подошва: кожа теленка/профилактика</li> <li>Стиль: smart casual</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Монки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(201) "туфли мужские, стильные туфли, базовые туфли, туфли на каждый день, офисные туфли, туфли на работу, синие туфли" ["model"]=> string(4) "8235" ["sku"]=> string(5) "11541" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0176-ds.jpg" ["manufacturer_id"]=> string(2) "41" ["manufacturer"]=> string(17) "Fratelli Rossetti" ["manufacturer_size_table"]=> string(1057) "<table class="women"> <tbody> <tr> <td>Международный (INT)</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> </tr> <tr> <td>Fratelli Rossetti</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>41,5</td> </tr> </tbody> </table> " ["price"]=> string(10) "16800.0000" ["special"]=> string(9) "8400.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["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-10-19 16:59:23" ["date_modified"]=> string(19) "2021-08-12 16:12:11" ["viewed"]=> string(3) "352" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "155" [3]=> string(3) "306" [4]=> string(3) "519" } [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 = '306' 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" } [13750]=> array(49) { ["product_id"]=> string(5) "13750" ["name"]=> string(32) "Монки черные Magnanni" ["description"]=> string(819) "<p>Оригинальные монки от испанского бренда&nbsp;Magnanni. Выполнены из натуральной кожи, в сдержанном черном цвете. Акцент модели - в стильных декоративных ремешках по бокам, с застежками серебристого цвета. Монки имеюют декоративную перфорацию. В этой обуви вас просто нельзя будет не заметить, а в добавок к этому именно в ней вы будете чувствовать себя комфортно.</p> <p>Монки черные Magnanni на сайте&nbsp;https://dn8.ua/ можно прямо сейчас.&nbsp;</p> " ["characteristics"]=> string(465) "<ul> <li>Код товара:&nbsp;13750</li> <li>Артикул:&nbsp;21133</li> <li>Бренд:&nbsp;Magnanni</li> <li>Страна: Испания</li> <li>Цвет: черный</li> <li>Верх: кожа</li> <li>Подкладка: кожа&nbsp;</li> <li>Подошва: кожа&nbsp;/ резина</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(37) "/image/catalog/videoproduct/13750.mp4" ["meta_title"]=> string(34) "Туфли мужские Magnanni" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Монки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "13750" ["sku"]=> string(5) "21133" ["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(39) "catalog/foto20-21predmetka/ao6b6929.jpg" ["manufacturer_id"]=> string(3) "113" ["manufacturer"]=> string(8) "Magnanni" ["manufacturer_size_table"]=> string(1137) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>39</td> <td>39.5</td> <td>40</td> <td>40.5</td> <td>41</td> <td>41.5</td> <td>42</td> <td>42.5</td> <td>43</td> <td>43.5</td> <td>44</td> <td>44.5</td> <td>45</td> <td>45,5</td> <td>примечание</td> </tr> <tr> <td>Magnanni</td> <td>39</td> <td>39.5</td> <td>40</td> <td>40.5</td> <td>41</td> <td>41.5</td> <td>42</td> <td>42.5</td> <td>43</td> <td>43.5</td> <td>44</td> <td>44.5</td> <td>45</td> <td>45,5</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "12600.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-12" ["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-08-05 11:36:26" ["viewed"]=> string(3) "877" ["categories"]=> array(4) { [0]=> string(2) "71" [1]=> string(3) "155" [2]=> string(3) "306" [3]=> string(3) "519" } [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 = '306' 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" } [10892]=> array(49) { ["product_id"]=> string(5) "10892" ["name"]=> string(41) "Монки гранатовые Paradigma" ["description"]=> string(1455) "<p>Кожаные дабл монки&nbsp; Paradigma гранатового цвета.</p> <p>Модель дабл монки&nbsp; отличается застежкой на две пряжки. Отрезной мысок декорирован перфорационным узором по шву. Кожаная подошва дополнительно защищена&nbsp; резиновой подметкой.</p> <p>Монки сшиты из кожи теленка гранатового цвета.</p> <p>Обувь произведена в Португалии.</p> <p>Модель предназначена для образов в смарт кэжуал и кэжуал стилях. Самые выигрышные комбинации дабл монок&nbsp; Paradigma с &nbsp;блейзерами и неформальными костюмами, но может комбинироваться с кэжуал брюками, джинсами.</p> <p>Купить монки коричневые Paradigma в&nbsp;dn8 вы можете незамедлительно. Ну а если у вас остались вопросы - вы можете их прояснить у наших менеджеров: онлайн на сайте или по номеру тел&nbsp;+38(067)510-28-88.&nbsp;</p> " ["characteristics"]=> string(696) "<ul> <li>Код товара:&nbsp;10892</li> <li>Артикул: 6724</li> <li>Бренд:&nbsp;Paradigma</li> <li>Страна: Португалия</li> <li>Цвет: гранатовый</li> <li>Сезон: вне сезона</li> <li>Внешний материал: кожа теленка</li> <li>Внутренний материал: кожа&nbsp;теленка</li> <li>Стелька: кожа</li> <li>Подошва: кожа&nbsp;/ резина</li> <li>Стиль: casual, business</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(20) "Туфли Paradigma" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Монки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "10892" ["sku"]=> string(4) "6724" ["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(43) "data/1c/utp007133_catalog_test_img_7689.jpg" ["manufacturer_id"]=> string(3) "103" ["manufacturer"]=> string(9) "Paradigma" ["manufacturer_size_table"]=> string(933) "<table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>39</td> <td>39.5</td> <td>40</td> <td>40.5</td> <td>41</td> <td>41.5</td> <td>42</td> <td>42.5</td> <td>43</td> <td>43.5</td> <td>44</td> <td>44.5</td> </tr> <tr> <td>Paradigma</td> <td>39</td> <td>39.5</td> <td>40</td> <td>40.5</td> <td>41</td> <td>41.5</td> <td>42</td> <td>42.5</td> <td>43</td> <td>43.5</td> <td>44</td> <td>44.5</td> </tr> </tbody> </table> " ["price"]=> string(9) "6500.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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-10-19 16:59:23" ["date_modified"]=> string(19) "2021-08-05 11:38:30" ["viewed"]=> string(3) "817" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "155" [3]=> string(3) "306" [4]=> string(3) "519" } [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 = '306' 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" } }