string(1915) " SELECT p.customizable,p.gift_condition,p.free_shipping_condition,p.show_price,p.condition, p.minimal_quantity, p.available_for_order,pl.name,pl.description,i.id_image, p.price, p.ean13, p.id_product,p.out_of_stock,pa.id_product_attribute, p.cache_default_attribute,p.id_category_default,pl.link_rewrite,pl.`product_category_title`, count(distinct id_attribute_group) as count, ( (p.price/cur.conversion_rate) - IFNULL(sp.reduction,0) ) as product_price, IF(ROUND(AVG(rat.rating), 1), ROUND(AVG(rat.rating), 1), 0) as rating, (SELECT count(*) FROM ps_gomakoil_reviews gr WHERE gr.id_shop = 1 AND gr.moderation=1 AND gr.rating > 0 AND gr.id_product = p.id_product ) as rating_count FROM ps_product_lang as pl INNER JOIN ps_product as p ON p.id_product = pl.id_product LEFT JOIN ps_product_attribute as pa ON p.id_product = pa.id_product LEFT JOIN ps_product_attribute_combination as pac ON pac.id_product_attribute = pa.id_product_attribute LEFT JOIN ps_image as i ON p.id_product = i.id_product AND i.cover = 1 LEFT JOIN ps_category_product as c ON p.id_product = c.id_product LEFT JOIN ps_product_shop as ps ON p.id_product = ps.id_product LEFT JOIN ps_specific_price as sp ON p.id_product = sp.id_product LEFT JOIN ps_gomakoil_reviews as rat ON p.id_product = rat.id_product AND rat.rating > 0 AND rat.moderation=1 LEFT JOIN ps_attribute as ag ON pac.id_attribute = ag.id_attribute LEFT JOIN ps_currency cur ON p.currency_price = cur.id_currency WHERE pl.id_lang = 1 AND pl.id_shop = 1 AND c.id_category = 22 AND p.condition != "discontinued" AND pac.id_attribute IN(432,437) GROUP BY p.id_product HAVING (count = 2) ORDER BY available_for_order desc, price_by_request asc ,product_price DESC LIMIT 1 " string(1975) " SELECT p.customizable,p.gift_condition,p.free_shipping_condition,p.show_price,p.condition, p.minimal_quantity, p.available_for_order,pl.name,pl.description,i.id_image, p.price, p.ean13, p.id_product,p.out_of_stock,pa.id_product_attribute, p.cache_default_attribute,p.id_category_default,pl.link_rewrite,pl.`product_category_title`, count(distinct id_attribute_group) as count, ( (p.price/cur.conversion_rate) - IFNULL(sp.reduction,0) ) as product_price, IF(ROUND(AVG(rat.rating), 1), ROUND(AVG(rat.rating), 1), 0) as rating, (SELECT count(*) FROM ps_gomakoil_reviews gr WHERE gr.id_shop = 1 AND gr.moderation=1 AND gr.rating > 0 AND gr.id_product = p.id_product ) as rating_count FROM ps_product_lang as pl INNER JOIN ps_product as p ON p.id_product = pl.id_product LEFT JOIN ps_product_attribute as pa ON p.id_product = pa.id_product LEFT JOIN ps_product_attribute_combination as pac ON pac.id_product_attribute = pa.id_product_attribute LEFT JOIN ps_image as i ON p.id_product = i.id_product AND i.cover = 1 LEFT JOIN ps_category_product as c ON p.id_product = c.id_product LEFT JOIN ps_product_shop as ps ON p.id_product = ps.id_product LEFT JOIN ps_specific_price as sp ON p.id_product = sp.id_product LEFT JOIN ps_gomakoil_reviews as rat ON p.id_product = rat.id_product AND rat.rating > 0 AND rat.moderation=1 LEFT JOIN ps_attribute as ag ON pac.id_attribute = ag.id_attribute LEFT JOIN ps_currency cur ON p.currency_price = cur.id_currency WHERE pl.id_lang = 1 AND pl.id_shop = 1 AND c.id_category = 22 AND p.condition != "discontinued" AND pac.id_attribute IN(432,437) GROUP BY p.id_product HAVING (count = 2) ORDER BY available_for_order desc, price_by_request asc ,(CASE p.condition WHEN "popular" THEN 1 ELSE 100 END) ASC, p.condition DESC LIMIT 0,24 " Дымоходы из нержавеющей стали: специальные элементы, одностенные ➔ Купить с доставкой по Украине, Киев | АртКамин
Корзина
Вы добавили в корзину за
Наименование Количество Стоимость
Общая стоимость:
Продолжить покупки Оформить заказ

Дымоходы из нержавеющей стали: специальные элементы, одностенные

товаров в категории: 61
Конструктор дымоходов онлайн
Каталог товаров
Подбор по параметрам
Цена
Тип



Элементы дымохода






















Толщина стали




Диаметр




























































Производитель

Страна-производитель

Назначение




Нужна помощь? Задайте вопрос консультанту
Задать вопрос
Спасибо за Ваш вопрос!
В ближайшее время ответ нашего специалиста будет отправлен Вам на почту.