Page History

SELECT 
issuenum as ТІКЕТ
, summary as ТЕМА
, customfieldvalue.stringvalue as ОРГАНІЗАЦІЯ
, CONCAT('*', issuestatus.pname, '*') as СТАТУС

FROM jiraissue
	JOIN issuestatus ON issuestatus.id=jiraissue.issuestatus
	JOIN customfieldvalue ON jiraissue.id = customfieldvalue.issue
        
where customfield in (12602,12617)
	AND project = (select id from project where pkey='SBM')