Page History

SELECT 

issuenum, reporter, assignee, issuetype, summary, customfieldvalue.stringvalue

FROM 

jiraissue

JOIN customfieldvalue ON jiraissue.id = customfieldvalue.issue where customfield=(select ID from customfield where cfname='Назва майданчика')
JOIN customfieldvalue ON jiraissue.id = customfieldvalue.issue where customfield=(select ID from customfield where cfname='Broker ID')


AND

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