Rapport de consommation: ajouter les immo au réel

[auf_coda_additions.git] / rapports / consommation.sql

diff --git a/rapports/consommation.sql b/rapports/consommation.sql
index 45649ec..075f36a 100644 (file)
--- a/rapports/consommation.sql
+++ b/rapports/consommation.sql
@@ -292,7 +292,7 @@ WHERE
     AND balcode = 'REEL'
     AND repbasis = 5
     AND curcode = 'EUR'
-    AND el1 LIKE '6%'
+    AND el1 LIKE '[26]%'
 GROUP BY el3, yr;
 
 -- Provisions par el3  {{{1