0 949aba7d8cca23f6eb2c7c410788f212 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:487:"SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.properties AS properties_3, p1_.id AS id_4, p1_.name AS name_5, p1_.points AS points_6, p1_.color AS color_7 FROM point_trigger_events p0_ LEFT JOIN point_triggers p1_ ON p0_.trigger_id = p1_.id WHERE p1_.is_published = ? AND (p1_.publish_down IS NULL OR p1_.publish_down >= ?) AND (p1_.publish_up IS NULL OR p1_.publish_up <= ?) AND p1_.points <= 0 AND p1_.group_id IS NULL ORDER BY p0_.action_order ASC, p1_.points 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:2:{s:1:"a";s:38:"Mautic\PointBundle\Entity\TriggerEvent";s:1:"r";s:33:"Mautic\PointBundle\Entity\Trigger";}s:11:"relationMap";a:1:{s:1:"r";s:7:"trigger";}s:14:"parentAliasMap";a:1:{s:1:"r";s:1:"a";}s:13:"fieldMappings";a:8:{s:4:"id_0";s:2:"id";s:6:"name_1";s:4:"name";s:6:"type_2";s:4:"type";s:12:"properties_3";s:10:"properties";s:4:"id_4";s:2:"id";s:6:"name_5";s:4:"name";s:8:"points_6";s:6:"points";s:7:"color_7";s:5:"color";}s:19:"columnAliasMappings";a:2:{s:38:"Mautic\PointBundle\Entity\TriggerEvent";a:1:{s:1:"a";a:4:{s:2:"id";s:4:"id_0";s:4:"name";s:6:"name_1";s:4:"type";s:6:"type_2";s:10:"properties";s:12:"properties_3";}}s:33:"Mautic\PointBundle\Entity\Trigger";a:1:{s:1:"r";a:4:{s:2:"id";s:4:"id_4";s:4:"name";s:6:"name_5";s:6:"points";s:8:"points_6";s:5:"color";s:7:"color_7";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:1:"a";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:8:{s:4:"id_0";s:1:"a";s:6:"name_1";s:1:"a";s:6:"type_2";s:1:"a";s:12:"properties_3";s:1:"a";s:4:"id_4";s:1:"r";s:6:"name_5";s:1:"r";s:8:"points_6";s:1:"r";s:7:"color_7";s:1:"r";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:8:{s:4:"id_0";s:38:"Mautic\PointBundle\Entity\TriggerEvent";s:6:"name_1";s:38:"Mautic\PointBundle\Entity\TriggerEvent";s:6:"type_2";s:38:"Mautic\PointBundle\Entity\TriggerEvent";s:12:"properties_3";s:38:"Mautic\PointBundle\Entity\TriggerEvent";s:4:"id_4";s:33:"Mautic\PointBundle\Entity\Trigger";s:6:"name_5";s:33:"Mautic\PointBundle\Entity\Trigger";s:8:"points_6";s:33:"Mautic\PointBundle\Entity\Trigger";s:7:"color_7";s:33:"Mautic\PointBundle\Entity\Trigger";}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:"true";a:1:{i:0;i:0;}s:3:"now";a:2:{i:0;i:1;i:1;i:2;}}}