SELECT
project.pname,
project.pkey,
jiraissue.issuenum,
resolution.pname as resolution,
changegroup.author,
changeitem.oldstring,
changeitem.newstring,
changegroup.created,
jiraissue.updated,
jiraissue.reporter,
project.lead,
issuetype.pname,
issuestatus.pname
FROM
changeitem,
changegroup,
jiraissue,
project,
issuetype,
issuestatus,
resolution
WHERE
changeitem.groupid=changegroup.id
AND changeitem.field='status'
AND jiraissue.reporter = changegroup.author
AND project.id = jiraissue.project
AND issuetype.id = jiraissue.issuetype
AND issuestatus.id = jiraissue.issuestatus
and resolution.id = jiraissue.resolution
and jiraissue.resolution = 'Not Resolved'
order by jiraissue.issuenum ASC
