whole day 9/2

french to english. some SQL update