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 OR cp ILIKE '%75%' OR cp ILIKE '%77%' OR cp ILIKE '%78%' OR cp ILIKE '%91%' OR cp ILIKE '%92%' OR cp ILIKE '%93%' OR cp ILIKE '%94%' OR cp ILIKE '%95%' )