public function addNameColumnQuery(Doctrine_Query $query, $field, $values) { if (is_array($values) && isset($values['text']) && '' != $values['text']) { $query->leftJoin('r.Translation t') // ->andWhere('t.lang = ?', $especify_one_language) // or it will search in all of them ->andWhere('CONCAT(t.name, t.shortname) like ?', '%' . $values['text'] . '%'); } }