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

 

  • (1.7230ms) SELECT * FROM parameter order by name asc
  • (0.4430ms) SELECT * FROM book WHERE id=5734 LIMIT 1
  • (0.3560ms) SELECT * FROM book_cat WHERE id=29 LIMIT 1
  • (0.1810ms) select * from menu WHERE type!='I' AND parentId=1 ORDER BY position ASC
  • (0.2350ms) select * from menu WHERE type!='I' AND parentId=36 ORDER BY position ASC
  • (0.1400ms) select * from menu WHERE type!='I' AND parentId=11 ORDER BY position ASC
  • (0.1450ms) select * from menu WHERE type!='I' AND parentId=56 ORDER BY position ASC
  • (0.2360ms) SELECT * FROM article WHERE code='COMMUNICATION' LIMIT 1
  • (0.3230ms) SELECT * FROM communication WHERE isAvailable=1 order by position ASC LIMIT 3
  • (1.4670ms) UPDATE communication SET hits=(hits+1) WHERE id=1
  • (0.1470ms) select * from menu WHERE type!='I' AND parentId=2 ORDER BY position ASC
  • (0.1430ms) select * from menu WHERE type!='I' AND parentId=3 ORDER BY position ASC
  • (0.1400ms) select * from menu WHERE type!='I' AND parentId=4 ORDER BY position ASC
  • (0.1850ms) SELECT * FROM article WHERE code='FOOTER_TEXT' LIMIT 1