0 8a4ee64cdaa6972756688594a020749b O:31:"Doctrine\ORM\Query\ParserResult":3:{s:44:"Doctrine\ORM\Query\ParserResultsqlExecutor";O:44:"Doctrine\ORM\Query\Exec\SingleSelectExecutor":2:{s:16:"*sqlStatements";s:452:"SELECT SUM(v0_.montant_en_USD) AS sclr_0, COUNT(DISTINCT d1_.id) AS sclr_1, p2_.nom AS nom_2 FROM dot d1_ LEFT JOIN operateur o3_ ON d1_.operateur_id = o3_.id LEFT JOIN ville v4_ ON o3_.ville_id = v4_.id LEFT JOIN province p2_ ON v4_.province_id = p2_.id LEFT JOIN information_financiere i5_ ON o3_.id = i5_.operateur_id LEFT JOIN versement_dot v0_ ON i5_.id = v0_.information_financiere_id WHERE v0_.is_publish = 1 GROUP BY p2_.nom ORDER BY sclr_1 ASC";s:20:"*queryCacheProfile";N;}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":19:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:0:{}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:0:{}s:14:"scalarMappings";a:3:{s:6:"sclr_0";s:7:"montant";s:6:"sclr_1";s:4:"nbre";s:5:"nom_2";s:8:"province";}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:3:{s:6:"sclr_0";s:6:"string";s:6:"sclr_1";s:7:"integer";s:5:"nom_2";s:6:"string";}s:14:"entityMappings";a:0:{}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:0:{}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:0:{}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:0:{}}