Женские брендовые сникеры

array(12) { [14047]=> array(49) { ["product_id"]=> string(5) "14047" ["name"]=> string(72) "Сникеры женские черные с логотипом No name" ["description"]=> string(741) "<p>Сникеры женские черные с логотипом No name подходят для того, чтобы носить их каждый день. Хорошо сочетается с разными предметами одежды. Шнуровка на 7 дырок. Модель на высокой плоской подошве. Замшевые вставки. Акцент - контрастные по цвету одежда и&nbsp; подошва.</p> <ul> </ul> <p>Если вас заинтересовала модель, купить сникеры женские черные с логотипом No name вы сможете в нашем магазине.</p> " ["characteristics"]=> string(760) "<ul> <li>Модель: женская повседневная спортивная обувь;</li> <li>Фасон: монохромные сникеры на высокой подошве;</li> <li>Цвет: черный;</li> <li>Материал верха: кожа 100%;</li> <li>Материал подкладки: кожа 100%;</li> <li>Подошва: резина;</li> <li>Утеплённые внутри, мех;</li> <li>Сезонность: осень-зима</li> <li>Производитель: No name (Ноу нейм);</li> <li>Производство: Франция.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(37) "Сникеры женские No name" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14047" ["sku"]=> string(10) "FNGHCU0415" ["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(39) "catalog/foto20-21predmetka/ao6b6741.jpg" ["manufacturer_id"]=> string(3) "100" ["manufacturer"]=> string(7) "NO NAME" ["manufacturer_size_table"]=> string(1161) "<table class="women"> <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>NO NAME</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) "5500.0000" ["special"]=> string(9) "2750.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-08" ["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) "50" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-11-30 10:26:45" ["viewed"]=> string(4) "1212" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" [3]=> string(3) "412" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14044]=> array(49) { ["product_id"]=> string(5) "14044" ["name"]=> string(65) "Сникеры женские бежевого цвета No name" ["description"]=> string(874) "<p>Сникеры женские бежевого цвета с декором No name на шнуровке. Удобная и стильная модель идеальна для повседневной носки. Комбинация разных материалов. Толстая резиновая подошва устойчива к влаге. Инновационная конструкция, удобная стелька, высококачественные дышащие материалы.</p> <ul style="list-style-type:disc"> </ul> <p>Заказать&nbsp;сникеры женские бежевого цвета с декором No name вы можете в нашем магазине. Удачных покупок!</p> <ul style="list-style-type:disc"> </ul> " ["characteristics"]=> string(761) "<ul style="list-style-type:disc"> <li>Модель: женские сникеры;</li> <li>Фасон: обувь на литой подошве;</li> <li>Цвет: бежевый, белый, коричневый;</li> <li>Узор: логотип производителя No name ;</li> <li>Верх: кожа, текстиль;</li> <li>Подкладка: текстиль;</li> <li>Подошва: резина;</li> <li>Сезонность: демисезонные;</li> <li>Бренд:&nbsp;No name (Ноу нейм);</li> <li>Страна бренда: Франция.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(37) "Сникеры женские No name" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14044" ["sku"]=> string(10) "FNGIP00402" ["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(39) "catalog/foto20-21predmetka/ao6b6654.jpg" ["manufacturer_id"]=> string(3) "100" ["manufacturer"]=> string(7) "NO NAME" ["manufacturer_size_table"]=> string(1161) "<table class="women"> <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>NO NAME</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) "4600.0000" ["special"]=> string(9) "2300.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-08" ["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) "49" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-11-30 10:27:00" ["viewed"]=> string(3) "987" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" [3]=> string(3) "412" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14045]=> array(49) { ["product_id"]=> string(5) "14045" ["name"]=> string(44) "Сникеры с логотипом No name" ["description"]=> string(646) "<p>Сникеры женские черного цвета с логотипом бренда No name из натуральной термостойкой кожи. Рифленый протектор против скольжения. Без перфорации. Металлические люверсы. Тип застежки - шнуровка. Невысокий подъем. Шерсть внутри.&nbsp;</p> <p>Заказать&nbsp;сникеры женские черного цвета с логотипом бренда No name вы можете в нашем магазине.&nbsp;</p> " ["characteristics"]=> string(779) "<ul style="list-style-type:disc"> <li>Модель: кожаные женские сникеры;</li> <li>Фасон: повседневная обувь;</li> <li>Цвет: черный;</li> <li>Узор: логотип бренда No name;</li> <li>Состав верха: кожа 100%;</li> <li>Подкладка: кожа 100%;</li> <li>Подошва: резина;</li> <li>Утеплённые внутри, мех;</li> <li>Сезонность: осень-зима;</li> <li>Бренд:&nbsp;No name (Ноу нейм);</li> <li>Страна бренда: Франция.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(37) "Сникеры женские No name" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Сникеры" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14045" ["sku"]=> string(10) "FNRMCU0415" ["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(39) "catalog/foto20-21predmetka/ao6b6632.jpg" ["manufacturer_id"]=> string(3) "100" ["manufacturer"]=> string(7) "NO NAME" ["manufacturer_size_table"]=> string(1161) "<table class="women"> <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>NO NAME</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) "4990.0000" ["special"]=> string(9) "2495.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-08" ["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) "48" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-09-18 13:36:49" ["date_modified"]=> string(19) "2021-11-30 10:27:19" ["viewed"]=> string(4) "1359" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13109]=> array(49) { ["product_id"]=> string(5) "13109" ["name"]=> string(63) "Сникеры женские черного цвета No name" ["description"]=> string(542) "<p>Эта <strong>летняя и повседневная версия</strong>, вдохновленная винтажными кроссовками, расширяет границы NO NAME! <strong>Подошва-платформа</strong>, заимствованная у культовых дизайнов бренда в стиле эспадрилий. Верх цвета <strong>синий &laquo;металлик&raquo; </strong>оживит любой наряд.</p> " ["characteristics"]=> string(662) "<ul style="list-style-type:disc"> <li>Код товара: 13109</li> <li>Артикул: ENDAPC0405</li> </ul> <ul> <li>Бренд: NO NAME</li> <li>Страна: Франция</li> <li>Модель: сникеры</li> <li>Цвет: темно-синий металлик</li> <li>Материал верха: текстиль</li> <li>Внутри: текстиль</li> <li>Стелька: текстиль</li> <li>Подошва: резина, высота 4 см</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Сникеры" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(186) "Туфли женские, текстильные, черного цвета, с шнурками, слипоны, кеды,купить, заказать No name, эспадрильи" ["model"]=> string(5) "13109" ["sku"]=> string(10) "ENDAPC0405" ["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(68) "catalog/dn8/fotosessija/2020/maj/obuv_1_etazh_pravki/_mg_1897-ds.jpg" ["manufacturer_id"]=> string(3) "100" ["manufacturer"]=> string(7) "NO NAME" ["manufacturer_size_table"]=> string(1161) "<table class="women"> <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>NO NAME</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) "3650.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-21 14:14:39" ["date_modified"]=> string(19) "2021-01-16 16:01:21" ["viewed"]=> string(4) "1015" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" [3]=> string(3) "412" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13107]=> array(49) { ["product_id"]=> string(5) "13107" ["name"]=> string(81) "Сникеры женские цвета хаки на платформе No Name" ["description"]=> string(445) "<p>Узнаваемая модель благодаря минималистическому дизайну и подошве на платформе. PLATO SNEAKER является классикой NO NAME с 1991 года.</p> <p>Верх - текстиль зеленого цвета. Платформа высотой 4 см. Эта пара кроссовок близка к оригиналу с 90-х.</p> " ["characteristics"]=> string(681) "<ul style="list-style-type:disc"> <li>Код товара: 13107</li> <li>Артикул: ENAA430441</li> </ul> <ul> <li>Бренд: NO NAME</li> <li>Страна: Франция</li> </ul> <ul> <li>Модель: сникеры</li> <li>Цвет: зеленый</li> <li>Материал верха: текстиль&nbsp;</li> <li>Всередине: текстиль</li> <li>Стелька: текстиль</li> <li>Подошва: резина, высота 4 см</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Сникеры" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(212) "Туфли женские, спортивные, текстильные, тканевые, хаки, слипоны, с шнурками, купить, на высокой подошве, No name, сникеры" ["model"]=> string(5) "13107" ["sku"]=> string(10) "ENAA430441" ["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/maj/obuv_1_etazh_pravki/_mg_1899-ds.jpg" ["manufacturer_id"]=> NULL ["manufacturer"]=> NULL ["manufacturer_size_table"]=> NULL ["price"]=> string(9) "3250.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-21 14:14:39" ["date_modified"]=> string(19) "2021-08-19 11:57:21" ["viewed"]=> string(3) "655" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" [3]=> string(3) "412" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13104]=> array(49) { ["product_id"]=> string(5) "13104" ["name"]=> string(59) "Сникеры женские цвета мокко No Name" ["description"]=> string(516) "<p>Обувь с изящными линиями, неподвластным времени стилем и усиленной боковой строчкой. ARCADE SNEAKER &ndash; это классическая модель сникеров.</p> <p>Кроссовки на плоской подошве NO NAME цвета мокко и анималистическим тиснением отлично подойдут к одежде в повседневном стиле.</p> " ["characteristics"]=> string(638) "<ul style="list-style-type:disc"> <li>Код товара: 13104</li> <li>Артикул: ENGB67042Q</li> </ul> <ul> <li>Бренд: NO NAME</li> <li>Страна: Франция</li> <li>Модель: сникеры</li> <li>Цвет: мокко</li> <li>Материал верха: замша&nbsp;</li> <li>Внутри: текстиль</li> <li>Стелька: текстиль</li> <li>Подошва: резина, высота 3 см</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Сникеры" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(166) "женские туфли, женская обувь, спортивные женские туфли, женские кеды, кожаные кеды, сникеры" ["model"]=> string(5) "13104" ["sku"]=> string(10) "ENGB67042Q" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "5" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(66) "catalog/dn8/fotosessija/2020/maj/obuv1etazh/no_name/engb67042q.jpg" ["manufacturer_id"]=> string(3) "100" ["manufacturer"]=> string(7) "NO NAME" ["manufacturer_size_table"]=> string(1161) "<table class="women"> <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>NO NAME</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) "3900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-21 14:14:39" ["date_modified"]=> string(19) "2021-01-16 15:55:29" ["viewed"]=> string(3) "678" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" [3]=> string(3) "412" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13114]=> array(49) { ["product_id"]=> string(5) "13114" ["name"]=> string(85) "Сникеры женские пудровые перфорированные No Name" ["description"]=> string(542) "<p>Обувь с изящными линиями, неподвластным времени стилем и усиленной боковой строчкой.</p> <p>ARCADE SNEAKER &ndash; это классическая модель сникеров. Кроссовки на плоской подошве NO NAME, розового цвета, изготовленные из перфорированной кожи, отлично подойдут к одежде в повседневном стиле.</p> " ["characteristics"]=> string(653) "<ul style="list-style-type:disc"> <li>Код товара: 13114</li> <li>Артикул: ENKCCU0402</li> </ul> <ul> <li>Бренд: NO NAME</li> <li>Страна: Франция</li> <li>Модель: сникеры</li> <li>Цвет: розовый</li> <li>Материал верха: перфорированная кожа</li> <li>Внутри: кожа</li> <li>Стелька: текстиль</li> <li>Подошва: резина, высота 3 см</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Сникеры" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(201) "Туфли, спортивные, женские, пудрового цвета, перфорированные, с шнурками, летние ,легкие, заказать,купить, No Name" ["model"]=> string(5) "13114" ["sku"]=> string(10) "ENKCCU0402" ["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(69) "catalog/dn8/fotosessija/2020/maj/obuv1etazh/no_name/enkccu0402(2).jpg" ["manufacturer_id"]=> string(3) "100" ["manufacturer"]=> string(7) "NO NAME" ["manufacturer_size_table"]=> string(1161) "<table class="women"> <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>NO NAME</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) "4860.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-21 14:14:39" ["date_modified"]=> string(19) "2021-01-16 16:14:29" ["viewed"]=> string(3) "568" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" [3]=> string(3) "412" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13102]=> array(49) { ["product_id"]=> string(5) "13102" ["name"]=> string(71) "Сникеры женские замшевые пудровые No Name" ["description"]=> string(530) "<p>Обувь с изящными линиями, неподвластным времени стилем и усиленной боковой строчкой. ARCADE SNEAKER &ndash; это классическая модель сникеров.</p> <p>Кроссовки на плоской подошве NO NAME пудрового цвета с перфорированной отделкой отлично подойдут к одежде в повседневном стиле.&nbsp;</p> " ["characteristics"]=> string(634) "<ul style="list-style-type:disc"> <li>Код товара: 13102</li> <li>Артикул: ENGBCV04UD</li> </ul> <ul> <li>Бренд: NO NAME</li> <li>Страна: Франция</li> <li>Модель: сникеры</li> <li>Цвет: пудровый</li> <li>Материал верха: замша</li> <li>Внутри: текстиль</li> <li>Стелька: текстиль</li> <li>Подошва: резина, высота 3 см</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Сникеры" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(223) "Туфли женские, спортивные, замшевые, пудрового цвета, купить, заказать, перфорированные, на шнурках, слипоны, No Name, сникеры" ["model"]=> string(5) "13102" ["sku"]=> string(10) "ENGBCV04UD" ["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(66) "catalog/dn8/fotosessija/2020/maj/obuv1etazh/no_name/engbcv04ud.jpg" ["manufacturer_id"]=> string(3) "100" ["manufacturer"]=> string(7) "NO NAME" ["manufacturer_size_table"]=> string(1161) "<table class="women"> <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>NO NAME</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) "4250.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-21 14:14:39" ["date_modified"]=> string(19) "2021-01-16 15:58:44" ["viewed"]=> string(3) "644" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" [3]=> string(3) "412" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13115]=> array(49) { ["product_id"]=> string(5) "13115" ["name"]=> string(74) "Сникеры женские желтые на платформе No Name" ["description"]=> string(615) "<p>Обувь с изящными линиями, неподвластным времени стилем и усиленной боковой строчкой.&nbsp;ARCADE SNEAKER &ndash; это&nbsp;<strong>классическая модель сникеров</strong>. Кроссовки на плоской подошве NO NAME&nbsp;<strong>лимонного цвета&nbsp;</strong>изготовленные из качественного текстиля, отлично дополнят одежду в повседневном стиле.</p> " ["characteristics"]=> string(640) "<ul style="list-style-type:disc"> <li>Код товара: 13115</li> <li>Артикул: ENKESF04C7</li> </ul> <ul> <li>Бренд: NO NAME</li> <li>Страна: Франция</li> <li>Модель: сникеры</li> <li>Цвет: лимонный</li> <li>Материал верха: текстиль</li> <li>Внутри: текстиль</li> <li>Стелька: текстиль</li> <li>Подошва: резина, высота 3 см</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Сникеры" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(241) "Туфли, спортивные, женские, желтого цвета, желтые, текстильные, на высокой подошве, с шнурками, летние, легкие, светлые, No Name, сникеры" ["model"]=> string(5) "13115" ["sku"]=> string(10) "ENKESF04C7" ["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(66) "catalog/dn8/fotosessija/2020/maj/obuv1etazh/no_name/enkesf04c7.jpg" ["manufacturer_id"]=> string(3) "100" ["manufacturer"]=> string(7) "NO NAME" ["manufacturer_size_table"]=> string(1161) "<table class="women"> <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>NO NAME</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) "3990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-21 14:14:39" ["date_modified"]=> string(19) "2021-01-16 15:51:38" ["viewed"]=> string(3) "627" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" [3]=> string(3) "412" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13118]=> array(49) { ["product_id"]=> string(5) "13118" ["name"]=> string(99) "Сникеры женские желтого цвета на высокой подошве No name " ["description"]=> string(516) "<p>SPICE SNEAKER &ndash; это новая версия культовой модели 1997 года. Вечный дизайн, сохранивший оригинальные черты линии: круглый носок, желтый кожаный верх и&nbsp;подошва-платформа толщиной 5 см. Подошва усилена боковой прошивкой&nbsp;для дополнительного комфорта и долговечности.</p> " ["characteristics"]=> string(633) "<ul style="list-style-type:disc"> <li>Код товара: 13118</li> <li>Артикул: ENTAZJ04HN</li> </ul> <ul> <li>Бренд: NO NAME</li> <li>Страна: Франция</li> <li>Модель: сникеры</li> <li>Цвет: желтый</li> <li>Материал верха: мягкая кожа</li> <li>Внутри: кожа</li> <li>Стелька: текстиль</li> <li>Подошва: резина, высота 5 см</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Сникеры" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(281) "спортивные туфли, спортивные туфли женские, спортивные туфли на танкетке, женские кроссовки, кроссовки на платформе, кроссовки на танкетке, кеды, сникеры" ["model"]=> string(5) "13118" ["sku"]=> string(10) "ENTAZJ04HN" ["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(66) "catalog/dn8/fotosessija/2020/maj/obuv1etazh/no_name/entazj04hn.jpg" ["manufacturer_id"]=> string(3) "100" ["manufacturer"]=> string(7) "NO NAME" ["manufacturer_size_table"]=> string(1161) "<table class="women"> <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>NO NAME</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) "5990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-21 14:14:39" ["date_modified"]=> string(19) "2021-08-19 11:59:29" ["viewed"]=> string(3) "822" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" [3]=> string(3) "412" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13108]=> array(49) { ["product_id"]=> string(5) "13108" ["name"]=> string(76) "Сникеры женские голубые на платформе No name" ["description"]=> string(441) "<p>Узнаваемая модель благодаря минималистичному дизайну и подошве на платформе. PLATO SNEAKER является классикой NO NAME с 1991 года. Верх &ndash; текстиль голубого цвета. Платформа высотой 4 см. Эта пара кроссовок близка к оригиналу из 90-х.&nbsp;</p> " ["characteristics"]=> string(648) "<ul style="list-style-type:disc"> <li>Код товара: 13108</li> <li>Артикул: ENACJN0403</li> </ul> <ul> <li>Бренд: NO NAME</li> <li>Страна: Франция</li> <li>Модель: сникеры</li> <li>Цвет: голубой</li> <li>Материал верха: текстиль&nbsp;</li> <li>Внутри: текстиль</li> <li>Стелька: текстиль</li> <li>Подошва: резина, высота 4 см</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Сникеры" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(177) "Туфли женские, джинсовые, на высокой подошве, с шнурками, купить, заказать, слипоны, No name, сникеры " ["model"]=> string(5) "13108" ["sku"]=> string(10) "ENACJN0403" ["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(66) "catalog/dn8/fotosessija/2020/maj/obuv1etazh/no_name/enacjn0403.jpg" ["manufacturer_id"]=> string(3) "100" ["manufacturer"]=> string(7) "NO NAME" ["manufacturer_size_table"]=> string(1161) "<table class="women"> <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>NO NAME</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) "3650.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-21 14:14:39" ["date_modified"]=> string(19) "2021-01-16 15:49:03" ["viewed"]=> string(3) "596" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" [3]=> string(3) "412" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13101]=> array(49) { ["product_id"]=> string(5) "13101" ["name"]=> string(74) "Сникеры женские белые с перфорацией No Name" ["description"]=> string(993) "<p>Кроссовки сдержанного дизайна. Тренд сезона. Обратите внимание на платформу - именно простота платформы NO NAME PLATO сделала бренд знаменитым. Благодаря узнаваемой ярко-белой обработке и фирменной подошве на платформе высотой 4 см вы сможете добавить сантиметров к росту.</p> <p>Удобные застежки-липучки позволяют обуться за считанные секунды. Перфорированная кожа имеет несколько особенностей - хорошо пропускает воздух и влияет на дизайн - добавляет обуви городского шика. Блестящая черная вставка на заднике завершает образ.</p> " ["characteristics"]=> string(690) "<ul style="list-style-type:disc"> <li>Код товара: 13101</li> <li>Артикул: ENAEP60401</li> </ul> <ul> <li>Бренд: NO NAME</li> <li>Страна: Франция</li> </ul> <ul> <li>Модель: сникеры</li> <li>Цвет: белый</li> <li>Материал верха: перфорированная кожа</li> <li>Всередине: текстиль</li> <li>Стелька: текстиль</li> <li>Подошва: резина, высота 4 см</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Сникеры" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(201) "Туфли спортивные, туфли женские, белого цвета, кожаные, на высокой подошве, на липучках, слипоны, No Name, сникеры" ["model"]=> string(5) "13101" ["sku"]=> string(10) "ENAEP60401" ["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(68) "catalog/dn8/fotosessija/2020/maj/obuv_1_etazh_pravki/_mg_1887-ds.jpg" ["manufacturer_id"]=> string(3) "100" ["manufacturer"]=> string(7) "NO NAME" ["manufacturer_size_table"]=> string(1161) "<table class="women"> <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>NO NAME</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) "4990.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-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) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-21 14:14:39" ["date_modified"]=> string(19) "2021-01-16 15:43:12" ["viewed"]=> string(3) "857" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "257" [3]=> string(3) "412" } [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 = '257' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }