Page History

select issuenum, ( select pname from issuestatus, jiraissue where issuestatus.id=jiraissue.issuestatus and issuenum = 18 and project = (select id from project where pkey='SBM') ), reporter, assignee, issuetype, summary from jiraissue where  project = (select id from project where pkey='SBM');