0 385e0e3bfd0d3c10ea33e23e9b6a1b54 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:750:"SELECT e0_.id AS id_0, e0_.email_address AS email_address_1, e0_.date_sent AS date_sent_2, e0_.is_read AS is_read_3, e0_.is_failed AS is_failed_4, e0_.viewed_in_browser AS viewed_in_browser_5, e0_.date_read AS date_read_6, e0_.tracking_hash AS tracking_hash_7, e0_.retry_count AS retry_count_8, e0_.source AS source_9, e0_.source_id AS source_id_10, e0_.tokens AS tokens_11, e0_.open_count AS open_count_12, e0_.last_opened AS last_opened_13, e0_.open_details AS open_details_14, e0_.email_id AS email_id_15, e0_.lead_id AS lead_id_16, e0_.list_id AS list_id_17, e0_.ip_id AS ip_id_18, e0_.copy_id AS copy_id_19 FROM email_stats e0_ LEFT JOIN leads l1_ ON e0_.lead_id = l1_.id LEFT JOIN emails e2_ ON e0_.email_id = e2_.id WHERE e0_.tracking_hash = ?";}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:"s";s:30:"Mautic\EmailBundle\Entity\Stat";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:15:{s:4:"id_0";s:2:"id";s:15:"email_address_1";s:12:"emailAddress";s:11:"date_sent_2";s:8:"dateSent";s:9:"is_read_3";s:6:"isRead";s:11:"is_failed_4";s:8:"isFailed";s:19:"viewed_in_browser_5";s:15:"viewedInBrowser";s:11:"date_read_6";s:8:"dateRead";s:15:"tracking_hash_7";s:12:"trackingHash";s:13:"retry_count_8";s:10:"retryCount";s:8:"source_9";s:6:"source";s:12:"source_id_10";s:8:"sourceId";s:9:"tokens_11";s:6:"tokens";s:13:"open_count_12";s:9:"openCount";s:14:"last_opened_13";s:10:"lastOpened";s:15:"open_details_14";s:11:"openDetails";}s:19:"columnAliasMappings";a:1:{s:30:"Mautic\EmailBundle\Entity\Stat";a:1:{s:1:"s";a:15:{s:2:"id";s:4:"id_0";s:12:"emailAddress";s:15:"email_address_1";s:8:"dateSent";s:11:"date_sent_2";s:6:"isRead";s:9:"is_read_3";s:8:"isFailed";s:11:"is_failed_4";s:15:"viewedInBrowser";s:19:"viewed_in_browser_5";s:8:"dateRead";s:11:"date_read_6";s:12:"trackingHash";s:15:"tracking_hash_7";s:10:"retryCount";s:13:"retry_count_8";s:6:"source";s:8:"source_9";s:8:"sourceId";s:12:"source_id_10";s:6:"tokens";s:9:"tokens_11";s:9:"openCount";s:13:"open_count_12";s:10:"lastOpened";s:14:"last_opened_13";s:11:"openDetails";s:15:"open_details_14";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:5:{s:11:"email_id_15";s:7:"integer";s:10:"lead_id_16";s:6:"bigint";s:10:"list_id_17";s:7:"integer";s:8:"ip_id_18";s:7:"integer";s:10:"copy_id_19";s:6:"string";}s:14:"entityMappings";a:1:{s:1:"s";N;}s:12:"metaMappings";a:5:{s:11:"email_id_15";s:8:"email_id";s:10:"lead_id_16";s:7:"lead_id";s:10:"list_id_17";s:7:"list_id";s:8:"ip_id_18";s:5:"ip_id";s:10:"copy_id_19";s:7:"copy_id";}s:14:"columnOwnerMap";a:20:{s:4:"id_0";s:1:"s";s:15:"email_address_1";s:1:"s";s:11:"date_sent_2";s:1:"s";s:9:"is_read_3";s:1:"s";s:11:"is_failed_4";s:1:"s";s:19:"viewed_in_browser_5";s:1:"s";s:11:"date_read_6";s:1:"s";s:15:"tracking_hash_7";s:1:"s";s:13:"retry_count_8";s:1:"s";s:8:"source_9";s:1:"s";s:12:"source_id_10";s:1:"s";s:9:"tokens_11";s:1:"s";s:13:"open_count_12";s:1:"s";s:14:"last_opened_13";s:1:"s";s:15:"open_details_14";s:1:"s";s:11:"email_id_15";s:1:"s";s:10:"lead_id_16";s:1:"s";s:10:"list_id_17";s:1:"s";s:8:"ip_id_18";s:1:"s";s:10:"copy_id_19";s:1:"s";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:15:{s:4:"id_0";s:30:"Mautic\EmailBundle\Entity\Stat";s:15:"email_address_1";s:30:"Mautic\EmailBundle\Entity\Stat";s:11:"date_sent_2";s:30:"Mautic\EmailBundle\Entity\Stat";s:9:"is_read_3";s:30:"Mautic\EmailBundle\Entity\Stat";s:11:"is_failed_4";s:30:"Mautic\EmailBundle\Entity\Stat";s:19:"viewed_in_browser_5";s:30:"Mautic\EmailBundle\Entity\Stat";s:11:"date_read_6";s:30:"Mautic\EmailBundle\Entity\Stat";s:15:"tracking_hash_7";s:30:"Mautic\EmailBundle\Entity\Stat";s:13:"retry_count_8";s:30:"Mautic\EmailBundle\Entity\Stat";s:8:"source_9";s:30:"Mautic\EmailBundle\Entity\Stat";s:12:"source_id_10";s:30:"Mautic\EmailBundle\Entity\Stat";s:9:"tokens_11";s:30:"Mautic\EmailBundle\Entity\Stat";s:13:"open_count_12";s:30:"Mautic\EmailBundle\Entity\Stat";s:14:"last_opened_13";s:30:"Mautic\EmailBundle\Entity\Stat";s:15:"open_details_14";s:30:"Mautic\EmailBundle\Entity\Stat";}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:"hash";a:1:{i:0;i:0;}}}