0 5431147995425937761b12c79f1f14ed 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:352:"SELECT c0_.id AS id_0, c0_.name AS name_1, l1_.id AS id_2 FROM campaigns c0_ LEFT JOIN campaign_leadlist_xref c2_ ON c0_.id = c2_.campaign_id LEFT JOIN lead_lists l1_ ON l1_.id = c2_.leadlist_id WHERE c0_.is_published = ? AND (c0_.publish_down IS NULL OR c0_.publish_down >= ?) AND (c0_.publish_up IS NULL OR c0_.publish_up <= ?) AND c0_.created_by = ?";}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:2:"ll";s:33:"Mautic\LeadBundle\Entity\LeadList";}s:11:"relationMap";a:1:{s:2:"ll";s:5:"lists";}s:14:"parentAliasMap";a:1:{s:2:"ll";s:1:"c";}s:13:"fieldMappings";a:3:{s:4:"id_0";s:2:"id";s:6:"name_1";s:4:"name";s:4:"id_2";s:2:"id";}s:19:"columnAliasMappings";a:2:{s:37:"Mautic\CampaignBundle\Entity\Campaign";a:1:{s:1:"c";a:2:{s:2:"id";s:4:"id_0";s:4:"name";s:6:"name_1";}}s:33:"Mautic\LeadBundle\Entity\LeadList";a:1:{s:2:"ll";a:1:{s:2:"id";s:4:"id_2";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:1:"c";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:3:{s:4:"id_0";s:1:"c";s:6:"name_1";s:1:"c";s:4:"id_2";s:2:"ll";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:2:{s:1:"c";s:4:"id_0";s:2:"ll";s:4:"id_2";}s:16:"declaringClasses";a:3:{s:4:"id_0";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:6:"name_1";s:37:"Mautic\CampaignBundle\Entity\Campaign";s:4:"id_2";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:3:{s:4:"true";a:1:{i:0;i:0;}s:3:"now";a:2:{i:0;i:1;i:1;i:2;}s:2:"id";a:1:{i:0;i:3;}}}