0 e0d4118c214a4cc4f14008606b604a67 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:1800:"SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT e0_.is_published AS is_published_0, e0_.date_added AS date_added_1, e0_.created_by AS created_by_2, e0_.created_by_user AS created_by_user_3, e0_.date_modified AS date_modified_4, e0_.modified_by AS modified_by_5, e0_.modified_by_user AS modified_by_user_6, e0_.checked_out AS checked_out_7, e0_.checked_out_by AS checked_out_by_8, e0_.checked_out_by_user AS checked_out_by_user_9, e0_.id AS id_10, e0_.name AS name_11, e0_.description AS description_12, e0_.subject AS subject_13, e0_.preheader_text AS preheader_text_14, e0_.from_address AS from_address_15, e0_.from_name AS from_name_16, e0_.reply_to_address AS reply_to_address_17, e0_.bcc_address AS bcc_address_18, e0_.use_owner_as_mailer AS use_owner_as_mailer_19, e0_.template AS template_20, e0_.content AS content_21, e0_.utm_tags AS utm_tags_22, e0_.plain_text AS plain_text_23, e0_.custom_html AS custom_html_24, e0_.email_type AS email_type_25, e0_.publish_up AS publish_up_26, e0_.publish_down AS publish_down_27, e0_.read_count AS read_count_28, e0_.sent_count AS sent_count_29, e0_.variant_sent_count AS variant_sent_count_30, e0_.variant_read_count AS variant_read_count_31, e0_.revision AS revision_32, e0_.lang AS lang_33, e0_.variant_settings AS variant_settings_34, e0_.variant_start_date AS variant_start_date_35, e0_.dynamic_content AS dynamic_content_36, e0_.headers AS headers_37, e0_.public_preview AS public_preview_38, e0_.visible_to_all AS visible_to_all_39 FROM emails e0_ LEFT JOIN categories c1_ ON e0_.category_id = c1_.id WHERE e0_.variant_parent_id IS NULL AND e0_.translation_parent_id IS NULL AND ((e0_.name LIKE ? OR e0_.subject LIKE ?) AND (e0_.name LIKE ? OR e0_.subject LIKE ?)) ORDER BY e0_.date_modified 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:"e";s:31:"Mautic\EmailBundle\Entity\Email";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:40:{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:10:"subject_13";s:7:"subject";s:17:"preheader_text_14";s:13:"preheaderText";s:15:"from_address_15";s:11:"fromAddress";s:12:"from_name_16";s:8:"fromName";s:19:"reply_to_address_17";s:14:"replyToAddress";s:14:"bcc_address_18";s:10:"bccAddress";s:22:"use_owner_as_mailer_19";s:16:"useOwnerAsMailer";s:11:"template_20";s:8:"template";s:10:"content_21";s:7:"content";s:11:"utm_tags_22";s:7:"utmTags";s:13:"plain_text_23";s:9:"plainText";s:14:"custom_html_24";s:10:"customHtml";s:13:"email_type_25";s:9:"emailType";s:13:"publish_up_26";s:9:"publishUp";s:15:"publish_down_27";s:11:"publishDown";s:13:"read_count_28";s:9:"readCount";s:13:"sent_count_29";s:9:"sentCount";s:21:"variant_sent_count_30";s:16:"variantSentCount";s:21:"variant_read_count_31";s:16:"variantReadCount";s:11:"revision_32";s:8:"revision";s:7:"lang_33";s:8:"language";s:19:"variant_settings_34";s:15:"variantSettings";s:21:"variant_start_date_35";s:16:"variantStartDate";s:18:"dynamic_content_36";s:14:"dynamicContent";s:10:"headers_37";s:7:"headers";s:17:"public_preview_38";s:13:"publicPreview";s:17:"visible_to_all_39";s:12:"visibleToAll";}s:19:"columnAliasMappings";a:1:{s:31:"Mautic\EmailBundle\Entity\Email";a:1:{s:1:"e";a:40:{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:7:"subject";s:10:"subject_13";s:13:"preheaderText";s:17:"preheader_text_14";s:11:"fromAddress";s:15:"from_address_15";s:8:"fromName";s:12:"from_name_16";s:14:"replyToAddress";s:19:"reply_to_address_17";s:10:"bccAddress";s:14:"bcc_address_18";s:16:"useOwnerAsMailer";s:22:"use_owner_as_mailer_19";s:8:"template";s:11:"template_20";s:7:"content";s:10:"content_21";s:7:"utmTags";s:11:"utm_tags_22";s:9:"plainText";s:13:"plain_text_23";s:10:"customHtml";s:14:"custom_html_24";s:9:"emailType";s:13:"email_type_25";s:9:"publishUp";s:13:"publish_up_26";s:11:"publishDown";s:15:"publish_down_27";s:9:"readCount";s:13:"read_count_28";s:9:"sentCount";s:13:"sent_count_29";s:16:"variantSentCount";s:21:"variant_sent_count_30";s:16:"variantReadCount";s:21:"variant_read_count_31";s:8:"revision";s:11:"revision_32";s:8:"language";s:7:"lang_33";s:15:"variantSettings";s:19:"variant_settings_34";s:16:"variantStartDate";s:21:"variant_start_date_35";s:14:"dynamicContent";s:18:"dynamic_content_36";s:7:"headers";s:10:"headers_37";s:13:"publicPreview";s:17:"public_preview_38";s:12:"visibleToAll";s:17:"visible_to_all_39";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:1:"e";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:40:{s:14:"is_published_0";s:1:"e";s:12:"date_added_1";s:1:"e";s:12:"created_by_2";s:1:"e";s:17:"created_by_user_3";s:1:"e";s:15:"date_modified_4";s:1:"e";s:13:"modified_by_5";s:1:"e";s:18:"modified_by_user_6";s:1:"e";s:13:"checked_out_7";s:1:"e";s:16:"checked_out_by_8";s:1:"e";s:21:"checked_out_by_user_9";s:1:"e";s:5:"id_10";s:1:"e";s:7:"name_11";s:1:"e";s:14:"description_12";s:1:"e";s:10:"subject_13";s:1:"e";s:17:"preheader_text_14";s:1:"e";s:15:"from_address_15";s:1:"e";s:12:"from_name_16";s:1:"e";s:19:"reply_to_address_17";s:1:"e";s:14:"bcc_address_18";s:1:"e";s:22:"use_owner_as_mailer_19";s:1:"e";s:11:"template_20";s:1:"e";s:10:"content_21";s:1:"e";s:11:"utm_tags_22";s:1:"e";s:13:"plain_text_23";s:1:"e";s:14:"custom_html_24";s:1:"e";s:13:"email_type_25";s:1:"e";s:13:"publish_up_26";s:1:"e";s:15:"publish_down_27";s:1:"e";s:13:"read_count_28";s:1:"e";s:13:"sent_count_29";s:1:"e";s:21:"variant_sent_count_30";s:1:"e";s:21:"variant_read_count_31";s:1:"e";s:11:"revision_32";s:1:"e";s:7:"lang_33";s:1:"e";s:19:"variant_settings_34";s:1:"e";s:21:"variant_start_date_35";s:1:"e";s:18:"dynamic_content_36";s:1:"e";s:10:"headers_37";s:1:"e";s:17:"public_preview_38";s:1:"e";s:17:"visible_to_all_39";s:1:"e";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:1:{s:1:"e";s:5:"id_10";}s:16:"declaringClasses";a:40:{s:14:"is_published_0";s:31:"Mautic\EmailBundle\Entity\Email";s:12:"date_added_1";s:31:"Mautic\EmailBundle\Entity\Email";s:12:"created_by_2";s:31:"Mautic\EmailBundle\Entity\Email";s:17:"created_by_user_3";s:31:"Mautic\EmailBundle\Entity\Email";s:15:"date_modified_4";s:31:"Mautic\EmailBundle\Entity\Email";s:13:"modified_by_5";s:31:"Mautic\EmailBundle\Entity\Email";s:18:"modified_by_user_6";s:31:"Mautic\EmailBundle\Entity\Email";s:13:"checked_out_7";s:31:"Mautic\EmailBundle\Entity\Email";s:16:"checked_out_by_8";s:31:"Mautic\EmailBundle\Entity\Email";s:21:"checked_out_by_user_9";s:31:"Mautic\EmailBundle\Entity\Email";s:5:"id_10";s:31:"Mautic\EmailBundle\Entity\Email";s:7:"name_11";s:31:"Mautic\EmailBundle\Entity\Email";s:14:"description_12";s:31:"Mautic\EmailBundle\Entity\Email";s:10:"subject_13";s:31:"Mautic\EmailBundle\Entity\Email";s:17:"preheader_text_14";s:31:"Mautic\EmailBundle\Entity\Email";s:15:"from_address_15";s:31:"Mautic\EmailBundle\Entity\Email";s:12:"from_name_16";s:31:"Mautic\EmailBundle\Entity\Email";s:19:"reply_to_address_17";s:31:"Mautic\EmailBundle\Entity\Email";s:14:"bcc_address_18";s:31:"Mautic\EmailBundle\Entity\Email";s:22:"use_owner_as_mailer_19";s:31:"Mautic\EmailBundle\Entity\Email";s:11:"template_20";s:31:"Mautic\EmailBundle\Entity\Email";s:10:"content_21";s:31:"Mautic\EmailBundle\Entity\Email";s:11:"utm_tags_22";s:31:"Mautic\EmailBundle\Entity\Email";s:13:"plain_text_23";s:31:"Mautic\EmailBundle\Entity\Email";s:14:"custom_html_24";s:31:"Mautic\EmailBundle\Entity\Email";s:13:"email_type_25";s:31:"Mautic\EmailBundle\Entity\Email";s:13:"publish_up_26";s:31:"Mautic\EmailBundle\Entity\Email";s:15:"publish_down_27";s:31:"Mautic\EmailBundle\Entity\Email";s:13:"read_count_28";s:31:"Mautic\EmailBundle\Entity\Email";s:13:"sent_count_29";s:31:"Mautic\EmailBundle\Entity\Email";s:21:"variant_sent_count_30";s:31:"Mautic\EmailBundle\Entity\Email";s:21:"variant_read_count_31";s:31:"Mautic\EmailBundle\Entity\Email";s:11:"revision_32";s:31:"Mautic\EmailBundle\Entity\Email";s:7:"lang_33";s:31:"Mautic\EmailBundle\Entity\Email";s:19:"variant_settings_34";s:31:"Mautic\EmailBundle\Entity\Email";s:21:"variant_start_date_35";s:31:"Mautic\EmailBundle\Entity\Email";s:18:"dynamic_content_36";s:31:"Mautic\EmailBundle\Entity\Email";s:10:"headers_37";s:31:"Mautic\EmailBundle\Entity\Email";s:17:"public_preview_38";s:31:"Mautic\EmailBundle\Entity\Email";s:17:"visible_to_all_39";s:31:"Mautic\EmailBundle\Entity\Email";}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:2:{s:4:"par2";a:2:{i:0;i:0;i:1;i:1;}s:4:"par3";a:2:{i:0;i:2;i:1;i:3;}}}