Page History

SELECT 
issuenum
, summary
, customfieldvalue.stringvalue
, issuestatus.pname

FROM jiraissue
	JOIN issuestatus ON issuestatus.id=jiraissue.issuestatus
	JOIN customfieldvalue ON jiraissue.id = customfieldvalue.issue 

where customfield=(select ID from customfield where cfname='Назва майданчика')
where customfield=(select ID from customfield where cfname='BROKER ID')
	AND project = (select id from project where pkey='SBM')