gistfile1.txt

    $subsub = $q->createSubQuery()
      ->addSelect('subp.id')
      ->addSelect('CONCAT(\',\', GROUP_CONCAT(DISTINCT sph.subject), \',\') as subj')
      ->from('Place subp')
      ->innerJoin('subp.Historiques sph')
      ->andWhere('subp.visit_status LIKE \'%D2\'')
      ->groupBy('subp.id')
      ->addHaving('( subj LIKE \'%,10,%\') AND (subj NOT LIKE \'%,11,%\')');

    $sub = $q->createSubQuery()->select('sub.id')->from('('.$subsub->getDql().') sub'); // Throws 'Couldn't find class (SELECT' exception , WTF? Just following http://www.symfony-project.org/cookbook/1_2/en/retrieving_data_with_doctrine#chapter_f6fc97d827760d5157133eaf9798ddaf_sub_queries