Page History

SELECT 
issuenum, issuestatus.pname, reporter, assignee, issuetype, summary
FROM 
jiraissue, LEFTissuestatus JOIN customfieldvalue ON jiraissuewhere issuestatus.id = customfieldjiraissue.issuestatus
AND
project = (select id from project where pkey='SBM')
ORDER BY issuenum;