select detail_affaire_id from capsudimmo_detail_affaire where affaire_id =  and detail_affaire_langue = 'fr'  limit 0,1