SELECT `a`.*, `b`.`name` as `staff_name`, `b`.`staff_id` as `staff_employment_id`
FROM `job__task_daily_summary` `a`
LEFT JOIN `user` `b` ON `b`.`id` = `a`.`userID`
WHERE `a`.`is_delete` = 0
AND `a`.`jobID` = '4'
ORDER BY `a`.`updatedTS` DESC