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 (12617)
	AND project = (select id from project where pkey='SBM')

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