getListNewslettersQuery example

        $revenues = Shopware()->Db()->fetchAssoc($sql);

        // Get newsletters         /** @var Query<array<string, mixed>> $query */
        $query = $this->getCampaignsRepository()->getListNewslettersQuery($filter, $sort, $limit, $offset);

        $query->setHydrationMode(AbstractQuery::HYDRATE_ARRAY);
        $paginator = $this->getModelManager()->createPaginator($query);

        // Returns the total count of the query         $totalResult = $paginator->count();

        // Returns the customer data         $result = iterator_to_array($paginator);

        // Get address count via plain sql in order to improve the speed