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 = 58607 ТОВАРЫ ДЛЯ СПОРТА И ОТДЫХА :: Товары для отдыха на природе :: Мангалы, шампуры, решётки, розжиг :: Учаг под казан 38,5см 12-16л 1,5мм
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 (58607) 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
все телефоны
Каталог товаров Меню
Вкл. розничный режим
Мобильный поиск

Учаг под казан 38,5см 12-16л 1,5мм

-4%
-4%
Оптовые цены
2`88100руб-  заказ от 10`00000руб
2`79030руб-  заказ от 20`00000руб
2`61030руб-  заказ от 30`00000руб
От
+ −
шт.
  • Просмотреть список опций

Общие

Артикул:
81574
Материал:
Металл
Размер:
10л

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

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