[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT COUNT(r2_.id) AS sclr_0, p0_.id AS id_1, p0_.display_name AS display_name_2, COALESCE(t1_.content, p0_.description) AS description_3, p0_.logo AS logo_4, p0_.website AS website_5, p0_.meta_description AS meta_description_6, p0_.meta_keyword AS meta_keyword_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.is_active AS is_active_11, u5_.id AS id_12, u5_.lastname AS lastname_13, u5_.firstname AS firstname_14, u5_.email AS email_15, u5_.roles AS roles_16, u5_.password AS password_17, u5_.last_login_at AS last_login_at_18, u5_.is_verified AS is_verified_19, u5_.locale AS locale_20, u5_.token AS token_21, u5_.token_expires_at AS token_expires_at_22, u5_.membership_claimed AS membership_claimed_23, u5_.membership_checked_at AS membership_checked_at_24, u5_.membership_expires_at AS membership_expires_at_25, u5_.membership_status AS membership_status_26, u5_.helloasso_member_id AS helloasso_member_id_27, u5_.created_at AS created_at_28, u5_.updated_at AS updated_at_29, u5_.deleted_at AS deleted_at_30, u5_.is_active AS is_active_31, p0_.user_id AS user_id_32, u5_.profile_id AS profile_id_33, u5_.helloasso_membership_campaign_id AS helloasso_membership_campaign_id_34, u5_.helloasso_membership_id AS helloasso_membership_id_35 FROM prescriber p0_ LEFT JOIN `user` u5_ ON p0_.user_id = u5_.id LEFT JOIN realization r2_ ON p0_.id = r2_.prescriber_id LEFT JOIN ext_translations t1_ ON t1_.locale = \'fr\' AND t1_.field = \'description\' AND t1_.object_class = \'App\\\\PrescriberBundle\\\\Entity\\\\Prescriber\' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = \'fr\' AND t3_.field = \'name\' AND t3_.object_class = \'App\\\\RealizationBundle\\\\Entity\\\\Realization\' AND t3_.foreign_key = r2_.id LEFT JOIN ext_translations t4_ ON t4_.locale = \'fr\' AND t4_.field = \'description\' AND t4_.object_class = \'App\\\\RealizationBundle\\\\Entity\\\\Realization\' AND t4_.foreign_key = r2_.id WHERE p0_.is_active = 1 GROUP BY p0_.id ORDER BY sclr_0 DESC, r2_.designed_at DESC, p0_.created_at DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'p' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'u' => 'App\\UserBundle\\Entity\\User', ], ], 'relationMap' => [ 2 => [ 'u' => 'user', ], ], 'parentAliasMap' => [ 2 => [ 'u' => 'p', ], ], 'fieldMappings' => [ 2 => [ 'id_1' => 'id', 'display_name_2' => 'displayName', 'description_3' => 'description', 'logo_4' => 'logo', 'website_5' => 'website', 'meta_description_6' => 'metaDescription', 'meta_keyword_7' => 'metaKeyword', 'created_at_8' => 'createdAt', 'updated_at_9' => 'updatedAt', 'deleted_at_10' => 'deletedAt', 'is_active_11' => 'isActive', 'id_12' => 'id', 'lastname_13' => 'lastname', 'firstname_14' => 'firstname', 'email_15' => 'email', 'roles_16' => 'roles', 'password_17' => 'password', 'last_login_at_18' => 'lastLoginAt', 'is_verified_19' => 'isVerified', 'locale_20' => 'locale', 'token_21' => 'token', 'token_expires_at_22' => 'tokenExpiresAt', 'membership_claimed_23' => 'membershipClaimed', 'membership_checked_at_24' => 'membershipCheckedAt', 'membership_expires_at_25' => 'membershipExpiresAt', 'membership_status_26' => 'membershipStatus', 'helloasso_member_id_27' => 'helloassoMemberId', 'created_at_28' => 'createdAt', 'updated_at_29' => 'updatedAt', 'deleted_at_30' => 'deletedAt', 'is_active_31' => 'isActive', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\PrescriberBundle\\Entity\\Prescriber' => [ 'p' => [ 'id' => 'id_1', 'displayName' => 'display_name_2', 'description' => 'description_3', 'logo' => 'logo_4', 'website' => 'website_5', 'metaDescription' => 'meta_description_6', 'metaKeyword' => 'meta_keyword_7', 'createdAt' => 'created_at_8', 'updatedAt' => 'updated_at_9', 'deletedAt' => 'deleted_at_10', 'isActive' => 'is_active_11', ], ], 'App\\UserBundle\\Entity\\User' => [ 'u' => [ 'id' => 'id_12', 'lastname' => 'lastname_13', 'firstname' => 'firstname_14', 'email' => 'email_15', 'roles' => 'roles_16', 'password' => 'password_17', 'lastLoginAt' => 'last_login_at_18', 'isVerified' => 'is_verified_19', 'locale' => 'locale_20', 'token' => 'token_21', 'tokenExpiresAt' => 'token_expires_at_22', 'membershipClaimed' => 'membership_claimed_23', 'membershipCheckedAt' => 'membership_checked_at_24', 'membershipExpiresAt' => 'membership_expires_at_25', 'membershipStatus' => 'membership_status_26', 'helloassoMemberId' => 'helloasso_member_id_27', 'createdAt' => 'created_at_28', 'updatedAt' => 'updated_at_29', 'deletedAt' => 'deleted_at_30', 'isActive' => 'is_active_31', ], ], ], ], 'typeMappings' => [ 2 => [ 'user_id_32' => 'integer', 'profile_id_33' => 'integer', 'helloasso_membership_campaign_id_34' => 'integer', 'helloasso_membership_id_35' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'p' => null, ], ], 'metaMappings' => [ 2 => [ 'user_id_32' => 'user_id', 'profile_id_33' => 'profile_id', 'helloasso_membership_campaign_id_34' => 'helloasso_membership_campaign_id', 'helloasso_membership_id_35' => 'helloasso_membership_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_1' => 'p', 'display_name_2' => 'p', 'description_3' => 'p', 'logo_4' => 'p', 'website_5' => 'p', 'meta_description_6' => 'p', 'meta_keyword_7' => 'p', 'created_at_8' => 'p', 'updated_at_9' => 'p', 'deleted_at_10' => 'p', 'is_active_11' => 'p', 'id_12' => 'u', 'lastname_13' => 'u', 'firstname_14' => 'u', 'email_15' => 'u', 'roles_16' => 'u', 'password_17' => 'u', 'last_login_at_18' => 'u', 'is_verified_19' => 'u', 'locale_20' => 'u', 'token_21' => 'u', 'token_expires_at_22' => 'u', 'membership_claimed_23' => 'u', 'membership_checked_at_24' => 'u', 'membership_expires_at_25' => 'u', 'membership_status_26' => 'u', 'helloasso_member_id_27' => 'u', 'created_at_28' => 'u', 'updated_at_29' => 'u', 'deleted_at_30' => 'u', 'is_active_31' => 'u', 'user_id_32' => 'p', 'profile_id_33' => 'u', 'helloasso_membership_campaign_id_34' => 'u', 'helloasso_membership_id_35' => 'u', ], ], 'declaringClasses' => [ 2 => [ 'id_1' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'display_name_2' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'description_3' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'logo_4' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'website_5' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'meta_description_6' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'meta_keyword_7' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'created_at_8' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'updated_at_9' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'deleted_at_10' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'is_active_11' => 'App\\PrescriberBundle\\Entity\\Prescriber', 'id_12' => 'App\\UserBundle\\Entity\\User', 'lastname_13' => 'App\\UserBundle\\Entity\\User', 'firstname_14' => 'App\\UserBundle\\Entity\\User', 'email_15' => 'App\\UserBundle\\Entity\\User', 'roles_16' => 'App\\UserBundle\\Entity\\User', 'password_17' => 'App\\UserBundle\\Entity\\User', 'last_login_at_18' => 'App\\UserBundle\\Entity\\User', 'is_verified_19' => 'App\\UserBundle\\Entity\\User', 'locale_20' => 'App\\UserBundle\\Entity\\User', 'token_21' => 'App\\UserBundle\\Entity\\User', 'token_expires_at_22' => 'App\\UserBundle\\Entity\\User', 'membership_claimed_23' => 'App\\UserBundle\\Entity\\User', 'membership_checked_at_24' => 'App\\UserBundle\\Entity\\User', 'membership_expires_at_25' => 'App\\UserBundle\\Entity\\User', 'membership_status_26' => 'App\\UserBundle\\Entity\\User', 'helloasso_member_id_27' => 'App\\UserBundle\\Entity\\User', 'created_at_28' => 'App\\UserBundle\\Entity\\User', 'updated_at_29' => 'App\\UserBundle\\Entity\\User', 'deleted_at_30' => 'App\\UserBundle\\Entity\\User', 'is_active_31' => 'App\\UserBundle\\Entity\\User', ], ], ], ], $o[0], [] ); } }];