Select a.epic_key,a.epic_id,a.issue_key,a.issue_id
,w.AUTHOR,w.STARTDATE,round(w.timeworked/3600,2) as timeworked
from
(
SELECT concat(p.pkey,'-',i.issuenum) as epic_key,concat(pl.pkey,'-',il.issuenum) as issue_key,il.ID as issue_id,i.ID as epic_id,l1.DESTINATION FROM jiraissue as i
inner join project as p on p.iD = i.PROJECT
left join issuelink as l1 on l1.SOURCE = i.ID
inner join jiraissue as il on il.ID = l1.DESTINATION
inner join project as pl on pl.iD = il.PROJECT
where i.issuetype = 5
) as a
left join worklog as w on w.issueid = a.issue_id |