SELECT CONCAT(project.pkey,'-',jiraissue.issuenum)
,
changegroup.AUTHOR , changeitem.OLDSTRING
, changeitem.NEWSTRING
, changegroup.CREATED AS ChangeDate
, LAG(changegroup.CREATED, 1,0) OVER (ORDER BY changegroup.CREATED) AS PreviousDate
, DATEDIFF(minute,LAG(changegroup.CREATED, 1,0) OVER (ORDER BY changegroup.CREATED),changegroup.CREATED) as Duration
FROM jiraissue
JOIN project ON jiraissue.PROJECT =
project.IDJOIN changegroup ON
jiraissue.ID = changegroup.issueid
JOIN changeitem ON
changegroup.ID = changeitem.groupid
WHERE
jiraissue.ID = 1748892 AND changeitem.FIELD = 'status'