gistfile1.php

 public function getUnpublished()
    {
        $qb = $this->createQueryBuilder();
        $query = $qb->select(array('thumbnail','show'))
                    ->from('\App\Thumbnail\Thumbnail','thumbnail')
                    ->from('\App\Cropper\Image','image')
                    ->from('\App\Entity\Content\Show', 'show')
                    ->where('show.image = image')
                    ->andWhere('thumbnail.image = image')
                    ->getQuery();
        return $query->execute();
    }