The Seller

array(12) { [15148]=> array(49) { ["product_id"]=> string(5) "15148" ["name"]=> string(70) "Туфлі човники жіночі двоколірні The Seller" ["description"]=> string(911) "<p>Туфлі човники жіночі на високих підборах з гострим носом The Seller виглядають елегантно і будуть доречні як в діловому офісному образі, так і для створення образу для святкового заходу. Закрита модель, гострий подовжений носок.</p> <p>Високий тонкий каблук-шпилька. Акцент в образі - відрізний носок контрастного кольору. Купити туфлі човники жіночі на високих підборах з гострим носом The Seller ви зможете в нашому магазині, оформивши замовлення зручним для вас способом. Вдалих покупок!</p> " ["characteristics"]=> string(629) "<ul> <li>Модель: туфлі на високих підборах;</li> <li>Фасон: човники з відкритою п&#39;ятою;</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(1046) "<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(1) "8" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-07-01 11:57:52" ["date_modified"]=> string(19) "2021-07-12 15:10:35" ["viewed"]=> string(4) "1004" ["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(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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' 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(83) "Туфлі човники жіночі з відкритою п'ятою The Seller" ["description"]=> string(1051) "<p>Туфлі на невисокому каблуці жіночі чорного кольору з відкритою п&#39;ятою і закритим носком The Seller - елегантна модель, яка підходять як для офісної капсули, так і для вечірнього виходу. Тонкий каблук середньої висоти злегка розширюється донизу. Вузький гострий носок. Фіксується на нозі за рахунок тонкого ремінця.</p> <p>Ширину можна регулювати і підбирати під повноту ноги. Замовити сандалі жіночі чорного кольору з відкритою п&#39;ятою і закритим носком The Seller ви зможете в нашому магазині, оформивши замовлення зручним для вас способом.</p> <p>&nbsp;</p> " ["characteristics"]=> string(614) "<ul> <li>Модель: туфлі на невисокому каблуці;</li> <li>Фасон: туфлі з відкритою п&#39;яткою;</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) "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(1046) "<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(1) "7" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-07-12 14:55:10" ["viewed"]=> string(4) "1326" ["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(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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15153]=> array(49) { ["product_id"]=> string(5) "15153" ["name"]=> string(80) "Туфлі човники жіночі на низькому ходу The Seller" ["description"]=> string(750) "<p>Туфлі жіночі&nbsp; з відкритою п&#39;ятою на низькому ходу The Seller в класичному стилі підходять як для елегантного образу, так і для неформальних зустрічей у дружній кампанії. Гострий ніс, низький каблук. Ширину можна регулювати завдяки ремінця.</p> <p>Купити туфлі жіночі з відкритою п&#39;ятою на низькому ходу The Seller ви зможете в нашому магазині, оформивши замовлення зручним для вас способом.</p> " ["characteristics"]=> string(501) "<ul> <li>Модель: туфлі з гострим носом;</li> <li>Фасон: човники;</li> <li>Візерунок: немає;</li> <li>Склад: шкіра 100%, підошва шкіра, гума;</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) "15153" ["sku"]=> string(5) "S8494" ["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(40) "catalog/predmetka_ijun_2019/ao6b5098.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1046) "<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) "5500.0000" ["special"]=> string(9) "2750.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(1) "5" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-07-01 11:57:52" ["date_modified"]=> string(19) "2021-07-12 15:11:17" ["viewed"]=> string(4) "1115" ["categories"]=> array(5) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "247" [4]=> string(3) "410" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16724]=> array(49) { ["product_id"]=> string(5) "16724" ["name"]=> string(80) "Шльопанці жіночі в смарагдовому кольорі Anima" ["description"]=> string(702) "<p><span style="font-size:11pt"><span style="background-color:white"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Шльопанці жіночі в смарагдовому кольорі. Модель виготовлена з натуральної шкіри <strong>з імітацією під шкіру змії</strong>. Шльопанці без задника, округлений носок.</span></span></span></span></span></p> " ["characteristics"]=> string(1054) "<ul> <li><span style="font-size:14px">Код товару: 16724</span></li> <li><span style="font-size:14px">Артикул: J7223</span></li> </ul> <ul> <li><span style="font-size:14px">Бренд: The Seller&nbsp;</span></li> <li><span style="font-size:14px">Країна: Італія</span></li> </ul> <ul> <li><span style="font-size:14px">Колір: смарагдовий</span></li> <li><span style="font-size:14px">Модель: шльопанці</span></li> <li><span style="font-size:14px">Матеріал: верх - шкіра 100%, підкладка - шкіра 100%, підошва - шкіра&nbsp;</span></li> <li><span style="font-size:14px">Стиль:&nbsp;casual</span></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(99) "Шльопанці, жіночі, зелені, блискучі, шкіряні, шкіра, Anima" ["model"]=> string(5) "16724" ["sku"]=> string(5) "J7223" ["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/0566-ds.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1046) "<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) "6300.0000" ["special"]=> string(9) "4410.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-10" ["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-10 11:22:53" ["date_modified"]=> string(19) "2021-05-20 12:53:17" ["viewed"]=> string(3) "420" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "405" [3]=> string(3) "406" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16720]=> array(49) { ["product_id"]=> string(5) "16720" ["name"]=> string(90) "Туфлі жіночі фіолетові шкіряні на підборах The Seller" ["description"]=> string(892) "<p><span style="font-size:16px"><span style="background-color:white"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Жіночі туфлі <strong>з натуральної шкіри нубук </strong>в темно-синьому кольорі. Модель виконана з перфорованого нубука, має декор дрібні заклепки, звужений носок і V-виріз.</span></span></span></span></p> <p><span style="font-size:16px"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Висота каблука 7,5 см.</span></span></p> " ["characteristics"]=> string(1035) "<ul> <li><span style="font-size:14px">Код товару: 16720</span></li> <li><span style="font-size:14px">Артикул: S8878</span></li> </ul> <ul> <li><span style="font-size:14px">Бренд: The Seller&nbsp;</span></li> <li><span style="font-size:14px">Країна: Італія</span></li> </ul> <ul> <li><span style="font-size:14px">Колір: темно-синій</span></li> <li><span style="font-size:14px">Модель: туфлі</span></li> <li><span style="font-size:14px">Матеріал: верх - шкіра 100%, підкладка - шкіра 100%, підошва - шкіра</span></li> <li><span style="font-size:14px">Стиль:&nbsp;casual</span></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(221) "туфлі жіночі, туфлі на тонкому каблуці, красиві туфлі, туфлі з гострим носком, туфлі на середньому підборі, туфлі на вихід" ["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) "8" ["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(1046) "<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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-05-21 15:25:34" ["viewed"]=> string(3) "525" ["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(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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16721]=> array(49) { ["product_id"]=> string(5) "16721" ["name"]=> string(53) "Балетки жіночі червоні The Seller" ["description"]=> string(523) "<p><span style="font-size:16px"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Жіночі балетки з натуральної шкіри, нубук в червоному кольорі. Модель виготовлена <strong>з перфорованого нубука</strong> і декором дрібні заклепки, має звужений носок і V-виріз.</span></span></p> " ["characteristics"]=> string(1054) "<ul> <li><span style="font-size:14px">Код товару: 16721</span></li> <li><span style="font-size:14px">Артикул: S8817</span></li> </ul> <ul> <li><span style="font-size:14px">Бренд: The Seller&nbsp;</span></li> <li><span style="font-size:14px">Країна: Італія</span></li> </ul> <ul> <li><span style="font-size:14px">Колір: червоний</span></li> <li><span style="font-size:14px">Модель: балетки&nbsp;</span></li> <li><span style="font-size:14px">Матеріал: верх - шкіра 100%, підкладка - шкіра 100%, підошва - шкіра&nbsp;</span></li> <li><span style="font-size:14px">Стиль:&nbsp;casual</span></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(0) "" ["model"]=> string(5) "16721" ["sku"]=> string(5) "S8817" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "9" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskaja_obuv/0558-ds.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1046) "<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) "7400.0000" ["special"]=> string(9) "5180.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-01-15 11:46:33" ["viewed"]=> string(3) "459" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16723]=> array(49) { ["product_id"]=> string(5) "16723" ["name"]=> string(62) "Балетки жіночі рожеві нубук The Seller" ["description"]=> string(405) "<p>Жіночі балетки з натуральної шкіри нубук в кольорі рожева пудра. Модель має звужений носок, маленький каблук. П&#39;ятка м&#39;яка, гнучка, що дозволяє носити модель без п&#39;яти.</p> <p>Висота каблука 2 см</p> " ["characteristics"]=> string(1060) "<ul> <li><span style="font-size:14px">Код товару: 6723</span></li> <li><span style="font-size:14px">Артикул: 0111</span></li> </ul> <ul> <li><span style="font-size:14px">Бренд: The Seller</span></li> <li><span style="font-size:14px">Країна: Італія</span></li> </ul> <ul> <li><span style="font-size:14px">Колір: рожевий</span></li> <li><span style="font-size:14px">Модель: балетки&nbsp;</span></li> <li><span style="font-size:14px">Матеріал: верх &ndash; шкіра 100%; підкладка &ndash; шкіра 100%; підошва &ndash; шкіра</span></li> <li><span style="font-size:14px">Стиль:&nbsp;casual</span></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(78) "Туфлі, жіночі, нубук, рожеві, Julie Dee Anima The Seller" ["model"]=> string(5) "16723" ["sku"]=> string(4) "0111" ["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/0561-ds.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1046) "<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) "5600.0000" ["special"]=> string(9) "3920.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-01-15 11:41:54" ["viewed"]=> string(3) "449" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16719]=> array(49) { ["product_id"]=> string(5) "16719" ["name"]=> string(68) "Босоніжки жіночі літні шкіряні The Seller" ["description"]=> string(412) "<p><span style="font-size:16px"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Босоніжки жіночі в чорному кольорі. Модель має звужений носок і V-виріз, регульовану застібку на пряжку, без задника.</span></span></p> " ["characteristics"]=> string(1053) "<ul> <li><span style="font-size:14px">Код товару: 16719</span></li> <li><span style="font-size:14px">Артикул: S8822</span></li> </ul> <ul> <li><span style="font-size:14px">Бренд: The Seller&nbsp;</span></li> <li><span style="font-size:14px">Країна: Італія&nbsp;</span></li> </ul> <ul> <li><span style="font-size:14px">Колір: чорний</span></li> <li><span style="font-size:14px">Модель: босоніжки</span></li> <li><span style="font-size:14px">Матеріал: верх - шкіра 100%, підкладка -&nbsp;шкіра 100%, підошва - шкіра</span></li> <li><span style="font-size:14px">Стиль:&nbsp;casual</span></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(113) "Босоніжки, жіночі, літні, шкіряні, The Seller, Spacio, натуральна шкіра" ["model"]=> string(5) "16719" ["sku"]=> string(5) "S8822" ["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/0532-ds.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1046) "<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) "2020-08-06" ["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-06 14:38:23" ["date_modified"]=> string(19) "2021-05-20 13:00:43" ["viewed"]=> string(3) "447" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "252" [3]=> string(3) "405" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16722]=> array(49) { ["product_id"]=> string(5) "16722" ["name"]=> string(78) "Босоніжки жіночі літні чорного кольору Anima" ["description"]=> string(981) "<p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Босоніжки жіночі в чорному кольорі. Модель виготовлена <strong>з лакової шкіри</strong>, має регульовану застібку на пряжку, округлений носок, геометричний каблук, всередині шкіра, підошва зі шкіри.</span></span></span></p> <p><span style="font-size:16px"><span style="font-family:Calibri,sans-serif"><span style="font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;">Висота каблука 7,5 см.</span></span></span></p> <p>&nbsp;</p> " ["characteristics"]=> string(1022) "<ul> <li><span style="font-size:14px">Код товару: 16722</span></li> <li><span style="font-size:14px">Артикул: J7216</span></li> </ul> <ul> <li><span style="font-size:14px">Бренд: BThe Seller&nbsp;</span></li> <li><span style="font-size:14px">Країна: Італія</span></li> </ul> <ul> <li><span style="font-size:14px">Колір: чорний</span></li> <li><span style="font-size:14px">Модель: босоніжки</span></li> <li><span style="font-size:14px">Матеріал: верх - шкіра 100%, підкладка 100%, підошва - шкіра</span></li> <li><span style="font-size:14px">Стиль:&nbsp;casual</span></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(110) "Босоніжки, жіночі, літні, чорного кольору, чорні, Anima, шкіряні" ["model"]=> string(5) "16722" ["sku"]=> string(5) "J7216" ["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/0530-ds.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1046) "<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) "5600.0000" ["special"]=> string(9) "3920.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-06" ["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-06 14:38:23" ["date_modified"]=> string(19) "2021-05-20 13:01:52" ["viewed"]=> string(3) "445" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "252" [3]=> string(3) "405" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' 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(88) "Туфлі човники жіночі з контрастним носком The Seller" ["description"]=> string(978) "<p>Туфлі жіночі чорного кольору з гострим носом на високому каблуці The Seller легко доповнять будь-який образ і є базовою парою в базовому гардеробі. Витягнутий гострий носок, високий каблук &quot;чарочка&quot;. Без застібки. Жорстка модель добре фіксує стопу і захищає від пошкоджень. Високоякісні матеріали гарантують бездоганний зовнішній вигляд протягом усього терміну служби.</p> <p>Купити туфлі жіночі чорного кольору з гострим носом на високому каблуці The Seller ви зможете в нашому магазині. Бажаємо вам вдалих покупок</p> " ["characteristics"]=> string(628) "<ul> <li>Модель: туфлі з гострим носом;</li> <li>Фасон: човники;</li> <li>Колір: чорний, бежевий;</li> <li>Візерунок: немає;</li> <li>Матеріал: верх - шкіра 100%; підкладка - шкіра 100%; підошва - шкіра / резина;</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) "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) "2" ["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(1046) "<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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-01-14 11:34:40" ["viewed"]=> string(4) "1163" ["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(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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15151]=> array(49) { ["product_id"]=> string(5) "15151" ["name"]=> string(77) "Туфлі жіночі білі з відкритою п'ятою The Seller" ["description"]=> string(1005) "<p>Сандалії жіночі з закритим носком і відкритою п&#39;ятою білого кольору The Seller - стильна модель, яка ніколи не втратить своєї актуальності. Підходить як для ділової зустрічі, так і для вечірнього виходу. Загострений витягнутий носок. Низький широкий каблук. Ремінці декоровані металевими бляшками. Застібка на ремінець у щиколотки дозволяє регулювати ширину.</p> <p>Якщо ви хотіли б оновити базовий гардероб на літо, замовити сандалі жіночі з закритим носком і відкритою п&#39;ятою білого кольору The Seller ви зможете в нашому магазині.</p> " ["characteristics"]=> string(577) "<ul> <li>Модель: туфлі з відкритою п&#39;ятою;</li> <li>Колір білий;</li> <li>Візерунок: немає;</li> <li>Склад: верх - шкіра 100%;</li> <li>Підкладка - шкіра 100%; підошва - шкіра / резина;</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) "15151" ["sku"]=> string(5) "J4540" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(40) "catalog/predmetka_ijun_2019/ao6b5116.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1046) "<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) "6900.0000" ["special"]=> string(9) "4830.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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-01-14 16:50:59" ["viewed"]=> string(3) "667" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "246" [3]=> string(3) "410" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15149]=> array(49) { ["product_id"]=> string(5) "15149" ["name"]=> string(111) "Босоніжки жіночі чорного кольору з металевими точками The Seller" ["description"]=> string(734) "<p>Босоніжки жіночі чорного кольору з металевими точками The Seller з високоякісних матеріалів. Широка поперечна смуга і каблук декоровані&nbsp;металевими точками. Стійка підошва, не ковзає. Зручна колодка, відкритий носок. Без застібки.</p> <p>Купити босоніжки жіночі чорного кольору з металевими точками The Seller ви зможете в нашому магазині, оформивши замовлення через сайт або по телефону.</p> " ["characteristics"]=> string(673) "<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(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15149" ["sku"]=> string(5) "J4578" ["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(40) "catalog/predmetka_ijun_2019/ao6b5054.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1046) "<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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-04 13:18:36" ["date_modified"]=> string(19) "2021-01-29 09:30:09" ["viewed"]=> string(3) "641" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "405" [3]=> string(3) "406" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '45' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }