0 89a47b8f5191062b05809504404565d3 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:"Doctrine\ORM\Query\ParserResultsqlExecutor";N;s:45:"Doctrine\ORM\Query\ParserResultsqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizersql";s:894:"SELECT o0_.id AS id_0, o0_.first_name AS first_name_1, o0_.middle_name AS middle_name_2, o0_.last_name AS last_name_3, o0_.email AS email_4, o0_.contact_number AS contact_number_5, o0_.status AS status_6, o0_.comment AS comment_7, o0_.mode_of_application AS mode_of_application_8, o0_.date_of_application AS date_of_application_9, o0_.cv_file_id AS cv_file_id_10, o0_.cv_text_version AS cv_text_version_11, o0_.keywords AS keywords_12, o0_.consent_to_keep_data AS consent_to_keep_data_13, o0_.added_person AS added_person_14 FROM ohrm_job_candidate o0_ LEFT JOIN ohrm_job_candidate_vacancy o1_ ON o0_.id = o1_.candidate_id LEFT JOIN hs_hr_employee h2_ ON o0_.added_person = h2_.emp_number LEFT JOIN ohrm_job_vacancy o3_ ON o1_.vacancy_id = o3_.id LEFT JOIN hs_hr_employee h4_ ON o3_.hiring_manager_id = h4_.emp_number WHERE o0_.id IN (?) ORDER BY o0_.date_of_application DESC, o0_.last_name ASC";}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":20:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:9:"candidate";s:26:"OrangeHRM\Entity\Candidate";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:14:{s:4:"id_0";s:2:"id";s:12:"first_name_1";s:9:"firstName";s:13:"middle_name_2";s:10:"middleName";s:11:"last_name_3";s:8:"lastName";s:7:"email_4";s:5:"email";s:16:"contact_number_5";s:13:"contactNumber";s:8:"status_6";s:6:"status";s:9:"comment_7";s:7:"comment";s:21:"mode_of_application_8";s:17:"modeOfApplication";s:21:"date_of_application_9";s:17:"dateOfApplication";s:13:"cv_file_id_10";s:8:"cvFileId";s:18:"cv_text_version_11";s:13:"cvTextVersion";s:11:"keywords_12";s:8:"keywords";s:23:"consent_to_keep_data_13";s:17:"consentToKeepData";}s:19:"columnAliasMappings";a:1:{s:26:"OrangeHRM\Entity\Candidate";a:1:{s:9:"candidate";a:14:{s:2:"id";s:4:"id_0";s:9:"firstName";s:12:"first_name_1";s:10:"middleName";s:13:"middle_name_2";s:8:"lastName";s:11:"last_name_3";s:5:"email";s:7:"email_4";s:13:"contactNumber";s:16:"contact_number_5";s:6:"status";s:8:"status_6";s:7:"comment";s:9:"comment_7";s:17:"modeOfApplication";s:21:"mode_of_application_8";s:17:"dateOfApplication";s:21:"date_of_application_9";s:8:"cvFileId";s:13:"cv_file_id_10";s:13:"cvTextVersion";s:18:"cv_text_version_11";s:8:"keywords";s:11:"keywords_12";s:17:"consentToKeepData";s:23:"consent_to_keep_data_13";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:1:{s:15:"added_person_14";s:7:"integer";}s:14:"entityMappings";a:1:{s:9:"candidate";N;}s:12:"metaMappings";a:1:{s:15:"added_person_14";s:12:"added_person";}s:14:"columnOwnerMap";a:15:{s:4:"id_0";s:9:"candidate";s:12:"first_name_1";s:9:"candidate";s:13:"middle_name_2";s:9:"candidate";s:11:"last_name_3";s:9:"candidate";s:7:"email_4";s:9:"candidate";s:16:"contact_number_5";s:9:"candidate";s:8:"status_6";s:9:"candidate";s:9:"comment_7";s:9:"candidate";s:21:"mode_of_application_8";s:9:"candidate";s:21:"date_of_application_9";s:9:"candidate";s:13:"cv_file_id_10";s:9:"candidate";s:18:"cv_text_version_11";s:9:"candidate";s:11:"keywords_12";s:9:"candidate";s:23:"consent_to_keep_data_13";s:9:"candidate";s:15:"added_person_14";s:9:"candidate";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:14:{s:4:"id_0";s:26:"OrangeHRM\Entity\Candidate";s:12:"first_name_1";s:26:"OrangeHRM\Entity\Candidate";s:13:"middle_name_2";s:26:"OrangeHRM\Entity\Candidate";s:11:"last_name_3";s:26:"OrangeHRM\Entity\Candidate";s:7:"email_4";s:26:"OrangeHRM\Entity\Candidate";s:16:"contact_number_5";s:26:"OrangeHRM\Entity\Candidate";s:8:"status_6";s:26:"OrangeHRM\Entity\Candidate";s:9:"comment_7";s:26:"OrangeHRM\Entity\Candidate";s:21:"mode_of_application_8";s:26:"OrangeHRM\Entity\Candidate";s:21:"date_of_application_9";s:26:"OrangeHRM\Entity\Candidate";s:13:"cv_file_id_10";s:26:"OrangeHRM\Entity\Candidate";s:18:"cv_text_version_11";s:26:"OrangeHRM\Entity\Candidate";s:11:"keywords_12";s:26:"OrangeHRM\Entity\Candidate";s:23:"consent_to_keep_data_13";s:26:"OrangeHRM\Entity\Candidate";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}}s:50:"Doctrine\ORM\Query\ParserResultparameterMappings";a:1:{s:12:"candidateIds";a:1:{i:0;i:0;}}}