SELECT issuenum, issuestatus.pname, reporter, assignee, issuetype, summary, customfieldvalue.stringvalue as Broker ID
   FROM jiraissue, issuestatus
   WHERE project = (select id from project where pkey='SBM')
     AND issuestatus.id = jiraissue.issuestatus 
   ORDER BY issuenum;

select 
 
 
  ,customfieldvalue.stringvalue as Sponsor