Terrida

array(9) { [1558]=> array(49) { ["product_id"]=> string(4) "1558" ["name"]=> string(53) "Чемодан кожаный с ручкой Terrida" ["description"]=> string(1188) "<p><strong>Чемодан троллей (trolly) от Terrida </strong>из линии Carbonio предназначен для перевозки багажа.</p> <p>Верх сшит из кожи теленка растительного дубления и карбонового волокна. Чемодан оборудован роликами и выдвижной ручкой.</p> <p>За счет применения карбонового волокна чемодан <strong>очень легкий</strong>. Основное отделение и внешний карман застегиваются на молнию.</p> <p>Чемодан существует в <strong>коричнево</strong>-<strong>черном, бордово-черном и желто-черном</strong> цветах. Для каждого цветового решения существуют дополнения &ndash; <strong>брифкейс,&nbsp; дорожная сумка и портплед из кожи того же цвета.</strong></p> " ["characteristics"]=> string(578) "<ul> <li>Код товара: 1558</li> <li>Артикул:&nbsp;CB1107&nbsp;</li> <li>Бренд: Terrida</li> <li>Страна: Италия</li> <li>Цвет: желто-черный, бордово-черный, коричнево-черный</li> <li>Материал: кожа теленка +карбоновое волокно</li> <li>Размер: 34Х54Х24</li> <li>Стиль: багаж путешественника</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(51) "/image/catalog/videoproduct/1558-4077-7161-1781.mp4" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(14) "Чемодан" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(49) "Чемодан, кожаный, Terrida, кожа" ["model"]=> string(4) "1558" ["sku"]=> string(6) "CB1107" ["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(53) "data/1c/utp005158_catalog_predmetka_1203_ao6b9342.jpg" ["manufacturer_id"]=> string(2) "17" ["manufacturer"]=> string(7) "Terrida" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(10) "46900.0000" ["special"]=> string(10) "28140.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-08" ["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) "2018-11-08 16:20:29" ["date_modified"]=> string(19) "2021-08-31 15:08:34" ["viewed"]=> string(4) "1306" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "344" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '17'ORDER BY p.sort_order DESC LIMIT 0,12" } [4077]=> array(49) { ["product_id"]=> string(4) "4077" ["name"]=> string(57) "Мужской брикфейс на молнии Terrida" ["description"]=> string(1226) "<p><strong>Брифкейс от Terrida из линии Carbonio </strong>предназначен для перевозки багажа путешественника в комплекте с чемоданом или отдельно.</p> <p>Верх сшит из кожи теленка <strong>растительного дубления и карбонового волокна</strong>. Переноска за <strong>двойные ручки или регулируемый наплечный ремень</strong>. Основное отделение застегивается на молнию. Предусмотрено&nbsp;<strong>крепление велкро</strong>&nbsp;за ручку чемодана.</p> <p>Брикфейс существует в <strong>желто-черном и коричнево-черном вариантах.</strong> Для каждого цветовой линии существуют дополнения &ndash; ч<strong>емодан, дорожная сумка и портплед из кожи того же цвета.</strong></p> " ["characteristics"]=> string(558) "<ul> <li>Код товара: 4077&nbsp;</li> <li>Артикул:&nbsp;CB1109&nbsp;</li> <li>Бренд: Terrida</li> <li>Страна: Италия</li> <li>Цвет: желто-черный, коричнево-черный</li> <li>Материал: кожа теленка +карбоновое волокно</li> <li>Размер: 41Х30Х8</li> <li>Стиль: багаж путешественника</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(51) "/image/catalog/videoproduct/1558-4077-7161-1781.mp4" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Брикфейс" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(96) "Мужской, кожаный, портфель, Terrida, с ручкой, с ремешком " ["model"]=> string(4) "4077" ["sku"]=> string(6) "CB1109" ["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(70) "catalog/dn8/fotosessija/2020/maj/2-jetazhterrida/cb1109(giallo)(3).jpg" ["manufacturer_id"]=> string(2) "17" ["manufacturer"]=> string(7) "Terrida" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(10) "14900.0000" ["special"]=> string(9) "8940.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-08" ["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) "2018-11-08 16:20:29" ["date_modified"]=> string(19) "2021-08-10 10:49:04" ["viewed"]=> string(3) "891" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "314" [3]=> string(3) "495" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '17'ORDER BY p.sort_order DESC LIMIT 0,12" } [7161]=> array(49) { ["product_id"]=> string(4) "7161" ["name"]=> string(42) "Портплед на молнии Terrida" ["description"]=> string(936) "<ul> </ul> <p>Портплед от Terrida из линии <strong>Carbonio</strong> предназначен для перевозки выглаженной одежды. Сшита из кожи теленка растительного дубления.</p> <p>Переноска двойные ручки или регулируемый наплечный ремень. Основное отделение и внешние карманы застегивается на молнию. Портплед существует коричневом и желтом цвете.</p> <p>Может использоваться самостоятельно или&nbsp; в комплекте с ч<strong>емоданом, дорожной сумкой, брикфейсом и портпледом из кожи того же цвета.</strong></p> " ["characteristics"]=> string(475) "<ul> <li>Код товара: 7161&nbsp;</li> <li>Артикул:&nbsp;LE1003</li> <li>Бренд: Terrida</li> <li>Страна: Италия</li> <li>Цвет: коричневый</li> <li>Материал: кожа теленка</li> <li>Размер: 92Х50Х4</li> <li>Стиль: багаж путешественника</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(51) "/image/catalog/videoproduct/1558-4077-7161-1781.mp4" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Портплед" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(94) "портплед, портфель, кофр, кожаный, мужской, дорожный" ["model"]=> string(4) "7161" ["sku"]=> string(5) "LE003" ["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(67) "catalog/dn8/fotosessija/2020/maj/2-jetazhterrida/le003(marrone).jpg" ["manufacturer_id"]=> string(2) "17" ["manufacturer"]=> string(7) "Terrida" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(10) "25900.0000" ["special"]=> string(10) "15540.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-11-08" ["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) "2018-11-08 16:20:29" ["date_modified"]=> string(19) "2021-06-25 14:55:37" ["viewed"]=> string(4) "1140" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "314" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '17'ORDER BY p.sort_order DESC LIMIT 0,12" } [1781]=> array(49) { ["product_id"]=> string(4) "1781" ["name"]=> string(35) "Дорожная сумка Terrida" ["description"]=> string(1192) "<ul> </ul> <p><strong>Дорожная сумка от Terrida из линии Carbonio</strong> предназначен для перевозки багажа путешественника в комплекте с чемоданом или отдельно.</p> <p>Верх сшит из <strong>кожи теленка</strong> растительного дубления и карбонового волокна. Переноска за двойные ручки или регулируемый наплечный ремень.</p> <p>Основное отделение застегивается на молнию. Предусмотрено крепление велкро за ручку чемодана. <strong>Брикфейс</strong> существует в коричневом &ndash; черном и желто-черном цветах.</p> <p>Для каждого цветовой линии существуют дополнения - <strong>дорожная сумка и портплед</strong> из кожи того же цвета.</p> " ["characteristics"]=> string(627) "<ul style="list-style-type:disc"> <li>Код товара: 1781&nbsp;</li> <li>Артикул:&nbsp;CB1040&nbsp;</li> </ul> <ul> <li>Бренд: Terrida</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: коричнево-черный</li> <li>Материал: кожа теленка +карбоновое волокно</li> <li>Размер: 53Х32Х17</li> <li>Стиль: багаж путешественника</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(51) "/image/catalog/videoproduct/1558-4077-7161-1781.mp4" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Сумка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(84) "Дорожная, сумка, кожаная, с ручками, Terrida, бренд" ["model"]=> string(4) "1781" ["sku"]=> string(6) "CB1040" ["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(71) "catalog/dn8/fotosessija/2020/maj/2-jetazhterrida/cb1040(marrone)(3).jpg" ["manufacturer_id"]=> string(2) "17" ["manufacturer"]=> string(7) "Terrida" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(10) "17900.0000" ["special"]=> string(10) "10740.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-21" ["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-21 12:49:31" ["date_modified"]=> string(19) "2021-08-10 10:47:36" ["viewed"]=> string(3) "508" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "314" [3]=> string(3) "495" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '17'ORDER BY p.sort_order DESC LIMIT 0,12" } [4078]=> array(49) { ["product_id"]=> string(4) "4078" ["name"]=> string(39) "Брикфейс кожаный Terrida" ["description"]=> string(1052) "<p><strong>Брикфейс&nbsp; от Terrida из линии Ghost</strong> предназначен для перевозки багажа путешественника, в комплекте с чемоданом или отдельно. Верх сшит из тесненной кожи теленка растительного дубления,<strong> принт &laquo;риб&raquo;</strong>.</p> <p>Основное отделение и внешний карман застегивается на молнию. Переноска за двойные ручки или регулируемый наплечный ремень.</p> <p>Может использоваться отдельно или в комплекте с чемоданом и дорожной сумкой из кожи того же цвета.</p> <p>Заказать брикфейс кожаный Terrida на нашем сайте можно прямо сейчас.</p> " ["characteristics"]=> string(490) "<ul> <li>Код товара: 4078&nbsp;</li> <li>Артикул:&nbsp;GH1088&nbsp;</li> <li>Бренд: Terrida</li> <li>Страна: Италия</li> <li>Цвет: серо-голубой</li> <li>Материал: кожа теленка</li> <li>Размеры: 45Х29Х3</li> <li>Стиль: багаж путешественника</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Сумка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(129) "Портфель, мужской, прямоугольный, серый, с потертостями, Terrida, с ручками" ["model"]=> string(4) "4078" ["sku"]=> string(6) "GH1088" ["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(62) "catalog/dn8/fotosessija/2020/maj/2-jetazhterrida/gh1088(3).jpg" ["manufacturer_id"]=> string(2) "17" ["manufacturer"]=> string(7) "Terrida" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "8900.0000" ["special"]=> string(9) "5340.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-21" ["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-21 12:49:31" ["date_modified"]=> string(19) "2021-06-25 14:34:13" ["viewed"]=> string(3) "494" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "314" [3]=> string(3) "495" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '17'ORDER BY p.sort_order DESC LIMIT 0,12" } [1780]=> array(49) { ["product_id"]=> string(4) "1780" ["name"]=> string(36) "Сумка дорожная Terrida " ["description"]=> string(1042) "<p><strong>Дорожная сумка от Terrida </strong>из линии Carbonio предназначен для перевозки багажа путешественника в комплекте с чемоданом или отдельно. Верх сшит из <strong>кожи теленка растительного дубления и карбонового волокна.</strong></p> <p>Переноска за двойные ручки или за регулируемый<strong> наплечный ремень</strong>. Основное отделение и внешний карман застегиваются на молнию.</p> <p><strong>Дорожная сумка</strong> существует в бордовом и коричневом цвете. Входит в багажный комплект из <strong>чемодана, брифкейса</strong> из кожи того же цвета.</p> " ["characteristics"]=> string(611) "<ul style="list-style-type:disc"> <li>Код товара: 1780&nbsp;</li> <li>Артикул:&nbsp;CB079&nbsp;</li> </ul> <ul> <li>Бренд: Terrida</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: бордовый</li> <li>Материал: кожа теленка +карбоновое волокно</li> <li>Размер: 42Х30Х23</li> <li>Стиль: багаж путешественника</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Сумка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(129) "Дорожная, сумка, с дополнительным, отделением, Terrida, брендовая, мужская " ["model"]=> string(4) "1780" ["sku"]=> string(5) "CB079" ["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(65) "catalog/dn8/fotosessija/2020/maj/2-jetazhterrida/cb079(bordo).jpg" ["manufacturer_id"]=> string(2) "17" ["manufacturer"]=> string(7) "Terrida" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(10) "18900.0000" ["special"]=> string(10) "11340.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-21" ["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-21 12:49:31" ["date_modified"]=> string(19) "2021-01-25 10:10:44" ["viewed"]=> string(3) "480" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "314" [3]=> string(3) "495" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '17'ORDER BY p.sort_order DESC LIMIT 0,12" } [1783]=> array(49) { ["product_id"]=> string(4) "1783" ["name"]=> string(35) "Дорожная сумка Terrida" ["description"]=> string(843) "<p>Дорожная сумка&nbsp; от Terrida из линии <strong>Ghost</strong> предназначен для перевозки багажа путешественника. Верх сшит из тесненной кожи теленка растительного дубления, принт &laquo;риб&raquo;.</p> <p>Основное отделение и внешний карман застегивается на молнию. Переноска за двойные ручки или регулируемый наплечный ремень.</p> <p>Может использоваться отдельно или в комплекте с <strong>чемоданом и брикфейсом</strong> из кожи того же цвета.</p> " ["characteristics"]=> string(592) "<ul style="list-style-type:disc"> <li>Код товара: 1783&nbsp;</li> <li>Артикул:&nbsp;GH1131&nbsp;</li> </ul> <ul> <li>Бренд: Terrida</li> <li>Страна: Италия</li> </ul> <ul> <li>Цвет: серо-голубой</li> <li>Материал: кожа теленка&nbsp;</li> <li>Размер: 41Х30Х17</li> <li>Стиль: багаж путешественника</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Сумка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(93) "Дорожная, сумка, кожаная, серая, вместительная, Terrida" ["model"]=> string(4) "1783" ["sku"]=> string(6) "GH1131" ["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(62) "catalog/dn8/fotosessija/2020/maj/2-jetazhterrida/gh1131(3).jpg" ["manufacturer_id"]=> string(2) "17" ["manufacturer"]=> string(7) "Terrida" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(10) "15900.0000" ["special"]=> string(9) "9540.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-21" ["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-21 12:49:31" ["date_modified"]=> string(19) "2021-01-25 10:14:39" ["viewed"]=> string(3) "388" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "314" [3]=> string(3) "495" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '17'ORDER BY p.sort_order DESC LIMIT 0,12" } [1559]=> array(49) { ["product_id"]=> string(4) "1559" ["name"]=> string(84) "Чемодан из натуральной кожи на колесиках Terrida " ["description"]=> string(901) "<ul> </ul> <p><strong>Чемодан trolly (троллей) </strong>от Terrida из линии Ghost предназначен для перевозки багажа.</p> <p>Чемодан оборудован роликами и выдвижной ручкой.</p> <p>Верх сшит из тесненной кожи теленка растительного дубления, принт <strong>&laquo;риб&raquo;.</strong></p> <p>Основное отделение и внешний карман застегиваются на молнию.</p> <p>Для чемодана существует дополнение &ndash; дорожная &nbsp;<strong>сумка и брифкейс &nbsp;из кожи того же цвета.</strong></p> " ["characteristics"]=> string(498) "<ul> <li>Код товара: 1559&nbsp;</li> <li>Артикул:&nbsp;GH530&nbsp;</li> <li>Бренд: Terrida</li> <li>Страна: Италия</li> <li>Цвет: серо-голубой</li> <li>Материал: кожа теленка&nbsp;</li> <li>Размер: 38Х50Х21</li> <li>Стиль: багаж путешественника</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(100) "Чемодан, натуральная, кожа, с ручкой, на колесиках, Terrida " ["model"]=> string(4) "1559" ["sku"]=> string(5) "GH530" ["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(58) "catalog/dn8/fotosessija/2020/maj/2-jetazhterrida/gh530.jpg" ["manufacturer_id"]=> string(2) "17" ["manufacturer"]=> string(7) "Terrida" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(10) "28500.0000" ["special"]=> string(10) "17100.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-21" ["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-21 12:49:31" ["date_modified"]=> string(19) "2021-08-31 15:05:25" ["viewed"]=> string(3) "395" ["categories"]=> array(3) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "344" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '17'ORDER BY p.sort_order DESC LIMIT 0,12" } [7162]=> array(49) { ["product_id"]=> string(4) "7162" ["name"]=> string(48) "Сумка-планшет кожаная Terrida" ["description"]=> string(1032) "<ul> </ul> <p><strong>Сумка-планшет</strong> от <strong>Terrida </strong>из линии <strong>Carbonio&nbsp;</strong>предназначен для перевозки документов,</p> <p>Сшита из <strong>кожи</strong> <strong>теленка растительного дубления</strong>.Переноска за регулируемый наплечный ремень.</p> <p>Основное отделение и внешний карман застегивается на молнию. Сумка-планшет существует в&nbsp;бордовом цвете.</p> <p>Может использоваться самостоятельно или&nbsp;в комплекте с <strong>чемоданом, дорожной сумкой, брикфейсом &nbsp;из кожи того же цвета.</strong></p> " ["characteristics"]=> string(481) "<ul> <li>Код товара: 7162&nbsp;</li> <li>Артикул:&nbsp;LE1078&nbsp;</li> <li>Бренд: Terrida</li> <li>Страна: Италия</li> <li>Цвет: бордовый</li> <li>Материал: кожа теленка</li> <li>Размер: 20Х25Х6</li> <li>Стиль: багаж путешественника</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(25) "Сумка-планшет" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(77) "Сумка, с длинной ручкой, сумка-кофр, купить" ["model"]=> string(4) "7162" ["sku"]=> string(6) "LE1078" ["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(69) "catalog/dn8/fotosessija/2020/maj/2-jetazhterrida/le1078(bordo)(3).jpg" ["manufacturer_id"]=> string(2) "17" ["manufacturer"]=> string(7) "Terrida" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "8500.0000" ["special"]=> string(9) "5100.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-05-21" ["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-21 14:14:39" ["date_modified"]=> string(19) "2021-06-25 14:53:35" ["viewed"]=> string(3) "521" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "314" [3]=> string(3) "491" } [0]=> string(1919) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product p LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '17'ORDER BY p.sort_order DESC LIMIT 0,12" } }