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