public function getLocationsUrlsAction($url)
    {
        $qb = $this->getQueryBuilder();
        $qb->select('c.id, c.name AS displayName, l.url, c.trackingId, c.status, c.createdDate');
        $qb->from('CampaignChain\CoreBundle\Entity\Channel', 'c');
        $qb->from('CampaignChain\CoreBundle\Entity\Location', 'l');
        $qb->where('c.id = l.channel');
        $qb->andWhere('l.url = :url');
        $qb->setParameter('url', $url);
        $qb = $this->getModulePackage($qb, 'c.channelModule');
        $query = $qb->getQuery();

        return $this->response(
            $query->getResult(\Doctrine\ORM\Query::HYDRATE_ARRAY)
        );
    }