Warning: pg_query(): Query failed: ERROR: relation "m_theme_lang" does not exist LINE 2: FROM m_theme_lang TL1 ^ in /production/www/clients/cartosante/home/www/export_liste_indics/export_liste_indics_Excel.php on line 85
Erreur de requĂȘte: SELECT TL1.lib as domaine, TL2.lib as theme, IL.lib_indicateur, DT1.id_variable, DT2.mods, DT.id_dataset, (case when TL3.lib=TL2.lib then '' else TL3.lib end) as sous_theme, IV.id_indicateur, MIN(VL.id_view) FROM m_theme_lang TL1 INNER JOIN m_theme T1 on (TL1.id_theme=T1.id_theme) INNER JOIN m_theme T2 on (T1.tree_path=SUBSTR(T2.tree_path,1,1) and T2.id_tree=T1.id_tree) INNER JOIN m_theme_lang TL2 on (TL2.id_theme=T2.id_theme) INNER JOIN m_theme T3 on (T2.tree_path=SUBSTR(T3.tree_path,1,3) and T3.id_tree=T2.id_tree) INNER JOIN m_theme_lang TL3 on (TL3.id_theme=T3.id_theme) INNER JOIN t_indicateur_theme IT ON (IT.id_theme=T3.id_theme) INNER JOIN t_indicateur_view IV ON (IV.id_indicateur=IT.id_indicateur and IV.id_dataset=IT.id_dataset) INNER JOIN t_indicateur_lang IL ON (IL.id_indicateur=IV.id_indicateur and IV.id_dataset=IL.id_dataset) INNER JOIN t_indicateur I ON (I.id_indicateur=IL.id_indicateur and I.id_dataset=IL.id_dataset) INNER JOIN m_dataset DT on (DT.id_dataset=IL.id_dataset) LEFT JOIN m_dataset_axis DT1 on (DT1.id_dataset=DT.id_dataset and DT1.type_axis='F') LEFT JOIN m_dataset_axis DT2 on (DT2.id_dataset=DT.id_dataset and DT2.type_axis='T') INNER JOIN m_view_lang VL on (VL.id_view=IV.id_view) INNER JOIN m_view V on (V.id_view=VL.id_view) WHERE IV.opened=1 AND I.published=1 AND DT.opened=1 and I.output='A' GROUP BY domaine, theme, sous_theme, IL.lib_indicateur, DT1.id_variable, DT2.mods, DT.id_dataset, IV.id_indicateur, T3.tree_path, T2.tree_path, T1.id_tree, IT.ordre ORDER BY T2.tree_path, T3.tree_path, IT.ordre ASC