$clicks = $this->createQueryBuilder()
            ->select('c')
            ->from('AppBundle:Click', 'c')
            ->where('c.date between :startDate and :endDate')
            ->andWhere('c.account in (:accounts)')
            ->setParameters([
                'startDate' => $start->format('Y-m-d'),
                'endDate' => $end->format('Y-m-d'),
                'account' => $accounts
            ])->getDQL();

        $transactions = $this->createQueryBuilder()
            ->select('t')
            ->from('AppBundle:Report', 'r')
            ->where('r.date between :startDate and :endDate')
            ->andWhere('r.account in (:accounts)')
            ->setParameters([
                'startDate' => $start->format('Y-m-d 0:0:0'),
                'endDate' => $end->format('Y-m-d 23:59:59'),
                'accounts' => $accounts
            ])->getDQL();