Женские спортивные туфли

Сортировать:

Показывать:

array(4) { [14536]=> array(49) { ["product_id"]=> string(5) "14536" ["name"]=> string(75) "Туфли мужские спортивные серые Watson&Parker" ["description"]=> string(667) "<p>Любите спортивный стиль? Тогда&nbsp;мужские туфли от итальянского бренда&nbsp;Watson&amp;Parker - именно то, что вам нужно. Верх и подкладка выпоннены из натуральной кожи, подошва - резина. На шнурках. Анцент модели - темные&nbsp;вставки на носке и пятке.&nbsp;</p> <p>Купить туфли мужские спортивные серые Watson&amp;Parker на нашем сайте можно прямо сейчас.&nbsp;</p> " ["characteristics"]=> string(407) "<ul> <li>Код товара:&nbsp;14536</li> <li>Артикул:&nbsp;504569 - BL</li> <li>Бренд: Watson&amp;Parker</li> <li>Страна: Италия</li> <li>Верх: кожа</li> <li>Подкладка: кожа&nbsp;</li> <li>Подошва: резина</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(0) "" ["model"]=> string(5) "14536" ["sku"]=> string(11) "504569 - BL" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "7" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2021/mart/predmetka/img_0007-ds-1500px.jpg" ["manufacturer_id"]=> string(3) "111" ["manufacturer"]=> string(18) "Watsons&Parker" ["manufacturer_size_table"]=> string(2162) "<p>Женская обувь</p> <table class="men"> <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>41,5</td> </tr> <tr> <td>Watsons&amp;Parker</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> <p>Мужская обувь</p> <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> <td>45</td> </tr> <tr> <td>Watsons&amp;Parker</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> </tr> </tbody> </table> " ["price"]=> string(9) "8790.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2021-03-22" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2021-03-22 12:30:11" ["date_modified"]=> string(19) "2021-06-22 14:01:57" ["viewed"]=> string(3) "155" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "155" [3]=> string(3) "248" [4]=> string(3) "307" } [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 = '248' 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" } [11345]=> array(49) { ["product_id"]=> string(5) "11345" ["name"]=> string(71) "Туфли спортивные из кожи бежевые Nando Muzi" ["description"]=> string(495) "<p>Удобные бежевые туфли Nando Muzi в спортивном стиле. Выполнены из натуральной кожи. На шнурке, сбоку декорированы&nbsp;узором. Задник&nbsp;украшен&nbsp;золотистой нашивкой с надписью бренда. Данная модель станет прекрасным дополением к вашему ежедневному образу.</p> " ["characteristics"]=> string(578) "<ul> <li>Модель: спортивные туфли;</li> <li>Цвет: бежевый, светло-бежевый;</li> <li>Узор: есть;</li> <li>Состав: верх - кожа 100%; подкладка - кожа 100%;</li> <li>Подошва: резина;</li> <li>Сезонность: весна-лето;</li> <li>Бренд: Nando Muzi;</li> <li>Страна бренда: Италия.</li> </ul> <p>&nbsp;</p> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(21) "Туфли Nando Muzi" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11345" ["sku"]=> string(12) "A167F67 A365" ["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(51) "data/1c/utp007866_catalog_loading_obyv_img_8895.jpg" ["manufacturer_id"]=> string(2) "20" ["manufacturer"]=> string(10) "Nando Muzi" ["manufacturer_size_table"]=> string(1169) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</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> </tr> <tr> <td>Nando Muzi</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> </tr> </tbody> </table> " ["price"]=> string(9) "9200.0000" ["special"]=> string(9) "4600.0000" ["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) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-05-31 15:25:18" ["viewed"]=> string(3) "981" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "248" } [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 = '248' 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" } [11342]=> array(49) { ["product_id"]=> string(5) "11342" ["name"]=> string(84) "Туфли спортивные из замши с перфорацией Nando Muzi" ["description"]=> string(733) "<p>Спортивная обувь может быть не только удобной, но и красивой. Данная модель &ndash; яркое подтверждение этих слов. Замшевые туфли от итальянского бренда Nando Muzi&nbsp;выполнены из натуральной замши. Лицевая часть фиксируется шнурком, на котором размещен серебристый элемент, сбоку декорированы&nbsp;мелкой перфорацией. Задняя часть&nbsp;украшена&nbsp;серебристой нашивкой с надписью бренда.</p> " ["characteristics"]=> string(565) "<ul> <li>Модель: спортивные туфли;</li> <li>Цвет: фиолетовый, белый;</li> <li>Узор: нет;</li> <li>Состав: верх - кожа 100%; подкладка - кожа 100%;</li> <li>Подошва: резина;</li> <li>Сезонность: весна-лето;</li> <li>Бренд: Nando Muzi;</li> <li>Страна бренда: Италия.</li> </ul> <p>&nbsp;</p> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(42) "Туфли спортивные Nando Muzi" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11342" ["sku"]=> string(11) "A156F67 091" ["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(51) "data/1c/utp007863_catalog_loading_obyv_img_8884.jpg" ["manufacturer_id"]=> string(2) "20" ["manufacturer"]=> string(10) "Nando Muzi" ["manufacturer_size_table"]=> string(1169) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</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> </tr> <tr> <td>Nando Muzi</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> </tr> </tbody> </table> " ["price"]=> string(10) "10300.0000" ["special"]=> string(9) "5150.0000" ["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) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-05-31 15:25:52" ["viewed"]=> string(3) "832" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "248" } [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 = '248' 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" } [11340]=> array(49) { ["product_id"]=> string(5) "11340" ["name"]=> string(58) "Туфли спортивные из замши Nando Muzi" ["description"]=> string(692) "<p>Стильные туфли&nbsp;Nando Muzi&nbsp;бежевого цвета на белой танкетке выполнены из натуральной кожи. Носочек круглой формы, задняя часть декорирована серебристой нашивкой с надписью бренда. Акцент данной модели - наличие вшитых боковых резинок. Эти туфли станут прекрасным дополнением к ежедневному образу тех женщин, которые всегда в движении и&nbsp;любят комфорт.&nbsp;</p> " ["characteristics"]=> string(592) "<ul> <li>Модель: спортивные туфли;</li> <li>Цвет: бежевый, белый;</li> <li>Узор: нет;</li> <li>Состав: верх - кожа 100%; подкладка - кожа 100%;</li> <li>Подошва: резина;</li> <li>Сезонность: весна-лето;</li> <li>Бренд: Nando Muzi;</li> <li>Страна бренда: Италия.</li> </ul> <p>&nbsp;</p> <p>&nbsp;</p> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(42) "Туфли спортивные Nando Muzi" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11340" ["sku"]=> string(7) "A150F67" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "9" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(53) "data/1c/utp007861_catalog_obuvmaj_img_1126_kopiya.jpg" ["manufacturer_id"]=> string(2) "20" ["manufacturer"]=> string(10) "Nando Muzi" ["manufacturer_size_table"]=> string(1169) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</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> </tr> <tr> <td>Nando Muzi</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> </tr> </tbody> </table> " ["price"]=> string(9) "7400.0000" ["special"]=> string(9) "3700.0000" ["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) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-05-31 15:17:25" ["viewed"]=> string(3) "871" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "248" } [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 = '248' 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" } }

Туфли мужские спортивные серые Watson&Parker

8 790 грн.
Любите спортивный стиль? Тогда мужские туфли от итальянского бренда Watson&Parker - им..
-50%
Туфли спортивные из кожи бежевые Nando Muzi

Туфли спортивные из кожи бежевые Nando Muzi

9 200 грн.

4 600 грн.

Удобные бежевые туфли Nando Muzi в спортивном стиле. Выполнены из натуральной кожи. На шнурке, сбоку..
-50%
Туфли спортивные из замши с перфорацией Nando Muzi

Туфли спортивные из замши с перфорацией Nando Muzi

10 300 грн.

5 150 грн.

Спортивная обувь может быть не только удобной, но и красивой. Данная модель – яркое подтвержде..
-50%
Туфли спортивные из замши Nando Muzi

Туфли спортивные из замши Nando Muzi

7 400 грн.

3 700 грн.

Стильные туфли Nando Muzi бежевого цвета на белой танкетке выполнены из натуральной кожи. ..
Показано с 1 по 4 из 4 (всего 1 страниц)