"SELECT user,time_in1,time_out1,time_in2,time_out2,time_in3,time_out3,
 DATE(time_in1) AS 'date',
 DAYOFWEEK(DATE(time_in1)) AS 'dow',
 TIME_TO_SEC(ADDTIME(TIMEDIFF(time_out1,time_in1),ADDTIME(TIMEDIFF(time_out2,time_in2),TIMEDIFF(time_out3,time_in3))))/3600 AS 'total_hour'
 FROM attendance
 WHERE status=0"