I need assistance adding a custom field to my query

[Jay Lefler]

I'm trying to pull a list of all tickets that a user has activity on for a specific time period and I'm able to pull that information with the following query:

select concat(p.pkey,'-',ji.issuenum), ji.summary
from project p 
inner join jiraissue ji on p.ID=ji.PROJECT 
left join jiraaction ja on ji.id=ja.issueid 
where ja.updateauthor='jlefler' and ja.updated between '2018-02-07 21:00:00' and '2018-02-08 05:00:00'
group by concat(p.pkey,'-',ji.issuenum)
order by concat(p.pkey,'-',ji.issuenum);

 I'm using Version v7.1.8

I tried looking at the schema document but couldn't quite figure out how to add the following information to my query.

There is a custom field called Customer (which correlates to cfname in customfield table), and this list of customers is found in customfieldoption under customvalue column).

Customer has these attributes in customfield table:

CUSTOMFIELDTYPEKEY com.atlassian.jira.plugin.system.customfieldtypes:multiselect

CUSTOMFIELDSEARCHERKEY com.atlassian.jira.plugin.system.customfieldtypes:multiselectsearcher

Multiple customers can be selected in this custom field.

What I would like to display is the Customer (or colon seperated list of multiple customers) between my concat(p.pkey,'-'ji.issuenum) and ji.summary fields

[Jay Lefler]

It's been almost a year. Can anyone assist? Or provide feedback if my original comments aren't clear enough?