0 88c3800f92285646bdf4e7ee5d9a5531 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:334:"SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.status AS status_1, o0_.applied_date AS applied_date_2 FROM ohrm_job_candidate_vacancy o0_ LEFT JOIN ohrm_job_vacancy o1_ ON o0_.vacancy_id = o1_.id WHERE o0_.candidate_id IN (?) AND o0_.status = ? AND o1_.status = ?) dctrn_result) dctrn_table";}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:16:"candidateVacancy";s:33:"OrangeHRM\Entity\CandidateVacancy";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:3:{s:4:"id_0";s:2:"id";s:8:"status_1";s:6:"status";s:14:"applied_date_2";s:11:"appliedDate";}s:19:"columnAliasMappings";a:1:{s:33:"OrangeHRM\Entity\CandidateVacancy";a:1:{s:16:"candidateVacancy";a:3:{s:2:"id";s:4:"id_0";s:6:"status";s:8:"status_1";s:11:"appliedDate";s:14:"applied_date_2";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:16:"candidateVacancy";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:3:{s:4:"id_0";s:16:"candidateVacancy";s:8:"status_1";s:16:"candidateVacancy";s:14:"applied_date_2";s:16:"candidateVacancy";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:3:{s:4:"id_0";s:33:"OrangeHRM\Entity\CandidateVacancy";s:8:"status_1";s:33:"OrangeHRM\Entity\CandidateVacancy";s:14:"applied_date_2";s:33:"OrangeHRM\Entity\CandidateVacancy";}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:3:{s:12:"candidateIds";a:1:{i:0;i:0;}s:6:"status";a:1:{i:0;i:1;}s:6:"active";a:1:{i:0;i:2;}}}