$criteria = new CDbCriteria; $criteria->condition = 't.name like :name1 AND manufacturer.name like :name2'; $criteria->params = array(':name1' => 'Q%', ':name2' => 'c%'); $models=TpcrawlerCar::model()->with('manufacturer')->findAll($criteria); print_r($models);