Inserts à Pellets

PIAZZETTA P973

PIAZZETTA MP973 TH

PIAZZETTA MP973 TH

PIAZZETTA MP938

PIAZZETTA MP938

PIAZZETTA IP9

PIAZZETTA IP78/68

PIAZZETTA IP78/68

PIAZZETTA IP78/58

PIAZZETTA IP78/58

PIAZZETTA IP7

PIAZZETTA IP68/49

PIAZZETTA IP68/49

PIAZZETTA IP11

JOTUL PI 901

JOTUL PI 1201

JOTUL PI 1200

JOTUL PC 901

JOTUL PC 801

JM SYNTHESIS MODULAR

JM SYNTHESIS MODULAR

JM SYNTHESIS 60

JM SYNTHESIS 60

Découvrez notre gamme !

Trouvez votre produit préféré en feuilletant toute l’étendue de notre gamme de produits

Téléchargez votre catalogue

(4.7219ms) SELECT * FROM parameter order by name asc
(1.2429ms) SELECT * FROM product_cat WHERE id=6 LIMIT 1
(4.6120ms) select * from product_cat ORDER BY id ASC
(0.5908ms) SELECT productCatId, count(*) as counter FROM `product` group by productCatId
(0.6151ms) select v.id, v.name from product as p, product_vendor as v where p.productVendorId=v.id AND p.productCatId IN ('6') group by productVendorId order by name ASC
(0.5231ms) select floor(min(efficiency)) as min, ceil(max(efficiency)) as max from product as p WHERE efficiency IS NOT NULL AND p.productCatId IN ('6')
(0.5929ms) select floor(min(powerMin)) as min, ceil(max(powerMax)) as max from product as p WHERE powerMin IS NOT NULL AND p.productCatId IN ('6')
(0.6630ms) select min(dimHeight) as min, max(dimHeight) as max from product as p WHERE dimHeight IS NOT NULL AND p.productCatId IN ('6')
(0.6549ms) select min(dimWidth) as min, max(dimWidth) as max from product as p WHERE dimWidth IS NOT NULL AND p.productCatId IN ('6')
(0.4990ms) select min(dimDepth) as min, max(dimDepth) as max from product as p WHERE dimDepth IS NOT NULL AND p.productCatId IN ('6')
(0.4959ms) select count(id) as c FROM product as p WHERE isRT2012=1 AND p.productCatId IN ('6')
(0.5121ms) select count(id) as c FROM product as p WHERE p.isPromotion=1 AND p.productCatId IN ('6')
(0.5009ms) select count(id) as c FROM product as p WHERE p.isDiscount=1 AND p.productCatId IN ('6')
(0.5009ms) select count(id) as c FROM product as p WHERE p.isNew=1 AND p.productCatId IN ('6')
(0.5381ms) select count(id) as c FROM product as p WHERE p.isExpo=1 AND p.productCatId IN ('6')
(0.8609ms) SELECT * FROM product_cat WHERE id=6 LIMIT 1
(1.7190ms) SELECT * FROM product_cat WHERE id=15 LIMIT 1
(0.5751ms) select * from menu WHERE type!='I' AND parentId=2 ORDER BY position ASC
(0.5291ms) select * from menu WHERE type!='I' AND parentId=1 ORDER BY position ASC
(0.6108ms) select * from menu WHERE type!='I' AND parentId=27 ORDER BY position ASC
(0.5391ms) select * from menu WHERE type!='I' AND parentId=11 ORDER BY position ASC
(0.5980ms) select * from menu WHERE type!='I' AND parentId=6 ORDER BY position ASC
(0.5419ms) select * from menu WHERE type!='I' AND parentId=93 ORDER BY position ASC
(0.5140ms) select * from menu WHERE type!='I' AND parentId=78 ORDER BY position ASC
(0.8790ms) SELECT * FROM product_cat WHERE id=6 LIMIT 1
(4.8029ms) select * from product_cat ORDER BY id ASC
(0.6630ms) SELECT productCatId, count(*) as counter FROM `product` group by productCatId
(0.5260ms) select count(*) as counter from product WHERE productCatId IN ('6','6') AND isAvailable=1 ORDER BY id desc
(3.1269ms) select * from product WHERE productCatId IN ('6','6') AND isAvailable=1 ORDER BY position ASC, name DESC LIMIT 0,60
(0.5641ms) select v.id, v.name from product as p, product_vendor as v where p.productVendorId=v.id AND p.productCatId IN ('6','6') group by productVendorId order by name ASC
(0.5472ms) SELECT * FROM article WHERE code='HOME_GAMME' LIMIT 1
(0.5200ms) select * from menu WHERE type!='I' AND parentId=2 ORDER BY position ASC
(0.5310ms) SELECT * FROM article WHERE code='FOOTER_OPEN' LIMIT 1
(0.7100ms) SELECT * FROM article WHERE code='FOOTER_ADDRESS' LIMIT 1
(0.7341ms) SELECT * FROM article WHERE code='FOOTER_CONTACT' LIMIT 1