SELECT `a`.`year`, `b`.`name` as `updated_by`, `a`.`updated_ts`
FROM `hr__leave_allocation` `a`
LEFT JOIN `user` `b` ON `b`.`id` = `a`.`updated_by`
WHERE `a`.`is_delete` =0
GROUP BY `a`.`year`
ORDER BY `a`.`year` DESC