SELECT products.product_id, descr1.product as product, products.product_type, products.parent_product_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (?:categories.usergroup_ids = '' OR FIND_IN_SET(0, ?:categories.usergroup_ids) OR FIND_IN_SET(1, ?:categories.usergroup_ids) OR FIND_IN_SET(3, ?:categories.usergroup_ids)) AND ?:categories.status IN ('A') LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1 AND products.amount >= 1 AND products.amount*products.list_price >= 200 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids) OR FIND_IN_SET(3, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1, 3) AND ?:product_required_products.product_id = 52985 ТОВАРЫ ДЛЯ СПОРТА И ОТДЫХА :: Товары для отдыха на природе :: Мангалы, шампуры, решётки, розжиг :: Решетка-барбекю /металл/дерево/ 25х35см /50/
SELECT products.product_id, descr1.product as product, products.product_type, products.parent_product_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (?:categories.usergroup_ids = '' OR FIND_IN_SET(0, ?:categories.usergroup_ids) OR FIND_IN_SET(1, ?:categories.usergroup_ids) OR FIND_IN_SET(3, ?:categories.usergroup_ids)) AND ?:categories.status IN ('A') WHERE 1 AND ?:categories.category_id IN (459) AND products.product_id NOT IN (52985) AND products.amount >= 1 AND products.amount*products.list_price >= 200 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids) OR FIND_IN_SET(3, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1, 3) AND products.parent_product_id = 0 LIMIT 0, 4
+7 (383) 240-81-19
все телефоны
Каталог товаров Меню
Вкл. розничный режим
Мобильный поиск

Решетка-барбекю /металл/дерево/ 25х35см /50/

-13%
-13%
Оптовые цены
29600руб-  заказ от 10`00000руб
28640руб-  заказ от 20`00000руб
27770руб-  заказ от 30`00000руб
От
+ −
шт.
  • Просмотреть список опций

Общие

Артикул:
030565

Похожие товары

Набор Шампуров 25см, 47шт Бамбук 35205-7/200/
072945
5700руб 7100руб
шт.
Горелка пьезо на листе 2Т-14 (45697) /10/100/
13823
43600руб 48700руб
шт.