0 abc1909312eb79668213bbac890e1aba 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:845:"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_.name AS name_11, l0_.description AS description_12, l0_.alias AS alias_13, l0_.public_name AS public_name_14, l0_.filters AS filters_15, l0_.is_global AS is_global_16, l0_.is_preference_center AS is_preference_center_17, l0_.last_built_date AS last_built_date_18, l0_.last_built_time AS last_built_time_19, l0_.category_id AS category_id_20 FROM lead_lists l0_ LEFT JOIN categories c1_ ON l0_.category_id = c1_.id ORDER BY l0_.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:1:"l";s:33:"Mautic\LeadBundle\Entity\LeadList";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:20:{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:"name_11";s:4:"name";s:14:"description_12";s:11:"description";s:8:"alias_13";s:5:"alias";s:14:"public_name_14";s:10:"publicName";s:10:"filters_15";s:7:"filters";s:12:"is_global_16";s:8:"isGlobal";s:23:"is_preference_center_17";s:18:"isPreferenceCenter";s:18:"last_built_date_18";s:13:"lastBuiltDate";s:18:"last_built_time_19";s:13:"lastBuiltTime";}s:19:"columnAliasMappings";a:1:{s:33:"Mautic\LeadBundle\Entity\LeadList";a:1:{s:1:"l";a:20:{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:"name";s:7:"name_11";s:11:"description";s:14:"description_12";s:5:"alias";s:8:"alias_13";s:10:"publicName";s:14:"public_name_14";s:7:"filters";s:10:"filters_15";s:8:"isGlobal";s:12:"is_global_16";s:18:"isPreferenceCenter";s:23:"is_preference_center_17";s:13:"lastBuiltDate";s:18:"last_built_date_18";s:13:"lastBuiltTime";s:18:"last_built_time_19";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:1:{s:14:"category_id_20";s:7:"integer";}s:14:"entityMappings";a:1:{s:1:"l";N;}s:12:"metaMappings";a:1:{s:14:"category_id_20";s:11:"category_id";}s:14:"columnOwnerMap";a:21:{s:14:"is_published_0";s:1:"l";s:12:"date_added_1";s:1:"l";s:12:"created_by_2";s:1:"l";s:17:"created_by_user_3";s:1:"l";s:15:"date_modified_4";s:1:"l";s:13:"modified_by_5";s:1:"l";s:18:"modified_by_user_6";s:1:"l";s:13:"checked_out_7";s:1:"l";s:16:"checked_out_by_8";s:1:"l";s:21:"checked_out_by_user_9";s:1:"l";s:5:"id_10";s:1:"l";s:7:"name_11";s:1:"l";s:14:"description_12";s:1:"l";s:8:"alias_13";s:1:"l";s:14:"public_name_14";s:1:"l";s:10:"filters_15";s:1:"l";s:12:"is_global_16";s:1:"l";s:23:"is_preference_center_17";s:1:"l";s:18:"last_built_date_18";s:1:"l";s:18:"last_built_time_19";s:1:"l";s:14:"category_id_20";s:1:"l";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:1:{s:1:"l";s:5:"id_10";}s:16:"declaringClasses";a:20:{s:14:"is_published_0";s:33:"Mautic\LeadBundle\Entity\LeadList";s:12:"date_added_1";s:33:"Mautic\LeadBundle\Entity\LeadList";s:12:"created_by_2";s:33:"Mautic\LeadBundle\Entity\LeadList";s:17:"created_by_user_3";s:33:"Mautic\LeadBundle\Entity\LeadList";s:15:"date_modified_4";s:33:"Mautic\LeadBundle\Entity\LeadList";s:13:"modified_by_5";s:33:"Mautic\LeadBundle\Entity\LeadList";s:18:"modified_by_user_6";s:33:"Mautic\LeadBundle\Entity\LeadList";s:13:"checked_out_7";s:33:"Mautic\LeadBundle\Entity\LeadList";s:16:"checked_out_by_8";s:33:"Mautic\LeadBundle\Entity\LeadList";s:21:"checked_out_by_user_9";s:33:"Mautic\LeadBundle\Entity\LeadList";s:5:"id_10";s:33:"Mautic\LeadBundle\Entity\LeadList";s:7:"name_11";s:33:"Mautic\LeadBundle\Entity\LeadList";s:14:"description_12";s:33:"Mautic\LeadBundle\Entity\LeadList";s:8:"alias_13";s:33:"Mautic\LeadBundle\Entity\LeadList";s:14:"public_name_14";s:33:"Mautic\LeadBundle\Entity\LeadList";s:10:"filters_15";s:33:"Mautic\LeadBundle\Entity\LeadList";s:12:"is_global_16";s:33:"Mautic\LeadBundle\Entity\LeadList";s:23:"is_preference_center_17";s:33:"Mautic\LeadBundle\Entity\LeadList";s:18:"last_built_date_18";s:33:"Mautic\LeadBundle\Entity\LeadList";s:18:"last_built_time_19";s:33:"Mautic\LeadBundle\Entity\LeadList";}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:0:{}}