Irresistibles

Promotion "Les Irresistibles" Cheminées et Poêles

 

Du 1er Octobre au 3 Novembre 2018, profitez des conditions Irresistibles sur un large choix de :

 

- Poêles à bois et à poêles à pellets

 

- Foyers gaz et poêles à gaz

 

- Cheminées et inserts

 

Des conditions à découvrir en magasin !

 

Devis gratuit

 

  • (2.9300ms) SELECT * FROM parameter order by name asc
  • (0.4620ms) SELECT * FROM book WHERE id=5734 LIMIT 1
  • (0.3780ms) SELECT * FROM book_cat WHERE id=29 LIMIT 1
  • (0.4330ms) select * from menu WHERE type!='I' AND parentId=1 ORDER BY position ASC
  • (0.2820ms) select * from menu WHERE type!='I' AND parentId=36 ORDER BY position ASC
  • (0.2580ms) select * from menu WHERE type!='I' AND parentId=11 ORDER BY position ASC
  • (0.3240ms) select * from menu WHERE type!='I' AND parentId=56 ORDER BY position ASC
  • (0.3880ms) SELECT * FROM article WHERE code='COMMUNICATION' LIMIT 1
  • (0.3630ms) SELECT * FROM communication WHERE isAvailable=1 order by position ASC LIMIT 3
  • (1.0430ms) UPDATE communication SET hits=(hits+1) WHERE id=1
  • (0.2800ms) select * from menu WHERE type!='I' AND parentId=2 ORDER BY position ASC
  • (0.2790ms) select * from menu WHERE type!='I' AND parentId=3 ORDER BY position ASC
  • (0.2760ms) select * from menu WHERE type!='I' AND parentId=4 ORDER BY position ASC
  • (0.2890ms) SELECT * FROM article WHERE code='FOOTER_TEXT' LIMIT 1