check child issue ie link (is child of) and portfolio child issu

[Hasna]

We need query to display all linked issues for a particular issues .

Below query gives list of issues , but we need details of 2 project , so can we make below project specific.

 select
ilt.linkname, 
concat(ap.pkey, '-', a.issuenum) AS TheSource,
concat(bp.pkey, '-', b.issuenum) AS TheChild
INTO OUTFILE '/tmp/link.csv' FROM issuelink il
JOIN jiraissue a ON il.source = a.id
JOIN jiraissue b ON il.destination = b.id
JOIN project ap ON a.project = ap.id
JOIN project bp ON b.project = bp.id
JOIN issuelinktype ilt ON il.linktype = ilt.id;