Ambitious

array(12) { [16550]=> array(49) { ["product_id"]=> string(5) "16550" ["name"]=> string(50) "Сникеры серые мужские Ambitious" ["description"]=> string(504) "<p>Кроссовки Ambitious созданы в спортивном ретро-стиле &ndash; замша в комбинации с перфорированным текстилем для воздухопроницаемости.&nbsp;</p> <p>Заказывайте скикеры серые мужские Ambitious на нашем сайте прямо сейчас. DN8: с нами покупки делать просто и приятно!&nbsp;</p> " ["characteristics"]=> string(563) "<ul> <li>Код товара: 16550</li> <li>Артикул: 10289А-1809АМ</li> <li>Бренд: Ambitious</li> <li>Страна: Португалия</li> <li>Цвет: серый/черный</li> <li>Модель: кроссовки</li> <li>Материал верха: кожа, замша, текстиль</li> <li>Материал внутри: текстиль</li> <li>Подовшва: резина</li> </ul> " ["color"]=> string(7) "#800000" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(15) "Сникеры " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(98) "Кроссовки, мужские, серые, Ambitious, кожа, замша, текстиль " ["model"]=> string(5) "16550" ["sku"]=> string(13) "10289A-1809AM" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0071-ds.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4500.0000" ["special"]=> NULL ["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-08-07 10:44:34" ["date_modified"]=> string(19) "2021-08-03 15:42:59" ["viewed"]=> string(3) "364" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "151" [3]=> string(3) "482" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16548]=> array(49) { ["product_id"]=> string(5) "16548" ["name"]=> string(62) "Сникеры мужские трехцветные Ambitious" ["description"]=> string(478) "<p>Кроссовки Ambitious созданы в спортивном ретро-стиле &ndash; замша в комбинации с перфорированным текстилем для воздухопроницаемости. В этой паре установлена резинка на пятке для дополнительного фиксирования стопы.</p> <p>Удачных покупок в&nbsp;DN8!</p> " ["characteristics"]=> string(579) "<ul> <li>Код товара: 16548</li> <li>Артикул: 10289-1380АМ.1</li> <li>Бренд: Ambitious</li> <li>Страна: Португалия</li> <li>Цвет: серый/черный/хаки/белый</li> <li>Модель: сникеры</li> <li>Материал верха: кожа, замша, текстиль</li> <li>Материал внутри: текстиль</li> <li>Подовшва: резина</li> </ul> " ["color"]=> string(7) "#000000" ["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(100) "Кроссовки, мужские, из кожи, кожа, текстиль, замша, Ambitious" ["model"]=> string(5) "16548" ["sku"]=> string(14) "10289-1380AM.1" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0074-ds.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4500.0000" ["special"]=> NULL ["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-08-07 10:34:37" ["date_modified"]=> string(19) "2021-08-03 15:43:28" ["viewed"]=> string(3) "290" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "151" [3]=> string(3) "482" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16546]=> array(49) { ["product_id"]=> string(5) "16546" ["name"]=> string(50) "Сникеры белые кожаные Ambitious" ["description"]=> string(561) "<p>Белые классические сникеры с темно-синей кожаной деталью на пятке. Они просто обязательны в современном гардеробе.</p> <p>Заказать сникеры белые кожаные Ambitious на нашем сайте вы можете прямо сейчас, и уже в ближайшее время они будут радовать вас и окружающих.&nbsp;DN8: мы любим наших клиентов!</p> " ["characteristics"]=> string(520) "<ul> <li>Код товара: 16546</li> <li>Артикул: 10634-4838АМ.1</li> <li>Бренд: Ambitious</li> <li>Страна: Португалия</li> <li>Цвет: белый</li> <li>Модель: кроссовки</li> <li>Материал верха: кожа</li> <li>Материал внутри: текстиль</li> <li>Подовшва: резина</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(145) "Кроссовки, мужские, белые, на шнурках, Ambitious, повседневные, шнурки, кожа, кожаные " ["model"]=> string(5) "16546" ["sku"]=> string(14) "10634-4838AM.1" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0044-ds.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4500.0000" ["special"]=> NULL ["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-08-07 10:34:37" ["date_modified"]=> string(19) "2021-08-03 15:44:25" ["viewed"]=> string(3) "395" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "151" [3]=> string(3) "482" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16544]=> array(49) { ["product_id"]=> string(5) "16544" ["name"]=> string(57) "Кроссовки черные кожаные Ambitious " ["description"]=> string(652) "<p>Эта амбициозная пара &ndash; ответ на тренд японской уличной моды. Она изготовлена из кожи с замшевыми и текстильными вставками. Контрастная белая подошва с гравированными деталями и акцентом цвета электрик на пятке делают эти кроссовки неповторимыми.</p> <p>Заказать кроссовки черные кожаные Ambitious можно на нашем сайте прямо сейчас.&nbsp;</p> " ["characteristics"]=> string(564) "<ul> <li>Код товара: 16544</li> <li>Артикул: 10339А-1321-АМ</li> <li>Бренд: Ambitious</li> <li>Страна: Португалия</li> <li>Цвет: черный/синий</li> <li>Модель: кроссовки</li> <li>Материал верха: замша, кожа, текстиль</li> <li>Материал внутри: текстиль</li> <li>Подовшва: резина</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(19) "Кроссовки " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(135) "Кроссовки, мужские, черные, кожа, замша, текстиль, Ambitious, спортивная, обувь " ["model"]=> string(5) "16544" ["sku"]=> string(13) "10339A-1321AM" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0064-ds.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4400.0000" ["special"]=> NULL ["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-08-07 10:34:37" ["date_modified"]=> string(19) "2021-06-23 15:17:34" ["viewed"]=> string(3) "616" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "149" [3]=> string(3) "482" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16519]=> array(49) { ["product_id"]=> string(5) "16519" ["name"]=> string(51) "Кроссовки трехцветные Ambitious" ["description"]=> string(490) "<p>Эти кроссовки Ambitious созданы с заботой о комфорте. У них есть мягкие воздушные баллоны на подошве, а верх кроссовок выполнен в контрастном сочетании цветов.</p> <p>Понравились кроссовки трехцветные Ambitious? Тогда заказывайте их в Dn8 незамедлительно.&nbsp;</p> " ["characteristics"]=> string(560) "<ul> <li>Код товара: 16519</li> <li>Артикул: 10474-3918АМ</li> <li>Бренд: Ambitious</li> <li>Страна: Португалия</li> <li>Цвет: белый/желтый/хаки</li> <li>Модель: кроссовки</li> <li>Материал верха: замша, текстиль</li> <li>Материал внутри: текстиль</li> <li>Подовшва: резина</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Кроссовки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(142) "Кроссовки, мужские, разноцветные, с высоким задником, Ambitious, спортивная, обувь " ["model"]=> string(5) "16519" ["sku"]=> string(12) "10474-3918AM" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0057-ds.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4700.0000" ["special"]=> NULL ["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-08-07 10:34:37" ["date_modified"]=> string(19) "2021-06-23 15:21:39" ["viewed"]=> string(3) "756" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "149" [3]=> string(3) "482" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16547]=> array(49) { ["product_id"]=> string(5) "16547" ["name"]=> string(52) "Кроссовки с символикой Ambitious" ["description"]=> string(630) "<p>Эта пара кроссовок Ambitious &ndash; сочетание спортивного и элегантного стиля с изюминкой благодаря сочетанию черного и желтого цветов.</p> <p>Понравились кроссовки с символикой Ambitious? Возникли вопросы по поводу размера или достувки? Согласуйте все ответы у наших менеджеров по тел&nbsp;+38(067)510-28-88 или на сайте в режиме онлайн.&nbsp;</p> " ["characteristics"]=> string(576) "<ul> <li>Код товара: 16547</li> <li>Артикул: 9849А-1607АМ</li> <li>Бренд: Ambitious</li> <li>Страна: Португалия</li> <li>Цвет: черный, желтый/серый</li> <li>Модель: кроссовки</li> <li>Материал верха: кожа, замша, текстиль</li> <li>Материал внутри: текстиль</li> <li>Подовшва: резина</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Кроссовки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(155) "Кроссовки, мужские, кожа, замша, текстиль, Ambitious, кожаные, замшевые, текстильные, спорт" ["model"]=> string(5) "16547" ["sku"]=> string(12) "9849A-1607AM" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0092-ds.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4500.0000" ["special"]=> NULL ["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-08-07 10:34:37" ["date_modified"]=> string(19) "2021-06-23 15:25:00" ["viewed"]=> string(3) "549" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "149" [3]=> string(3) "482" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16545]=> array(49) { ["product_id"]=> string(5) "16545" ["name"]=> string(66) "Кроссовки мужские кожа и замша Ambitious" ["description"]=> string(488) "<p>Кроссовки на толстой рельефной резиновой подошве, массивные и стильные. Белый цвет гармонирует с глубокими серыми, темно-синими и желтыми тонами. Носите с повседневными или официальными образами.</p> <p>DN8: выбор тех, кто&nbsp;любит красоту и комфорт!</p> " ["characteristics"]=> string(594) "<ul> <li>Код товара: 16545</li> <li>Артикул: 10487-1755АМ</li> <li>Бренд: Ambitious</li> <li>Страна: Португалия</li> <li>Цвет: белый/желтый/серый/темно-синий</li> <li>Модель: кроссовки</li> <li>Материал верха: замша, кожа, текстиль</li> <li>Материал внутри: текстиль</li> <li>Подовшва: резина</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Кроссовки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(114) "Кроссовки, мужские, кожа, замша, Ambitious, спорт, спортивная, обувь " ["model"]=> string(5) "16545" ["sku"]=> string(12) "10487-1755AM" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0062-ds.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4700.0000" ["special"]=> NULL ["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-08-07 10:34:37" ["date_modified"]=> string(19) "2021-06-23 15:36:30" ["viewed"]=> string(3) "475" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "149" [3]=> string(3) "482" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16520]=> array(49) { ["product_id"]=> string(5) "16520" ["name"]=> string(63) "Кроссовки белые со вставками Ambitious" ["description"]=> string(622) "<p>Массивная форма и яркие контрастные цвета делают эту пару неповторимой. Изготовленные из кожи с акцентированными замшевыми вставками, они выглядят стильно и легко улучшат любой образ.</p> <p>Если вам понравились кроссовки белые со вставками Ambitious, заказывайте их на нашем сайте прямо сейчас.&nbsp;Удачных покупок в&nbsp;DN8!</p> " ["characteristics"]=> string(584) "<ul> <li>Код товара: 16520</li> <li>Артикул: 10452-4838АМ</li> <li>Бренд: Ambitious</li> <li>Страна: Португалия</li> <li>Цвет: белый/голубой/коричневый</li> <li>Модель: кроссовки</li> <li>Материал верха: кожа, замша, текстиль</li> <li>Материал внутри: текстиль</li> <li>Подовшва: резина</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Кроссовки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(160) "Кроссовки, мужские, с завышенной подошвой, Ambitious, спортивная, обувь, белые, разноцветные " ["model"]=> string(5) "16520" ["sku"]=> string(12) "10452-4838AM" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskaja_obuv/0054-ds.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4960.0000" ["special"]=> NULL ["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-08-07 10:34:37" ["date_modified"]=> string(19) "2021-06-23 15:43:39" ["viewed"]=> string(4) "1196" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "149" [3]=> string(3) "482" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15204]=> array(49) { ["product_id"]=> string(5) "15204" ["name"]=> string(59) "Лоферы из коричневой замши Ambitious" ["description"]=> string(765) "<p>Туфли мужские из коричневой замши Ambitious удобные в носке и подходят для любого лука. Верх замша. Дизайн напоминает пенни-лоферы (с пряжкой), высокая подошва придает образу неформальный шик.&nbsp;</p> <ul style="list-style-type:disc"> </ul> <p>Если вас заинтересовала модель, купить&nbsp;туфли мужские из коричневой замши Ambitious можно а нашем магазине, оформив заказ через сайт или по телефону. Удачных покупок!</p> " ["characteristics"]=> string(756) "<ul style="list-style-type:disc"> <li>Модель: летняя мужская обувь;</li> <li>Фасон: эспадрильи на высокой подошве;</li> <li>Цвет: коричневый (цвет молочный шоколад);</li> <li>Узор: нет;</li> <li>Состав верха: кожа 100%;</li> <li>Подкладка: кожа 100%;</li> <li>Подошва: резина;</li> <li>Сезонность: весна-лето;</li> <li>Бренд:&nbsp;Ambitious (Амбишез);</li> <li>Страна бренда: Португалия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Лоферы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15204" ["sku"]=> string(14) "8487A-1602AM.1" ["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(40) "catalog/predmetka_ijun_2019/ao6b5281.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "3700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-08-03 12:03:05" ["viewed"]=> string(4) "1006" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "150" [3]=> string(3) "155" [4]=> string(3) "483" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15201]=> array(49) { ["product_id"]=> string(5) "15201" ["name"]=> string(54) "Кроссовки черного цвета Ambitious" ["description"]=> string(1002) "<p>Туфли спортивные мужские черного цвета из натуральной кожи Ambitious - стильная и удобная обувь на каждый день. Высококачественная кожа хорошо держит форму, прочная и эластичная в носке. Шнуровка сверху надежно фиксирует стопу. Широкая резиновая подошва обеспечивает надежное сцепление с любыми видами поверхности. слитый язычок предотвращает попадание грязи внутри и натирание.&nbsp;</p> <p>Заказать&nbsp;туфли спортивные мужские черного цвета из натуральной кожи Ambitious вы можете в нашем магазине, оформив удобным для вас способом.</p> " ["characteristics"]=> string(768) "<ul style="list-style-type:disc"> <li>Модель: мужские спортивные туфли;</li> <li>Фасон: мужские повседневные кроссовки,&nbsp;ugly sneakers;</li> <li>Цвет: черный, белый;</li> <li>Узор: символика Ambitious;</li> <li>Состав: кожа 100%;</li> <li>Подкладка: кожа 100%;</li> <li>Подошва: резина;</li> <li>Сезонность: демисезонные;</li> <li>Бренд:&nbsp;Ambitious (Амбищез);</li> <li>Страна бренда: Португалия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15201" ["sku"]=> string(18) "8894/9676-3511AM.4" ["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(40) "catalog/predmetka_ijun_2019/ao6b5303.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4200.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-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(5) ["reviews"]=> string(1) "1" ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-07-23 15:29:52" ["viewed"]=> string(4) "1069" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "149" [3]=> string(3) "482" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15198]=> array(49) { ["product_id"]=> string(5) "15198" ["name"]=> string(51) "Кроссовки трехцветные Ambitious" ["description"]=> string(1096) "<p>Туфли спортивные мужские оранжевого цвета с серыми вставками Ambitious декорированы стилистикой бренда. Верх из ткани и высококачественной кожи обеспечивает легкий вес и циркуляцию воздуха. Шнуровка сверху максимально фиксирует стопу. Продуманный супинатор равномерно распределяет нагрузку на ступню. Толстая резиновая подошва с мощным протектором для лучшего сцепления с поверхностью.&nbsp;</p> <p>Если вас заинтересовала модель, купить&nbsp;туфли спортивные мужские оранжевого цвета с серыми вставками Ambitious вы сможете в нашем магазине.&nbsp;</p> <ul style="list-style-type:disc"> </ul> " ["characteristics"]=> string(737) "<ul style="list-style-type:disc"> <li>Модель: мужские спортивные туфли;</li> <li>Фасон: повседневные кроссовки;</li> <li>Цвет: оранжевый, серый, черный;</li> <li>Узор: стилистика бренда;</li> <li>Состав: верх - кожа 100%; подкладка - кожа 100%; подошва - резина;</li> <li>Сезонность: весна-лето-осень;</li> <li>Бренд:&nbsp;Ambitious (Амбишиз);</li> <li>Страна бренда: Португалия.&nbsp;</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Кроссовки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15198" ["sku"]=> string(11) "8879-3499AM" ["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(40) "catalog/predmetka_ijun_2019/ao6b5163.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-07-23 15:30:56" ["viewed"]=> string(3) "998" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "149" [3]=> string(3) "482" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15203]=> array(49) { ["product_id"]=> string(5) "15203" ["name"]=> string(63) "Кроссовки темно-синего цвета Ambitious" ["description"]=> string(934) "<div>Туфли спортивные мужские темно-синего цвета с надписью Ambitious - стильное завершение неформального образа. Верхняя часть изготовлена из высококачественной кожи, что хорошо держит форму. Сеточная часть гарантирует легкий вес и отличную воздухопроницаемость. Шнуровка спереди. Мощный протектор для надежного сцепления с поверхностью.</div> <div>&nbsp;</div> <div>Если вас заинтересовала модель, купить туфли спортивные мужские темно-синего цвета с надписью Ambitious вы сможете в нашем магазине.</div> " ["characteristics"]=> string(700) "<ul> <li>Модель: мужские спортивные туфли;</li> <li>Фасон: ugly shoes, ugly-sneakers;</li> <li>Цвет: темно-синий, белый;</li> <li>Узор: стилистика бренда;</li> <li>Материал: кожа 100%;</li> <li>Состав подкладки: кожа 100%;</li> <li>Подошва: резина;</li> <li>Сезонность: весна-лето-осень;</li> <li>Бренд: Ambitious (Амбишез);</li> <li>Страна бренда: Португалия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(18) "Кроссовки" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15203" ["sku"]=> string(11) "9509-1320AM" ["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(40) "catalog/predmetka_ijun_2019/ao6b5179.jpg" ["manufacturer_id"]=> string(2) "70" ["manufacturer"]=> string(9) "Ambitious" ["manufacturer_size_table"]=> string(1144) "<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>Ambitious</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>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4300.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-07-23 15:31:53" ["viewed"]=> string(3) "674" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "71" [2]=> string(3) "149" [3]=> string(3) "482" } [0]=> string(1982) "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 p 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 p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }