0 d7a88630bc37fba732bb7c2119de9fa3 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:639:"SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.text AS text_11, l0_.type AS type_12, l0_.date_time AS date_time_13 FROM lead_notes l0_ WHERE l0_.lead_id = ? ORDER BY l0_.date_time DESC) 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:1:"n";s:33:"Mautic\LeadBundle\Entity\LeadNote";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:14:{s:14:"is_published_0";s:11:"isPublished";s:12:"date_added_1";s:9:"dateAdded";s:12:"created_by_2";s:9:"createdBy";s:17:"created_by_user_3";s:13:"createdByUser";s:15:"date_modified_4";s:12:"dateModified";s:13:"modified_by_5";s:10:"modifiedBy";s:18:"modified_by_user_6";s:14:"modifiedByUser";s:13:"checked_out_7";s:10:"checkedOut";s:16:"checked_out_by_8";s:12:"checkedOutBy";s:21:"checked_out_by_user_9";s:16:"checkedOutByUser";s:5:"id_10";s:2:"id";s:7:"text_11";s:4:"text";s:7:"type_12";s:4:"type";s:12:"date_time_13";s:8:"dateTime";}s:19:"columnAliasMappings";a:1:{s:33:"Mautic\LeadBundle\Entity\LeadNote";a:1:{s:1:"n";a:14:{s:11:"isPublished";s:14:"is_published_0";s:9:"dateAdded";s:12:"date_added_1";s:9:"createdBy";s:12:"created_by_2";s:13:"createdByUser";s:17:"created_by_user_3";s:12:"dateModified";s:15:"date_modified_4";s:10:"modifiedBy";s:13:"modified_by_5";s:14:"modifiedByUser";s:18:"modified_by_user_6";s:10:"checkedOut";s:13:"checked_out_7";s:12:"checkedOutBy";s:16:"checked_out_by_8";s:16:"checkedOutByUser";s:21:"checked_out_by_user_9";s:2:"id";s:5:"id_10";s:4:"text";s:7:"text_11";s:4:"type";s:7:"type_12";s:8:"dateTime";s:12:"date_time_13";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:1:"n";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:14:{s:14:"is_published_0";s:1:"n";s:12:"date_added_1";s:1:"n";s:12:"created_by_2";s:1:"n";s:17:"created_by_user_3";s:1:"n";s:15:"date_modified_4";s:1:"n";s:13:"modified_by_5";s:1:"n";s:18:"modified_by_user_6";s:1:"n";s:13:"checked_out_7";s:1:"n";s:16:"checked_out_by_8";s:1:"n";s:21:"checked_out_by_user_9";s:1:"n";s:5:"id_10";s:1:"n";s:7:"text_11";s:1:"n";s:7:"type_12";s:1:"n";s:12:"date_time_13";s:1:"n";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:14:{s:14:"is_published_0";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:12:"date_added_1";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:12:"created_by_2";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:17:"created_by_user_3";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:15:"date_modified_4";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:13:"modified_by_5";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:18:"modified_by_user_6";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:13:"checked_out_7";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:16:"checked_out_by_8";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:21:"checked_out_by_user_9";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:5:"id_10";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:7:"text_11";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:7:"type_12";s:33:"Mautic\LeadBundle\Entity\LeadNote";s:12:"date_time_13";s:33:"Mautic\LeadBundle\Entity\LeadNote";}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:4:"par0";a:1:{i:0;i:0;}}}