My Longest Query Ever

SELECT fname AS 'Complainant First Name', mname AS 'Complainant Middle Name', surname AS 'Complainant Surname',
 sex AS 'Complainant Sex', person_address AS 'Complainant Address', citizenship AS 'Complainant Citizenship',
 birthdate AS 'Complainant Birthday', contactnum AS 'Complainant Contact Number', email AS 'Complainant Email Address',

 date_received, case_details, lagdo_ccn, nbi_ccn, nbi_acmo, nature_of_case,

(SELECT fname FROM persons_tbl
INNER JOIN case_victim_tbl ON persons_tbl.person_id = case_victim_tbl.person_id) AS 'Victim First Name',
(SELECT mname FROM persons_tbl
INNER JOIN case_victim_tbl ON persons_tbl.person_id = case_victim_tbl.person_id) AS 'Victim Middle Name',
(SELECT surname FROM persons_tbl
INNER JOIN case_victim_tbl ON persons_tbl.person_id = case_victim_tbl.person_id) AS 'Victim Surname',
(SELECT sex FROM persons_tbl
INNER JOIN case_victim_tbl ON persons_tbl.person_id = case_victim_tbl.person_id) AS 'Victim Sex',
(SELECT person_address FROM persons_tbl
INNER JOIN case_victim_tbl ON persons_tbl.person_id = case_victim_tbl.person_id) AS 'Victim Address',
(SELECT citizenship FROM persons_tbl
INNER JOIN case_victim_tbl ON persons_tbl.person_id = case_victim_tbl.person_id) AS 'Victim Citizenship',
(SELECT birthdate FROM persons_tbl
INNER JOIN case_victim_tbl ON persons_tbl.person_id = case_victim_tbl.person_id) AS 'Victim Birthday',
(SELECT contactnum FROM persons_tbl
INNER JOIN case_victim_tbl ON persons_tbl.person_id = case_victim_tbl.person_id) AS 'Victim Contact Number',
(SELECT email FROM persons_tbl
INNER JOIN case_victim_tbl ON persons_tbl.person_id = case_victim_tbl.person_id) AS 'Victim Email Address',

(SELECT fname FROM persons_tbl
INNER JOIN case_subject_tbl ON persons_tbl.person_id = case_subject_tbl.person_id) AS 'Subject First Name',
(SELECT mname FROM persons_tbl
INNER JOIN case_subject_tbl ON persons_tbl.person_id = case_subject_tbl.person_id) AS 'Subject Middle Name',
(SELECT surname FROM persons_tbl
INNER JOIN case_subject_tbl ON persons_tbl.person_id = case_subject_tbl.person_id) AS 'Subject Surname',
(SELECT sex FROM persons_tbl
INNER JOIN case_subject_tbl ON persons_tbl.person_id = case_subject_tbl.person_id) AS 'Subject Sex',
(SELECT person_address FROM persons_tbl
INNER JOIN case_subject_tbl ON persons_tbl.person_id = case_subject_tbl.person_id) AS 'Subject Address',
(SELECT citizenship FROM persons_tbl
INNER JOIN case_subject_tbl ON persons_tbl.person_id = case_subject_tbl.person_id) AS 'Subject Citizenship',
(SELECT birthdate FROM persons_tbl
INNER JOIN case_subject_tbl ON persons_tbl.person_id = case_subject_tbl.person_id) AS 'Subject Birthday',
(SELECT contactnum FROM persons_tbl
INNER JOIN case_subject_tbl ON persons_tbl.person_id = case_subject_tbl.person_id) AS 'Subject Contact Number',
(SELECT fname FROM persons_tbl
INNER JOIN case_subject_tbl ON persons_tbl.person_id = case_subject_tbl.person_id) AS 'Subject Email Address'

FROM persons_tbl
INNER JOIN case_complainant_tbl ON persons_tbl.person_id = case_complainant_tbl.person_id
INNER JOIN case_tbl ON case_complainant_tbl.case_id = case_tbl.case_id
INNER JOIN citizenship_tbl ON persons_tbl.citizenship_id = citizenship_tbl.citizenship_id
INNER JOIN nature_case_tbl ON case_tbl.nature_case_id = nature_case_tbl.nature_case_id
WHERE lagdo_ccn = 'C-17-09-0001'