Женские сумки

array(12) { [11843]=> array(49) { ["product_id"]=> string(5) "11843" ["name"]=> string(96) "Сумка шопер женская в цвете пудра с косметичкой Chiara P" ["description"]=> string(1326) "<div><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Женская сумка шопер в цвете пудра. Выполнена из экокожи, застёжка на магнит. Сумка имеет две ручки, съёмный регулируемый плечевой ремень, просторное открытое отделение и косметичку на молнии.</span></span></div> <p><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Сумка украшена по бокам металлическими заклёпками, перфорацией и имеет декоративный элемент &ndash; кисточки на ручке.</span></span></p> <p><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Если вам понравилась сумка шопер женская в цвете пудра с косметичкой Chiara P, приобрести модель&nbsp;можно на сайте нашего магазина. Удачных покупок!</span></span></p> " ["characteristics"]=> string(2141) "<ul style="list-style-type:disc"> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Код товара: 11843</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Артикул: 93122 cipria</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Бренд: Chiara P</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Страна: Италия</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Модель: сумка</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Цвет: пудровый</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Материал: полиуретан</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Стиль: кэжуал</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Длина 43 см;</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Ширина 10 см;</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Высота 35 см.</span></span></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(137) "Сумка, шопер, женская, пудра, бежевая, пудровая, с косметичкой, экокожа, Chiara P" ["model"]=> string(5) "11843" ["sku"]=> string(12) "93122 cipria" ["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/sumki4etazh/93122cipria.jpg" ["manufacturer_id"]=> string(2) "40" ["manufacturer"]=> string(9) "Chiara P." ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "3600.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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-04-07 10:29:15" ["viewed"]=> string(4) "1233" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } [11842]=> array(49) { ["product_id"]=> string(5) "11842" ["name"]=> string(82) "Сумка шопер женская белая с косметичкой Chiara P" ["description"]=> string(1362) "<p><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Женская&nbsp;сумка шопер&nbsp;белого цвета. Выполнена из&nbsp;экокожи, застёжка на&nbsp;магнит. Сумка имеет две ручки, съёмный&nbsp;регулируемый плечевой ремень, просторное открытое отделение и косметичку на молнии.</span></span></p> <p><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Сумка украшена по бокам металлическими заклёпками, перфорацией и имеет декоративный элемент &ndash;&nbsp;кисточки на ручке.</span></span></p> <p><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Если вам понравилась сумка шопер женская белая с косметичкой Chiara P , приобрести модель&nbsp;можно на сайте нашего магазина. Удачных покупок!</span></span></p> " ["characteristics"]=> string(2144) "<ul style="list-style-type:disc"> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Код товара: 11842</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Артикул: 93122 panna&nbsp;</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Бренд: Chiara P</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Страна: Италия</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Модель: сумка</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Цвет: белый</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Материал: полиуретан</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Стиль: кэжуал</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Длина 43 см;</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Ширина 10 см;</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif">Высота 35 см.</span></span></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(87) "Сумка, шопер, женская, белая, с косметичкой, Chiara P" ["model"]=> string(5) "11842" ["sku"]=> string(11) "93122 panna" ["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(59) "catalog/dn8/fotosessija/2020/maj/sumki4etazh/93122panna.jpg" ["manufacturer_id"]=> string(2) "40" ["manufacturer"]=> string(9) "Chiara P." ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "3600.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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-05-18 10:32:25" ["date_modified"]=> string(19) "2021-04-07 10:22:28" ["viewed"]=> string(3) "780" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } [15025]=> array(49) { ["product_id"]=> string(5) "15025" ["name"]=> string(101) "Сумка женская черного цвета на молнии и кнопке Gianni Chiarini" ["description"]=> string(1116) "<p>Сумка женская черного цвета на молнии и кнопке Gianni Chiarini из фактурной кожи с золотистой прочной фурнитурой. Дневная сумка, но благодаря черному цвету вы смело сможете брать ее на вечерние прогулки или встречи с друзьями. Жесткая модель, хорошо держит форму. Сверху удобная ручка и съемный длинный ремень. Застегивается сверху на молнию и кнопку-магнит. По бокам вертикальные отсеки на молнии. Спереди логотип бренда.</p> <p>Добавить акцентов образу и приобрести сумку женскую черного цвета на молнии и кнопке Gianni Chiarini вы сможете у нас. Желаем удачных покупок!</p> <ul style="list-style-type:disc"> </ul> " ["characteristics"]=> string(643) "<ul> <li>Модель: твердая женская сумка;</li> <li>Фасон: перевернутая трапеция;</li> <li>Узор: фактурная кожа;</li> <li>Состав: 100% кожа;</li> <li>Сезонность: внесезонная;</li> <li>Бренд: Gianni Chiarini (Джанни Кьярини);</li> <li>Страна бренда: Италия.</li> <li>Длина 42см;</li> <li>Ширина 13 см;</li> <li>Высота 32 см.</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) "15025" ["sku"]=> string(17) "BS 6841 GOLX NERO" ["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(41) "catalog/aimage/f10/ao6b4674-1000x1500.jpg" ["manufacturer_id"]=> string(2) "63" ["manufacturer"]=> string(15) "Gianni Chiarini" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "5900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-03-27" ["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-03-27 10:21:56" ["date_modified"]=> string(19) "2021-05-14 12:19:24" ["viewed"]=> string(3) "833" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } [15024]=> array(49) { ["product_id"]=> string(5) "15024" ["name"]=> string(115) "Сумка женская светло-коричневого цвета на одной ручке Gianni Chiarini" ["description"]=> string(924) "<p>Сумка женская светло-коричневого цвета на одной ручке Gianni Chiarini из высококачественной кожи с золотистой добротной фурнитурой. Сверху застегивается на молнию и дополнительно фиксируется на кнопку-магнит. Кроме основной ручки есть съемный ремень, длину которого можно регулировать и носить изделие через плечо. Спереди логотип бренда.&nbsp;Дневная плоская сумка украсит ваш образ.</p> <p>Заказать сумку женскую светло-коричневого цвета на одной ручке Gianni Chiarini можн в нашем магазине.&nbsp;</p> " ["characteristics"]=> string(813) "<ul style="list-style-type:disc"> <li>Модель: повседневная вместительная сумка;</li> <li>Фасон: твердая сумка с одной ручкой;</li> <li>Цвет: светло-коричневый (горчичный);</li> <li>Узор: фактурная кожа;</li> <li>Состав: кожа 100%;</li> <li>Сезонность: внесезонная;</li> <li>Бренд:&nbsp;Gianni Chiarini (Джанни Кьярини);</li> <li>Страна бренда: Италия.</li> <li>Длина 42см;</li> <li>Ширина 13 см;</li> <li>Высота 32 см.</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) "15024" ["sku"]=> string(18) "BS 6841 GOLX CAMEL" ["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(37) "catalog/aimage/ao6b4879-1000x1500.jpg" ["manufacturer_id"]=> string(2) "63" ["manufacturer"]=> string(15) "Gianni Chiarini" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "5900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-03-27" ["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-03-27 10:21:56" ["date_modified"]=> string(19) "2021-05-14 12:18:31" ["viewed"]=> string(3) "737" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } [15015]=> array(49) { ["product_id"]=> string(5) "15015" ["name"]=> string(89) "Сумка женская объемная из зеленой ткани Gianni Chiarini" ["description"]=> string(702) "<p>Сумка женская объемная из зеленой ткани Gianni Chiarini - удобная&nbsp;вместительная женская сумка.&nbsp;&nbsp;Вы можете носить ее на плече, держа за ручки. по бокам декорирована молниями и кожаными вставками.</p> <p>Приобрести сумку&nbsp;женскую&nbsp;объемную&nbsp;из зеленой ткани с кожаными вставками и длинной ручкой Gianni Chiarini&nbsp;вы сможете у нас. Желаем удачных покупок!</p> " ["characteristics"]=> string(537) "<ul> <li>Модель:&nbsp;объемная женская сумка;</li> <li>Фасон: прямоугольная сумка;</li> <li>Сезонность: внесезонная;</li> <li>Бренд: Gianni Chiarini (Джанни Кьярини);</li> <li>Страна бренда: Италия.</li> <li>Длина 40 см;</li> <li>Ширина 20 см;</li> <li>Высота 33 см.</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) "15015" ["sku"]=> string(14) "BS 6792 TS-NUV" ["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(37) "catalog/aimage/ao6b4905-1000x1500.jpg" ["manufacturer_id"]=> string(2) "63" ["manufacturer"]=> string(15) "Gianni Chiarini" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "5100.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-03-27" ["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-03-27 10:21:56" ["date_modified"]=> string(19) "2021-05-19 13:57:01" ["viewed"]=> string(3) "516" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } [16152]=> array(49) { ["product_id"]=> string(5) "16152" ["name"]=> string(60) "Сумка женская полосатая Andrea Cordone " ["description"]=> string(692) "<p>Сумка женская полосатая Andrea Cordone - вы можете носить держа за ручки, или на плечо. Декорирована&nbsp;вставками с анималистическим принтом &quot;Зебра&quot;. Внутрии маленький кошелек.</p> <p>Чтобы оформить заказ, заполните заявку самостоятельно или&nbsp; с помощью нашего консультанта. Мы осуществляем доставку не только по Киеву, но и по всей Украине (Новая Почта).</p> " ["characteristics"]=> string(718) "<ul> <li>Модель:&nbsp;женская сумка шопер;</li> <li>Фасон: женская сумка объмная;</li> <li>Цвет: черный;</li> <li>Узор: анималистический принт, зебра;</li> <li>Состав: кожа 100%;</li> <li>Сезонность: внесезона;</li> <li>Бренд: Andrea Cordone (Андреа Кордоне);</li> <li>Страна бренда: Италия.</li> <li>Длина 42 см;</li> <li>Ширина 16 см;</li> <li>Высота 34 см.</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(146) "Сумка, женская, полосатая, Andrea Cordone, брендовая, сумочка, зебра, стильная, заказать" ["model"]=> string(5) "16152" ["sku"]=> string(4) "1156" ["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(65) "catalog/dn8/fotosessija/2019/predmetka_1etazh/img_3261-kopija.jpg" ["manufacturer_id"]=> NULL ["manufacturer"]=> NULL ["manufacturer_size_table"]=> NULL ["price"]=> string(9) "4150.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-16" ["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) "2019-12-16 13:19:43" ["date_modified"]=> string(19) "2021-05-19 14:06:08" ["viewed"]=> string(3) "341" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } [15016]=> array(49) { ["product_id"]=> string(5) "15016" ["name"]=> string(52) "Сумка женская белая Gianni Chiarini" ["description"]=> string(730) "<p>Сумка женская белого цвета из гладкой кожи Gianni Chiarini подходит как для дневного, так и для вечернего выхода. По форме сумка треугольная. Жесткая форма хорошо держит форму. Застегивается на кнопку-магнит и дополнительная фиксация на молнию.&nbsp;</p> <p>Купить сумку женскую белого цвета из гладкой кожи Gianni Chiarini вы сможете в нашем магазине, оформив заказ удобным для вас способом.&nbsp;</p> " ["characteristics"]=> string(701) "<ul style="list-style-type:disc"> <li>Модель: маленькая женская сумка;</li> <li>Фасон: клатч конверт;</li> <li>Цвет: белый;</li> <li>Узор: нет;</li> <li>Состав: кожа 100%;</li> <li>Сезонность: весна-лето;</li> <li>Бренд:&nbsp;Gianni Chiarini (Джанни Кьярини);</li> <li>Страна бренда: Италия.</li> <li>Длина 30 см;</li> <li>Ширина 13 см;</li> <li>Высота 25 см.</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) "15016" ["sku"]=> string(11) "BS 6786 LTS" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(40) "catalog/predmetka_ijun_2019/ao6b4808.jpg" ["manufacturer_id"]=> string(2) "63" ["manufacturer"]=> string(15) "Gianni Chiarini" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "5900.0000" ["special"]=> NULL ["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) "2019-07-01 10:30:10" ["date_modified"]=> string(19) "2021-05-14 12:01:33" ["viewed"]=> string(3) "881" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } [15856]=> array(49) { ["product_id"]=> string(5) "15856" ["name"]=> string(74) "Женская кожаная сумка с ручками Gianni Chiarini" ["description"]=> string(805) "<p>Женская кожаная сумка с ручками Gianni Chiarini- актуальна для повседневного лука и для вечернего выхода. Несмотря на компактные размеры, модель удобная и вместительная имеет интересную форму. Есть ручки для переноски. Застегивается на молнию.</p> <p>Чтобы оформить заказ, заполните заявку самостоятельно или&nbsp;&nbsp;с помощью нашего консультанта. Мы осуществляем доставку не только по Киеву, но и по всей Украине (Новая Почта).</p> " ["characteristics"]=> string(679) "<ul> <li>Модель:&nbsp;женская сумка на плечо;</li> <li>Фасон: женская сумка с ручками;</li> <li>Цвет: фуксия;</li> <li>Узор: нет;</li> <li>Состав: кожа 100%;</li> <li>Сезонность: весна-лето;</li> <li>Бренд: Gianni Chiarini (Джанни Кьярини);</li> <li>Страна бренда: Италия.</li> <li>Длина 29 см;</li> <li>Ширина 15 см;</li> <li>Высота 20 см.</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(128) "Женская, кожаная, сумка квадратной формы Gianni Chiarini, брендовая, заказать" ["model"]=> string(5) "15856" ["sku"]=> string(11) "BS 7450 FRZ" ["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(58) "catalog/dn8/fotosessija/2019/predmetka_4etazh/img_3401.jpg" ["manufacturer_id"]=> string(2) "63" ["manufacturer"]=> string(15) "Gianni Chiarini" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "4500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-12-16" ["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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-12-16 13:28:41" ["date_modified"]=> string(19) "2021-05-14 12:27:03" ["viewed"]=> string(3) "649" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } [15188]=> array(49) { ["product_id"]=> string(5) "15188" ["name"]=> string(77) "Сумка женская плетеная черного цвета Seafolly" ["description"]=> string(742) "<p>Сумка женская плетеная черного цвета Seafolly -&nbsp; вечная классика. Вместительный и вместе с тем компактный аксессуар, который привлечет к вам внимание окружающих. Изделие хорошо растягивается, заменит неудобные пакеты. Длинные ручки, широкая вязка.</p> <p>Купить&nbsp;сумку женскую плетеную черного цвета Seafolly вы сможете в нашем магазине через сайт или по телефону.&nbsp;</p> <p>&nbsp;</p> " ["characteristics"]=> string(637) "<ul style="list-style-type:disc"> <li>Модель: плетеная сумка;</li> <li>Фасон: сумка-сетка (авоська);</li> <li>Цвет: черный;</li> <li>Узор: нет;</li> <li>Сезонность: демисезонная;</li> <li>Бренд:&nbsp;Seafolly (Сифолли);</li> <li>Страна бренда: Австралия.</li> <li>Длина 37 см;</li> <li>Ширина 1 см;</li> <li>Высота 45 см.</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) "15188" ["sku"]=> string(8) "71417-BG" ["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/ao6b6030.jpg" ["manufacturer_id"]=> string(2) "26" ["manufacturer"]=> string(8) "Seafolly" ["manufacturer_size_table"]=> string(1696) "<p>Нижнее белье и купальники</p> <table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примечание</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>соответствуют</td> </tr> </tbody> </table> <p>Пляжная обувь</p> <table class="men"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>2XL</td> <td>3XL</td> <td>примечание</td> </tr> <tr> <td>SeaFolly</td> <td>&nbsp;</td> <td>6</td> <td>8</td> <td>10</td> <td>12</td> <td>14</td> <td>16</td> <td>18</td> <td>соответствуют</td> </tr> </tbody> </table> " ["price"]=> string(9) "1200.0000" ["special"]=> string(8) "840.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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-07-01 11:57:52" ["date_modified"]=> string(19) "2021-04-06 16:21:47" ["viewed"]=> string(3) "976" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } [7201]=> array(49) { ["product_id"]=> string(4) "7201" ["name"]=> string(77) "Сумка женская серебристого цвета Gianni Chiarini" ["description"]=> string(2240) "<p>Сумка женская серебристого цвета Gianni Chiarini - универсальная модель, которую можно носить как в руках, так и через плечо. Длинный ремень можно регулировать по своему усмотрению. Изделие можно носить как в руках, так на плече. Жесткая сумка хорошо держит форму.&nbsp;</p> <p>В процессе обработки материала образовался оригинальный рисунок. Лаковое покрытие не вытирается и сохранит надолго презентабельный внешний вид.&nbsp;Молнии, карабины, затяжки для <strong>сумки</strong> выполнены из прочного металла серебристого цвета. Простые и удобные в использовании, не затираются и не линяют.</p> <p>Легко комбинировать с разными вариантами лука. Аксессуар служит завершающим акцентом как в образе с <a href="https://dn8.ua/palto-zhenskoe-luisa-cerano-12731" target="_blank">элегантным черным пальто</a>, так и в весенне-летнем образе с <a href="https://dn8.ua/zhaket-zh-n-kossa-13946" target="_blank">женским жакетом в клетку.</a>&nbsp;</p> <p>Если вас заинтересовала модель, купить женскую сумку с короткой ручкой и длинным ремешком Gianni Chiarini вы сможете на сайте нашего магазина. Заполнить форму на покупку можно как по телефону, так и на через корзину. Доставка работает по Киеву и по регионам Украины (Новая Почта).&nbsp;</p> <p>&nbsp;</p> " ["characteristics"]=> string(732) "<ul> <li>Модель: женская сумка на каждый день;</li> <li>Фасон: сумка-трапеция, сумка через плечо;</li> <li>Цвет: серый, серебристый (металлик);</li> <li>Принт: вертикальная полоска;</li> <li>Материал: кожа 100%;</li> <li>Бренд:&nbsp;Gianni Chiarini (Джанни Кьярини);</li> <li>Страна бренда: Италия.&nbsp;</li> <li>Длина 29 см;</li> <li>Ширина 15 см;</li> <li>Высота 20 см.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(41) "Сумка женская Gianni Chiarini" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Сумка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "7201" ["sku"]=> string(7) "BS 5005" ["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(39) "catalog/foto20-21predmetka/ao6b7614.jpg" ["manufacturer_id"]=> string(2) "63" ["manufacturer"]=> string(15) "Gianni Chiarini" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "4500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-13" ["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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2018-11-13 09:58:29" ["date_modified"]=> string(19) "2021-05-19 14:11:03" ["viewed"]=> string(4) "1287" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } [12632]=> array(49) { ["product_id"]=> string(5) "12632" ["name"]=> string(99) "Сумка женская кожаная черного цвета металлик Gianni Chiarini" ["description"]=> string(1952) "<p>Сумка женская кожаная черного цвета металлик Gianni Chiarini - объемная сумка прямоугольной формы - стильная модель на каждый день. Подходит как для офиса, так и для встреч в неформальной обстановке. Дополнит образ и акцентирует внимание на практичности и удобстве. Вы смело можете комбинировать аксессуар как с элегантным <a href="https://dn8.ua/palto-zhenskoe-rich-and-royal-12596" target="_blank">пальто темно-красного цвета</a>, так и с более кэжуальным вариантом - укороченной курткой-пуховиком <a href="https://dn8.ua/kurtka-zh-n-reset-14282" target="_blank">нежно-персикового цвета</a>.</p> <p>Фактурная кожа смотрится эффектно и привлекает внимание внимание окружающих. Крупные элементы фурнитуры выполнены из металла. Сумка застегивается сверху на молнию. Мягкая и удобная, кожа не линяет, не протирается и надолго сохраняет презентабельный внешний вид.</p> <p>Если вас заинтересовала модель, купить&nbsp;сумку сумку из кожи черного цвета с ремнем и короткими ручками Gianni Chiarini можно в нашем магазине. Работает доставка по Киеву и по регионам Украины.&nbsp;</p> <p>&nbsp;</p> " ["characteristics"]=> string(755) "<ul> <li>Модель: женская сумка для повседневной носки;</li> <li>Фасон: сумка-шопер с ремнем через плечо и короткими ручками;</li> <li>Цвет: черный металлик;</li> <li>Принт: фактурная кожа;</li> <li>Материал: кожа 100%;</li> <li>Бренд:&nbsp;Gianni Chiarini (Джанни Кьярини);</li> <li>Страна бренда: Италия.</li> <li>Длина 46 см;</li> <li>Ширина 10&nbsp;см;</li> <li>Высота 37&nbsp;см.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(41) "Сумка женская Gianni Chiarini" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Сумка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "12632" ["sku"]=> string(27) "BS 5846/17AI GKL-SE ACCIAIO" ["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(39) "catalog/foto20-21predmetka/ao6b7698.jpg" ["manufacturer_id"]=> string(2) "63" ["manufacturer"]=> string(15) "Gianni Chiarini" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "5600.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-13" ["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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2018-11-13 09:58:29" ["date_modified"]=> string(19) "2021-05-19 14:28:05" ["viewed"]=> string(4) "1104" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } [12634]=> array(49) { ["product_id"]=> string(5) "12634" ["name"]=> string(73) "Сумка женская кожаная бордовая Gianni Chiarini" ["description"]=> string(2123) "<p>мка женская кожаная бордовая Gianni Chiarini - эластичная, приятная на ощупь кожа. В процессе выделки на ее поверхности образовались мелкие морщинки, которые и сформировали необычный рисунок.&nbsp;</p> <p>Карабины, молнии, затяжки для сумки выполнены из прочного металла, что гарантирует долгую носку и удобство в использовании. <strong>Сумка</strong> застегивается на молнию.&nbsp;</p> <p>Повседневная сумка полу жесткая, хорошо держит форму. Можно использовать в качестве дневной модели для завершения стильного образа. Хорошо смотрится как со <a href="https://dn8.ua/kurtka-zh-n-reset-14280" target="_blank">стеганой курткой-пуховиком</a>, так и с элегантным <a href="https://dn8.ua/palto-dvubortnoe-na-4-pugovicy-zheltoe-blend-she-14207" target="_blank">пальто двубортным пальто желтого цвета</a>. Плоская <strong>сумка - </strong>комфортная и вместительная, универсальный вариант на каждый день.&nbsp;</p> <p>Если вас заинтересовала модель, купить кожаную женскую сумку бордового цвета от Gianni Chiarini можно на сайте нашего магазина. Оформить заказ по телефону помогут наши менеджеры или вы сможете сделать это самостоятельно. Доставка работает по Киеву и по регионам Украины.&nbsp;</p> " ["characteristics"]=> string(745) "<ul> <li>Модель: женская <strong>сумка</strong> на каждый день;</li> <li>Фасон: сумка-шопер с короткими ручками и длинным ремнем;</li> <li>Цвет: бордовый;</li> <li>Принт: фактурная выделка кожи;</li> <li>Материал: кожа 100%;</li> <li>Бренд:&nbsp;Gianni Chiarini (Джанни Кьярини);</li> <li>Страна бренда: Италия.</li> <li>Длина 46 см;</li> <li>Ширина 10 см;</li> <li>Высота 37 см.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(41) "Сумка женская Gianni Chiarini" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Сумка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "12634" ["sku"]=> string(25) "BS 5846/17AI MKG BORDEAUX" ["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(39) "catalog/foto20-21predmetka/ao6b7693.jpg" ["manufacturer_id"]=> string(2) "63" ["manufacturer"]=> string(15) "Gianni Chiarini" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "5600.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-13" ["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) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2018-11-13 09:58:29" ["date_modified"]=> string(19) "2021-05-19 14:10:29" ["viewed"]=> string(4) "1149" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "84" [2]=> string(3) "270" [3]=> string(3) "416" } [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 = '416' 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" } }