Котел газовый BAXI DUO-TEC COMPACT 28 конденсационный, настенный, 2 конт., закр. кам. сгор.

Код товара: A7722039

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

BAXI

154850 р

Ближайшая доставка: дата
Самовывоз: дата, бесплатно по адресу Москва, ул. Ивана Сусанина, 2с2

Wi-Fi модуль

Доп.опция

Вес товара (нетто), кг

Вес товара с упаковкой (брутто), кг

Вид топлива

Природный газ

Вид управления

Комбинированное

Все характеристики

Настенные конденсационные котлы BAXI Duo-Tec Compact – это надежное и современное решение для обеспечения теплоснабжения в доме или офисе. Они сочетают в себе простоту монтажа и эксплуатации, эффективность и возможность работы в различных условиях.

Основные особенности газовых котлов BAXI Duo-Tec Compact:

Современная газовая горелка, которая обеспечивает полное предварительное смешение газо-воздушной смеси. Это повышает эффективность сгорания и снижает выбросы оксида азота.

Способность адаптироваться к различным условиям. Котлы могут работать с различными типами газа и дымоходами, а также приспосабливаются к различным параметрам сети.

Коэффициент модуляции мощности 1:7 позволяет котлу регулировать свою мощность в зависимости от потребностей системы отопления и ГВС.

Обновленная панель управления. Отображение информации в виде текста и пиктограмм, что делает её понятной и удобной в использовании.

Надежность и безопасность на протяжении всего срока эксплуатации.

Характеристики

Wi-Fi модуль

Доп.опция

Вес товара (нетто), кг

Вес товара с упаковкой (брутто), кг

Вид топлива

Природный газ

Вид управления

Комбинированное

Встроенный программатор 'Program easy'

Нет

Встроенный расширительный бак

Да

Встроенный циркуляционный насос

Да

Вход/выход ГВС, дюйм

1/2 (наружная)

Высота товара, см

Высота упаковки товара, см

Гарантийный документ

Гарантийный талон

Гарантийный срок

2 года

Глубина товара, см

29.9

Глубина упаковки товара, см

Датчик тяги дымохода (отключает подачу газа)

Да

Защита насоса от заклинивания

Да

Защита от перегрева

Да

Контур водяного отопления

Да

Контур горячего водоснабжения ГВС

Да

Кпд, %

107.6

Макс. мощность, кВт

Макс. производительность при Т=25°С, л/мин, л/мин

16.1

Материал корпуса

Сталь

Материал теплообменника

Нерж. сталь

Минимальное давление газа, мбар

НС-код

НС-1294680

Область применения

Для систем отопления

Подающая/обратная линии системы отопления, дюйм

3/4 (наружная)

Подсоединение газа к котлу, дюйм

3/4 (наружная)

Расход природного газа, до, м3/час

3.06

Регулировка температуры

Да

Режим работы с водяным теплым полом 'Affect Floor'

Да

Серия

DUO-TEC COMPACT

Система антизамерзания

Да

Система дымоудаления

(60-100)/80

Система погодозависимого управления температурой

Да

Система самодиагностики неисправности

Да

Страна производства

ИТАЛИЯ

Тип камеры сгорания

Закрытая камера (TURBO)

Тип котла

Конденсационный газовый

Тип монтажа

Настенный

Функция форсированного нагрева ГВС 'FHF'

Нет

Цвет корпуса

Белый

Цифровой дисплей

Да

Ширина товара, см

Ширина упаковки товара, см

Эксклюзив

Да

Эффективен для помещ. площадью до, м2

280

Отзывов: 0

Средняя оценка: 0.0

Нет отзывов об этом товаре.

Вопросов: 0

Пока нет вопросов об этом товаре. Станьте первым!

Аналогичные товары

Котел газовый BAXI LUNA DUO-TEC E 1.24 конденсационный, настенный, 1 конт., закр. кам. сгор.

170430 р

Котел напольный газовый SLIM EF 1.31

214130 р

Котел газовый BAXI NUVOLA DUO-TEC+ 24 GA конденс., настен., 2 конт., з.к.с., со встроен. бойлером

303145 р

Котел газовый BAXI LUNA DUO-TEC MP+ 1.90 конденсационный, настенный, 1 конт., закр. кам. сгор.

653125 р

Котел газовый настенный BAXI ECO Nova 31 F, двухконтурный,с закрытой камерой сгорания

119795 р

0.0204052927	event/translation (50 action)
0.0092949866	event/theme (25 action)
0.0059065815	event/language (95 action)

1.5640480518	startup/router (1 action)
0.0200870037	startup/startup (1 action)
0.0103769302	startup/seo_url (1 action)
0.0013799667	startup/event (1 action)
0.0006139278	startup/session (1 action)
0.0002079010	startup/maintenance (1 action)
0.0001449585	startup/error (1 action)

0.7509663104	extension/module/uni_new_data (7 action)
0.7167820930	extension/module/uni_auto_related (1 action)
0.0110890865	extension/module/bundles (1 action)
0.0055768490	extension/module/uni_request (1 action)
0.0044879914	extension/advertise/google (2 action)
0.0030450820	extension/module/banner (2 action)
0.0026519299	extension/module/uni_news_related (1 action)
0.0023198128	extension/module/uni_subscribe (1 action)
0.0014169216	extension/module/uni_slideshow_v2 (1 action)
0.0008816719	extension/module/ocfilter (25 action)
0.0006868839	extension/module/uni_notification (1 action)
0.0001320839	extension/module/uni_tool (1 action)
0.0000839233	extension/module/uni_viewed (1 action)

1.5636279583	product/product (1 action)
0.0052490234	product/uni_reviews (1 action)

0.0767900944	common/header (1 action)
0.0272281170	common/menu (1 action)
0.0212302208	common/cart (1 action)
0.0161859989	common/content_bottom (1 action)
0.0139019489	common/footer (1 action)
0.0088691712	common/column_left (2 action)
0.0077319145	common/currency (2 action)
0.0040397644	common/column_right (2 action)
0.0035398006	common/search (1 action)
0.0033090115	common/language (1 action)
0.0022168159	common/content_top (1 action)

0.0389790535	SELECT p.product_id FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '1771' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id > '166736' AND p.product_id != '166736' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
0.0167410374	DELETE FROM `oc_session` WHERE `expire` < '2025-12-17 01:22:50'
0.0083088875	SELECT p.product_id FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '1772' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id > '166736' AND p.product_id != '166736' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
0.0080838203	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE (c.parent_id = '0' OR c.category_id IN(SELECT category_id FROM oc_category_parent cpr WHERE cpr.parent_id = '0' )) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.0052249432	SELECT category_id, parent_id FROM oc_category ORDER BY parent_id
0.0048229694	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '166738' AND od.language_id = '1' ORDER BY o.sort_order
0.0045950413	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '166739' AND od.language_id = '1' ORDER BY o.sort_order
0.0044159889	SELECT p.product_id FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '1773' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id > '166736' AND p.product_id != '166736' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
0.0040760040	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '166741' AND od.language_id = '1' ORDER BY o.sort_order
0.0038418770	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '166737' AND od.language_id = '1' ORDER BY o.sort_order
0.0037801266	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '166740' AND od.language_id = '1' ORDER BY o.sort_order
0.0036559105	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '166736' AND od.language_id = '1' ORDER BY o.sort_order
0.0026102066	SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
0.0023589134	UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '166736'
0.0022418499	SHOW TABLES LIKE 'oc_ocfilter_setting'
0.0020298958	SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
0.0018930435	SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
0.0018930435	SHOW TABLES LIKE 'oc_cartkeeper'
0.0014939308	SHOW TABLES LIKE 'oc_cartkeeper_share'
0.0014879704	SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '166736' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0012979507	SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
0.0012180805	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_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 oc_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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '166737' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0011031628	SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '166736' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0010809898	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_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 oc_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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '166738' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0010747910	SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
0.0009639263	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_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 oc_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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '166739' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0009379387	SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=166737' AND store_id = '0' AND language_id = '1' LIMIT 1
0.0009150505	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_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 oc_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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '166736' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0008711815	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_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 oc_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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '166740' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0008268356	SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=166740' AND store_id = '0' AND language_id = '1' LIMIT 1
0.0008189678	SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
0.0008080006	SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '3' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
0.0007939339	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_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 oc_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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '166741' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0007419586	SELECT query FROM oc_seo_url WHERE keyword = 'kotel-gazovyj-baxi-duo-tec-compact-28-kondensatsionnyj-nastennyj-2-kont-zakr-kam-sgor' AND store_id = '0' AND language_id = '1' LIMIT 1
0.0007240772	SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=166741' AND store_id = '0' AND language_id = '1' LIMIT 1
0.0007059574	SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=238' AND store_id = '0' AND language_id = '1' LIMIT 1
0.0006830692	SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '3' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
0.0006799698	SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '3' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
0.0006380081	SELECT * FROM oc_ocfilter_setting
0.0006279945	SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=166736' AND store_id = '0' AND language_id = '1' LIMIT 1

Основные особенности газовых котлов BAXI Duo-Tec Compact:

Характеристики

event

startup

extension

product

common