ERREUR
SELECT type_bien, trans_bien, ville_bien, t_types.nom_type_en AS nom_type FROM t_biens JOIN t_types ON t_types.id_type = t_biens.type_bien WHERE id_bien = 31
Unknown column 'trans_bien' in 'field list'