SELECT 
issuenum, issuestatus.pname, reporter, assignee, issuetype, summary, customfield,

FROM 
jiraissue, issuestatus

WHERE project = (select id from project where pkey='SBM')

AND issuestatus.id = jiraissue.issuestatus 
ORDER BY issuenum;

select * from customfieldvalue where customfield=(select ID from customfield where cfname='Broker ID')