1 answer
Pablo Beltran
Rising Star 
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
You are able to get it with the SQL for JIRA plugin.
select i.key
from issues i inner join issuecustomfields cf on cf.issueid=i.id
where jql='type=Epic' and cf.epic_name not in (
select distinct cf.epic_link
from issues i inner join issuecustomfields cf on cf.issueid = i.id
where jql=' "Epic Link" in sql("select key from issues where jql=''type=Epic'' ") '
)
I've tried it on my testing environment and it worked fine 
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.