Женские туфли на каблуке

array(12) { [16720]=> array(49) { ["product_id"]=> string(5) "16720" ["name"]=> string(92) "Туфли женские фиолетовые кожаные на каблуке The Seller" ["description"]=> string(375) "<p>Женские туфли из натуральной кожи нубук в тёмно-синем цвете. Модель выполнена из перфорированного нубука, имеет декор мелкие заклёпки, зауженный носок и V-вырез.</p> <p>Высота каблука 7,5 см.</p> " ["characteristics"]=> string(509) "<ul> <li>Код товара: 16720</li> <li>Артикул: S8878</li> <li>Бренд: The Seller&nbsp;</li> <li>Страна: Италия</li> <li>Цвет: темно-синий</li> <li>Модель: туфли</li> <li>Материал: верх - кожа 100%, подкладка - кожа 100%, подошва - кожа</li> <li>Стиль:&nbsp;casual</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(215) "туфли женские, туфли на тонком каблуке, красивые туфли, туфли с острым носком, туфли на среднем каблуке, туфли на выход" ["model"]=> string(5) "16720" ["sku"]=> string(5) "S8878" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "7" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskaja_obuv/0562-ds.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1050) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>The Seller</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(9) "7980.0000" ["special"]=> string(9) "5586.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-11-08 09:24:34" ["viewed"]=> string(3) "846" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "247" [4]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16732]=> array(49) { ["product_id"]=> string(5) "16732" ["name"]=> string(83) "Туфли женские оливковые кожаные с бантом Pollini" ["description"]=> string(328) "<p>Туфли женские в оливковом цвете. Модель выполнена из жатой лакированной кожи, имеет декор бант с лого бренда, зауженный носок и V-вырез.</p> <p>Высота каблука 10,5 см.</p> " ["characteristics"]=> string(528) "<ul> <li>Код товара: 16732</li> <li>Артикул: SA10388C0A807</li> <li>Бренд: Pollini</li> <li>Страна: Италия</li> <li>Цвет: оливковый</li> <li>Модель: туфли&nbsp;</li> <li>Материал: верх - кожа 100%, подкладка -&nbsp;кожа 100%, подошва - кожа</li> <li>Стиль:&nbsp;деловой</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(187) "туфли женские, туфли на тонком каблуке, красивые туфли, туфли с острым носком, туфли на среднем каблуке" ["model"]=> string(5) "16732" ["sku"]=> string(13) "SA10388C0A807" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskaja_obuv/0550-ds.jpg" ["manufacturer_id"]=> string(3) "155" ["manufacturer"]=> string(7) "Pollini" ["manufacturer_size_table"]=> string(1195) "<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>Pollini</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>35</td> <td>&nbsp;</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>&nbsp;</td> <td>41</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "11500.0000" ["special"]=> string(9) "8050.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-11-08 09:25:01" ["viewed"]=> string(4) "1319" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "247" [4]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16733]=> array(49) { ["product_id"]=> string(5) "16733" ["name"]=> string(99) "Туфли женские на среднем каблуке кожаные с бантом Pollini" ["description"]=> string(358) "<p>Туфли женские в голубом цвете. Модель выполнена из лакированной кожи, имеет чёрно-бежевый эластичный ремешок на подъёме с лого бренда, зауженный носок.</p> <p>Высота каблука 5,5 см.</p> " ["characteristics"]=> string(574) "<ul> <li>Код товара: 16733</li> <li>Артикул: SA10415C0A712</li> <li>Бренд: Pollini</li> <li>Страна: Италия</li> <li>Цвет: голубой</li> <li>Модель: туфли</li> <li>Материал: верх - кожа 100%, вставка - вискоза, эластан, полиэстер, подкладка -&nbsp;кожа 100%, подошва - кожа</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(187) "туфли женские, туфли на тонком каблуке, красивые туфли, туфли с острым носком, туфли на среднем каблуке" ["model"]=> string(5) "16733" ["sku"]=> string(13) "SA10415C0A712" ["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(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskaja_obuv/0574-ds.jpg" ["manufacturer_id"]=> string(3) "155" ["manufacturer"]=> string(7) "Pollini" ["manufacturer_size_table"]=> string(1195) "<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>Pollini</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>35</td> <td>&nbsp;</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>&nbsp;</td> <td>41</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "11700.0000" ["special"]=> string(9) "8190.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-11-08 09:25:29" ["viewed"]=> string(3) "992" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "247" [4]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11384]=> array(49) { ["product_id"]=> string(5) "11384" ["name"]=> string(68) "Туфли женские черные с пряжкой Luis Onofre" ["description"]=> string(942) "<p>Черные женские туфли на каблуке в классическом стиле выглядят элегантно. Акцент - носок декорирован металлической лентой, состоящих из мелких цепочек. Высокий тонкий каблук-шпилька 7,5 см.&nbsp;Универсальный цвет обуви позволяет легко подбирать и сочетать одежду с туфлями лодочками.&nbsp;</p> <p>Подходят для офиса с нестрогим дресс-кодом, праздничного мероприятия или романтического ужина.&nbsp;Удачно женская туфли на каблуке будут смотреться смотреться с платьями, блузами и юбками.&nbsp;&nbsp;</p> " ["characteristics"]=> string(773) "<ul style="list-style-type:disc"> <li>Код товара: 11384&nbsp;</li> <li>Артикул: UK 3457&nbsp;</li> </ul> <ul> <li>Бренд: Luis Onofre&nbsp;</li> <li>Страна:&nbsp;Португалия&nbsp;</li> </ul> <ul> <li>Цвет: черный</li> <li>Сезон: весна-лето</li> <li>Внешний материал: кожа</li> <li>Внутренний материал: кожа</li> <li>Подошва: кожа</li> <li>Стелька: кожа&nbsp;</li> <li>Стиль:&nbsp;классика</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(241) "Туфли женские, туфли на каблуке, туфли лодочки, туфли с высоким каблуком, туфли на высоком каблуке, кожаные туфли, Luis Onofre, Луис Онофре" ["model"]=> string(5) "11384" ["sku"]=> string(7) "UK 3457" ["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(61) "catalog/dn8/fotosessija/2020/maj/obuv_4_etazh/_mg_1698(2).jpg" ["manufacturer_id"]=> string(2) "96" ["manufacturer"]=> string(11) "Luis Onofre" ["manufacturer_size_table"]=> string(633) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> </tr> <tr> <td>Luis Onofre</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> </tr> </tbody> </table> " ["price"]=> string(9) "9600.0000" ["special"]=> string(9) "4800.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-18" ["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(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-12-24 12:45:06" ["viewed"]=> string(3) "955" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "247" [4]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15150]=> array(49) { ["product_id"]=> string(5) "15150" ["name"]=> string(85) "Туфли лодочки женские с открытой пяткой The Seller" ["description"]=> string(1069) "<p>Туфли на невысоком каблуке женские черного цвета с открытой пяткой и закрытым носком The Seller - элегантная модель, которая подходят как для офисной капсулы, так и для вечернего выхода. Тонкий каблук средней высоты слегка расширяется книзу. Узкий острый носок. Фиксируется на ноге за счет тонкого ремешка. Ширину можно регулировать и подбирать под полноту ноги.&nbsp;</p> <ul style="list-style-type:disc"> </ul> <p>Заказать&nbsp;сандалии женские черного цвета с открытой пяткой и закрытым носком The Seller вы сможете в нашем магазине, оформив заказ удобным для вас способом.&nbsp;</p> " ["characteristics"]=> string(659) "<ul style="list-style-type:disc"> <li>Модель: туфли на невысоком каблуке;</li> <li>Фасон: закрытые босоножки на каблуке-рюмке;</li> <li>Цвет: черный;</li> <li>Узор: нет;</li> <li>Состав: кожа 100%;</li> <li>Подошва: кожа, резина;</li> <li>Сезонность: весна-лето;</li> <li>Бренд:&nbsp;The Seller (Селлер);</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15150" ["sku"]=> string(5) "S8489" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "8" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(40) "catalog/predmetka_ijun_2019/ao6b5037.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1050) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>The Seller</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(9) "5980.0000" ["special"]=> string(9) "4186.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-01" ["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(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-12-24 12:48:48" ["viewed"]=> string(4) "1767" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "247" [4]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15152]=> array(49) { ["product_id"]=> string(5) "15152" ["name"]=> string(90) "Туфли лодочки женские с контрастным носком The Seller" ["description"]=> string(1076) "<p>Туфли женские черного цвета с острым носом на высоком каблуке The Seller легко дополнят любой образ и являются базовой парой в базовом гардеробе. Вытянутый острый носок, высокий&nbsp; каблук &quot;рюмочка&quot;. Без застежки. Жесткая модель хорошо фиксирует стопу и защищает от повреждений. Высококачественные материалы гарантируют безупречный внешний вид на протяжении всего срока службы.&nbsp;</p> <ul style="list-style-type:disc"> </ul> <p>Купить&nbsp;туфли женские черного цвета с острым носом на высоком каблуке The Seller вы сможете в нашем магазине. Желаем вам удачных покупок!</p> " ["characteristics"]=> string(681) "<ul style="list-style-type:disc"> <li>Модель: туфли с острым носом ;</li> <li>Фасон: лодочки;</li> <li>Цвет: черный, бежевый;</li> <li>Узор: нет;</li> <li>Материал: верх &ndash; кожа 100%; подкладка &ndash; кожа 100%; подошва &ndash; кожа/резина;</li> <li>Сезонность: весна-лето-осень;</li> <li>Бренд:&nbsp;The Seller (Селлер);</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15152" ["sku"]=> string(5) "S8389" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(40) "catalog/predmetka_ijun_2019/ao6b5012.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1050) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>The Seller</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(9) "6500.0000" ["special"]=> string(9) "3250.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-01" ["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(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-12-08 14:30:40" ["viewed"]=> string(4) "1576" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "247" [4]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15148]=> array(49) { ["product_id"]=> string(5) "15148" ["name"]=> string(74) "Туфли лодочки женские двухцветные The Seller" ["description"]=> string(891) "<p>Туфли лодочки женские на высоком каблуке с острым носом The Seller выглядят элегантно и будут уместны как в деловом офисном образе, так и для создания образа для праздничного мероприятия. Закрытая модель, острый удлиненный носок. Высокий тонкий каблук-шпилька. Акцент в образе - отрезной носок контрастного цвета.</p> <p>Купить туфли лодочки женские на высоком каблуке с острым носом The Seller вы сможете в нашем магазине, оформив заказ удобным для вас способом. Удачных покупок!</p> " ["characteristics"]=> string(604) "<ul> <li>Модель: туфли на высоком каблуке;</li> <li>Фасон: лодочки с открытой пяткой;</li> <li>Цвет: черный, бежевый;</li> <li>Узор: нет;</li> <li>Состав: кожа 100%;</li> <li>Подошва: кожа, резина;</li> <li>Сезонность: весна-лето;</li> <li>Бренд: The Seller (Селлер);</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15148" ["sku"]=> string(5) "S8326" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "8" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(40) "catalog/predmetka_ijun_2019/ao6b4991.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1050) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>The Seller</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(9) "6500.0000" ["special"]=> string(9) "4550.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-01" ["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(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-07-01 11:57:52" ["date_modified"]=> string(19) "2021-12-24 12:46:55" ["viewed"]=> string(4) "1406" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "247" [4]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11386]=> array(49) { ["product_id"]=> string(5) "11386" ["name"]=> string(50) "Туфли лодочки черные Luis Onofre" ["description"]=> string(995) "<p>Елегантные туфли-лодочки от потругальского бренда&nbsp;Luis Onofre, предоставляющего обувь премиального класса. Данная модель прекрасно дополнит как вечерний лук, так и деловой костюм. Носок&nbsp;украшен декоративной вставкой в виде золотистого&nbsp;элемента прямоугольной формы. Модель на тонком каблуке.&nbsp;</p> <p>Приобрести невероятные туфли-лодочки черного цвета&nbsp;вы можете в нашем магазине. Оформляйте заказ прямо сейчас, а наши консультанты с удовольствием&nbsp;ответят&nbsp;на все ваши вопросы. Удачных покупок в DN8!</p> " ["characteristics"]=> string(371) "<ul> <li>Модель:&nbsp;Туфли</li> <li>Код: 11386</li> <li>Артикул: UK 3458/01</li> <li>Материал: кожа 100%</li> <li>Бренд:&nbsp;LUIS ONOFRE</li> <li>Страна: Португалия</li> </ul> <p>&nbsp;</p> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(22) "Туфли Luis Onofre" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11386" ["sku"]=> string(10) "UK 3458/01" ["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(55) "catalog/dn8/fotosessija/2021/november/16-11-2/11386.jpg" ["manufacturer_id"]=> string(2) "96" ["manufacturer"]=> string(11) "Luis Onofre" ["manufacturer_size_table"]=> string(633) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> </tr> <tr> <td>Luis Onofre</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> </tr> </tbody> </table> " ["price"]=> string(9) "9600.0000" ["special"]=> string(9) "4800.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-12-24 12:31:33" ["viewed"]=> string(4) "1059" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(3) "246" [2]=> string(3) "247" [3]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [7910]=> array(49) { ["product_id"]=> string(4) "7910" ["name"]=> string(73) "Туфли лодочки женские серые Cantini & Cantini" ["description"]=> string(800) "<p>Стильные туфли-лодочки женские серые Cantini &amp; Cantini. В них невозможно остаться незамеченной. Модель выполнена в благородном сером цвете, носочек острой формы. Пятка закрыта, устойчевый классический&nbsp;каблук средней&nbsp; высоты.</p> <p>Если вас заинтересовала модель, вы сможете заказать туфли-лодочки женские серые Cantini &amp; Cantini на нашем сайте. Доставка работает в Киеве и по всем регионам Украины.</p> <p>&nbsp;</p> " ["characteristics"]=> string(561) "<ul> <li>Модель: туфли лодочки;</li> <li>Цвет: серый;</li> <li>Материал: верх кожа 100%, подкладка кожа 100%, подошва кожа 100%;</li> <li>Сезонность: внесезонная;</li> <li>Бренд: Cantini&amp;Cantini (Кантини энд Кантини);</li> <li>Страна бренда: Италия.</li> </ul> <p>&nbsp;</p> <p>&nbsp;</p> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(32) "Туфли Cantini & Cantini" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "7910" ["sku"]=> string(3) "R38" ["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(52) "catalog/dn8/fotosessija/2021/november/16_11/7910.jpg" ["manufacturer_id"]=> string(2) "77" ["manufacturer"]=> string(21) "Cantini & Cantini" ["manufacturer_size_table"]=> string(1105) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> <tbody> <tr> <td>Cantini &amp; Cantini</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(9) "5200.0000" ["special"]=> string(9) "2080.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-11-30 11:53:25" ["viewed"]=> string(4) "1022" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "247" [4]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11684]=> array(49) { ["product_id"]=> string(5) "11684" ["name"]=> string(84) "Туфли лодочки женские с открытой пяткой The Seller" ["description"]=> string(1663) "<p>Стильная модель для офиса или деловой встречи.&nbsp;Уплотненный носок. Удобная внутренняя часть. Пара обуви удобна в носке. Хорошо продуманная колодка не дает ноге устать, сохраняет правильную осанку и предотвращает сколиоз. Похожие модели, которые могут быть интересны -<a href="https://dn8.ua/tufli-zhenskie-the-seller-11680" target="_blank"> туфли черного цвета на высоком каблуке</a>&nbsp;и <a href="https://dn8.ua/tufli-zhenskie-the-seller-11681" target="_blank">туфли-лодочки из лакированной</a>&nbsp;кожи.&nbsp;</p> <p>Преимущества&nbsp;женских туфель черного цвета из натуральной кожи The Seller. Стильный дизайн; классическая модель туфель на выход; регулируемый ремешок на щиколотке; устойчивый каблук.</p> <p>Если вам понравилась модель, приобрести&nbsp;женские туфли-лодочки черного цвета из натуральной кожи The Seller можно на сайте нашего магазина. Доставка работает по Киеву и по областям Украины. Удачных покупок!</p> " ["characteristics"]=> string(643) "<ul> <li>Модель: женские туфли с открытой пяткой и закрытым носком;</li> <li>Фасон: туфли-лодочки на высокой шпильке;</li> <li>Цвет: черный, бежевый;</li> <li>Принт: нет;</li> <li>Материал: текстиль 100%, кожа 100%;</li> <li>Сезонность: весна-лето;</li> <li>Бренд:&nbsp;The Seller (Зэ Селлер);</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(21) "Туфли The Seller" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11684" ["sku"]=> string(5) "S5535" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "8" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(55) "catalog/dn8/fotosessija/2021/november/16-11-2/11684.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1050) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>The Seller</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(9) "5900.0000" ["special"]=> string(9) "4130.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-28" ["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(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-12-24 12:39:46" ["viewed"]=> string(4) "1350" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "247" [4]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11385]=> array(49) { ["product_id"]=> string(5) "11385" ["name"]=> string(68) "Туфли лодочки женские красные Luis Onofre" ["description"]=> string(967) "<p>Туфли женские (лодочки) кожаные красного цвет на высоком каблуке Luis Onofre - яркий акцент в образе. Вытянутый острый носок. Высокий каблук-шпилька, обтянутый кожей. Декор - металлическая пряжка с символикой бренда. Гладкая кожа высокого качества. Внутри - кожа бежевого цвета. Стелька брендированная.</p> <p>Если вам понравилась модель, приобрести женские туфли (лодочки) кожаные красного цвет на высоком каблуке Luis Onofre на сайте нашего магазина. Доставка работает по Киеву и по регионам Украины. Удачных покупок!&nbsp;</p> " ["characteristics"]=> string(682) "<ul> <li>Модель: женские туфли на высоком каблуке;</li> <li>Фасон: кожаные лодочки на высокой шпильке;</li> <li>Цвет: красный, золотой, бежевый;</li> <li>Принт: символика бренда Luis Onofre;</li> <li>Материал: кожа 100%;</li> <li>Сезонность: весна-лето-осень;</li> <li>Бренд:&nbsp;Luis Onofre (Луис Онофре);</li> <li>Страна бренда: Португалия.&nbsp;</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(22) "Туфли Luis Onofre" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11385" ["sku"]=> string(10) "UK 3416/03" ["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(55) "catalog/dn8/fotosessija/2021/november/16-11-2/11385.jpg" ["manufacturer_id"]=> string(2) "96" ["manufacturer"]=> string(11) "Luis Onofre" ["manufacturer_size_table"]=> string(633) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> </tr> <tr> <td>Luis Onofre</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> </tr> </tbody> </table> " ["price"]=> string(9) "9600.0000" ["special"]=> string(9) "4800.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-12-14 09:36:48" ["viewed"]=> string(4) "1196" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "247" [4]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [7904]=> array(49) { ["product_id"]=> string(4) "7904" ["name"]=> string(82) "Туфли лодочки женские золотого цвета Fabio di Luna" ["description"]=> string(857) "<p>Стильнильные туфли-лодочки от итальнского бренда&nbsp;Fabio di Luna. В них невозможно остаться незамеченной. Модель выполнена в золотистом цвете, носочек острой формы, дополнительно украшен декоративными элементами.&nbsp;</p> <p>Если вам понравились эти туфли на каблуке, вы можете купить их прямо сейчас в нашем магазине удобным для вас способом:&nbsp;оформив онлайн или по номеру телефона +38 (067) 510-28-88, или обратившись к нашим консультантам в мессенджерах.</p> " ["characteristics"]=> string(546) "<ul> <li>Модель: туфли на каблуке;</li> <li>Фасон: лодочки;</li> <li>Цвет: золотистый;</li> <li>Материал: верх - кожа 100%; подкл.- кожа 100%;</li> <li>Подошва: кожа/резина</li> <li>Сезонность: весна,лето;</li> <li>Бренд: Fabio di Luna;</li> <li>Страна бренда: Италия.&nbsp;</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(24) "Туфли Fabio di Luna" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Туфли" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "7904" ["sku"]=> string(4) "5447" ["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(52) "catalog/dn8/fotosessija/2021/november/16_11/7904.jpg" ["manufacturer_id"]=> string(2) "86" ["manufacturer"]=> string(13) "Fabio di Luna" ["manufacturer_size_table"]=> string(635) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> </tr> <tr> <td>Fabio di Luna</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> </tr> </tbody> </table> " ["price"]=> string(9) "9500.0000" ["special"]=> string(9) "3800.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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(4) "1900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-12-24 12:36:44" ["viewed"]=> string(4) "1382" ["categories"]=> array(3) { [0]=> string(3) "246" [1]=> string(3) "247" [2]=> string(3) "407" } [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 = '407' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }