Notice: No translation for the language 'en_US' available. in /production/www/clients/bilangesv2/home/www/library/Zend/Translate/Adapter.php on line 456
ADEME - Site Bilans GES
Centre de ressources sur les bilans de gaz à effet de serre
ADEME
1141 membres inscrits
1613 facteurs d'émissions validés
2413 bilans obligatoires réalisés
#14# guides sectoriels
7 - 0.0030887126922607
connect
SELECT pco.PCO_ID as ID, pco.PCO_DESIGNATION AS DESIGNATION, null as MODULE, null as CONTROLEUR, pco.PCO_TITRE as TITRE, CONCAT(IFNULL(pco.SMN_ID, ""), "_", IFNULL(pco.MNU_ID, "")) as CHEMIN, pco.PCO_ORDRE as ORDRE, pro.PRO_POIDS as POIDS, pco.PCO_IS_TITRE_GRAS as SI_GRAS, pco.LAN_CODE as LANGUE FROM PAGE_CONTENU pco JOIN PROFIL pro on (pro.PRO_ID = pco.PRO_ID) JOIN MENU mnu on (mnu.MNU_ID = pco.MNU_ID and mnu.MNU_LIBELLE_FR <> "Pied de page") WHERE pco.MNU_ID IS NOT NULL AND pco.SMN_ID IS NOT NULL UNION SELECT pdy.PDY_ID as ID, NULL as DESIGNATION, pdy.PDY_MODULE as MODULE, pdy.PDY_CONTROLEUR as CONTROLEUR, pdy.PDY_TITRE_FR as TITRE, CONCAT(IFNULL(pdy.SMN_ID, ""), "_", IFNULL(pdy.MNU_ID, "")) as CHEMIN, pdy.PDY_ORDRE as ORDRE, pro.PRO_POIDS as POIDS, pdy.PDY_IS_TITRE_GRAS as SI_GRAS, null as LANGUE FROM PAGE_DYNAMIQUE pdy JOIN PROFIL pro on (pro.PRO_ID = pdy.PRO_ID) JOIN MENU mnu on (mnu.MNU_ID = pdy.MNU_ID and mnu.MNU_LIBELLE_FR <> "Pied de page") WHERE pdy.MNU_ID IS NOT NULL AND pdy.SMN_ID IS NOT NULL ORDER BY ORDRE
SELECT pco.PCO_ID as ID, pco.PCO_DESIGNATION AS DESIGNATION, null as MODULE, null as CONTROLEUR, pco.PCO_TITRE as TITRE, CONCAT(IFNULL(pco.SMN_ID, ""), "_", IFNULL(pco.MNU_ID, "")) as CHEMIN, pco.PCO_ORDRE as ORDRE, pro.PRO_POIDS as POIDS, pco.PCO_IS_TITRE_GRAS as SI_GRAS, pco.LAN_CODE as LANGUE FROM PAGE_CONTENU pco JOIN PROFIL pro on (pro.PRO_ID = pco.PRO_ID) JOIN MENU mnu on (mnu.MNU_ID = pco.MNU_ID and mnu.MNU_LIBELLE_FR = "Pied de page") WHERE pro.PRO_POIDS <= :POIDS UNION SELECT pdy.PDY_ID as ID, NULL as DESIGNATION, pdy.PDY_MODULE as MODULE, pdy.PDY_CONTROLEUR as CONTROLEUR, pdy.PDY_TITRE_FR as TITRE, CONCAT(IFNULL(pdy.SMN_ID, ""), "_", IFNULL(pdy.MNU_ID, "")) as CHEMIN, pdy.PDY_ORDRE as ORDRE, pro.PRO_POIDS as POIDS, pdy.PDY_IS_TITRE_GRAS as SI_GRAS, null as LANGUE FROM PAGE_DYNAMIQUE pdy JOIN PROFIL pro on (pro.PRO_ID = pdy.PRO_ID) JOIN MENU mnu on (mnu.MNU_ID = pdy.MNU_ID and mnu.MNU_LIBELLE_FR = "Pied de page") WHERE pro.PRO_POIDS <= :POIDS ORDER BY ORDRE
SELECT `PAC`.* FROM `PAGE_ACCUEIL` AS `PAC` WHERE (PAC.LAN_CODE = 'FR')
SELECT COUNT(1) AS `TOTAL` FROM `UTILISATEUR` AS `UTI`
SELECT COUNT(1) AS `TOTAL` FROM `ELEMENT` AS `ELE` WHERE (ELE.STE_CODE IN ('VG', 'VG')) AND (ELE.TEL_CODE = 'FE')
SELECT pco.PCO_ID as ID, pco.PCO_DESIGNATION AS DESIGNATION, null as MODULE, null as CONTROLEUR, pco.PCO_TITRE as TITRE, CONCAT(IFNULL(pco.SMN_ID, ""), "_", IFNULL(pco.MNU_ID, "")) as CHEMIN, pco.PCO_ORDRE as ORDRE, pro.PRO_POIDS as POIDS, pco.PCO_IS_TITRE_GRAS as SI_GRAS, pco.LAN_CODE as LANGUE FROM PAGE_CONTENU pco JOIN PROFIL pro on (pro.PRO_ID = pco.PRO_ID) JOIN MENU mnu on (mnu.MNU_ID = pco.MNU_ID and mnu.MNU_LIBELLE_FR = "Pied de page") WHERE pro.PRO_POIDS <= :POIDS UNION SELECT pdy.PDY_ID as ID, NULL as DESIGNATION, pdy.PDY_MODULE as MODULE, pdy.PDY_CONTROLEUR as CONTROLEUR, pdy.PDY_TITRE_FR as TITRE, CONCAT(IFNULL(pdy.SMN_ID, ""), "_", IFNULL(pdy.MNU_ID, "")) as CHEMIN, pdy.PDY_ORDRE as ORDRE, pro.PRO_POIDS as POIDS, pdy.PDY_IS_TITRE_GRAS as SI_GRAS, null as LANGUE FROM PAGE_DYNAMIQUE pdy JOIN PROFIL pro on (pro.PRO_ID = pdy.PRO_ID) JOIN MENU mnu on (mnu.MNU_ID = pdy.MNU_ID and mnu.MNU_LIBELLE_FR = "Pied de page") WHERE pro.PRO_POIDS <= :POIDS ORDER BY ORDRE