Женские лоферы

array(4) { [16745]=> array(49) { ["product_id"]=> string(5) "16745" ["name"]=> string(76) "Лоферы женские красные с перфорацией Perrone" ["description"]=> string(552) "<p>Яркие&nbsp;лоферы от итальянского бренда Perrone выполнены в насыщенном красном цвете. Модель изготовлена исключительно из натуральных материалов, с перфорацией. В ловерах комфортно и приятно, поэтому их можно носить хоть каждый день, дополняя как деловые луки, так и праздничные наряды.&nbsp;</p> " ["characteristics"]=> string(504) "<ul> <li>Модель: лоферы;</li> <li>Цвет: красный;</li> <li>Декор: перфорация;</li> <li>Состав: кожа 100%;</li> <li>Подошва: кожа, резина;</li> <li>Сезонность: весна-лето;</li> <li>Бренд: Perrone;</li> <li>Страна бренда: Италия.</li> </ul> <p>&nbsp;</p> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Лоферы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "16745" ["sku"]=> string(17) "D852-1000-012/195" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskaja_obuv/0582-ds.jpg" ["manufacturer_id"]=> string(3) "159" ["manufacturer"]=> string(7) "PERRONE" ["manufacturer_size_table"]=> string(1790) "<p>МУЖСКАЯ ОБУВЬ</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>39</td> <td>39.5</td> <td>40</td> <td>40.5</td> <td>41</td> <td>41.5</td> <td>42</td> <td>42.5</td> <td>43</td> <td>43.5</td> <td>44</td> <td>44.5</td> <td>45</td> <td>примечание</td> </tr> <tr> <td>Perrone</td> <td>39</td> <td>&nbsp;</td> <td>40</td> <td>&nbsp;</td> <td>41</td> <td>&nbsp;</td> <td>42</td> <td>&nbsp;</td> <td>43</td> <td>&nbsp;</td> <td>44</td> </tr> </tbody> </table> <p>ЖЕНСКАЯ ОБУВЬ</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> <td>примечание</td> </tr> <tr> <td>Perrone</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> </tr> </tbody> </table> " ["price"]=> string(9) "5400.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-05-24 11:13:00" ["viewed"]=> string(3) "553" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "255" [3]=> string(3) "411" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '255' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16746]=> array(49) { ["product_id"]=> string(5) "16746" ["name"]=> string(50) "Лоферы женские бежевые Perrone" ["description"]=> string(537) "<p>Классические лоферы от италянского бренда&nbsp;Perrone выполнены в приятной пастельной цветовой гамме. Акцент в образе - декоративная вставка на лицевой стороне. Плоская подошва с прорезиненными шипами. Эта модель станет прекрасным дополнением к деловому стилю своей обладательницы.</p> " ["characteristics"]=> string(478) "<ul> <li>Модель: лоферы;</li> <li>Цвет: бежевый;</li> <li>Узор: нет;</li> <li>Состав: кожа 100%;</li> <li>Подошва: резина;</li> <li>Сезонность: весна-лето;</li> <li>Бренд: Perrone;</li> <li>Страна бренда: Италия.</li> </ul> <p>&nbsp;</p> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Лоферы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "16746" ["sku"]=> string(17) "D852-1001-006/155" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(70) "catalog/dn8/fotosessija/2020/ijul/predmetka/zhenskaja_obuv/0584-ds.jpg" ["manufacturer_id"]=> string(3) "159" ["manufacturer"]=> string(7) "PERRONE" ["manufacturer_size_table"]=> string(1790) "<p>МУЖСКАЯ ОБУВЬ</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>39</td> <td>39.5</td> <td>40</td> <td>40.5</td> <td>41</td> <td>41.5</td> <td>42</td> <td>42.5</td> <td>43</td> <td>43.5</td> <td>44</td> <td>44.5</td> <td>45</td> <td>примечание</td> </tr> <tr> <td>Perrone</td> <td>39</td> <td>&nbsp;</td> <td>40</td> <td>&nbsp;</td> <td>41</td> <td>&nbsp;</td> <td>42</td> <td>&nbsp;</td> <td>43</td> <td>&nbsp;</td> <td>44</td> </tr> </tbody> </table> <p>ЖЕНСКАЯ ОБУВЬ</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> <td>примечание</td> </tr> <tr> <td>Perrone</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> </tr> </tbody> </table> " ["price"]=> string(9) "4660.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-07" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-07 10:34:37" ["date_modified"]=> string(19) "2021-05-21 14:56:13" ["viewed"]=> string(3) "648" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "255" [3]=> string(3) "411" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '255' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11685]=> array(49) { ["product_id"]=> string(5) "11685" ["name"]=> string(59) "Лоферы женские фиолетовые The Seller" ["description"]=> string(353) "<p>Слипоны женские из натуральной замши в тёмно-синем цвете. Модель украшена декоративной окантовкой в сине-перламутровом цвете с кисточками на носке.</p> <p>Высота каблука 2,5 см.</p> " ["characteristics"]=> string(508) "<ul> <li>Артикул S5526</li> <li>Код товара 11685</li> <li>Бренд: The Seller</li> <li>Страна: Италия</li> <li>Модель: лоферы</li> <li>Цвет: синий</li> <li>Материал: верх - кожа 100%; подкладка - кожа 100%; подошва &ndash; кожа/резина</li> <li>Стиль: кежуал</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(21) "Туфли The Seller" ["meta_h1"]=> string(12) "Лоферы" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11685" ["sku"]=> string(5) "S5526" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(53) "data/1c/utp008118_catalog_obuvmaj_img_0942_kopiya.jpg" ["manufacturer_id"]=> string(2) "45" ["manufacturer"]=> string(10) "The Seller" ["manufacturer_size_table"]=> string(1050) "<table class="women"> <tbody> <tr> <td>Международный (INT)</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> </tr> <tr> <td>The Seller</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>41,5</td> </tr> </tbody> </table> " ["price"]=> string(9) "5900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-28" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-08-25 15:48:11" ["viewed"]=> string(4) "1122" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "255" [3]=> string(3) "411" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '255' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [11339]=> array(49) { ["product_id"]=> string(5) "11339" ["name"]=> string(67) "Лоферы женские из кожи голубые Nando Muzi" ["description"]=> string(758) "<p>Женские туфли лоферы&nbsp;голубого цвета от итальянского бренда&nbsp;Nando Muzi просто не могут не поднять настроение как своей обладательнице, так и&nbsp;откружающим. Модель, которую вы&nbsp;видете перед собой на фото, имеет круглый носок&nbsp;с серебристой декорацией и обьемными нашивками и виде вертикальных полосок. Туфли лоферы Nando Muzi на удобной танкетке белого цвета с золотистой полоской.&nbsp;&nbsp;</p> " ["characteristics"]=> string(585) "<ul> <li>Модель: туфли на танкетке;</li> <li>Фасон: лоферы;</li> <li>Цвет: голубой, белый;</li> <li>Узор: нет;</li> <li>Состав: верх - кожа 100%; подкладка - кожа 100%;</li> <li>Подошва: резина;</li> <li>Сезонность: весна-лето;</li> <li>Бренд:&nbsp;Nando Muzi;</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(21) "Туфли Nando Muzi" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Лоферы" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "11339" ["sku"]=> string(7) "D159CHO" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "0" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(51) "data/1c/utp007860_catalog_loading_obyv_img_8911.jpg" ["manufacturer_id"]=> string(2) "20" ["manufacturer"]=> string(10) "Nando Muzi" ["manufacturer_size_table"]=> string(1169) "<table class="size-table"> <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>Nando Muzi</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) "8400.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-30" ["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) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-05-31 15:45:18" ["viewed"]=> string(4) "1447" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "83" [2]=> string(3) "255" [3]=> string(3) "411" } [0]=> string(2135) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '255' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }