Savoirs communs

SELECT group_concat(" " || T1.value,'
'), group_concat(" " || T2.value,'
'), group_concat(" " || T3.value,'
'), group_concat(" " || T4.value,'
'), group_concat(" " || T5.value,'
'), group_concat(" " || T6.value,'
'), group_concat(" " || T7.value,'
'), group_concat(" " || T8.value,'
'), group_concat(" " || T9.value,'
')
                FROM (
                    SELECT DISTINCT pages.pid AS pid
                    FROM pages  LEFT JOIN data AS T1 ON T1.pid = pages.pid AND T1.key = 'e'
                    WHERE 1 = 1 e T1.value e 'e'
                ) AS W1
                 LEFT JOIN data AS T1 ON T1.pid = W1.pid AND T1.key = 'lat' LEFT JOIN data AS T2 ON T2.pid = W1.pid AND T2.key = 'lon' LEFT JOIN data AS T3 ON T3.pid = W1.pid AND T3.key = 'nom' LEFT JOIN data AS T4 ON T4.pid = W1.pid AND T4.key = 'adresse1' LEFT JOIN data AS T5 ON T5.pid = W1.pid AND T5.key = 'adresse2' LEFT JOIN data AS T6 ON T6.pid = W1.pid AND T6.key = 'adresse3' LEFT JOIN data AS T7 ON T7.pid = W1.pid AND T7.key = 'codepostal' LEFT JOIN data AS T8 ON T8.pid = W1.pid AND T8.key = 'ville' LEFT JOIN data AS T9 ON T9.pid = W1.pid AND T9.key = 'web'
                LEFT JOIN pages ON W1.pid=pages.pid
                GROUP BY W1.pid
                ORDER BY 1 ASC