select `odv`.`item_type` AS `item_type`, `odv`.`item_id` AS `item_id`, `ti`.`type`, `u`.`id` AS `user_id`, `p`.`name` AS `user_name`, ifnull(sum(tl.hours_spent),0) as total_hoursfrom (((((overview_doc_view odv join overview_doc_item_task odit on ( odit.item_type = odv.item_type and odit.item_id = odit.item_id )) join task ti on (odit.task_id = ti.id)) join task_user tuii on (ti.id = tuii.task_id)) join user u on (u.id = tuii.user_id)) join person p on (p.id = u.profile_id)) left join task_log tl on ((tl.task_id = ti.id) and (tl.user_id = u.id))group by u.id, odv.item_type, odv.item_id, ti.type;