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