/** * * @param \Desarrolla2\Bundle\BlogBundle\Entity\Tag $tag * @return \Doctrine\ORM\Query */ public function getQueryForGetByTag(Tag $tag) { $em = $this->getEntityManager(); $query = $em->createQuery(' SELECT p FROM BlogBundle:Post p ' . ' JOIN p.tags t ' . ' WHERE p.status = ' . PostStatus::PUBLISHED . ' AND t.slug = :slug ' . ' ORDER BY p.publishedAt DESC ')->setParameter('slug', $tag->getSlug()); return $query; }