Балетки

array(12) { [16734]=> array(49) { ["product_id"]=> string(5) "16734" ["name"]=> string(97) "Балетки жіночі червоні на низькому ходу з бантом Pollini" ["description"]=> string(350) "<p>Балетки жіночі в червоному кольорі. Модель виконана з жатої лакованої шкіри, має декор бант з лого бренду, звужений носок і V-виріз, маленький каблук.</p> <p>Висота каблука 1 см.</p> " ["characteristics"]=> string(1033) "<ul> <li><span style="font-size:14px">Код товару: 16734</span></li> <li><span style="font-size:14px">Артикул: SA11081C0A502</span></li> </ul> <ul> <li><span style="font-size:14px">Бренд: Pollini</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%, підкладка -&nbsp;шкіра 100%, підошва - гума</span></li> <li><span style="font-size:14px">Стиль: кежуал</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(215) "туфлі жіночі, туфлі на низькому ходу, туфлі на кожен день, туфлі без каблука, туфлі зручні, повсякденне взуття, балетки" ["model"]=> string(5) "16734" ["sku"]=> string(13) "SA11081C0A502" ["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/0552-ds.jpg" ["manufacturer_id"]=> string(3) "155" ["manufacturer"]=> string(7) "Pollini" ["manufacturer_size_table"]=> string(1191) "<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) "10200.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-08-31 11:42:55" ["viewed"]=> string(3) "768" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' 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(590) "<ul> <li>Код товару: 16721</li> <li>Артикул: S8817</li> </ul> <ul> <li>Бренд: The Seller&nbsp;</li> <li>Країна: Італія</li> </ul> <ul> <li>Колір: червоний</li> <li>Модель: балетки&nbsp;</li> <li>Матеріал: верх - шкіра 100%, підкладка - шкіра 100%, підошва - шкіра&nbsp;</li> <li>Стиль:&nbsp;casual</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) "8" ["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"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-08-31 12:46:01" ["viewed"]=> string(3) "708" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' 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(596) "<ul> <li>Код товару: 6723</li> <li>Артикул: 0111</li> </ul> <ul> <li>Бренд: The Seller</li> <li>Країна: Італія</li> </ul> <ul> <li>Колір: рожевий</li> <li>Модель: балетки&nbsp;</li> <li>Матеріал: верх &ndash; шкіра 100%; підкладка &ndash; шкіра 100%; підошва &ndash; шкіра</li> <li>Стиль:&nbsp;casual</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) "6" ["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"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-08-31 12:45:03" ["viewed"]=> string(3) "654" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11346]=> array(49) { ["product_id"]=> string(5) "11346" ["name"]=> string(75) "Балетки жіночі шкіряні темно-сині La Ballerina" ["description"]=> string(559) "<p>Жіночі&nbsp;шкіряні балетки&nbsp;темно-синього кольору. Модель виготовлена&nbsp;з м&#39;якої шкіри. Взуття прикрашено бантом із пензликами і бахромою зі шкіри.</p> <p>Зручна ортопедична модель, закруглений носок, форма підходить на будь-яку форму ноги. Базова модель балеток на кожен день.</p> " ["characteristics"]=> string(678) "<ul style="list-style-type:disc"> <li>Код товару:&nbsp;11346</li> <li>Артикул: 607-24:F59 blu</li> </ul> <ul> <li>Бренд: LA BALLERINA</li> <li>Країна: Швейцарія&nbsp;</li> </ul> <ul> <li>Колір: темно-синій</li> <li>Модель: балетки&nbsp;</li> <li>Материал: верх &ndash; шкіра 100%; підкладка &ndash; шкіра 100%; підошва &ndash; гума</li> <li>Стиль:&nbsp;casual</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(125) "Туфлі, жіночі, балетки, шкіряні, з овальним носком, темно-сині, La Ballerina" ["model"]=> string(5) "11346" ["sku"]=> string(14) "607-24:F59 blu" ["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(60) "catalog/dn8/fotosessija/2020/maj/obuv_pravki/_mg_1689-ds.jpg" ["manufacturer_id"]=> string(2) "29" ["manufacturer"]=> string(12) "La Ballerina" ["manufacturer_size_table"]=> string(1162) "<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>La Ballerina</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> </tbody> </table> " ["price"]=> string(9) "2990.0000" ["special"]=> string(9) "1495.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) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-01-15 11:46:20" ["viewed"]=> string(4) "1123" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11355]=> array(49) { ["product_id"]=> string(5) "11355" ["name"]=> string(75) "Балетки жіночі шкіряні з бантиком La Ballerina" ["description"]=> string(480) "<p>Жіночі шкіряні балетки білого кольору. Модель прикрашена на миску маленьким бантом.</p> <p>Ортопедична модель балеток, витягнутий закруглений носок, форма моделі балеток добре тримає будь-яку форму ноги, базові та зручні в носінні на кожен день.</p> " ["characteristics"]=> string(665) "<ul style="list-style-type:disc"> <li>Код товару:&nbsp;11355</li> <li>Артикул: 6192-2B:5A63</li> </ul> <ul> <li>Бренд: LA BALLERINA</li> <li>Країна: Швейцарія&nbsp;</li> </ul> <ul> <li>Колір: білий</li> <li>Модель: балетки&nbsp;</li> <li>Матеріал: верх &ndash; шкіра 100%; підкладка &ndash; шкіра 100%; підошва &ndash; гума</li> <li>Стиль:&nbsp;casual</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(101) "Туфлі, жіночі, балетки, білі, шкіряні, з бантиком, La Ballerina" ["model"]=> string(5) "11355" ["sku"]=> string(12) "6192-2B:5A63" ["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(60) "catalog/dn8/fotosessija/2020/maj/obuv_pravki/_mg_1712-ds.jpg" ["manufacturer_id"]=> string(2) "29" ["manufacturer"]=> string(12) "La Ballerina" ["manufacturer_size_table"]=> string(1162) "<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>La Ballerina</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> </tbody> </table> " ["price"]=> string(9) "2990.0000" ["special"]=> NULL ["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) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-01-15 11:44:49" ["viewed"]=> string(3) "755" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13096]=> array(49) { ["product_id"]=> string(5) "13096" ["name"]=> string(66) "Балетки жіночі чорні замшеві La Ballerina" ["description"]=> string(579) "<p>Жіночі балетки <strong>з натуральної замші</strong> чорного кольору. На високій рифленій підошві.</p> <p><strong>Ортопедична модель </strong>балеток, витягнутий закруглений носок. Форма моделі балеток добре тримає будь-яку форму ноги, <strong>зручні в носінні на кожен день.</strong> Висота підошви 2 см.</p> " ["characteristics"]=> string(612) "<ul> <li>Код товару: 13096</li> <li>Артикул: H9157</li> </ul> <ul> <li>Бренд: LA BALLERINA</li> <li>Країна: Швейцарія&nbsp;</li> </ul> <ul> <li>Колір: чорний</li> <li>Модель: балетки&nbsp;</li> <li>Матеріал: верх &ndash; замша 100%; підкладка &ndash; шкіра 100%; підошва &ndash; гума</li> <li>Стиль:&nbsp;casual</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) "13096" ["sku"]=> string(5) "H9157" ["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(60) "catalog/dn8/fotosessija/2020/maj/obuv_pravki/_mg_1690-ds.jpg" ["manufacturer_id"]=> string(2) "29" ["manufacturer"]=> string(12) "La Ballerina" ["manufacturer_size_table"]=> string(1162) "<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>La Ballerina</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> </tbody> </table> " ["price"]=> string(9) "4200.0000" ["special"]=> string(9) "2100.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) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-01-15 11:43:36" ["viewed"]=> string(3) "830" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13364]=> array(49) { ["product_id"]=> string(5) "13364" ["name"]=> string(73) "Балетки жіночі чорні зі стразами La Ballerina" ["description"]=> string(825) "<p><span style="font-family:Times New Roman,serif"><span style="font-size:16px">Жіночі <strong>балетки з натуральної замші </strong>чорного кольору з прикрасою у вигляді банта з дрібних страз і бісеру.</span></span></p> <p><span style="font-family:&quot;Times New Roman&quot;,serif; font-size:16px"><strong>Ортопедична підошва</strong>, овальна форма носка, глибока форма добре тримає будь-яку форму ноги. <strong>Комфортна і зручна</strong> в носінні модель на кожен день.</span></p> " ["characteristics"]=> string(661) "<ul style="list-style-type:disc"> <li>Код товару:&nbsp;13364</li> <li>Артикул: 0228-7</li> </ul> <ul> <li>Бренд: LA BALLERINA</li> <li>Країна: Швейцарія&nbsp;</li> </ul> <ul> <li>Колір: чорний</li> <li>Модель: балетки&nbsp;</li> <li>Матеріал: верх &ndash; замша 100%; підкладка &ndash; шкіра 100%; підошва &ndash; гума</li> <li>Стиль:&nbsp;casual</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) "13364" ["sku"]=> string(6) "0228-7" ["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(60) "catalog/dn8/fotosessija/2020/maj/obuv_pravki/_mg_1686-ds.jpg" ["manufacturer_id"]=> string(2) "29" ["manufacturer"]=> string(12) "La Ballerina" ["manufacturer_size_table"]=> string(1162) "<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>La Ballerina</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> </tbody> </table> " ["price"]=> string(9) "3700.0000" ["special"]=> string(9) "1850.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) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-01-15 11:43:47" ["viewed"]=> string(4) "1133" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11353]=> array(49) { ["product_id"]=> string(5) "11353" ["name"]=> string(65) "Балетки жіночі сині з бантом La Ballerina" ["description"]=> string(523) "<p>Жіночі <strong>шкіряні балетки </strong>синього кольору з акуратним бантом і фурнітурою золотого кольору.</p> <p><strong>Ортопедична підошва</strong>, овальна форма носка. Глибока форма добре тримає ногу. Балетки <strong>комфортні і зручні </strong>для щоденного носіння.</p> " ["characteristics"]=> string(659) "<ul style="list-style-type:disc"> <li>Код товару: 11353</li> <li>Артикул: 20010-1:2N6 blu</li> </ul> <ul> <li>Бренд: LA BALLERINA</li> <li>Країна: Швейцарія&nbsp;</li> </ul> <ul> <li>Колір: синій</li> <li>Модель: балетки&nbsp;</li> <li>Матеріал: верх &ndash; шкіра 100%; підкладка &ndash; шкіра 100%; підошва &ndash; гума</li> <li>Стиль:&nbsp;casual</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(107) "Туфлі, жіночі, балетки, темно-сині, з великим бантом, La Ballerina" ["model"]=> string(5) "11353" ["sku"]=> string(15) "20010-1:2N6 blu" ["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(60) "catalog/dn8/fotosessija/2020/maj/obuv_pravki/_mg_1683-ds.jpg" ["manufacturer_id"]=> string(2) "29" ["manufacturer"]=> string(12) "La Ballerina" ["manufacturer_size_table"]=> string(1162) "<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>La Ballerina</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> </tbody> </table> " ["price"]=> string(9) "2990.0000" ["special"]=> string(9) "1495.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) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-01-15 11:42:59" ["viewed"]=> string(3) "913" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11348]=> array(49) { ["product_id"]=> string(5) "11348" ["name"]=> string(66) "Балетки жіночі світло-рожеві La Ballerina" ["description"]=> string(672) "<p>Жіночі балетки відтінку рожевої пудри. <strong>Виготовлені з нубуку</strong>, який добре пропускає повітря. Декоровані візерунком у вигляді прошитих ромбів і бантом на носку.</p> <p><strong>Комфортна ортопедична модель балеток</strong>, закруглений лакований носок. Форма моделі балеток добре тримає будь-яку форму ноги, зручні в носінні на кожен день.</p> " ["characteristics"]=> string(705) "<ul style="list-style-type:disc"> <li>Код товару:&nbsp;11348</li> <li>Артикул: 6192-4A:204/1N32</li> </ul> <ul> <li>Бренд: LA BALLERINA</li> <li>Країна: Швейцарія&nbsp;</li> </ul> <ul> <li>Колір: рожевий (пудровий)</li> <li>Модель: балетки&nbsp;</li> <li>Матеріал: верх &ndash; нубук (шкіра) 100%; підкладка &ndash; шкіра 100%; підошва &ndash; гума</li> <li>Стиль:&nbsp;casual</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(224) "балетки, шкіряні балетки, рожеві балетки, зручне взуття, туфлі на низькому ходу, шкіряні балетки, балетки з овальним носком" ["model"]=> string(5) "11348" ["sku"]=> string(16) "6192-4A:204/1N32" ["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(60) "catalog/dn8/fotosessija/2020/maj/obuv_pravki/_mg_1692-ds.jpg" ["manufacturer_id"]=> string(2) "29" ["manufacturer"]=> string(12) "La Ballerina" ["manufacturer_size_table"]=> string(1162) "<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>La Ballerina</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> </tbody> </table> " ["price"]=> string(9) "2990.0000" ["special"]=> string(9) "1495.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) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-01-15 11:42:47" ["viewed"]=> string(3) "842" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13366]=> array(49) { ["product_id"]=> string(5) "13366" ["name"]=> string(67) "Балетки жіночі сірі з пряжкою La Ballerina" ["description"]=> string(614) "<p><strong>Жіночі балетки</strong> сірого кольору, виготовлені&nbsp;<strong>з м&#39;якого нубуку</strong>. Прикрашені пряжкою зі сріблястого металу на носку.</p> <p><strong>Ортопедична модель</strong> балеток, закруглений лакований носок, форма моделі балеток добре тримає будь-яку форму ноги, зручні в носінні на кожен день.</p> " ["characteristics"]=> string(626) "<ul> <li>Код товару: 6192-197</li> <li>Артикул: 13366</li> </ul> <ul> <li>Бренд: LA BALLERINA</li> <li>Країна: Швейцарія&nbsp;</li> </ul> <ul> <li>Колір: сірий</li> <li>Модель: балетки&nbsp;</li> <li>Материал: верх &ndash; нубук (кожа 100%); подкладка &ndash; кожа 100%; подошва &ndash; резина</li> <li>Стиль:&nbsp;casual</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Балетки " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(277) "балетки, жіночі туфлі на низькому ходу, шкіряні туфлі, туфлі з бантом, балетки шкіряні, туфлі шкіряні, балетки з овальним носком, туфлі з овальним носком" ["model"]=> string(5) "13366" ["sku"]=> string(8) "6192-197" ["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(60) "catalog/dn8/fotosessija/2020/maj/obuv_pravki/_mg_1691-ds.jpg" ["manufacturer_id"]=> string(2) "29" ["manufacturer"]=> string(12) "La Ballerina" ["manufacturer_size_table"]=> string(1162) "<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>La Ballerina</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> </tbody> </table> " ["price"]=> string(9) "3400.0000" ["special"]=> string(9) "1700.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) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-01-15 11:44:17" ["viewed"]=> string(3) "833" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13365]=> array(49) { ["product_id"]=> string(5) "13365" ["name"]=> string(73) "Балетки жіночі пудровие з бантом La Ballerina" ["description"]=> string(525) "<p><strong>Шкіряні жіночі балетки</strong>&nbsp;відтінку рожевого пудри. Прикрашені бантом і намистинами у вигляді перлин.</p> <p><strong>Зручна ортопедична модель</strong>,&nbsp;закруглений носок, модель добре тримає будь-яку форму ноги. Базова модель балеток на кожен день.</p> " ["characteristics"]=> string(590) "<ul> <li>Код товару:&nbsp;13365</li> <li>Артикул: 6398-87</li> <li>Бренд: LA BALLERINA</li> <li>Країна: Швейцарія&nbsp;</li> <li>Колір: рожевий (пудровий)</li> <li>Модель: балетки&nbsp;</li> <li>Матеріал: верх &ndash; шкіра 100%; підкладка &ndash; шкіра 100%; підошва &ndash; гума</li> <li>Стиль:&nbsp;casual</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(114) "Туфлі, жіночі, балетки, пудрові, з овальним носком, бант, La Ballerina" ["model"]=> string(5) "13365" ["sku"]=> string(7) "6398-87" ["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(60) "catalog/dn8/fotosessija/2020/maj/obuv_pravki/_mg_1693-ds.jpg" ["manufacturer_id"]=> string(2) "29" ["manufacturer"]=> string(12) "La Ballerina" ["manufacturer_size_table"]=> string(1162) "<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>La Ballerina</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> </tbody> </table> " ["price"]=> string(9) "3400.0000" ["special"]=> string(9) "1700.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) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-08-25 15:34:21" ["viewed"]=> string(4) "1218" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [13095]=> array(49) { ["product_id"]=> string(5) "13095" ["name"]=> string(55) "Балетки жіночі замшеві La Ballerina" ["description"]=> string(634) "<p>Жіночі балетки рожевого відтінку. Виготовлені <strong>з нубуку</strong>, <strong>з декоративним тисненням</strong>. На високій рифленій підошві. Висота підошви 2 см.</p> <p><strong>Ортопедична модель балеток</strong>, витягнутий закруглений носок, форма моделі балеток добре тримає будь-яку форму ноги, зручні в носінні на кожен день.</p> " ["characteristics"]=> string(679) "<ul style="list-style-type:disc"> <li>Код товару:&nbsp;13095</li> <li>Артикул: H9157-225</li> </ul> <ul> <li>Бренд: LA BALLERINA</li> <li>Країна: Швейцарія&nbsp;</li> </ul> <ul> <li>Колір: рожевий</li> <li>Модель: балетки&nbsp;</li> <li>Матеріал: верх &ndash; нубук (шкіра) 100%; підкладка &ndash; шкіра 100%; підошва &ndash; гума</li> <li>Стиль:&nbsp;casual</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(249) "балетки, жіночі туфлі на низькому ходу, шкіряні туфлі, балетки шкіряні, туфлі шкіряні, балетки з овальним носком, туфлі з овальним носком" ["model"]=> string(5) "13095" ["sku"]=> string(9) "H9157-225" ["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(60) "catalog/dn8/fotosessija/2020/maj/obuv_pravki/_mg_1681-ds.jpg" ["manufacturer_id"]=> string(2) "29" ["manufacturer"]=> string(12) "La Ballerina" ["manufacturer_size_table"]=> string(1162) "<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>La Ballerina</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> </tbody> </table> " ["price"]=> string(9) "4200.0000" ["special"]=> NULL ["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) "2900" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-01-15 11:45:38" ["viewed"]=> string(3) "769" ["categories"]=> array(3) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "251" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '251' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }