Мужские рюкзаки

Сортировать:

Показывать:

array(4) { [15315]=> array(49) { ["product_id"]=> string(5) "15315" ["name"]=> string(35) "Сумка-рюкзак North Sails" ["description"]=> string(773) "<p>Сумка-рюкзак North Sails белого цвета с синими вставками и логотипом North sails - стильная и практичная модель, которая дополнит образ. Плоский дизайн. Анатомическая спинка, удобные лямки. Застегивается на молнию. Верх сумки закручивается в небольшой рулон. </p> <p>Если вас заинтересовала модель, приобрести сумку-рюкзак белого цвета с синими вставками и логотипом North sails вы сможете в нашем магазине.</p> " ["characteristics"]=> string(638) "<ul style="list-style-type:disc"> <li>Модель: мужской рюкзак;</li> <li>Фасон: мужская сумка-рюкзак;</li> <li>Цвет: белый, синий, красный;</li> <li>Узор: символика бренда North sails;</li> <li>Состав: поливинилхлорид 100%;</li> <li>Сезонность: весна-лето;</li> <li>Бренд: North sails (Норт Сейлз);</li> <li>Страна бренда: Италия</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(23) "Сумка-рюкзак" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15315" ["sku"]=> string(6) "631177" ["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/ao6b4932.jpg" ["manufacturer_id"]=> string(3) "131" ["manufacturer"]=> string(11) "North Sails" ["manufacturer_size_table"]=> string(2058) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>North Sails</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> <tr> <td>куртки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> <tr> <td>футболка/поло/пуловер/кардиган</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> <tr> <td>брюки/джинсы/шорты</td> <td> </td> <td> </td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(9) "3980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-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(4) "2600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-07-08 13:14:38" ["date_modified"]=> string(19) "2022-05-03 14:49:00" ["viewed"]=> string(3) "751" ["categories"]=> array(7) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "357" [3]=> string(3) "497" [4]=> string(3) "564" [5]=> string(3) "606" [6]=> string(3) "607" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '357' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14820]=> array(49) { ["product_id"]=> string(5) "14820" ["name"]=> string(39) "Рюкзак мужской North Sails" ["description"]=> string(814) "<p>Рюкзак мужской North Sails черный с синими вставками и символикой бренда North Sails из прочной водоотталкивающей ткани не пропускает влагу. Анатомическая спинка, много карманов внутри и снаружи. Удобные лямки, укрепленная ручка. Подходит как для похода на природу, так и для путешествий.</p> <p>Если вас заинтересовала модель, вы сможете заказать рюкзак мужской черный с синими вставками и символикой бренда North Sails в нашем магазине.</p> " ["characteristics"]=> string(647) "<ul style="list-style-type:disc"> <li>Модель: мужской рюкзак средних размеров;</li> <li>Фасон: спортивный рюкзак;</li> <li>Цвет: черный, синий;</li> <li>Узор: символика бренда North Sails;</li> <li>Состав: полиэстер 100%;</li> <li>Сезонность: демисезоныннй;</li> <li>Бренд: North Sails (Норт Сейлз);</li> <li>Страна бренда: Италия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Рюкзак" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14820" ["sku"]=> string(6) "631175" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "2" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(40) "catalog/predmetka_ijun_2019/ao6b4944.jpg" ["manufacturer_id"]=> string(3) "131" ["manufacturer"]=> string(11) "North Sails" ["manufacturer_size_table"]=> string(2058) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>North Sails</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> <tr> <td>куртки</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> <tr> <td>футболка/поло/пуловер/кардиган</td> <td> </td> <td> </td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td> </td> <td> </td> </tr> <tr> <td>брюки/джинсы/шорты</td> <td> </td> <td> </td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td> </td> <td> </td> </tr> </tbody> </table> " ["price"]=> string(9) "3500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-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(4) "2600" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2019-07-08 13:10:44" ["date_modified"]=> string(19) "2022-05-03 14:46:47" ["viewed"]=> string(3) "885" ["categories"]=> array(6) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "357" [3]=> string(3) "496" [4]=> string(3) "606" [5]=> string(3) "607" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '357' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15393]=> array(49) { ["product_id"]=> string(5) "15393" ["name"]=> string(52) "Рюкзак мужской тканевый Pacsafe" ["description"]=> string(1843) "<p>Идеальная модель для городских приключений. Внутренние карманы помогут сортировать вещи. Есть потайной карман для хранения ценностей. Все остальное защищено прочными молниями и другими противоугонными технологиями. Подходит для 10- и 15-дюймового ноутбука. Дополнительный мягкий чехол для переноски техники.</p> <p>Накладка для багажа. Внешние крепления для небольших предметов таких, как зонтик, дождевик, шапка и т. д. Крепления на плечевом ремне для бутылки с водой, чехол для телефона и т. д. Слот для карт, билетов, ключей от отеля и других пропускных документов. Внутри много отделений, которые помогают организовать пространство и сохранить вещи от повреждения. Сверху петля для переноски в руках. Боковой карман для бутылки с водой или маленького зонтика.</p> <p>Материал, устойчивый к порезам. Прочные молнии с замками. анкерный ремень для фиксации вокруг неподвижной опоры. RFID карман для защиты данных от сканирования. Потайной карман для хранения особо ценных вещей. </p> " ["characteristics"]=> string(922) "<ul> <li>Фасон: рюкзак на 2 лямки;</li> <li>Цвет: зеленый (оливковый);</li> <li>Принт: символика бренда Pacsafe;</li> <li>Материал верха: нейлон 100%;</li> <li>Подкладка: переработанный полиэстер 100%;</li> <li>Вес: 0, 73 кг;</li> <li>Объем: 20 л;</li> <li>Длина ремня (минимум): 61,5 см;</li> <li>Длина ремня (максимум): 82 см;</li> <li>Размеры: 42 х 29,5 х 13 см;</li> <li>Сезонность: внесезонная;</li> <li>Бренд: Pacsafe (Пасксэйф);</li> <li>Страна бренда: Китай.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Рюкзак" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "15393" ["sku"]=> string(8) "30640136" ["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(44) "catalog/dn8/rjukzakipacksave/packsafe_25.jpg" ["manufacturer_id"]=> string(3) "147" ["manufacturer"]=> string(7) "Pacsafe" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "3980.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-10-04" ["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-10-04 14:37:33" ["date_modified"]=> string(19) "2021-08-10 11:45:35" ["viewed"]=> string(4) "1120" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "357" [3]=> string(3) "497" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '357' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [12819]=> array(49) { ["product_id"]=> string(5) "12819" ["name"]=> string(37) "Рюкзак мужской GreenLand" ["description"]=> string(588) "<p>Мужской рюкзак GreenLand выполнен из натуральной кожи. Имеет 1 основное отделение, закрывается на молнию. С лицевой стороны вместительные карманы на молнии. Подкладка - текстиль. Шлейки регулируются по длине. Если вам понравилась модель, приобрести Рюкзак GreenLand можно на сайте нашего магазина. Удачных покупок!</p> " ["characteristics"]=> string(565) "<ul> <li>Модель: рюкзак для мужчин;</li> <li>Цвет: коричневый</li> <li>Принт: символика бренда;</li> <li>Материал: кожа 100%;</li> <li>Размер: <span style="font-family:Helvetica">26х33х9 см (ВхШхГ) </span></li> <li>Бренд: Greenland (Гринленд);</li> <li>Страна бренда: Германия.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Рюкзак" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "12819" ["sku"]=> string(4) "2913" ["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(53) "data/1c/utp009636_catalog_predmetka_1203_ao6b9195.jpg" ["manufacturer_id"]=> string(2) "68" ["manufacturer"]=> string(9) "GreenLand" ["manufacturer_size_table"]=> string(0) "" ["price"]=> string(9) "5000.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-29" ["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-08-29 16:37:17" ["date_modified"]=> string(19) "2022-01-18 13:45:57" ["viewed"]=> string(4) "1215" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "357" [3]=> string(3) "497" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM dn_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '357' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }