public function normalizeJournalTotalArticleDownload() { $rsm = new ResultSetMapping(); $sql = <<<SQL UPDATE journal SET total_article_download = (SELECT SUM(t2.download_count) FROM article t2 WHERE t2.journal_id = journal.id) SQL; $query = $this->em->createNativeQuery($sql, $rsm); $query->getResult(); }