0 a0ee3452835cb94b09bc3742616d6102 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:1417:"SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.name AS name_11, c0_.description AS description_12, c0_.publish_up AS publish_up_13, c0_.publish_down AS publish_down_14, c0_.canvas_settings AS canvas_settings_15, c0_.allow_restart AS allow_restart_16, c0_.deleted AS deleted_17, c0_.version AS version_18, c1_.is_published AS is_published_19, c1_.date_added AS date_added_20, c1_.created_by AS created_by_21, c1_.created_by_user AS created_by_user_22, c1_.date_modified AS date_modified_23, c1_.modified_by AS modified_by_24, c1_.modified_by_user AS modified_by_user_25, c1_.checked_out AS checked_out_26, c1_.checked_out_by AS checked_out_by_27, c1_.checked_out_by_user AS checked_out_by_user_28, c1_.id AS id_29, c1_.title AS title_30, c1_.description AS description_31, c1_.alias AS alias_32, c1_.color AS color_33, c1_.bundle AS bundle_34, c0_.category_id AS category_id_35 FROM campaigns c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c0_.deleted IS NULL AND (c0_.name LIKE ? OR c0_.description LIKE ?) ORDER BY c0_.date_modified DESC";}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:2:{s:1:"c";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:3:"cat";s:37:"Mautic\CategoryBundle\Entity\Category";}s:11:"relationMap";a:1:{s:3:"cat";s:8:"category";}s:14:"parentAliasMap";a:1:{s:3:"cat";s:1:"c";}s:13:"fieldMappings";a:35:{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:13:"publish_up_13";s:9:"publishUp";s:15:"publish_down_14";s:11:"publishDown";s:18:"canvas_settings_15";s:14:"canvasSettings";s:16:"allow_restart_16";s:12:"allowRestart";s:10:"deleted_17";s:7:"deleted";s:10:"version_18";s:7:"version";s:15:"is_published_19";s:11:"isPublished";s:13:"date_added_20";s:9:"dateAdded";s:13:"created_by_21";s:9:"createdBy";s:18:"created_by_user_22";s:13:"createdByUser";s:16:"date_modified_23";s:12:"dateModified";s:14:"modified_by_24";s:10:"modifiedBy";s:19:"modified_by_user_25";s:14:"modifiedByUser";s:14:"checked_out_26";s:10:"checkedOut";s:17:"checked_out_by_27";s:12:"checkedOutBy";s:22:"checked_out_by_user_28";s:16:"checkedOutByUser";s:5:"id_29";s:2:"id";s:8:"title_30";s:5:"title";s:14:"description_31";s:11:"description";s:8:"alias_32";s:5:"alias";s:8:"color_33";s:5:"color";s:9:"bundle_34";s:6:"bundle";}s:19:"columnAliasMappings";a:2:{s:37:"Mautic\CampaignBundle\Entity\Campaign";a:1:{s:1:"c";a:19:{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:9:"publishUp";s:13:"publish_up_13";s:11:"publishDown";s:15:"publish_down_14";s:14:"canvasSettings";s:18:"canvas_settings_15";s:12:"allowRestart";s:16:"allow_restart_16";s:7:"deleted";s:10:"deleted_17";s:7:"version";s:10:"version_18";}}s:37:"Mautic\CategoryBundle\Entity\Category";a:1:{s:3:"cat";a:16:{s:11:"isPublished";s:15:"is_published_19";s:9:"dateAdded";s:13:"date_added_20";s:9:"createdBy";s:13:"created_by_21";s:13:"createdByUser";s:18:"created_by_user_22";s:12:"dateModified";s:16:"date_modified_23";s:10:"modifiedBy";s:14:"modified_by_24";s:14:"modifiedByUser";s:19:"modified_by_user_25";s:10:"checkedOut";s:14:"checked_out_26";s:12:"checkedOutBy";s:17:"checked_out_by_27";s:16:"checkedOutByUser";s:22:"checked_out_by_user_28";s:2:"id";s:5:"id_29";s:5:"title";s:8:"title_30";s:11:"description";s:14:"description_31";s:5:"alias";s:8:"alias_32";s:5:"color";s:8:"color_33";s:6:"bundle";s:9:"bundle_34";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:1:{s:14:"category_id_35";s:7:"integer";}s:14:"entityMappings";a:1:{s:1:"c";N;}s:12:"metaMappings";a:1:{s:14:"category_id_35";s:11:"category_id";}s:14:"columnOwnerMap";a:36:{s:14:"is_published_0";s:1:"c";s:12:"date_added_1";s:1:"c";s:12:"created_by_2";s:1:"c";s:17:"created_by_user_3";s:1:"c";s:15:"date_modified_4";s:1:"c";s:13:"modified_by_5";s:1:"c";s:18:"modified_by_user_6";s:1:"c";s:13:"checked_out_7";s:1:"c";s:16:"checked_out_by_8";s:1:"c";s:21:"checked_out_by_user_9";s:1:"c";s:5:"id_10";s:1:"c";s:7:"name_11";s:1:"c";s:14:"description_12";s:1:"c";s:13:"publish_up_13";s:1:"c";s:15:"publish_down_14";s:1:"c";s:18:"canvas_settings_15";s:1:"c";s:16:"allow_restart_16";s:1:"c";s:10:"deleted_17";s:1:"c";s:10:"version_18";s:1:"c";s:15:"is_published_19";s:3:"cat";s:13:"date_added_20";s:3:"cat";s:13:"created_by_21";s:3:"cat";s:18:"created_by_user_22";s:3:"cat";s:16:"date_modified_23";s:3:"cat";s:14:"modified_by_24";s:3:"cat";s:19:"modified_by_user_25";s:3:"cat";s:14:"checked_out_26";s:3:"cat";s:17:"checked_out_by_27";s:3:"cat";s:22:"checked_out_by_user_28";s:3:"cat";s:5:"id_29";s:3:"cat";s:8:"title_30";s:3:"cat";s:14:"description_31";s:3:"cat";s:8:"alias_32";s:3:"cat";s:8:"color_33";s:3:"cat";s:9:"bundle_34";s:3:"cat";s:14:"category_id_35";s:1:"c";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:1:{s:1:"c";s:5:"id_10";}s:16:"declaringClasses";a:35:{s:14:"is_published_0";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:12:"date_added_1";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:12:"created_by_2";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:17:"created_by_user_3";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:15:"date_modified_4";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:13:"modified_by_5";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:18:"modified_by_user_6";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:13:"checked_out_7";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:16:"checked_out_by_8";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:21:"checked_out_by_user_9";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:5:"id_10";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:7:"name_11";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:14:"description_12";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:13:"publish_up_13";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:15:"publish_down_14";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:18:"canvas_settings_15";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:16:"allow_restart_16";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:10:"deleted_17";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:10:"version_18";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:15:"is_published_19";s:37:"Mautic\CategoryBundle\Entity\Category";s:13:"date_added_20";s:37:"Mautic\CategoryBundle\Entity\Category";s:13:"created_by_21";s:37:"Mautic\CategoryBundle\Entity\Category";s:18:"created_by_user_22";s:37:"Mautic\CategoryBundle\Entity\Category";s:16:"date_modified_23";s:37:"Mautic\CategoryBundle\Entity\Category";s:14:"modified_by_24";s:37:"Mautic\CategoryBundle\Entity\Category";s:19:"modified_by_user_25";s:37:"Mautic\CategoryBundle\Entity\Category";s:14:"checked_out_26";s:37:"Mautic\CategoryBundle\Entity\Category";s:17:"checked_out_by_27";s:37:"Mautic\CategoryBundle\Entity\Category";s:22:"checked_out_by_user_28";s:37:"Mautic\CategoryBundle\Entity\Category";s:5:"id_29";s:37:"Mautic\CategoryBundle\Entity\Category";s:8:"title_30";s:37:"Mautic\CategoryBundle\Entity\Category";s:14:"description_31";s:37:"Mautic\CategoryBundle\Entity\Category";s:8:"alias_32";s:37:"Mautic\CategoryBundle\Entity\Category";s:8:"color_33";s:37:"Mautic\CategoryBundle\Entity\Category";s:9:"bundle_34";s:37:"Mautic\CategoryBundle\Entity\Category";}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:2:{i:0;i:0;i:1;i:1;}}}