SELECT (id_agence || id_annonce) as id_bien, * FROM biens b WHERE true AND code_type_transac IN (1) AND code_type_bien IN (10) AND ( false )