How to get all the child calls/subtasks of a particular issue raised by a certain group of reporters

[Chetan Krishna Sai Naidu/Jira-Admin]

How to get all the child calls/subtasks of a particular issue raised by a certain group of reporters.

My Requirement is to get the parent & child calls for all the issues raised by a certain group of reporters for certain issue types.

Thank you in advance.

[Mykenna Cepek]

SQL like the following might be helpful - experiment with this:

type = sub-task and reporter in (person1, person2, person3)